Skip to content

Instantly share code, notes, and snippets.

@LouDnl

LouDnl/gist:16b4b7a689229c637d04

Created January 6, 2015 22:19
Show Gist options
  • Save LouDnl/16b4b7a689229c637d04 to your computer and use it in GitHub Desktop.
Save LouDnl/16b4b7a689229c637d04 to your computer and use it in GitHub Desktop.
Download ZIP
extdb
Raw
gistfile1.txt
[2015-Jan-06 15:02:12.367190]: ThreadID 0x00001a90: extDB: Version: 25
[2015-Jan-06 15:02:12.368190]: ThreadID 0x00001a90: extDB: Found extdb-conf.ini
[2015-Jan-06 15:02:12.368190]: ThreadID 0x00001a90: extDB: Creating Worker Thread +1
[2015-Jan-06 15:02:12.368190]: ThreadID 0x00001a90: extDB: Creating Worker Thread +1
[2015-Jan-06 15:02:12.368190]: ThreadID 0x00001a90: extDB: Creating Worker Thread +1
[2015-Jan-06 15:02:12.368190]: ThreadID 0x00001a90: extDB: Creating Worker Thread +1
[2015-Jan-06 15:02:12.368190]: ThreadID 0x00001a90: extDB: Creating Worker Thread +1
[2015-Jan-06 15:02:12.368190]: ThreadID 0x00001a90: extDB: Creating Worker Thread +1
[2015-Jan-06 15:02:12.369191]: ThreadID 0x00001a90: extDB: Creating Worker Thread +1
[2015-Jan-06 15:02:12.369191]: ThreadID 0x00001a90: extDB: Creating Worker Thread +1
[2015-Jan-06 15:02:12.390164]: ThreadID 0x00001a90: extDB: Database Type: MySQL
[2015-Jan-06 15:02:12.395169]: ThreadID 0x00001a90: extDB: Database Session Pool Started
[2015-Jan-06 20:03:10.106234]: ThreadID 0x0000038c: 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 = '76561198162113901', MapID = 1, CreationDate = NOW(), Hunger=100,Thirst=100,Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=2500,Position='["21209.451172","16427.134766","0.00145531"]',Direction=0.144753,CurrentWeapon='"hgun_ACPC2_F"',Stance='"Pknl"',Uniform='"U_I_GhillieSuit"',Vest='"V_Rangemaster_belt"',Backpack='"B_AssaultPack_rgr"',Goggles='""',Headgear='"H_MilCap_dgtl"',PrimaryWeapon='""',SecondaryWeapon='""',HandgunWeapon='"hgun_ACPC2_F"',PrimaryWeaponItems='[]',SecondaryWeaponItems='[]',HandgunItems='["","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","NVGoggles","Rangefinder"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["9Rnd_45ACP_Mag",3]]',VestWeapons='[]',VestItems='[]',VestMagazines='[]',BackpackWeapons='[]',BackpackItems='[]',BackpackMagazines='[]',LoadedMagazines='[["9Rnd_45ACP_Mag",9]]',WastelandItems='[["cannedfood",1],["water",1],["repairkit",1]]' ON DUPLICATE KEY UPDATE Hunger=VALUES(Hunger),Thirst=VALUES(Thirst),Damage=VALUES(Damage),HitPoints=VALUES(HitPoints),Money=VALUES(Money),Position=VALUES(Position),Direction=VALUES(Direction),CurrentWeapon=VALUES(CurrentWeapon),Stance=VALUES(Stance),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),WastelandItems=VALUES(WastelandItems);
[2015-Jan-06 20:03:10.106234]: ThreadID 0x0000038c: extDB: DB_CUSTOM_V3: Error StatementException: SQL:INSERT INTO PlayerSave SET PlayerUID = '76561198162113901', MapID = 1, CreationDate = NOW(), Hunger=100,Thirst=100,Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=2500,Position='["21209.451172","16427.134766","0.00145531"]',Direction=0.144753,CurrentWeapon='"hgun_ACPC2_F"',Stance='"Pknl"',Uniform='"U_I_GhillieSuit"',Vest='"V_Rangemaster_belt"',Backpack='"B_AssaultPack_rgr"',Goggles='""',Headgear='"H_MilCap_dgtl"',PrimaryWeapon='""',SecondaryWeapon='""',HandgunWeapon='"hgun_ACPC2_F"',PrimaryWeaponItems='[]',SecondaryWeaponItems='[]',HandgunItems='["","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","NVGoggles","Rangefinder"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["9Rnd_45ACP_Mag",3]]',VestWeapons='[]',VestItems='[]',VestMagazines='[]',BackpackWeapons='[]',BackpackItems='[]',BackpackMagazines='[]',LoadedMagazines='[["9Rnd_45ACP_Mag",9]]',WastelandItems='[["cannedfood",1],["water",1],["repairkit",1]]' ON DUPLICATE KEY UPDATE Hunger=VALUES(Hunger),Thirst=VALUES(Thirst),Damage=VALUES(Damage),HitPoints=VALUES(HitPoints),Money=VALUES(Money),Position=VALUES(Position),Direction=VALUES(Direction),CurrentWeapon=VALUES(CurrentWeapon),Stance=VALUES(Stance),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),WastelandItems=VALUES(WastelandItems);
[2015-Jan-06 20:10:38.818809]: ThreadID 0x000018c0: 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 = '76561198074160182', MapID = 1, CreationDate = NOW(), Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=0,Uniform='"U_B_CombatUniform_mcam_vest"',Vest='"V_Chestrig_rgr"',Backpack='"B_Kitbag_mcamo_Eng"',Goggles='""',Headgear='"H_HelmetB_desert"',PrimaryWeapon='"arifle_MXC_Holo_pointer_F"',SecondaryWeapon='""',HandgunWeapon='"hgun_P07_F"',PrimaryWeaponItems='["","acc_pointer_IR","optic_Holosight"]',SecondaryWeaponItems='[]',HandgunItems='["","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","NVGoggles"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["30Rnd_65x39_caseless_mag",2],["Chemlight_green",1]]',VestWeapons='[]',VestItems='[]',VestMagazines='[["30Rnd_65x39_caseless_mag",3],["16Rnd_9x21_Mag",2],["HandGrenade",2],["SmokeShell",1],["SmokeShellGreen",1],["SmokeShellBlue",1],["SmokeShellOrange",1],["Chemlight_green",1]]',BackpackWeapons='[]',BackpackItems='[["ToolKit",1],["MineDetector",1]]',BackpackMagazines='[["SatchelCharge_Remote_Mag",1],["DemoCharge_Remote_Mag",2]]',LoadedMagazines='[["30Rnd_65x39_caseless_mag",30],["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-06 20:10:38.818809]: ThreadID 0x000018c0: extDB: DB_CUSTOM_V3: Error StatementException: SQL:INSERT INTO PlayerSave SET PlayerUID = '76561198074160182', MapID = 1, CreationDate = NOW(), Damage=0,HitPoints='[["HitHead",0],["HitBody",0],["HitHands",0],["HitLegs",0]]',Money=0,Uniform='"U_B_CombatUniform_mcam_vest"',Vest='"V_Chestrig_rgr"',Backpack='"B_Kitbag_mcamo_Eng"',Goggles='""',Headgear='"H_HelmetB_desert"',PrimaryWeapon='"arifle_MXC_Holo_pointer_F"',SecondaryWeapon='""',HandgunWeapon='"hgun_P07_F"',PrimaryWeaponItems='["","acc_pointer_IR","optic_Holosight"]',SecondaryWeaponItems='[]',HandgunItems='["","",""]',AssignedItems='["ItemMap","ItemCompass","ItemWatch","ItemRadio","NVGoggles"]',UniformWeapons='[]',UniformItems='[["FirstAidKit",1]]',UniformMagazines='[["30Rnd_65x39_caseless_mag",2],["Chemlight_green",1]]',VestWeapons='[]',VestItems='[]',VestMagazines='[["30Rnd_65x39_caseless_mag",3],["16Rnd_9x21_Mag",2],["HandGrenade",2],["SmokeShell",1],["SmokeShellGreen",1],["SmokeShellBlue",1],["SmokeShellOrange",1],["Chemlight_green",1]]',BackpackWeapons='[]',BackpackItems='[["ToolKit",1],["MineDetector",1]]',BackpackMagazines='[["SatchelCharge_Remote_Mag",1],["DemoCharge_Remote_Mag",2]]',LoadedMagazines='[["30Rnd_65x39_caseless_mag",30],["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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment