[Solved]: Fatal Error. Debugged already, what to do next?

[VikiL]

Hello,

My gallery: http://viiki-world.net/gallery

My gallery was working last night when I checked but when I went to my site today, the link to my gallery shows "fatal error." I read some topics here saying that I should go to "debug mode." I did and now I receive the following message:

"While executing query "delete from `coppermine`.cpg14x_sessions where time<1228709486 and remember=0;" on Resource id #6

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

Did I get hacked? What should I do?

Thanks so much in advance! I am not very good with this business so please be patient with me.

[François Keller]

a quick search on this board with your error message give this result
http://forum.coppermine-gallery.net/index.php/topic,10409.0.html
next time search the board before asking for support 

[VikiL]

I did search and I found the same thread. However, where do you change the table name? I logged onto my phpMyAdmin but I don't where where to "Replace cpg131_pictures with your table name" What is "my table name"? Can you give me an example?

[François Keller]

While executing query "delete from `coppermine`.cpg14x_sessions

your table name is cpg14x_sessions (it's in th error message)

[VikiL]

Hi, I must sound really stupid or something...

so do I replace "cpg131_pictures" to "cpg14x_sessions"? If so, where can I do that in the database?

Thanks in advance! Sorry but I am very slow with this stuff.

[Fabricio Ferrero]

If you read carefully the thread that François linked it says:

The error:

Can't open file: 'cpg131_pictures.MYI'. (errno: 145)

The problem:

Your table is corrupted.

The solution:

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)

And, the answer in that thread it says:

ask your webhost for support, this issue is not directly related to coppermine.

So please, do a little bit of learning before keep posting...

[VikiL]

Hi,

I would love to learn but you can direct me to a place to learn how to fix this problem?

I asked my webhost for help but they said they don't support third-party stuff...if you guys are not suppose to help me since it's not a coppermine problem, can you direct me to a place where I can fix this?

Now I've got this problem...the error message changed.

"While executing query "delete from `coppermine`.cpg14x_sessions where time<1228767558 and remember=0;" on Resource id #6

mySQL error: File './coppermine/cpg14x_sessions.MYD' not found (Errcode: 13)"

[Nibbler]

Go into phpmyadmin, click on the SQL tab and enter

Code Select Expand

REPAIR TABLE `coppermine`.cpg14x_sessions

Then press 'Go'. If that doesn't help run this instead and then run update.php.

Code Select Expand

DROP TABLE `coppermine`.cpg14x_sessions

[Joachim Müller]

And tell your webhost that the issue does not lie within a "third party application". The database is broken. This usually happens if there is something wrong with the server setup. That is the business of your webhost and none of ours. If your webhost is so ignorant and doesn't realize that, you better look for a new webhost.

[VikiL]

Thank you Nibbler, the first code solve the problem!