Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Fatal Error - MSQL Error 127 from Query Delete  (Read 10165 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.024 seconds with 20 queries.