[Solved]: Fatal error: --possibly due to MYSQL upgrade?

[mcoates]

Hello All,

When I tried to open my gallery recently I got 'Fatal error:'.  I haven't made any changes to my gallery but my webhost says it's because they updated to msql 5 and I didn't update my scripts.  I am running coppermine 1.4.12.  I tried to update to 1.4.16 and the upgrade would not work because of the 'Fatal error:'.

When I enabled coppermine debug I got the following additional information:

"While executing query "delete from `jamieand_copp1`.cpg_sessions where time<1203974220 and remember=0;" on Resource id #5

mySQL error: Table './jamieand_copp1/cpg_sessions' is marked as crashed and should be repaired"

My webhost said that I need to restore my database from a backup.  I tried this but it did nothing.  They were incredibly unhelpful and said I would need to restart from scratch. 

Hopefully this is not true and there is something I can do to restore my gallery?  Any help or suggestions will be much appreciated THANK YOU!

Melissa

[mcoates]

Just some additional information:

I have read both these posts:
http://forum.coppermine-gallery.net/index.php/topic,10409.0.html
http://forum.coppermine-gallery.net/index.php/topic,50701.0.html

Which seem to be similar to my problem.  However, I'm not very familiar with phpmyadmin and I am not sure where to run this repair command from. 

If I select the table which needs repair 'cpg_sessions':
>>>
Error

SQL query: Edit

SHOW INDEX FROM `cpg_sessions` ;

MySQL said: Documentation
#145 - Table './jamieand_copp1/cpg_sessions' is marked as crashed and should be repaired
>>>

And then go to the 'operations' tab.  Under table maintenance all I see is 'Flush Table'.  I don't know what flushing does but it doesn't sound good.  With other tables I see a repair table option but not with this table.  So.....where can I run the sql query repair table? 

Thanks in advance.
Melissa

[Nibbler]

Just click on the SQL tab and type in the query.

Code Select Expand

REPAIR TABLE cpg_sessions

[mcoates]

Thank you,

When I tried that I got:

SQL result

Host: localhost
Database: jamieand_copp1
Generation Time: Feb 25, 2008 at 05:49 PM
Generated by: phpMyAdmin 2.11.4 / MySQL 5.0.45-community-log
SQL query: REPAIR TABLE cpg_sessions;
Rows: 1
Table    Op    Msg_type    Msg_text
jamieand_copp1.cpg_sessions    repair    status    Table is already up to date

However, it doesn't seem to fix anything.  I get the same error when trying to access my gallery and the same error in phpmyadmin when I go back to the browse table tab or the structure tab for cpg_sessions.

Any other suggestions?

[Nibbler]

Drop the table and then run update.php to restore it.

[mcoates]

Thanks VERY much!!!

That worked.  It just took me some searching to learn how to run update.php

For reference of anyone else following this thread I did it by typing

www.jamieandmelissa.org/coppermine/update.php into my browser.  Where www.jamieandmelissa.org/coppermine/ is where I have my coppermine gallery. 

Thanks again, I am very glad I did not have to start from scratch as my webhosting tech support suggested!!!

[AngelC]

Drop the table and then run update.php to restore it.

Hi, i have a similar problem but i try drop and update,,,and i drop the sessions table, but now i cant update and debug mode says that sessions tables doesnt exists... how i can create new session table and run again the coppermine?

[Nibbler]

Run update.php.