[solved] Sql-problem with stats and bots
1 Attachment(s)
I'm getting this error on every map change:
Code:
L 01/26/2021 - 18:52:56: [gungame.amxx] Could not execute query [INSERT INTO `gg_stats` (authid,name,timestamp,wins,points,streak,serverip) VALUES ('BOT','Deadlynome','1611683576','0','21','0','89.163.190.40:27515'),('BOT','Firestorm','1611683576','0','21','0','89.163.190.40:27515'),('BOT','bussemann','1611683576','0',] -- err #1062 [Duplicate entry 'BOT-89.163.190.40:27515' for key 'PRIMARY']
status
meta list
amxx list
I'm using the original gungame 2.13c except added 2 letters in client_disconnected-funktion to prevent the warning. |
Re: Sql-problem with stats and bots
The error provides from duplicate entry:
"[Duplicate entry 'BOT-89.163.190.40:27515' for key 'PRIMARY']" Because Bots have as steamid 'BOT' and a PRIMARY KEY in MySQL can't be duplicated: PRIMARY KEY(`authid`,`serverip`) see line 8467 in gungame.sma. |
Re: Sql-problem with stats and bots
How to fix it?
|
Re: Sql-problem with stats and bots
Well, try setting PRIMARY KEY(`authid`,`serverip`) in PRIMARY KEY(`name`,`serverip`)
|
Re: Sql-problem with stats and bots
If I could change the code I would not have asked (or not here but in scripting help) :wink:
EDIT: Memo to self: read the f**ing cvars: Quote:
|
All times are GMT -4. The time now is 10:32. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.