kasuganosoras / esx_realparking

🅿️ A real car parking script for FiveM
GNU General Public License v3.0
51 stars 31 forks source link

Syntax Error #6

Open NZBlackKiwi opened 4 years ago

NZBlackKiwi commented 4 years ago

So im getting a db error saying incorrect syntax both when saving car and retrieving where u have "set stored 0 or 2" in there sql statement its saying it needs to be an identifier any ideas thanks

Great script BTW

kasuganosoras commented 4 years ago
  1. Find all UPDATE owned_vehicles SET stored = 0 and UPDATE owned_vehicles SET stored = 2 in server/main.lua
  2. Replace with
    UPDATE owned_vehicles SET stored = '0'

    and

    UPDATE owned_vehicles SET stored = '2'
NZBlackKiwi commented 4 years ago

Sorry also one other thing the cars arent respawning when u come back to the carpark

NZBlackKiwi commented 4 years ago
1. Find all `UPDATE owned_vehicles SET stored = 0` and `UPDATE owned_vehicles SET stored = 2` in `server/main.lua`

2. Replace with
   ```
   UPDATE owned_vehicles SET stored = '0'
   ```

   and
   ```
   UPDATE owned_vehicles SET stored = '2'
   ```

sorted it mate had to be 'sorted' = '0' or '2'