'There was an error while processing a database query.' 'There was an error while processing a database query.'
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

'There was an error while processing a database query.'

Started by tearcharmer, January 31, 2006, 06:43:41 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

tearcharmer

This is the second time I have received this message. It seems like anytime I upload my images in batches, this happens. The first time it happened, I uninstalled and reinstalled Coppermine. Now tonight, I was uploading some 900+ movie screencaps and when I went to go refresh the page, I got the same error message again and nothing can be accessed. I put the gallery into debub mode and it is telling me this is my error:

Quote
While executing query "SELECT sum(hits) FROM cpg143_pictures as p LEFT JOIN cpg143_albums as a ON p.aid=a.aid WHERE 1" on 0

mySQL error: Got error 127 from storage engine


I'd just like to know how I can fix this problem so it won't keep happening over and over again and where do I even begin, as to correct the problem. I understand that it seems to be predominately a mySQL error. But, I need as much help as I can get, as I don't understand mySQL and phpmyadmin very well and how it is associated with Coppermine itself.

Thanks in advance.

Abbas Ali

Chief Geek at Ranium Systems

tearcharmer

I do search before posting. I actually did for 10 minutes before posting this. But after a while, it just gets a little ridiculous.

I apologize. I'll check those links out.