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&q  (Read 7762 times)

0 Members and 1 Guest are viewing this topic.

SurfDude

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
    • http://surfdude.student.utwent.nl
"There was an error while processing a database query&q
« on: October 22, 2003, 10:09:32 pm »

When I try to open my gallery, I get the error "There was an error while processing a database query". Before this, all worked just fine, and I don't think I have changed anything. What happened?
Logged
Frans AKA SurfDude || My Gallery

jasendorf

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 350
    • http://www.338tharmyband.com
"There was an error while processing a database query&q
« Reply #1 on: October 22, 2003, 10:10:45 pm »

we need a screen shot or some more information... can you turn debugging on (last option in config page)?
Logged
Read the Online DOCs,FAQ, and SEARCH the board BEFORE posting questions for help.

SurfDude

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
    • http://surfdude.student.utwent.nl
"There was an error while processing a database query&q
« Reply #2 on: October 22, 2003, 10:30:20 pm »

Quote from: "jasendorf"
we need a screen shot or some more information... can you turn debugging on (last option in config page)?

Debugmode gives this error:

Quote

While executing query "SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 4" on 0

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


File: c:\phpdev\www\fotosvoorerror\include\functions.inc.php - Line: 105
Logged
Frans AKA SurfDude || My Gallery

jasendorf

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 350
    • http://www.338tharmyband.com
"There was an error while processing a database query&q
« Reply #3 on: October 22, 2003, 10:37:05 pm »

Try repairing the table in MySQL  (perhaps through phpMyAdmin)
Logged
Read the Online DOCs,FAQ, and SEARCH the board BEFORE posting questions for help.

SurfDude

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
    • http://surfdude.student.utwent.nl
"There was an error while processing a database query&q
« Reply #4 on: October 22, 2003, 10:38:11 pm »

Quote from: "jasendorf"
Try repairing the table in MySQL  (perhaps through phpMyAdmin)

How should I do that?  :?
Logged
Frans AKA SurfDude || My Gallery

jasendorf

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 350
    • http://www.338tharmyband.com
Logged
Read the Online DOCs,FAQ, and SEARCH the board BEFORE posting questions for help.

SurfDude

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
    • http://surfdude.student.utwent.nl
"There was an error while processing a database query&q
« Reply #6 on: October 22, 2003, 11:30:46 pm »

Quote from: "jasendorf"
http://www.mysql.com/doc/en/Repair.html

I'm running my server on Windows XP. I think I have to run "myisamchk", but how do I do that with windows XP?
Logged
Frans AKA SurfDude || My Gallery

SurfDude

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
    • http://surfdude.student.utwent.nl
"There was an error while processing a database query&q
« Reply #7 on: October 22, 2003, 11:42:13 pm »

I've done a repair on that table with phpMyAdmin, and now it works all fine (again)!
Logged
Frans AKA SurfDude || My Gallery

Zarsky

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 268
    • Zerr Family Website
"There was an error while processing a database query&q
« Reply #8 on: October 22, 2003, 11:46:36 pm »

surfdude,

Congradulations on resolving your problem....primarily through your own diligence.


PS...  There is a lesson to the other grasshoppers on this board.  I think us devs are all willing to help anyone, but sometimes you have to learn to use the relevant resources widely available.
Logged
Read the Online DOCs, FAQ, and SEARCH the board BEFORE posting questions for help.

jasendorf

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 350
    • http://www.338tharmyband.com
"There was an error while processing a database query&q
« Reply #9 on: October 23, 2003, 06:12:20 am »

Quote from: "zarsky99"
PS...  There is a lesson to the other grasshoppers on this board.  I think us devs are all willing to help anyone, but sometimes you have to learn to use the relevant resources widely available.


Yeah, some devs give you fish (if they've got some spare), some teach you to fish... and then there's those like me who point at the lake and then run off for band rehearsal!
Logged
Read the Online DOCs,FAQ, and SEARCH the board BEFORE posting questions for help.
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 19 queries.