search

Lexicality / applejack

The private version of Applejack with loads of improvements and stuff (Side note - this has nothing to do with ponies)
4 stars 1 forks source link

Duplicate entries in the mysql #67

Closed DanChap95 closed 10 years ago

DanChap95 commented 10 years ago

This bug only affects certain people. For now I have saw it happen with TJ and Syff. But didn't happen with me, Shepsie or Jonesy. This happens each time they join the server, and the db saying they have a duplicate entry thus not loading their profile. 

[04/25/14 00:02:53] ||VM|| DanC [STEAM_0:1:34566661|46.64.124.43:50861]: /giveitem syff money 10000
ServerLog: [Event] ||VM|| DanC gave ||VM|| Syff 10000 Dollars.
[Event] ||VM|| DanC gave ||VM|| Syff 10000 Dollars.
ServerLog: [Commands] ||VM|| DanC ran the command giveitem "Player [1][||VM|| Syff]" "money" "10000"
[Commands] ||VM|| DanC ran the command giveitem "Player [1][||VM|| Syff]" "money" "10000"
[04/25/14 00:02:54] ||VM|| DanC [STEAM_0:1:34566661|46.64.124.43:50861]: /save
ServerLog: [Debug] SQL Statement for "||VM|| Syff": UPDATE cider SET _Arrested = "false", _Money = 10000, _UniqueID = "2224447849", _Donator = 0, _SteamID = "STEAM_0:1:2674941", _Name = "||VM|| Syff", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = -2070519447
[Debug] SQL Statement for "||VM|| Syff": UPDATE cider SET _Arrested = "false", _Money = 10000, _UniqueID = "2224447849", _Donator = 0, _SteamID = "STEAM_0:1:2674941", _Name = "||VM|| Syff", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = -2070519447
ServerLog: [Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10000, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "chinese_takeout: 5; health_vial: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
[Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10000, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "chinese_takeout: 5; health_vial: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
ServerLog: [Event] ||VM|| DanC saved everyone's profiles.
[Event] ||VM|| DanC saved everyone's profiles.
ServerLog: [Commands] ||VM|| DanC ran the command save
[Commands] ||VM|| DanC ran the command save
ServerLog: [Debug] SQL Statement successful for "||VM|| Syff"
[Debug] SQL Statement successful for "||VM|| Syff"
ServerLog: [Debug] SQL Statement successful for "||VM|| DanC"
[Debug] SQL Statement successful for "||VM|| DanC"
[04/25/14 00:03:00] ||VM|| Syff [STEAM_0:1:2674941|87.208.67.108:27005] disconnected from the server.
ServerLog: [Event] ||VM|| Syff (STEAM_0:1:2674941) disconnected.
[Event] ||VM|| Syff (STEAM_0:1:2674941) disconnected.
ServerLog: [Debug] SQL Statement for "||VM|| Syff": UPDATE cider SET _Arrested = "false", _Money = 10000, _UniqueID = "2224447849", _Donator = 0, _SteamID = "STEAM_0:1:2674941", _Name = "||VM|| Syff", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = -2070519447
[Debug] SQL Statement for "||VM|| Syff": UPDATE cider SET _Arrested = "false", _Money = 10000, _UniqueID = "2224447849", _Donator = 0, _SteamID = "STEAM_0:1:2674941", _Name = "||VM|| Syff", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = -2070519447
Dropped ||VM|| Syff from server (Disconnect by user.)
ServerLog: [Debug] SQL Statement successful for "||VM|| Syff"
[Debug] SQL Statement successful for "||VM|| Syff"
[04/25/14 00:03:00] ||VM|| Syff [87.208.67.108:27005] connected to the server.
Player connected "||VM|| Syff", (87.208.67.108:27005): nil,
Client "||VM|| Syff" connected (87.208.67.108:27005).
[04/25/14 00:03:27] ||VM|| Syff [STEAM_0:1:2674941|87.208.67.108:27005] spawned for the first time this session.
ServerLog: [Debug] ||VM|| Syff is new to the server. Data not loaded.
[Debug] ||VM|| Syff is new to the server. Data not loaded.
ServerLog: [Teams] ||VM|| Syff changed team to "Citizen"
[Teams] ||VM|| Syff changed team to "Citizen"
ServerLog: [Event] ||VM|| Syff finished connecting.
[Event] ||VM|| Syff finished connecting.
ServerLog: [Debug] SQL Statement for "||VM|| Syff": INSERT INTO cider (_Arrested, _Money, _UniqueID, _Donator, _SteamID, _Name, _Clan, _Blacklist, _Inventory, _Access, _Misc) VALUES("false", 0, "2224447849", 0, "STEAM_0:1:2674941", "||VM|| Syff", "", "[]", "health_vial: 5; chinese_takeout: 5", "", "[]")
[Debug] SQL Statement for "||VM|| Syff": INSERT INTO cider (_Arrested, _Money, _UniqueID, _Donator, _SteamID, _Name, _Clan, _Blacklist, _Inventory, _Access, _Misc) VALUES("false", 0, "2224447849", 0, "STEAM_0:1:2674941", "||VM|| Syff", "", "[]", "health_vial: 5; chinese_takeout: 5", "", "[]")
[04/25/14 00:03:27][Errors] SQL Error in "||VM|| Syff"'s save: Duplicate entry '2224447849' for key 'PRIMARY'
[||VM|| DanC|4|STEAM_0:1:34566661] Lua Error:
[04/24/14 23:07:38][Errors] SQL Error in "||VM|| Syff"'s save: Duplicate entry '2224447849' for key 'PRIMARY'

[||VM|| Syff|5|STEAM_0:1:2674941] Lua Error:
04/25/14 00:07:40 - Finished connecting

[||VM|| Syff|5|STEAM_0:1:2674941] Lua Error:
[04/25/14 00:07:43][Errors] SQL Error in "||VM|| Syff"'s save: Duplicate entry '2224447849' for key 'PRIMARY'

[04/25/14 00:05:56] ||VM|| Syff [STEAM_0:1:2674941|87.208.67.108:27005] disconnected from the server.
ServerLog: [Event] ||VM|| Syff (STEAM_0:1:2674941) disconnected.
[Event] ||VM|| Syff (STEAM_0:1:2674941) disconnected.
ServerLog: [Debug] SQL Statement for "||VM|| Syff": UPDATE cider SET _Arrested = "false", _Money = 0, _UniqueID = "2224447849", _Donator = 0, _SteamID = "STEAM_0:1:2674941", _Name = "||VM|| Syff", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = -2070519447
[Debug] SQL Statement for "||VM|| Syff": UPDATE cider SET _Arrested = "false", _Money = 0, _UniqueID = "2224447849", _Donator = 0, _SteamID = "STEAM_0:1:2674941", _Name = "||VM|| Syff", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = -2070519447
Dropped ||VM|| Syff from server (Disconnect by user.)
ServerLog: [Debug] SQL Statement successful for "||VM|| Syff"
[Debug] SQL Statement successful for "||VM|| Syff"
ServerLog: [Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10200, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "chinese_takeout: 5; health_vial: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
[Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10200, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "chinese_takeout: 5; health_vial: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
ServerLog: [Debug] SQL Statement successful for "||VM|| DanC"
[Debug] SQL Statement successful for "||VM|| DanC"
[04/25/14 00:10:15] ||VM|| DanC [STEAM_0:1:34566661|46.64.124.43:50861]: /save
ServerLog: [Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10200, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "chinese_takeout: 5; health_vial: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
[Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10200, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "chinese_takeout: 5; health_vial: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
ServerLog: [Event] ||VM|| DanC saved everyone's profiles.
[Event] ||VM|| DanC saved everyone's profiles.
ServerLog: [Commands] ||VM|| DanC ran the command save
[Commands] ||VM|| DanC ran the command save
ServerLog: [Debug] SQL Statement successful for "||VM|| DanC"
[Debug] SQL Statement successful for "||VM|| DanC"
[04/25/14 00:10:20] ||VM|| DanC [STEAM_0:1:34566661|46.64.124.43:50861] disconnected from the server.
ServerLog: [Event] ||VM|| DanC (STEAM_0:1:34566661) disconnected.
[Event] ||VM|| DanC (STEAM_0:1:34566661) disconnected.
ServerLog: [Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10200, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "chinese_takeout: 5; health_vial: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
[Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10200, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "chinese_takeout: 5; health_vial: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
Dropped ||VM|| DanC from server (Disconnect by user.)
ServerLog: [Debug] SQL Statement successful for "||VM|| DanC"
[Debug] SQL Statement successful for "||VM|| DanC"
[04/25/14 00:10:57] ||VM|| DanC [46.64.124.43:50861] connected to the server.
Player connected "||VM|| DanC", (46.64.124.43:50861): nil,
Client "||VM|| DanC" connected (46.64.124.43:50861).
[04/25/14 00:11:08] ||VM|| DanC [STEAM_0:1:34566661|46.64.124.43:50861] spawned for the first time this session.
ServerLog: [Debug] Loading of ||VM|| DanC's data complete.
[Debug] Loading of ||VM|| DanC's data complete.
ServerLog: [Teams] ||VM|| DanC changed team to "Citizen"
[Teams] ||VM|| DanC changed team to "Citizen"
ServerLog: [Event] ||VM|| DanC finished connecting.
[Event] ||VM|| DanC finished connecting.
[||VM|| DanC|6|STEAM_0:1:34566661] Lua Error:
04/24/14 23:15:17 - Finished connecting

[04/25/14 00:11:22] ||VM|| DanC [STEAM_0:1:34566661|46.64.124.43:50861] disconnected from the server.
ServerLog: [Event] ||VM|| DanC (STEAM_0:1:34566661) disconnected.
[Event] ||VM|| DanC (STEAM_0:1:34566661) disconnected.
ServerLog: [Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10200, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
[Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10200, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
Dropped ||VM|| DanC from server (Disconnect by user.)
ServerLog: [Debug] SQL Statement successful for "||VM|| DanC"
[Debug] SQL Statement successful for "||VM|| DanC"
[04/25/14 00:12:21] ||VM|| DanC [46.64.124.43:50861] connected to the server.
Player connected "||VM|| DanC", (46.64.124.43:50861): nil,
Client "||VM|| DanC" connected (46.64.124.43:50861).
[04/25/14 00:12:31] [DSUK] Shepsie [92.40.39.112:27005] connected to the server.
Player connected "[DSUK] Shepsie", (92.40.39.112:27005): nil,
Client "[DSUK] Shepsie" connected (92.40.39.112:27005).
[04/25/14 00:12:41] ||VM|| DanC [STEAM_0:1:34566661|46.64.124.43:50861] spawned for the first time this session.
ServerLog: [Debug] Loading of ||VM|| DanC's data complete.
[Debug] Loading of ||VM|| DanC's data complete.
ServerLog: [Teams] ||VM|| DanC changed team to "Citizen"
[Teams] ||VM|| DanC changed team to "Citizen"
ServerLog: [Event] ||VM|| DanC finished connecting.
[Event] ||VM|| DanC finished connecting.
[04/25/14 00:12:48] [DSUK] Shepsie [STEAM_0:1:22614393|92.40.39.112:27005] spawned for the first time this session.
ServerLog: [Debug] [DSUK] Shepsie is new to the server. Data not loaded.
[Debug] [DSUK] Shepsie is new to the server. Data not loaded.
ServerLog: [Teams] [DSUK] Shepsie changed team to "Citizen"
[Teams] [DSUK] Shepsie changed team to "Citizen"
ServerLog: [Event] [DSUK] Shepsie finished connecting.
[Event] [DSUK] Shepsie finished connecting.
ServerLog: [Debug] SQL Statement for "[DSUK] Shepsie": INSERT INTO cider (_Arrested, _Money, _UniqueID, _Donator, _SteamID, _Name, _Clan, _Blacklist, _Inventory, _Access, _Misc) VALUES("false", 0, "1851656456", 0, "STEAM_0:1:22614393", "[DSUK] Shepsie", "", "[]", "health_vial: 5; chinese_takeout: 5", "", "[]")
[Debug] SQL Statement for "[DSUK] Shepsie": INSERT INTO cider (_Arrested, _Money, _UniqueID, _Donator, _SteamID, _Name, _Clan, _Blacklist, _Inventory, _Access, _Misc) VALUES("false", 0, "1851656456", 0, "STEAM_0:1:22614393", "[DSUK] Shepsie", "", "[]", "health_vial: 5; chinese_takeout: 5", "", "[]")
ServerLog: [Debug] SQL Statement successful for "[DSUK] Shepsie"
[Debug] SQL Statement successful for "[DSUK] Shepsie"
[[DSUK] Shepsie|8|STEAM_0:1:22614393] Lua Error:
04/24/14 23:17:15 - Finished connecting

[||VM|| DanC|7|STEAM_0:1:34566661] Lua Error:
04/24/14 23:16:50 - Finished connecting

[04/25/14 00:13:28] ||VM|| DanC [STEAM_0:1:34566661|46.64.124.43:50861]: /giveitem shepsie money 100000
ServerLog: [Event] ||VM|| DanC gave [DSUK] Shepsie 100000 Dollars.
[Event] ||VM|| DanC gave [DSUK] Shepsie 100000 Dollars.
ServerLog: [Commands] ||VM|| DanC ran the command giveitem "Player [2][[DSUK] Shepsie]" "money" "100000"
[Commands] ||VM|| DanC ran the command giveitem "Player [2][[DSUK] Shepsie]" "money" "100000"
[04/25/14 00:13:30] ||VM|| Jonesy [5.81.114.129:27005] connected to the server.
Player connected "||VM|| Jonesy", (5.81.114.129:27005): nil,
Client "||VM|| Jonesy" connected (5.81.114.129:27005).
[04/25/14 00:13:31] ||VM|| DanC [STEAM_0:1:34566661|46.64.124.43:50861]: /save
ServerLog: [Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10200, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "chinese_takeout: 5; health_vial: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
[Debug] SQL Statement for "||VM|| DanC": UPDATE cider SET _Arrested = "false", _Money = 10200, _UniqueID = "2123189395", _Donator = 0, _SteamID = "STEAM_0:1:34566661", _Name = "||VM|| DanC", _Clan = "", _Blacklist = "[]", _Inventory = "chinese_takeout: 5; health_vial: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 2123189395
ServerLog: [Debug] SQL Statement for "[DSUK] Shepsie": UPDATE cider SET _Arrested = "false", _Money = 100000, _UniqueID = "1851656456", _Donator = 0, _SteamID = "STEAM_0:1:22614393", _Name = "[DSUK] Shepsie", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 1851656456
[Debug] SQL Statement for "[DSUK] Shepsie": UPDATE cider SET _Arrested = "false", _Money = 100000, _UniqueID = "1851656456", _Donator = 0, _SteamID = "STEAM_0:1:22614393", _Name = "[DSUK] Shepsie", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 1851656456
ServerLog: [Event] ||VM|| DanC saved everyone's profiles.
[Event] ||VM|| DanC saved everyone's profiles.
ServerLog: [Commands] ||VM|| DanC ran the command save
[Commands] ||VM|| DanC ran the command save
ServerLog: [Debug] SQL Statement successful for "||VM|| DanC"
[Debug] SQL Statement successful for "||VM|| DanC"
ServerLog: [Debug] SQL Statement successful for "[DSUK] Shepsie"
[Debug] SQL Statement successful for "[DSUK] Shepsie"
[04/25/14 00:13:50] [DSUK] Shepsie [STEAM_0:1:22614393|92.40.39.112:27005] disconnected from the server.
ServerLog: [Event] [DSUK] Shepsie (STEAM_0:1:22614393) disconnected.
[Event] [DSUK] Shepsie (STEAM_0:1:22614393) disconnected.
ServerLog: [Debug] SQL Statement for "[DSUK] Shepsie": UPDATE cider SET _Arrested = "false", _Money = 100000, _UniqueID = "1851656456", _Donator = 0, _SteamID = "STEAM_0:1:22614393", _Name = "[DSUK] Shepsie", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 1851656456
[Debug] SQL Statement for "[DSUK] Shepsie": UPDATE cider SET _Arrested = "false", _Money = 100000, _UniqueID = "1851656456", _Donator = 0, _SteamID = "STEAM_0:1:22614393", _Name = "[DSUK] Shepsie", _Clan = "", _Blacklist = "[]", _Inventory = "health_vial: 5; chinese_takeout: 5", _Access = "", _Misc = "[]" WHERE _UniqueID = 1851656456
Dropped [DSUK] Shepsie from server (Disconnect by user.)
ServerLog: [Debug] SQL Statement successful for "[DSUK] Shepsie"
[Debug] SQL Statement successful for "[DSUK] Shepsie"
[04/25/14 00:13:51] [DSUK] Shepsie [92.40.39.112:27005] connected to the server.
Player connected "[DSUK] Shepsie", (92.40.39.112:27005): nil,
Client "[DSUK] Shepsie" connected (92.40.39.112:27005).
[04/25/14 00:14:02] [DSUK] Shepsie [STEAM_0:1:22614393|92.40.39.112:27005] spawned for the first time this session.
ServerLog: [Debug] Loading of [DSUK] Shepsie's data complete.
[Debug] Loading of [DSUK] Shepsie's data complete.
ServerLog: [Teams] [DSUK] Shepsie changed team to "Citizen"
[Teams] [DSUK] Shepsie changed team to "Citizen"
ServerLog: [Event] [DSUK] Shepsie finished connecting.
[Event] [DSUK] Shepsie finished connecting.
Syff commented 10 years ago

Atm this is the only thing that is holding the release up. Would be great if we can get this fixxed today , since the hype is too damn high! :)

DanChap95 commented 10 years ago

Also it looks like when it finds the duplicate it is just erasing the old data

Syff commented 10 years ago

TJjoker also looked for the origin of the bug but couldn;t find it either. Any update on this?

Because tonight is the best moment for the release (+ i told people it would be up because i was told it was good to go :P ) The hype is too damn high

Syff commented 10 years ago

:(

Lexicality commented 10 years ago

Assuming syff has completed the

    `_UniqueID` BIGINT NOT NULL,

Change in the db, this should now be fixed? See this comment for new table.