forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: mcoates on February 25, 2008, 11:26:28 pm
-
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!!!
-
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.