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
my gallery can be found via
http://www.severeidaho.com/gallery/
Thats incase you need to check for yourself..
-gerrit
Had a hunch and backed up the database and then Optimized the database. Seems to have fixed the problem.
ISSUE= RESOLVED
Thanks
-gerrit
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?
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
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...
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
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
It never hurts to post a lot of info ;)
Marking topic as solved.
severeidaho by PM:
Quote from: severeidaho on June 07, 2007, 10:18:36 AM
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.
QuoteDon'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
Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145) (http://forum.coppermine-gallery.net/index.php?topic=10409.0)
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.