coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: richardkers on August 09, 2004, 10:12:57 AM

Title: There was an error while processing a database query.
Post by: richardkers on August 09, 2004, 10:12:57 AM
Can someone help me please, i cant resolve this problem!!
It occurt when i uploaded a cople of photo´s

Thanks





Kritieke fout

There was an error while processing a database query.

While executing query "SELECT count(*) FROM cpg11d_albumspictures, cpg11d_albumsalbums WHERE cpg11d_albumspictures.aid = cpg11d_albumsalbums.aid AND category >= 10000" on 0

mySQL error: Can't open file: 'cpg11d_albumspictures.MYD'. (errno: 145)



Bestand: /home/virtual/site8/fst/var/www/html/fotoalbum/include/functions.inc.php - Regel: 105




Debug info
USER:
Array
(
    [ID] => 2073dfc5a4bfd9bfb04214ae39441201
    [am] => 1
)


GET :
Array
(
)


POST :
Array
(
)


Page generated in 0.042 seconds - 8 queries in 0.002 seconds - Album set : 
Advanced debug mode (phpinfo)
Title: Re: There was an error while processing a database query.
Post by: Casper on August 09, 2004, 11:30:45 AM
QuotemySQL error: Can't open file: 'cpg11d_albumspictures.MYD'. (errno: 145)

This means your table is probably corrupt.

Use you database tool to browse to the pictures table, click on 'operation', then repair.
Hopefully that will sort it.
Title: Re: There was an error while processing a database query.
Post by: richardkers on August 09, 2004, 06:51:42 PM
Witch database tool do you mean and where do i find mij pictures table??

thanks,



Quote from: Casper on August 09, 2004, 11:30:45 AM
QuotemySQL error: Can't open file: 'cpg11d_albumspictures.MYD'. (errno: 145)

This means your table is probably corrupt.

Use you database tool to browse to the pictures table, click on 'operation', then repair.
Hopefully that will sort it.
Title: Re: There was an error while processing a database query.
Post by: Casper on August 09, 2004, 08:47:45 PM
the table is in the database that coppermine uses.

You need a tool like phpmyadmin to work on the database.  Most hosts give you a tool like this to use.
Title: Re: There was an error while processing a database query.
Post by: tmonkey on August 16, 2004, 06:54:59 PM
I was getting the same message when i had an apostophe in the folder name that contained the photos. I deleted the album and recreated it after changing the folder name.
Title: Re: There was an error while processing a database query.
Post by: bit bit spears on August 17, 2004, 05:46:05 AM
yes! that was the problem for me months ago, i finally tried clicking repair on the table that looked corrupt, and viola! it worked.