Site Doesn't Show Up Anymore ...

[rengels]

Here is the URL of a site I have:

http://www.remioilpaintings.com/

This site has never given me a problem until today when it showed this message:

___________________________________
jtablesession::Store Failed
DB function failed with error number 145
Table './remiceng_remioilpaintings/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`clie nt_id` ) VALUES ( 'a6f2f3ef0d8f1c1a79e665e4965a16f5','1231429437','' ,'0','1','0' )
___________________________________

Any ideas as to how to fix this?

Thanks

Remi

[Falcon1986]

I don't see any errors.

[pghcollectibles]

i dont see any errors on the main page being displayed.

if your page is working fine, dont do anything (other than maybe checking your table to see what it looks like) if you are getting that error again, the first thing i would do is go to phpMyAdmin from the cpanel.

check your tables stucture. it should look like it was made from this code:


CREATE TABLE IF NOT EXISTS `jos_session` ( `username` varchar(150) default '', `time` varchar(14) default '', `session_id` varchar(200) NOT NULL default '0', `guest` tinyint(4) default '1', `userid` int(11) default '0', `usertype` varchar(50) default '', `gid` tinyint(3) unsigned NOT NULL default '0', `client_id` tinyint(3) unsigned NOT NULL default '0', `data` longtext, PRIMARY KEY (`session_id`(64)), KEY `whosonline` (`guest`,`usertype`), KEY `userid` (`userid`), KEY `time` (`time`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
the contents of that table are not relevant as they should get deleted and new rows of data added as the time is older than whatever you have it set to in your configuration. it is the fields themselves that need to be correct.

worst case scenario:

Back up the database (even though it may be corrupted).

Select the table jos_session from the correct database,
click the drop button,
confirm you are going to delete the table and all of its contents.

then you would select the database itself,
click the sql tab,
paste the above code into the box,
(i also uncheck the box titled "Show this query here again")
click go.

that will replace your table's structure.
then you can open a new tab in your browser and go to your page,
navigate once within your site,
then you could click the browse button back on the phpmyadmin page within that table to see what data it inserted to record your session

[r2b2]

Table './remiceng_remioilpaintings/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`clie nt_id` ) VALUES ( 'a6f2f3ef0d8f1c1a79e665e4965a16f5','1231429437','' ,'0','1','0' )

Looks like your table became corrupt - might be working again now if HM support have run repairs on all the tables on that server...

[rengels]

Thank you so much people!
All seems to work well again. The tables were apparently repaired

Remi