Server crashed, now this

[PROxac]

When I try to access my admin area I get this:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /xxx/xxx/xxx/xxx/xxx/admin/includes/functions/database.php on line 45

1194 - Table 'sessions' is marked as crashed and should be repaired

 

select value from sessions where sesskey = 'xxxxxxxxxxxxxxxx' and expiry > 'xxxxxxxxxx'

 

[TEP STOP]

What do I do to fix it? HELP :(

[PROxac]

1) Go to you ISPs admin area for your site.

 

2) Click on the icon for Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your host.

 

3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box.

 

4) Click on the table to be repaired in the let hand column.

 

5) Click on the Operation tab.

 

6) Click on Repair table and duck.

Found that in another thread. It seems to have done the trick! *wipes forehead off*

 

Thanks

[♥geoffreywalton]

Thought I recognised my SOH.

 

Anyway don't you just love google.

[PROxac]

Anyway don't you just love google.

Best ever! B)

[warrenerjm]

Thought I recognised my SOH.

 

Anyway don't you just love google.

Hi Geoffrey :)

 

My cPanel doesn't seem to be able to repair the table? But I could be missing something.

 

I have contacted my hosts (was Supanames which were great but 123-reg took over & they are C**p!)

 

1194 - Table 'sessions' is marked as crashed and should be repaired

select value from sessions where sesskey = '0ddcf78e1d70b7d95556a41967d35306' and expiry > '1274699464'

[TEP STOP]

 

Please help :)

 

Thanks

Julie

[warrenerjm]

The operations tab has this Table 'sessions' is marked as crashed and should be repaired

 

Searching I see a suggestion for the sql tab which is showing as normal.

 

SELECT * FROM `sessions` WHERE 1 (do I keep this or replace it with) repair table sessions;

 

Would this work??????????

 

Thanks

Julie

[♥mdtaylorlrim]

The operations tab has this Table 'sessions' is marked as crashed and should be repaired

 

Searching I see a suggestion for the sql tab which is showing as normal.

 

SELECT * FROM `sessions` WHERE 1 (do I keep this or replace it with) repair table sessions;

 

Would this work??????????

 

Thanks

Julie

Try this...

 

 

Delete from sessions

 

 

All it will do is empty the sessions table keeping the structure intact. If it still fails we will have to rebuild the structure.