Table 'smf_sessions' is marked as crashed and last (automatic?) repair failed

Started by jt4x4, October 28, 2014, 07:33:29 PM

Previous topic - Next topic

jt4x4

What happened and how do I fix it?

hxxp:jt4x4.com/smf/index.php [nonactive] 

Kindred

well, it described exactly what happened.   the table crashed

How do you fix it?

Go to your host panel or phpmyadmin and repair the table
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

moparts

Table 'smf_sessions' is marked as crashed and last (automatic?) repair failed

Tried to repair table, error, tried to open table, error  tried to empty table, error

Now trying to rebuild as in recreate the table?  I seem to understand that an empty table is OK , just members will need to log back in

What is the structure of the table as in columns need etc?

vbgamer45

It is

CREATE TABLE smf_sessions (
  session_id char(32) NOT NULL,
  last_update int(10) unsigned NOT NULL,
  data text NOT NULL,
  PRIMARY KEY (session_id)
) ENGINE=MyISAM;
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Arantor


vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Arantor

Odd... I thought all of 1.1's tables had camelCase column names rather than the under_scored that 2.0 had to have, but didn't have a 1.1 install to hand to check.

Illori


moparts

Thank You    vbgamer45

Rebuilt the Table with those Columns and the board is now working again

The hosting company has a very restrictive interface to work with the Mysql, but got it done

Wish I had a command line to work with,  but thanks again

hxxp:jt4x4.com/smf/index.php [nonactive]

Advertisement: