Bug #86
Bans from server do not add to database
| Status : | Closed | Start : | 06/16/2008 | |
| Priority : | Normal | Due date : | ||
| Assigned to : | - | % Done : | 0% |
|
| Category : | - | |||
| Target version : | - | |||
Description
I started with a fresh install and removed:
`lastvisit` DATETIME NULL,
with a clean database. Installed successfully and everything works fine. The game server auto added itself to the database however bans and the record of blocked users is not being updated in the database. I have the latest version of all files and I am banning via the menu so that a reason is aways defined. I was told that it could be an indexing issue in the table or something like that but I have checked the release notes to the latest changes to the install directory and say nothing that would have fixed that. Besides if the change to the install directory was the removing of `lastvisit` DATETIME NULL, to correct the install error than nothing will change as I already had it removed before proceeding with the install.
If there is a way to modify the table manually to fix it once you guys figure out the problem let me know, I have phpmyadmin and can go fix just that table so that it works.
Error is shown as:[ERROR] Query Failed: Duplicate entry '208.43.3.160-27015' for key 2
History
06/25/2008 10:14 AM - Jon H
Are you using the latest SVN release of sourcebans available from the website? You shouldn't need to edit the install at all using that version.
06/25/2008 09:37 PM - ZERO ibis
I installed from a fresh install with 1.1.1b when the install was having problems I was told to remove that line thus fixing it. I wiped the database before the final install that did work. Currently I am running 1.1.1c(although i am still running the same database created by 1.1.1b after the file edit)
07/02/2008 03:01 AM - Jon H
That error would tend to say that the server trying to add itself to the database twice... you can try setting the server id in the config file in an attempt to fix it.
07/22/2008 12:03 AM - Erik Minekus
Is this still a problem? It seems to be the same as #162, apart from it showing a way different error.