Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 permissions => Topic started by: doRm on August 07, 2006, 08:01:16 AM

Title: Error - mysql query
Post by: doRm on August 07, 2006, 08:01:16 AM
There's an error in my gallery - http://gallery.exweb.org. In czech "Vyskytla se chyba při databázovém dotazu." and in english it's something like that: "There's an error with mysql query". Do you know what it is?
Title: Re: Error - mysql query
Post by: Sami on August 07, 2006, 08:20:58 AM
enable debug mode and post the actual Error
Title: Re: Error - mysql query
Post by: Joachim Müller on August 07, 2006, 10:56:33 AM
http://coppermine-gallery.net/tutorial/debug_mode.php
Title: Re: Error - mysql query
Post by: doRm on August 08, 2006, 08:54:24 AM
hi,

While executing query "SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000" on 0

mySQL error: Can't open file: 'cpg132_pictures.MYI' (errno: 145)

Title: Re: Error - mysql query
Post by: Sami on August 08, 2006, 09:00:25 AM
Your cpg132_picture is cruppted
Eiher use phpmyadmin to repair that table or use repair option under mysql database section of your hosting control panel (if you have)
Title: Re: Error - mysql query
Post by: Joachim Müller on August 08, 2006, 09:20:54 AM
FAQ-thread: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145) (http://forum.coppermine-gallery.net/index.php?topic=10409.0)
Title: Re: Error - mysql query
Post by: doRm on August 08, 2006, 12:52:46 PM
ahhh :-) Thanks!!!  :-*
Title: Re: Error - mysql query
Post by: Joachim Müller on August 08, 2006, 12:56:40 PM
In the future, search for your error message.
Text only | Text with Images