coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: sevedd on May 30, 2006, 07:13:16 AM

Title: mySQL error: Unknown column 'brute_force' in 'where clause'
Post by: sevedd on May 30, 2006, 07:13:16 AM
Just upgraded from 1.3 to 1.4.6 and I received the following on the index page.

QuoteWhile executing query "SELECT * FROM cpg132_banned WHERE (ip_addr='68.204.239.97' OR ip_addr='68.204.239.97' OR user_id=0) AND brute_force=0" on 0

mySQL error: Unknown column 'brute_force' in 'where clause'
Title: Re: mySQL error: Unknown column 'brute_force' in 'where clause'
Post by: Joachim Müller on May 30, 2006, 07:15:55 AM
Make sure that you have run update.php during the upgrade process. Make sure that your mysql user has ALTER privileges. Post a link to your coppermine gallery.
Title: Re: mySQL error: Unknown column 'brute_force' in 'where clause'
Post by: sevedd on May 30, 2006, 07:20:37 AM
Yes I have Alter Priv and I ran the update. www.EaselArt.com/Gallery (http://www.easelart.com)
Title: Re: mySQL error: Unknown column 'brute_force' in 'where clause'
Post by: Joachim Müller on May 30, 2006, 07:28:17 AM
I doubt that you performed the update script (http://www.easelart.com/Gallery/update.php) successfully, because when I try to access it, I get an internal error (500).

Joachim

P.S. Avoid capital letters in URLs under all circumstances (www.easelart.com/Gallery/ is not the same thing as www.easelart.com/gallery/)!
Title: Re: mySQL error: Unknown column 'brute_force' in 'where clause'
Post by: sevedd on May 30, 2006, 07:43:00 AM
I ran the update gallery before I posted and it returned an error that I found a fix for here on the forums. It was missing a sessions table. I ran the script manually and I was able to get to the main page now. However I can not get past the Unknown column error. I apologize for the spelling, I created the site last year.
Title: Re: mySQL error: Unknown column 'brute_force' in 'where clause'
Post by: sevedd on May 30, 2006, 01:46:26 PM
I am not sure what you did, however THANK YOU.. It's working now, and all I have to do is turn off the debug mode. Thank you I really appreciate the help.