[Solved]: There was an error while processing a database query

[donvalentine]

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

[Joe Carver]

Your version is old, you can find it when viewing the source of your pages.

<!--Coppermine Photo Gallery 1.4.19 (stable)-->

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

[Joachim Müller]

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 Expand

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.

[donvalentine]

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!