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: mySQL error: Unknown column 'brute_force' in 'where clause'  (Read 5516 times)

0 Members and 1 Guest are viewing this topic.

sevedd

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
mySQL error: Unknown column 'brute_force' in 'where clause'
« 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.

Quote
While 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'
« Last Edit: May 30, 2006, 02:03:28 pm by Nibbler »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mySQL error: Unknown column 'brute_force' in 'where clause'
« Reply #1 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.
Logged

sevedd

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: mySQL error: Unknown column 'brute_force' in 'where clause'
« Reply #2 on: May 30, 2006, 07:20:37 am »
Yes I have Alter Priv and I ran the update. www.EaselArt.com/Gallery
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mySQL error: Unknown column 'brute_force' in 'where clause'
« Reply #3 on: May 30, 2006, 07:28:17 am »
I doubt that you performed the update script 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/)!
Logged

sevedd

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: mySQL error: Unknown column 'brute_force' in 'where clause'
« Reply #4 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.
Logged

sevedd

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: mySQL error: Unknown column 'brute_force' in 'where clause'
« Reply #5 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.
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.017 seconds with 16 queries.