There was an error while processing a database query.

[richardkers]

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)

[Casper]

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

[richardkers]

Witch database tool do you mean and where do i find mij pictures table??

thanks,

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

[Casper]

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.

[tmonkey]

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.

[bit bit spears]

yes! that was the problem for me months ago, i finally tried clicking repair on the table that looked corrupt, and viola! it worked.