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
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
Just click on the SQL tab and type in the query.
REPAIR TABLE cpg_sessions
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?
Drop the table and then run update.php to restore it.
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!!!
Quote from: Nibbler on February 26, 2008, 12:54:57 AM
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?
Run update.php.