[script:oxmysql] Error: krz_gangsbuilder was unable to execute a query!

[matoqwerty]

Salut, je ne parviens pas à utiliser le script du à cette erreur l'ors de la création du gang, pouvez vous m'aider svp?

l'erreur :

[ script:oxmysql] Error: krz_gangsbuilder was unable to execute a query!
[ script:oxmysql] Query: INSERT INTO addon_account (name, label, shared) VALUES (?, ?, 1);
[ script:oxmysql] INSERT INTO datastore (name, label, shared) VALUES (?, ?, 1);
[ script:oxmysql] INSERT INTO addon_inventory (name, label, shared) VALUES (?, ?, 1);
[ script:oxmysql] INSERT INTO jobs (name, label, whitelisted) VALUES (?, ?, 1);
[ script:oxmysql] INSERT INTO job_grades (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
[ script:oxmysql] (?, 0, 'rookie', 'Associé', 0, '{}', '{}'),
[ script:oxmysql] (?, 1, 'member', 'Soldat', 0, '{}', '{}'),
[ script:oxmysql] (?, 2, 'elite', 'Elite', 0, '{}', '{}'),
[ script:oxmysql] (?, 3, 'lieutenant', 'Lieutenant', 0, '{}', '{}'),
[ script:oxmysql] (?, 4, 'viceboss', 'Bras Droit', 0, '{}', '{}'),
[ script:oxmysql] (?, 5, 'boss', 'Patron', 0, '{}', '{}');
[ script:oxmysql]
[ script:oxmysql] ["society_mafia","Mafia","society_mafia","Mafia","society_mafia","Mafia","mafia","Mafia","mafia","mafia","mafia","mafia","mafia","mafia"]
[ script:oxmysql] 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 'INSERT INTO datastore (name, label, shared) VALUES ('society_mafia', 'Mafia',...' at line 2

Le code en question (server/builder.lua) :

RegisterServerEvent('gb:addGang')
AddEventHandler('gb:addGang', function(data)
MySQL.Async.execute([[
INSERT INTO addon_account (name, label, shared) VALUES (@gangSociety, @gangLabel, 1);
INSERT INTO datastore (name, label, shared) VALUES (@gangSociety, @gangLabel, 1);
INSERT INTO addon_inventory (name, label, shared) VALUES (@gangSociety, @gangLabel, 1);
INSERT INTO jobs (name, label, whitelisted) VALUES (@GANGNAME, @gangLabel, 1);
INSERT INTO job_grades (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
(@GANGNAME, 0, 'rookie', 'Associé', 0, '{}', '{}'),
(@GANGNAME, 1, 'member', 'Soldat', 0, '{}', '{}'),
(@GANGNAME, 2, 'elite', 'Elite', 0, '{}', '{}'),
(@GANGNAME, 3, 'lieutenant', 'Lieutenant', 0, '{}', '{}'),
(@GANGNAME, 4, 'viceboss', 'Bras Droit', 0, '{}', '{}'),
(@GANGNAME, 5, 'boss', 'Patron', 0, '{}', '{}')
;
]], {
['@GANGNAME'] = data.Name,
['@gangLabel'] = data.Label,
['@gangSociety'] = 'society_' .. data.Name
}, function(rowsChanged)
table.insert(GangsData, data)
SaveResourceFile('krz_gangsbuilder', 'data/gangData.json', json.encode(GangsData))
end)
end)

[Dev5M]

GangsData = {}

function GetGangs()
local data = LoadResourceFile('krz_gangsbuilder', 'data/gangData.json')
return data and json.decode(data) or {}
end

function GetGang(job2)
for i = 1, #GangsData, 1 do
if job2.name == GangsData[i].Name then
return GangsData[i]
end
end

return false

end

ESX.RegisterServerCallback('KorioZ-GangsBuilder:Admin_getUsergroup', function(source, cb)
local xPlayer = ESX.GetPlayerFromId(source)
local plyGroup = xPlayer.getGroup()

if plyGroup ~= nil then 
	cb(plyGroup)
else
	cb('user')
end

end)

RegisterServerEvent('gb:addGang')
AddEventHandler('gb:addGang', function(data)
local gangName = data.Name;
local gangLabel = data.Label;
local gangSociety = 'society_' .. data.Name;
MySQL.insert('INSERT INTO addon_account (name, label, shared) VALUES (?, ?, ?)', {gangSociety, gangLabel, 1})
MySQL.insert('INSERT INTO datastore (name, label, shared) VALUES (?, ?, ?)', {gangSociety, gangLabel, 1})
MySQL.insert('INSERT INTO addon_inventory (name, label, shared) VALUES (?, ?, ?)', {gangSociety, gangLabel, 1})
MySQL.insert('INSERT INTO jobs2 (name, label, whitelisted) VALUES (?, ?, ?)', {gangName, gangLabel, 1})
--Code KorioZ non compatible oxmysql
--Va dans le Mysql.Async.execute de base
--Ne pas reactivé ses lignes ici même :
-- INSERT INTO addon_account (name, label, shared) VALUES (@gangSociety, @gangLabel, 1);
-- INSERT INTO datastore (name, label, shared) VALUES (@gangSociety, @gangLabel, 1);
-- INSERT INTO addon_inventory (name, label, shared) VALUES (@gangSociety, @gangLabel, 1);
-- INSERT INTO jobs2 (name, label, whitelisted) VALUES (@GANGNAME, @gangLabel, 1);
MySQL.Async.execute([[
INSERT INTO job2_grades (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
(@GANGNAME, 0, 'rookie', 'Associé', 0, '{}', '{}'),
(@GANGNAME, 1, 'member', 'Soldat', 0, '{}', '{}'),
(@GANGNAME, 2, 'elite', 'Elite', 0, '{}', '{}'),
(@GANGNAME, 3, 'lieutenant', 'Lieutenant', 0, '{}', '{}'),
(@GANGNAME, 4, 'viceboss', 'Bras Droit', 0, '{}', '{}'),
(@GANGNAME, 5, 'boss', 'Patron', 0, '{}', '{}');
]], {
['@GANGNAME'] = data.Name,
['@gangLabel'] = data.Label,
['@gangSociety'] = 'society_' .. data.Name
}, function(rowsChanged)
table.insert(GangsData, data)
SaveResourceFile('krz_gangsbuilder', 'data/gangData.json', json.encode(GangsData))
end)
end)

RegisterServerEvent('gb:requestSync')
AddEventHandler('gb:requestSync', function()
local xPlayer = ESX.GetPlayerFromId(source)
local plyGang = GetGang(xPlayer.job2)
TriggerClientEvent('gb:SyncGang', xPlayer.source, plyGang)
end)

AddEventHandler('esx:playerLoaded', function(source, xPlayer)
local plyGang = GetGang(xPlayer.job2)
TriggerClientEvent('gb:SyncGang', source, plyGang)
end)

AddEventHandler('esx:setJob2', function(source, job2)
local plyGang = GetGang(job2)
TriggerClientEvent('gb:SyncGang', source, plyGang)
end)

Citizen.CreateThread(function()
GangsData = GetGangs()

for i = 1, #GangsData, 1 do
	TriggerEvent('esx_society:registerSociety', GangsData[i].Name, GangsData[i].Label, 'society_' .. GangsData[i].Name, 'society_' .. GangsData[i].Name, 'society_' .. GangsData[i].Name, {type = 'public'})
end

end)