Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: There was an error while processing a database query.  (Read 3650 times)

0 Members and 1 Guest are viewing this topic.

richardkers

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
There was an error while processing a database query.
« 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)
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: There was an error while processing a database query.
« Reply #1 on: August 09, 2004, 11:30:45 am »

Quote
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.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

richardkers

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: There was an error while processing a database query.
« Reply #2 on: August 09, 2004, 06:51:42 pm »

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

thanks,



Quote
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.
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: There was an error while processing a database query.
« Reply #3 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.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

tmonkey

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: There was an error while processing a database query.
« Reply #4 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.
Logged

bit bit spears

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 240
    • TangibleBrit.com
Re: There was an error while processing a database query.
« Reply #5 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.