Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Fatal Error - MSQL Error 127 from Query Delete  (Read 10166 times)

0 Members and 1 Guest are viewing this topic.

severeidaho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62
Fatal Error - MSQL Error 127 from Query Delete
« 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
« Last Edit: June 10, 2007, 09:40:10 pm by Nibbler »
Logged

severeidaho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #1 on: June 07, 2007, 09:30:46 am »

my gallery can be found via

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

Thats incase you need to check for yourself.. 

-gerrit
Logged

severeidaho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #2 on: June 07, 2007, 09:46:05 am »

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

ISSUE=  RESOLVED

Thanks

-gerrit
Logged

severeidaho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #3 on: June 07, 2007, 10:05:17 am »

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?
Logged

severeidaho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #4 on: June 07, 2007, 10:10:33 am »

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
Logged

severeidaho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #5 on: June 07, 2007, 10:21:18 am »

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...
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #6 on: June 07, 2007, 10:45:08 am »

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
Logged
‍I don't answer to PM with support question
Please post your issue to related board

severeidaho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #7 on: June 07, 2007, 10:48:46 am »

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
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #8 on: June 07, 2007, 10:52:31 am »

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #9 on: June 07, 2007, 12:20:12 pm »

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.
Logged

severeidaho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #10 on: June 07, 2007, 10:14:44 pm »

Quote
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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Logged

severeidaho

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62
Re: Fatal Error - MSQL Error 127 from Query Delete
« Reply #12 on: June 10, 2007, 09:37:17 pm »

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.
Logged
Pages: [1]   Go Up
 

Page created in 0.051 seconds with 19 queries.