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
Drop the bans table and recreate it using phpmyadmin. Make backups before you delete anything if you don't know what you are doing.
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;