coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: jamku on September 23, 2006, 10:57:45 AM

Title: MySQL update --> Fatal error
Post by: jamku on September 23, 2006, 10:57:45 AM
Hi all, sorry if this already has been asked, tried to seek answer to this with no luck.

I'm running two versions of coppermine, 1.3.2 and 1.4.3.
My ISP updated their MySQL-version, and at that point, the 1.4.3 version completely stopped working. just shows "Fatal error:" at a blank page. See it at: http://www.karstyling.org/gallery/index.php (http://www.karstyling.org/gallery/index.php)

The 1.3.2 version seems to work just fine though. At http://jamku.laatikko.org/cpg132/index.php (http://jamku.laatikko.org/cpg132/index.php)

ATM, i'm trying to solve the versionnumbers between those two MySQL-versions, will post them in here ASAP.

If anyone could help, i would be more than thankful!
Title: Re: MySQL update --> Fatal error
Post by: kegobeer on September 23, 2006, 01:12:53 PM
Have you asked your host about this yet?
Title: Re: MySQL update --> Fatal error
Post by: jamku on September 23, 2006, 03:03:06 PM
of course. thats how i got noted that the mysqlversion had been updated around the time my gallery went broken.
Title: Re: MySQL update --> Fatal error
Post by: Nibbler on September 24, 2006, 12:21:47 AM
http://coppermine-gallery.net/tutorial/debug_mode.php
Title: Re: MySQL update --> Fatal error
Post by: jamku on September 24, 2006, 11:41:50 AM
debug-mode gave the following:

While executing query "delete from `krst06`.cpg143_sessions where time<1159087171 and remember=0;" on Resource id #6

mySQL error: Can't open file: 'cpg143_sessions.MYI' (errno: 145)
Title: Re: MySQL update --> Fatal error
Post by: Sami on September 24, 2006, 11:46:29 AM
Repair the table (cpg143_sessions) by phpmyadmin
Title: Re: MySQL update --> Fatal error
Post by: jamku on September 24, 2006, 12:43:36 PM
sorry, but i have absolutely no idea about how that is done. maybe i could ask my host to take care of it? that is, if noone can help me out step by step.. :'(
Title: Re: MySQL update --> Fatal error
Post by: Nibbler on September 24, 2006, 12:45:45 PM
They can fix it, but it's better if you learn how to fix thimgs like this yourself.
Title: Re: MySQL update --> Fatal error
Post by: Sami on September 24, 2006, 01:04:20 PM
You can find the solution on mysql.org
Just search "repair table " there
Title: Re: MySQL update --> Fatal error
Post by: jamku on September 24, 2006, 02:18:06 PM
a million thanks to you guys.. i love you :P

the gallery is working now, and everything's okay..

:-*