db3 errors

db3 errors

« posted: Jun 27, 2017, 09:30 PM »
can anyone point me whats wrong with this please its not saving cash i pickup too


thanks in advance





[19:55:34:312500 +01:00] [Thread 1504] extDB3: Locked
[20:03:23:277343 +01:00] [Thread 2180] 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 'Class,Position,Direction,Velocity,Flying,Damage,Fuel,HitPoints,OwnerUID,LockStat' at line 1
[20:03:23:277343 +01:00] [Thread 2180] extDB3: SQL: Error MariaDBQueryException: Input: getParkedVehicles:76561197966415228:normal:,Class,Position,Direction,Velocity,Flying,Damage,Fuel,HitPoints,OwnerUID,LockState,Variables,Textures,Weapons,Magazines,Items,Backpacks,TurretMagazines,TurretMagazines2,TurretMagazines3,AmmoCargo,FuelCargo,RepairCargo
  • Offline AgentRev
  • Developer
  • Veteran
  • ******
  • Posts: 2354

Re: db3 errors

« Reply #1 posted: Jul 14, 2017, 07:02 PM »
I need to see the full log.

Re: db3 errors

« Reply #2 posted: Jul 19, 2017, 11:58 PM »
The output is slightly confusing there, but the error is caused by the input underneath it.

Quote
getParkedVehicles:76561197966415228:normal:,Class,Position,Direction,Velocity,Flying,Damage,Fuel,HitPoints,OwnerUID,LockState,Variables,Textures,Weapons,Magazines,Items,Backpacks,TurretMagazines,TurretMagazines2,TurretMagazines3,AmmoCargo,FuelCargo,RepairCargo

It is complaining that

Quote
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 'Class,Position,Direction,Velocity,Flying,Damage,Fuel,HitPoints,OwnerUID,LockStat' at line 1

This is the SQL Entry in the sql_custom file


Code: [Select]
[getParkedVehicles]
SQL1_1 = SELECT CONCAT('"',ID,'"') $CUSTOM_3$ FROM ServerVehicles sv INNER JOIN (SELECT ID AS ServerMapID FROM ServerMap WHERE Environment = '$CUSTOM_2$') sm
SQL1_2 = WHERE OwnerUID = '"$CUSTOM_1$"' AND Parked > 0 AND sv.MapID = sm.ServerMapID;

SQL1_INPUTS = 1-STRIP-MYSQL_ESCAPE, 2-STRIP-MYSQL_ESCAPE, 3-STRIP
Prepared Statement = false
  • Offline AgentRev
  • Developer
  • Veteran
  • ******
  • Posts: 2354

Re: db3 errors

« Reply #3 posted: Jul 20, 2017, 12:19 AM »
Still doesn't ring a bell. He probably has an outdated INI that doesn't have the CONCAT('"',ID,'"'), in which case this error would make sense.

Re: db3 errors

« Reply #4 posted: Jul 20, 2017, 09:05 PM »
here is my RPT https://pastebin.com/xP7mym1j




and here is my sql custom a3wastelands.ini


https://pastebin.com/KSRWNkLi

  • Offline AgentRev
  • Developer
  • Veteran
  • ******
  • Posts: 2354

Re: db3 errors

« Reply #5 posted: Jul 20, 2017, 09:46 PM »
Exactly, your INI is older than the one I released with the official implementation of extDB3.

Re: db3 errors

« Reply #6 posted: Jul 20, 2017, 10:41 PM »
really ?? i will update tomorow and report back thanks