forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: severeidaho on June 07, 2007, 09:29:03 am
-
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:
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.
-
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
-
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.