An urgent ExtDB3 error! D:

  • Offline X-Bacon
  • Fresh Spawn
  • *
  • Posts: 2
  • "Cheese Bacon is da best :) "

An urgent ExtDB3 error! D:

« posted: May 28, 2017, 08:39 PM »
Sorry guys, I know u're probably saturated with these too...
So I've recently updated my mission to ExtDB3, making sure I followed every single commit by Rev... But now, I'm getting an error with my database... It looks like that:

Code: [Select]
12:04:56 "[INFO] extDB3 v1.028 extension loaded"
12:04:56 "[extDB3] Startup..."
12:04:56 "[extDB3] Initialized SQL_CUSTOM protocol"
12:04:56 "[extDB3] Environment setup..."
12:04:56 "[extDB3] Locked"
12:04:57 "[extDB3] Startup complete!"
12:04:57 "[INFO] A3W playerSaving = ON"
12:04:57 "[INFO] A3W baseSaving = ON"
12:04:57 "[INFO] A3W vehicleSaving = ON"
12:04:57 "[INFO] A3W boxSaving = ON"
12:04:57 "[INFO] A3W staticWeaponSaving = ON"
12:04:57 "[INFO] A3W warchestSaving = OFF"
12:04:57 "[INFO] A3W warchestMoneySaving = OFF"
12:04:57 "[INFO] A3W spawnBeaconSaving = ON"
12:04:57 "[INFO] A3W timeSaving = ON"
12:04:57 "[INFO] A3W weatherSaving = ON"
12:04:57 "[INFO] A3W hcObjSaving = OFF"
12:04:58 "[extDB3] ███ Protocol Error: [0,""Error MariaDBQueryException Exception""], Unique ID: 104"
12:04:58 "A3Wasteland - world persistence loaded 0 objects from extDB"

I am absolutely frustrated... I honestly have 0 clue as to what to do, and its pretty bad since no objects like crates and spawn beacons are being loaded! They get saved on the database, but do not load... I've gone through all of Rev's commits for ExtDB3 and nothing has solved... I should probably add that I am running A3Wasteland v1.3b + ExtDB3 on Esseker + RHS: Escalation mods...

ExtDB3 logs looks like that:
Code: [Select]
[15:06:00:228697 -04:00] [Thread 3848] extDB3: Locked
[15:06:01:953415 -04:00] [Thread 1728] extDB3: SQL: Error MariaDBQueryException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ID),Class,Position,Direction,Locked,Damage,AllowDamage,OwnerUID,Variables,Weapo' at line 1
[15:06:01:953742 -04:00] [Thread 1728] extDB3: SQL: Error MariaDBQueryException: Input: getServerObjects:1:1:QUOTE(ID),Class,Position,Direction,Locked,Damage,AllowDamage,OwnerUID,Variables,Weapons,Magazines,Items,Backpacks,TurretMagazines,AmmoCargo,FuelCargo,RepairCargo


Pleeaaase guys! Help me with this :( :-\


EDIT: I actually just realized I posted this in the wrong section.. Now  I cant delete it :( Sorry guys!

Edit 2: Nevermind guys, I believe I might have found my mistake... GetObjects had not been updated by me it seems.. Testing now to see if updating it will fix the issue, which i believe it might! :D

Re: An urgent ExtDB3 error! D:

« Reply #1 posted: May 29, 2017, 12:03 PM »
Been having similar issues, let me know what you find to stop this.
  • Offline Matt76
  • Mercenary
  • *****
  • Posts: 389
  • co founder of customcombatgaming.com

Re: An urgent ExtDB3 error! D:

« Reply #2 posted: May 29, 2017, 04:59 PM »
using the very latest mission file stops 99.9% of these issues, don't try to mash together your old versions use the latest one instead.

Re: An urgent ExtDB3 error! D:

« Reply #3 posted: May 29, 2017, 06:10 PM »
using the very latest mission file stops 99.9% of these issues, don't try to mash together your old versions use the latest one instead.


We are running the latest one
  • Offline Matt76
  • Mercenary
  • *****
  • Posts: 389
  • co founder of customcombatgaming.com

Re: An urgent ExtDB3 error! D:

« Reply #4 posted: May 29, 2017, 06:35 PM »

We are running the latest one


[15:06:01:953415 -04:00] [Thread 1728] extDB3: SQL: Error MariaDBQueryException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ID),Class,Position,Direction,Locked,Damage,AllowDamage,OwnerUID,Variables,Weapo' at line 1

this is a scripting error within your mission file so you can't be
  • Offline AgentRev
  • Developer
  • Veteran
  • ******
  • Posts: 2288

Re: An urgent ExtDB3 error! D:

« Reply #5 posted: May 29, 2017, 07:35 PM »
Nevermind guys, I believe I might have found my mistake... GetObjects had not been updated by me it seems.. Testing now to see if updating it will fix the issue, which i believe it might! :D

It's not just one function, you need to replace the whole INI file.