CPG worked all fine, now error and totally down, help?

[Syree]

Hello everyone, its been a while since i've been here, with a lot of help from the devs here, i got my gallery up and running for a good while. All seemed to be fine untill i just got home from my honeymoon and saw only "fatal error: " and thats it when visiting my gallery. I have no idea what happened, i didn't touched anything in the gallery and already asked m y host about it. They said its an error in the script. I've deleted the install lock file, and tried to re install, but when doing that i got the following error:

mySQL Error: Table 'cpg140_albums' already exists on query ' CREATE TABLE cpg140_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL, visibility int(11) NOT NULL default '0', uploads enum('YES','NO') NOT NULL default 'NO', comments enum('YES','NO') NOT NULL default 'YES', votes enum('YES','NO') NOT NULL default 'YES', pos int(11) NOT NULL default '0', category int(11) NOT NULL default '0', thumb int(11) NOT NULL default '0', keyword VARCHAR( 50 ), alb_password VARCHAR( 32 ), alb_password_hint TEXT, PRIMARY KEY (aid), KEY alb_category (category) ) TYPE=MyISAM'

Now i have NO idea how to take care of this error, could anyone help me out? And i have no idea how it got there lol...thanks in advance!
My gallery is located here: http://www.janetplanet-pictures.net/gallery

[Syree]

Ok, i found a somewhat similar topic, and followed the instructions to put it in debug mode. Now on the left side of my phpadmin panel, before i put it in debug mode, there was already the following notice:

SQL-query: 

SELECT COUNT( * ) AS num
FROM `janet_pics`.`cpg140_sessions`

MySQL retourneerde: 

#1016 - Can't open file: 'cpg140_sessions.MYI' (errno: 145)


And now when i visit my gallery, i get this:

While executing query "delete from `janet_pics`.cpg140_sessions where time<1148847046 and remember=0;" on Resource id #6

mySQL error: Can't open file: 'cpg140_sessions.MYI' (errno: 145)

I'm puzzled.......

[Nibbler]

Please read the sticky that explains how to fix this error.

[Syree]

Nibbler, tnx for responding, i'm doing that now...but the problem i have, is that i can't even find the table cpg140_sessions.... it seems to be not there? So weird.. I'm in phpadmin now, do you know where i should look to find this table?

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php?topic=10409.0

[Syree]

yeah thats the one i'm reading now...

Use your website's Control Panel to repair the table, or use phpMyAdmin to execute this sql query: repair table cpg131_pictures
(Replace cpg131_pictures with your table name)

Now i'm embarrassed to ask this question, but how do I execute a sql query??? I'm sorry but this is totally new to me, i'm inside phpmyadmin, and trying to find this table of mine cpg140_sessions but its not there so far...I must be overlooking something?

[Joachim Müller]

You run a query in phpMyAdmin by going to the tab labelled "SQL".

[Syree]

THANKS!!!! i did it and it works now Thanks for the help!

ps. Is there anything i can do to prevent this from happening in the future? I mean that tables get corrupted? Just asking, maybe its someting simple to prevent it lol

[Syree]

......it was all fine again..and now some other error appears, maybe you could look at this?

While executing query "SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg140_albums as a LEFT JOIN cpg140_pictures as p ON a.thumb=p.pid WHERE category=2 ORDER BY a.pos LIMIT 0,4" on 0

mySQL error: Got error 127 from storage engine

(and on top it said - translated from dutch - "unable to get data from the database")

Any idea how i can fix this?

[Nibbler]

MySQL error code 127: Record-file is crashed

Try a repair or contact your host.

[Syree]

Nibbler, how do i do this repair?? Cause my host isn't particularly helpfull unfortunately ...i dont'even know where i can find this thing lol...i know i sound dumb now, but if you could tell me how i can do this repair i'd be happy! Thanks!

[Stramm]

phpmyadmin -> select the table -> Operations ->  Repair table
or ask your host