Question SCRIPT ERROR in promise (unhandled rejection): Error: dealership was unable to execute a query!

[Florilaure]

Hello, im trying to instal a new ressource on my server but i got an error

[ scriptxmysql] SCRIPT ERROR in promise (unhandled rejection): Error: dealership was unable to execute a query!
[ scriptxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `dealership_hired_players` (
[ scriptxmysql] `dealership_id` V...' at line 16

 

[lua.broski]

You can just remove or comment out whole citizen thread and copy all that sql and just import it in your db.

 

[Florilaure]

thank you it worked but now when i try to open the menu in game it say SCRIPT ERROR: @dealership/server.lua:132: attempt to index a nil value (global 'Framework')

 

[lua.broski]

Which framework do you use so i can help you out ?

 

[Florilaure]

i use qbcore

 

[lua.broski]

Its looks like you have config in script and you can change framework and something is not set propertly. For Qbus it should be local QBCore = exports['qb-core']:GetCoreObject() on top in client and server and just change Framework to QBCore , in your case - QBCore.Functions.GetPlayer(source)

 

[Florilaure]

thanks