Im collating my problems in this post.
I am getting this message when banning someone of the webpanel:
Duplicate entry '0' for key 1
SQL Query type: EXECUTE
Script: '/sourcebans/index.php'
SQL Query: INSERT INTO sb_log(type,title,message, function, query, aid, host, created) VALUES ('m','Ban Added','Ban against (STEAM_0:1:112) has been added, reason: Cheats, length: 0','/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/xajax.inc.php - 1095
/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/includes/xajax.inc.php - 744
/mounted-storage/home59c/sub001/sc37219-RPSA/www/sourcebans/index.php - 21
','N/A','1','78.86.4.24',1212955056)
SQL Params:
In my sourcebans.sql ive noticed this new ban is now starting with banid 0, instead of continuing from the last ban. There is 791 bans in my database, so it should start from 792 instead of 0. But strangely enough, the ban DOES go in the database. After this 1st ban, i cant ban anymore as i get the same message
I attach my sourcebans.sql, i hope someone can help me as i figure the error is stemming from this file
www.dragonrock.org/sourcebans.sql