Skip to content

Instantly share code, notes, and snippets.

@LouDnl

LouDnl/gist:98e19a8f2043178595bd

Created January 8, 2015 08:20
Show Gist options
  • Save LouDnl/98e19a8f2043178595bd to your computer and use it in GitHub Desktop.
Save LouDnl/98e19a8f2043178595bd to your computer and use it in GitHub Desktop.
Download ZIP
extdb logs
Raw
gistfile1.txt
[2015-Jan-04 09:13:57.916529]: ThreadID 0x00000c20: extDB: Version: 25
[2015-Jan-04 09:13:57.917530]: ThreadID 0x00000c20: extDB: Found extdb-conf.ini
[2015-Jan-04 09:13:57.917530]: ThreadID 0x00000c20: extDB: Creating Worker Thread +1
[2015-Jan-04 09:13:57.917530]: ThreadID 0x00000c20: extDB: Creating Worker Thread +1
[2015-Jan-04 09:13:57.917530]: ThreadID 0x00000c20: extDB: Creating Worker Thread +1
[2015-Jan-04 09:13:57.917530]: ThreadID 0x00000c20: extDB: Creating Worker Thread +1
[2015-Jan-04 09:13:57.917530]: ThreadID 0x00000c20: extDB: Creating Worker Thread +1
[2015-Jan-04 09:13:57.917530]: ThreadID 0x00000c20: extDB: Creating Worker Thread +1
[2015-Jan-04 09:13:57.917530]: ThreadID 0x00000c20: extDB: Creating Worker Thread +1
[2015-Jan-04 09:13:57.917530]: ThreadID 0x00000c20: extDB: Creating Worker Thread +1
[2015-Jan-04 09:13:57.939352]: ThreadID 0x00000c20: extDB: Database Type: MySQL
[2015-Jan-04 09:13:57.943356]: ThreadID 0x00000c20: extDB: Database Session Pool Started
[2015-Jan-04 14:55:30.966133]: ThreadID 0x00000ec0: extDB: DB_CUSTOM_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`a3wasteland`.`playersave`, CONSTRAINT `fk_PlayerSave_PlayerInfo` FOREIGN KEY (`PlayerUID`) REFERENCES `playerinfo` (`UID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [mysql_stmt_errno]: 1452 [mysql_stmt_sqlstate]: 23000 [statemnt]: INSERT INTO PlayerSave SET PlayerUID = '76561198035576580', MapID = 1, CreationDate = NOW(), Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=2500,Uniform='"U_O_CombatUniform_ocamo"',Vest='"V_Rangemaster_belt"',Backpack='"B_AssaultPack_rgr"',Goggles='""',Headgear='"H_MilCap_ocamo"',PrimaryWeapon='""',SecondaryWeapon='""',HandgunWeapon='"hgun_ACPC2_F"',PrimaryWeaponItems='[]',SecondaryWeaponItems='[]',HandgunItems='["","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","NVGoggles"]',UniformWeapons='[]',UniformItems='[]',UniformMagazines='[["9Rnd_45ACP_Mag",3]]',VestWeapons='[]',VestItems='[]',VestMagazines='[]',BackpackWeapons='[]',BackpackItems='[["Medikit",1]]',BackpackMagazines='[]',LoadedMagazines='[["9Rnd_45ACP_Mag",9]]' ON DUPLICATE KEY UPDATE Damage=VALUES(Damage),HitPoints=VALUES(HitPoints),Money=VALUES(Money),Uniform=VALUES(Uniform),Vest=VALUES(Vest),Backpack=VALUES(Backpack),Goggles=VALUES(Goggles),Headgear=VALUES(Headgear),PrimaryWeapon=VALUES(PrimaryWeapon),SecondaryWeapon=VALUES(SecondaryWeapon),HandgunWeapon=VALUES(HandgunWeapon),PrimaryWeaponItems=VALUES(PrimaryWeaponItems),SecondaryWeaponItems=VALUES(SecondaryWeaponItems),HandgunItems=VALUES(HandgunItems),AssignedItems=VALUES(AssignedItems),UniformWeapons=VALUES(UniformWeapons),UniformItems=VALUES(UniformItems),UniformMagazines=VALUES(UniformMagazines),VestWeapons=VALUES(VestWeapons),VestItems=VALUES(VestItems),VestMagazines=VALUES(VestMagazines),BackpackWeapons=VALUES(BackpackWeapons),BackpackItems=VALUES(BackpackItems),BackpackMagazines=VALUES(BackpackMagazines),LoadedMagazines=VALUES(LoadedMagazines);
[2015-Jan-04 14:55:30.967133]: ThreadID 0x00000ec0: extDB: DB_CUSTOM_V3: Error StatementException: SQL:INSERT INTO PlayerSave SET PlayerUID = '76561198035576580', MapID = 1, CreationDate = NOW(), Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=2500,Uniform='"U_O_CombatUniform_ocamo"',Vest='"V_Rangemaster_belt"',Backpack='"B_AssaultPack_rgr"',Goggles='""',Headgear='"H_MilCap_ocamo"',PrimaryWeapon='""',SecondaryWeapon='""',HandgunWeapon='"hgun_ACPC2_F"',PrimaryWeaponItems='[]',SecondaryWeaponItems='[]',HandgunItems='["","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","NVGoggles"]',UniformWeapons='[]',UniformItems='[]',UniformMagazines='[["9Rnd_45ACP_Mag",3]]',VestWeapons='[]',VestItems='[]',VestMagazines='[]',BackpackWeapons='[]',BackpackItems='[["Medikit",1]]',BackpackMagazines='[]',LoadedMagazines='[["9Rnd_45ACP_Mag",9]]' ON DUPLICATE KEY UPDATE Damage=VALUES(Damage),HitPoints=VALUES(HitPoints),Money=VALUES(Money),Uniform=VALUES(Uniform),Vest=VALUES(Vest),Backpack=VALUES(Backpack),Goggles=VALUES(Goggles),Headgear=VALUES(Headgear),PrimaryWeapon=VALUES(PrimaryWeapon),SecondaryWeapon=VALUES(SecondaryWeapon),HandgunWeapon=VALUES(HandgunWeapon),PrimaryWeaponItems=VALUES(PrimaryWeaponItems),SecondaryWeaponItems=VALUES(SecondaryWeaponItems),HandgunItems=VALUES(HandgunItems),AssignedItems=VALUES(AssignedItems),UniformWeapons=VALUES(UniformWeapons),UniformItems=VALUES(UniformItems),UniformMagazines=VALUES(UniformMagazines),VestWeapons=VALUES(VestWeapons),VestItems=VALUES(VestItems),VestMagazines=VALUES(VestMagazines),BackpackWeapons=VALUES(BackpackWeapons),BackpackItems=VALUES(BackpackItems),BackpackMagazines=VALUES(BackpackMagazines),LoadedMagazines=VALUES(LoadedMagazines);
[2015-Jan-04 15:00:39.073306]: ThreadID 0x00001938: extDB: Version: 25
[2015-Jan-04 15:00:39.073306]: ThreadID 0x00001938: extDB: Found extdb-conf.ini
[2015-Jan-04 15:00:39.073306]: ThreadID 0x00001938: extDB: Creating Worker Thread +1
[2015-Jan-04 15:00:39.073306]: ThreadID 0x00001938: extDB: Creating Worker Thread +1
[2015-Jan-04 15:00:39.073306]: ThreadID 0x00001938: extDB: Creating Worker Thread +1
[2015-Jan-04 15:00:39.073306]: ThreadID 0x00001938: extDB: Creating Worker Thread +1
[2015-Jan-04 15:00:39.074308]: ThreadID 0x00001938: extDB: Creating Worker Thread +1
[2015-Jan-04 15:00:39.074308]: ThreadID 0x00001938: extDB: Creating Worker Thread +1
[2015-Jan-04 15:00:39.074308]: ThreadID 0x00001938: extDB: Creating Worker Thread +1
[2015-Jan-04 15:00:39.074308]: ThreadID 0x00001938: extDB: Creating Worker Thread +1
[2015-Jan-04 15:00:39.092797]: ThreadID 0x00001938: extDB: Database Type: MySQL
[2015-Jan-04 15:00:39.096801]: ThreadID 0x00001938: extDB: Database Session Pool Started
[2015-Jan-04 15:46:18.610266]: ThreadID 0x00000b10: extDB: DB_CUSTOM_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`a3wasteland`.`playersave`, CONSTRAINT `fk_PlayerSave_PlayerInfo` FOREIGN KEY (`PlayerUID`) REFERENCES `playerinfo` (`UID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [mysql_stmt_errno]: 1452 [mysql_stmt_sqlstate]: 23000 [statemnt]: INSERT INTO PlayerSave SET PlayerUID = '76561198015223357', MapID = 1, CreationDate = NOW(), Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=0,Uniform='"U_B_GhillieSuit"',Vest='"V_Chestrig_rgr"',Backpack='""',Goggles='"G_Sport_BlackWhite"',Headgear='""',PrimaryWeapon='"srifle_LRR_camo_SOS_F"',SecondaryWeapon='""',HandgunWeapon='"hgun_P07_snds_F"',PrimaryWeaponItems='["","","optic_SOS"]',SecondaryWeaponItems='[]',HandgunItems='["muzzle_snds_L","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","ItemGPS","NVGoggles","Rangefinder"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["7Rnd_408_Mag",3],["SmokeShell",1]]',VestWeapons='[]',VestItems='[]',VestMagazines='[["7Rnd_408_Mag",2],["16Rnd_9x21_Mag",2],["ClaymoreDirectionalMine_Remote_Mag",1],["APERSTripMine_Wire_Mag",1],["SmokeShellGreen",1],["SmokeShellBlue",1],["SmokeShellOrange",1],["Chemlight_green",2]]',BackpackWeapons='[]',BackpackItems='[]',BackpackMagazines='[]',LoadedMagazines='[["7Rnd_408_Mag",7],["16Rnd_9x21_Mag",16]]' ON DUPLICATE KEY UPDATE Damage=VALUES(Damage),HitPoints=VALUES(HitPoints),Money=VALUES(Money),Uniform=VALUES(Uniform),Vest=VALUES(Vest),Backpack=VALUES(Backpack),Goggles=VALUES(Goggles),Headgear=VALUES(Headgear),PrimaryWeapon=VALUES(PrimaryWeapon),SecondaryWeapon=VALUES(SecondaryWeapon),HandgunWeapon=VALUES(HandgunWeapon),PrimaryWeaponItems=VALUES(PrimaryWeaponItems),SecondaryWeaponItems=VALUES(SecondaryWeaponItems),HandgunItems=VALUES(HandgunItems),AssignedItems=VALUES(AssignedItems),UniformWeapons=VALUES(UniformWeapons),UniformItems=VALUES(UniformItems),UniformMagazines=VALUES(UniformMagazines),VestWeapons=VALUES(VestWeapons),VestItems=VALUES(VestItems),VestMagazines=VALUES(VestMagazines),BackpackWeapons=VALUES(BackpackWeapons),BackpackItems=VALUES(BackpackItems),BackpackMagazines=VALUES(BackpackMagazines),LoadedMagazines=VALUES(LoadedMagazines);
[2015-Jan-04 15:46:18.610266]: ThreadID 0x00000b10: extDB: DB_CUSTOM_V3: Error StatementException: SQL:INSERT INTO PlayerSave SET PlayerUID = '76561198015223357', MapID = 1, CreationDate = NOW(), Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=0,Uniform='"U_B_GhillieSuit"',Vest='"V_Chestrig_rgr"',Backpack='""',Goggles='"G_Sport_BlackWhite"',Headgear='""',PrimaryWeapon='"srifle_LRR_camo_SOS_F"',SecondaryWeapon='""',HandgunWeapon='"hgun_P07_snds_F"',PrimaryWeaponItems='["","","optic_SOS"]',SecondaryWeaponItems='[]',HandgunItems='["muzzle_snds_L","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","ItemGPS","NVGoggles","Rangefinder"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["7Rnd_408_Mag",3],["SmokeShell",1]]',VestWeapons='[]',VestItems='[]',VestMagazines='[["7Rnd_408_Mag",2],["16Rnd_9x21_Mag",2],["ClaymoreDirectionalMine_Remote_Mag",1],["APERSTripMine_Wire_Mag",1],["SmokeShellGreen",1],["SmokeShellBlue",1],["SmokeShellOrange",1],["Chemlight_green",2]]',BackpackWeapons='[]',BackpackItems='[]',BackpackMagazines='[]',LoadedMagazines='[["7Rnd_408_Mag",7],["16Rnd_9x21_Mag",16]]' ON DUPLICATE KEY UPDATE Damage=VALUES(Damage),HitPoints=VALUES(HitPoints),Money=VALUES(Money),Uniform=VALUES(Uniform),Vest=VALUES(Vest),Backpack=VALUES(Backpack),Goggles=VALUES(Goggles),Headgear=VALUES(Headgear),PrimaryWeapon=VALUES(PrimaryWeapon),SecondaryWeapon=VALUES(SecondaryWeapon),HandgunWeapon=VALUES(HandgunWeapon),PrimaryWeaponItems=VALUES(PrimaryWeaponItems),SecondaryWeaponItems=VALUES(SecondaryWeaponItems),HandgunItems=VALUES(HandgunItems),AssignedItems=VALUES(AssignedItems),UniformWeapons=VALUES(UniformWeapons),UniformItems=VALUES(UniformItems),UniformMagazines=VALUES(UniformMagazines),VestWeapons=VALUES(VestWeapons),VestItems=VALUES(VestItems),VestMagazines=VALUES(VestMagazines),BackpackWeapons=VALUES(BackpackWeapons),BackpackItems=VALUES(BackpackItems),BackpackMagazines=VALUES(BackpackMagazines),LoadedMagazines=VALUES(LoadedMagazines);
[2015-Jan-04 15:51:05.485599]: ThreadID 0x0000173c: extDB: Version: 25
[2015-Jan-04 15:51:05.485599]: ThreadID 0x0000173c: extDB: Found extdb-conf.ini
[2015-Jan-04 15:51:05.486599]: ThreadID 0x0000173c: extDB: Creating Worker Thread +1
[2015-Jan-04 15:51:05.486599]: ThreadID 0x0000173c: extDB: Creating Worker Thread +1
[2015-Jan-04 15:51:05.486599]: ThreadID 0x0000173c: extDB: Creating Worker Thread +1
[2015-Jan-04 15:51:05.486599]: ThreadID 0x0000173c: extDB: Creating Worker Thread +1
[2015-Jan-04 15:51:05.486599]: ThreadID 0x0000173c: extDB: Creating Worker Thread +1
[2015-Jan-04 15:51:05.486599]: ThreadID 0x0000173c: extDB: Creating Worker Thread +1
[2015-Jan-04 15:51:05.486599]: ThreadID 0x0000173c: extDB: Creating Worker Thread +1
[2015-Jan-04 15:51:05.486599]: ThreadID 0x0000173c: extDB: Creating Worker Thread +1
[2015-Jan-04 15:51:05.505735]: ThreadID 0x0000173c: extDB: Database Type: MySQL
[2015-Jan-04 15:51:05.510614]: ThreadID 0x0000173c: extDB: Database Session Pool Started
[2015-Jan-04 18:05:36.633175]: ThreadID 0x000019b8: extDB: DB_CUSTOM_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`a3wasteland`.`playerstats`, CONSTRAINT `fk_PlayerStats_PlayerInfo` FOREIGN KEY (`PlayerUID`) REFERENCES `playerinfo` (`UID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [mysql_stmt_errno]: 1452 [mysql_stmt_sqlstate]: 23000 [statemnt]: INSERT INTO PlayerStats SET PlayerUID = '76561198123270779', deathCount = 1 ON DUPLICATE KEY UPDATE deathCount = deathCount + 1;
[2015-Jan-04 18:05:36.634176]: ThreadID 0x000019b8: extDB: DB_CUSTOM_V3: Error StatementException: SQL:INSERT INTO PlayerStats SET PlayerUID = '76561198123270779', deathCount = 1 ON DUPLICATE KEY UPDATE deathCount = deathCount + 1;
[2015-Jan-04 18:05:36.636178]: ThreadID 0x000019b8: extDB: DB_CUSTOM_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error [mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`a3wasteland`.`playerstatsmap`, CONSTRAINT `fk_PlayerStatsMap_PlayerStats` FOREIGN KEY (`PlayerUID`) REFERENCES `playerstats` (`PlayerUID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [mysql_stmt_errno]: 1452 [mysql_stmt_sqlstate]: 23000 [statemnt]: INSERT INTO PlayerStatsMap SET PlayerUID = '76561198123270779', ServerID = 1, MapID = 1, deathCount = 1 ON DUPLICATE KEY UPDATE deathCount = deathCount + 1;
[2015-Jan-04 18:05:36.636178]: ThreadID 0x000019b8: extDB: DB_CUSTOM_V3: Error StatementException: SQL:INSERT INTO PlayerStatsMap SET PlayerUID = '76561198123270779', ServerID = 1, MapID = 1, deathCount = 1 ON DUPLICATE KEY UPDATE deathCount = deathCount + 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment