Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: [Solved]: Fatal error: --possibly due to MYSQL upgrade?  (Read 4866 times)

0 Members and 1 Guest are viewing this topic.

mcoates

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
[Solved]: Fatal error: --possibly due to MYSQL upgrade?
« 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


« Last Edit: February 26, 2008, 07:47:20 am by Joachim Müller »
Logged

mcoates

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Fatal error: --possibly due to MYSQL upgrade?
« Reply #1 on: February 26, 2008, 12:07:27 am »

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

Logged

Nibbler

  • Guest
Re: Fatal error: --possibly due to MYSQL upgrade?
« Reply #2 on: February 26, 2008, 12:31:03 am »

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

Code: [Select]
REPAIR TABLE cpg_sessions
Logged

mcoates

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Fatal error: --possibly due to MYSQL upgrade?
« Reply #3 on: February 26, 2008, 12:52:39 am »

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?
Logged

Nibbler

  • Guest
Re: Fatal error: --possibly due to MYSQL upgrade?
« Reply #4 on: February 26, 2008, 12:54:57 am »

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

mcoates

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Fatal error: --possibly due to MYSQL upgrade?
« Reply #5 on: February 26, 2008, 01:13:02 am »

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!!!
Logged

AngelC

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 35
    • Fotos de San Sebastián - Imagenes de Donosti
Re: Fatal error: --possibly due to MYSQL upgrade?
« Reply #6 on: April 15, 2008, 06:51:07 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?

Nibbler

  • Guest
Re: [Solved]: Fatal error: --possibly due to MYSQL upgrade?
« Reply #7 on: April 15, 2008, 10:09:17 am »

Run update.php.
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 19 queries.