TinyPortal

General => Chit chat => Topic started by: courage on January 11, 2006, 12:46:52 AM

Title: Forum Crashed
Post by: courage on January 11, 2006, 12:46:52 AM
My entire site went down and it complained about optimizing database in subs. Does anybody know what caused the problem?
Title: Re: Forum Crashed
Post by: Moocat on January 11, 2006, 12:49:59 AM
can you explain what you mean by "down"? are you getting error messages when you access the forum directory? maintainance mode? can you either copy the error msgs or provide a link?
Title: Re: Forum Crashed
Post by: courage on January 11, 2006, 12:58:38 AM
I just wanted to mention that my forum crashed. I gave up an hour ago trying to fix it so I am reinstalling it. Somebody else had the same problem with the subs.php. It said something about unable to session_create(). Anyway, thats that. Just to tell everybody, but it might've been something else.
Title: Re: Forum Crashed
Post by: Rasyr on January 11, 2006, 03:12:08 AM
That sounds more like your sessions table, in the database, got corrupted somehow. The fix for that is to go into phpMyAdmin (or whatever you use to administer your DB), and do "REPAIR TABLE xxx_sessions" (where xxx = the prefix you assigned to the DB). You just go into your DB admin program and run the bolded text above (changed to match the actual table name in your DB) in the SQL area/box/etc.

I have actually had that happen several times to my forums (SMF 1.1 RC1) since I installed. The first time, we called our host and he found the problem and repaired the table. After that, I did some research and found out how to use the SQL command I noted above. Since then I have had to repair the DB a couple of times, but since I started going into the SMF Admin section and use the DB tools (at the bottom of the menu - Forum Maintainance) and using some of the tools in it occassionally, I haven't really had that much problem with it.

Title: Re: Forum Crashed
Post by: Moocat on January 11, 2006, 05:15:53 AM
it'd be nice if you'd please supply some more information like error msgs, smf version, tp version, etc. when did this happen, after you installed tp?
Title: Re: Forum Crashed
Post by: Xarcell on January 11, 2006, 02:19:07 PM
I had similiar problems, but it turned out my host had "extra security" that was causing the problem.