maintenace mode notice not working

[vacuman]

I have corrupted SMF_sessions table in MySQL which I'm trying to repair. I've set my SMF into maintenance mode and adding a suitable notice but my users only see this message
Table 'smfdata_verulam-forum_co_uk.smf_sessions' doesn't exist

Any suggestions about how I can ensure that when my forum users visit my forum they see a maintenance mode message rather that the MySQL error?

[margarett]

Humm... Now that's bad... It seems your "sessions" table is gone...
Can you check in phpmyadmin if it is really there or not?

[ziycon]

First off, create a full backup of your database.

Check and make sure the table is there, if so try running the below statement within phpmyadmin in the SQL tab.

Code Select Expand

REPAIR TABLE smfdata_verulam-forum_co_uk.smf_sessions USE_FRM;

Otherwise if the table is not there you'll need to recreate it, with the below code:

Code Select Expand

CREATE TABLE {$db_prefix}sessions (
  session_id char(32) NOT NULL,
  last_update int(10) unsigned NOT NULL,
  data text NOT NULL,
  PRIMARY KEY (session_id)
) ENGINE=MyISAM;

[vacuman]

Thanks for the help with the repair. For some reason I don't have a record of my login & pw for phpmyadmin for my server and I'm awaiting my ISP to help me get the table restored.

The Sessions table was there...I tried to fix it by renaming it hence the error message. Previously it said something about being corrupted but now I can't even rename it back again.

Once I'm able to get on to myPHPadmin I'll try those steps suggested by Ziycon. Meanwhile, any suggestions re a way of getting a notice online as I'm getting fed up of my users emailing and texting me to let me know they can't access our forum, not realising it's not a problem at their end.

[Kindred]

rename index.php temporarily and put your own index.html page with a message up...