Fatal Error - MSQL Error 127 from Query Delete

[severeidaho]

I searched and searched but couldnt find any info on this.  Luckily I had phpmyadmin installed and changed it to debug mode.  The error I got is below...

Fatal Error :

While executing query "delete from `MY Gallery Name Here`.cpg143_sessions where time<1181197218 and remember=0;" on Resource id #6

mySQL error: Got error 127 from storage engine

Any help would be greatly appreciated. 

BTW:  I dont remember deleting anything,  Im quite suspicious at the moment. 

-gerrit

[severeidaho]

my gallery can be found via

http://www.severeidaho.com/gallery/

Thats incase you need to check for yourself.. 

-gerrit

[severeidaho]

Had a hunch and backed up the database and then Optimized the database.  Seems to have fixed the problem. 

ISSUE=  RESOLVED

Thanks

-gerrit

[severeidaho]

ISSUE = Unresolved.

After changing debug mode back to 0 my Board went back to fatal error.  The weird thing is that my Gallery shows correctly.  Debug mode doesnt show any errors.  Yet If I click Config I get the error again.

While executing query "delete from `my gallery here`.cpg143_sessions where time<1181199730 and remember=0;" on Resource id #6

mySQL error: Server shutdown in progress


what does all this mean?

[severeidaho]

Heres another error on top of that.  Once again I clicked "Config"

While executing query "SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `my gallery here`.cpg143_users AS u INNER JOIN `MY GALLERY HERE`.cpg143_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1'" on Resource id #6

mySQL error: Server shutdown in progress

[severeidaho]

Also Noticed this error

While executing query "select * from cpg143_plugins order by priority asc;" on 0

mySQL error: Server shutdown in progress


This error occured with the url

http://www.severeidaho.com/gallery/index.php

But if you type

http://www.severeidaho.com/gallery/

then it appears to work...

[Sami]

This is a mysql server issue ... ask your host for support
your mysql server seems to be down !

fixing the table with PhpMyAdmin or similar program will solve error 127

[severeidaho]

I believe I found the problem.  Please inform me if you think it is something else.  But I remember installing Search Engine friendly urls about a month ago.  Everything worked fine till now.  Well I removed the plugin by phpmyadmin,  checked my gallery and turned debug mode off and checked Config to make sure everything worked and so far everything is fine.  Will do a couple of run thrus to make sure everything is going good.  

For now it sppears to be solved.  Sorry for all the posts.  I was trying to be as informative as possible to help hurry the solution.  

-gerrit

[Hein Traag]

It never hurts to post a lot of info 
Marking topic as solved.

[Joachim Müller]

severeidaho by PM:

Hi there, I recently posted a topic  http://forum.coppermine-gallery.net/index.php?topic=44328.0

I posted Issue Resolved,  but later found that I still had problems.  Wanted to see if you or someone else could take a look into the post at

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

And give me some feedback... 

Thanks...

-gerrit

Don't PM supporters. Just replying to this thread, saying what you had to say in your PM would have had the same effect: the thread would have been marked as "open" again. This would have caused less moderation effort and would have made me less reluctant to look into your issues.

[severeidaho]

Don't PM supporters. Just replying to this thread, saying what you had to say in your PM would have had the same effect:

Sorry about the Gaugau,  I wasnt sure if the post would be avoided due to "Solved" being there.  I know the rules now. 

I woke up today and the Gallery is offline again.  Got another error

While executing query "delete from `MY gallery here`.cpg143_sessions where time<1181243606 and remember=0;" on Resource id #6

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


I have forwarded all this info to my host in Hopes they can figure it out.  Hopefully this will be fixed by tonight. 

-gerrit

[Joachim Müller]

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

[severeidaho]

I wanted to Update this thread with my Solution since my Gallery is now fixed. 

With phpmyadmin I checked each table to see if there were errors.  The corrupted Table was cpg143_sessions , Because I couldnt repair via phpmyadmin I had to use SSH.  I simply logged in via SSH, connected to my database and repaired cpg143_sessions and Everything is up and running as It should be.  It was my Host that gave support on how to fix the database, since I had no clue on how. 

Thanks for the advice and overall support. 

ISSUE= Offically Resolved.