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: [Solved]: There was an error while processing a database query  (Read 4361 times)

0 Members and 1 Guest are viewing this topic.

donvalentine

  • Coppermine newbie
  • Offline Offline
  • Posts: 2

Hello, I have put my board into DeBug mode, but I am not sure of the version of Coppermine I have, I don't see it listed anywhere on the gallery. I goofed something up, I deleted the cpg1410_banned table because I misunderstood some instructions I found online for unbanning myself from my gallery. Now the gallery tells me:  There was an error while processing a database query

I didn't find any google documentation on how to restore the table and was hoping someone here could help me.

Here is my gallery: http://www.pottstownpc.com/gallery

Thanks in advance!

Don
« Last Edit: May 29, 2009, 03:36:20 pm by Nibbler »
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: There was an error while processing a database query
« Reply #1 on: May 29, 2009, 01:54:24 pm »

Your version is old, you can find it when viewing the source of your pages.
Quote
<!--Coppermine Photo Gallery 1.4.19 (stable)-->

If you have made a backup of your database,
Google search like this.

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: There was an error while processing a database query
« Reply #2 on: May 29, 2009, 02:01:11 pm »

Don't be afraid - the banned table doesn't contain vital information. You just need to re-create the missing table - even if you don't have a backup.
Run the query
Code: [Select]
CREATE TABLE cpg1410_banned (
        ban_id int(11) NOT NULL auto_increment,
        user_id int(11) DEFAULT NULL,
        ip_addr tinytext,
        expiry datetime DEFAULT NULL,
        brute_force tinyint(5) NOT NULL default '0',
        PRIMARY KEY  (ban_id)
) TYPE=MyISAM COMMENT='Data about banned users';
in phpMyAdmin and you should be fine. In the future, be more carefull before messing with the database - usually, there is no such soft recovery possible.
Logged

donvalentine

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: There was an error while processing a database query
« Reply #3 on: May 29, 2009, 02:48:54 pm »

Awesome, thanks so much! I am not very proficient (<-spelling) in MySQL stuff, lol.

I ran that query and the gallery is back! Thanks so much again. You rock!
Logged
Pages: [1]   Go Up
 

Page created in 0.055 seconds with 19 queries.