MySQL update --> Fatal error

[jamku]

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

The 1.3.2 version seems to work just fine though. At 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!

[kegobeer]

Have you asked your host about this yet?

[jamku]

of course. thats how i got noted that the mysqlversion had been updated around the time my gallery went broken.

[Nibbler]

http://coppermine-gallery.net/tutorial/debug_mode.php

[jamku]

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)

[Sami]

Repair the table (cpg143_sessions) by phpmyadmin

[jamku]

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.. :'(

[Nibbler]

They can fix it, but it's better if you learn how to fix thimgs like this yourself.

[Sami]

You can find the solution on mysql.org
Just search "repair table " there

[jamku]

a million thanks to you guys.. i love you

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