Fatal error :There was an error while processing a database query. BANNED

[Doggie]

right... where do I start??

I had a working site but when a friend of mine tried to login 6 times with an account that I had previously deleted he got banned... Not only did he get banned but so did I and anyone else who visited the page (unregistered folk)

I "may" have deleted a couple of things from the database in phpMyAdmin

I have enabled debug mode to 1 and this is the message I get now


While executing query "SELECT * FROM albm_banned WHERE ip_addr='127.0.0.1' OR ip_addr='81.182.238.23' OR user_id=0" on 0

mySQL error: Unknown column 'ip_addr' in 'where clause'

Please help me as I had a lot of photos on my site

the site is http://www.komoroczy.hu/index.php

[Nibbler]

Drop the bans table and recreate it using phpmyadmin. Make backups before you delete anything if you don't know what you are doing.

Code Select Expand


DROP TABLE albm_banned;

CREATE TABLE albm_banned (
        ban_id int(11) NOT NULL auto_increment,
        user_id int(11) DEFAULT NULL,
        ip_addr tinytext DEFAULT NULL,
        expiry datetime DEFAULT NULL,
        brute_force tinyint(5) NOT NULL default '0',
        PRIMARY KEY  (ban_id)
) TYPE=MyISAM;