Forum Crashed

[courage]

My entire site went down and it complained about optimizing database in subs. Does anybody know what caused the problem?

[Moocat]

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?

[courage]

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.

[Rasyr]

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.

[Moocat]

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?

[Xarcell]

I had similiar problems, but it turned out my host had "extra security" that was causing the problem.