qbcore script issue

[Acecash112]

I keep getting these two errors in my console when running the script ;

Error loading script init.lua in resource renzu_shops: @renzu_shops/init.lua:96: bad argument #1 to 'for iterator' (table expected, got nil) [ script:renzu_shops] stack traceback: [ script:renzu_shops] [C]: in function 'next' [ script:renzu_shops] @renzu_shops/init.lua:96: in function 'MultiCategory' [ script:renzu_shops] [string "return {..."]:369: in main chunk [ script:renzu_shops] (...tail calls...) [ script:renzu_shops] @renzu_shops/init.lua:114: in main chunk [ c-scripting-core] Failed to load script init.lua.

this is the second error code :

[ script:renzu_shops] SCRIPT ERROR: @renzu_shops/server/main.lua:1990: attempt to concatenate a nil value (global 'vehicletable') [ script:renzu_shops] SCRIPT ERROR: [string "local dbdata = {['financedata'] = {['columns'..."]:201: bad argument #1 to 'for iterator' (table expected, got nil) [ script:renzu_shops] > [global chunk] (ocal dbdata = {['financedata'] = {['columns'] = 'identifier,max,financed',['values'] = '?,?,?'},['renzu_stores'] = {['columns'] = 'shop,owner,money,items,employee,cashier,customitems,job',['values'] = '?,?,?,?,?,?,?,?'},['movableshops'] = {['columns'] = 'identifier,owner,money,items,plate,type,shopname',['values'] = '?,?,?,?,?,?,?'},} [ script:renzu_shops] [ script:renzu_shops] local db = setmetatable({},{ [ script:renzu_shops] __call = function(self) [ script:renzu_shops] [ script:renzu_shops] self.insert = function(name, data) [ script:renzu_shops] local str = 'INSERT INTO %s (%s) VALUES(%s)' [ script:renzu_shops] return MySQL.insert.await(str:format(name,dbdata[name].columns,dbdata[name].values),data) [ script:renzu_shops] end [ script:renzu_shops] [ script:renzu_shops] self.update = function(name, column, where, update, data) [ script:renzu_shops] local str = 'UPDATE %s SET %s = ? WHERE %s = ?' [ script:renzu_shops] return MySQL.query(str:format(name,column,where),{data,update}) [ script:renzu_shops] end [ script:renzu_shops] [ script:renzu_shops] self.delete = function(name, where, update) [ script:renzu_shops] local str = 'DELETE FROM %s WHERE %s = ?' [ script:renzu_shops] return MySQL.query(str:format(name,where),{update}) [ script:renzu_shops] end [ script:renzu_shops] [ script:renzu_shops] self.save = function(data) [ script:renzu_shops] Citizen.CreateThreadNow(function() [ script:renzu_shops] for shopname,v in pairs(data) do [ script:renzu_shops] local select = MySQL.query.await('SELECT FROM renzu_stores WHERE shop = ?', {shopname}) [ script:renzu_shops] if select then [ script:renzu_shops] for k,v in pairs(v) do [ script:renzu_shops] if type(v) == 'table' then [ script:renzu_shops] self.update('renzu_stores',k,'shop',shopname,json.encode(v)) [ script:renzu_shops] else [ script:renzu_shops] self.update('renzu_stores',k,'shop',shopname,v) [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] else [ script:renzu_shops] self.insert('renzu_stores',{ [ script:renzu_shops] shopname, [ script:renzu_shops] v.owner, [ script:renzu_shops] json.encode(v['money'] or {}), [ script:renzu_shops] json.encode(v['items'] or {}), [ script:renzu_shops] json.encode(v['employee'] or {}), [ script:renzu_shops] json.encode(v['cashier'] or {}), [ script:renzu_shops] json.encode(v['customitems'] or {}), [ script:renzu_shops] v['job'], [ script:renzu_shops] }) [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] end) [ script:renzu_shops] end [ script:renzu_shops] return self [ script:renzu_shops] end [ script:renzu_shops] }) [ script:renzu_shops] local Sql = db() [ script:renzu_shops] [ script:renzu_shops] local success, result = pcall(MySQL.scalar.await, 'SELECT 1 FROM renzu_stores') [ script:renzu_shops] [ script:renzu_shops] if not success then [ script:renzu_shops] MySQL.query([[CREATE TABLE renzu_stores ( [ script:renzu_shops] id int NOT NULL AUTO_INCREMENT KEY, [ script:renzu_shops] shop varchar(60) DEFAULT NULL, [ script:renzu_shops] owner varchar(64) DEFAULT NULL, [ script:renzu_shops] money longtext DEFAULT NULL, [ script:renzu_shops] items longtext DEFAULT NULL, [ script:renzu_shops] employee longtext DEFAULT NULL, [ script:renzu_shops] cashier longtext DEFAULT NULL, [ script:renzu_shops] customitems longtext DEFAULT NULL, [ script:renzu_shops] job varchar(64) DEFAULT NULL [ script:renzu_shops] )]]) [ script:renzu_shops] end [ script:renzu_shops] local success, result = pcall(MySQL.scalar.await, 'SELECT 1 FROM movableshops') [ script:renzu_shops] [ script:renzu_shops] if not success then [ script:renzu_shops] MySQL.query([[CREATE TABLE movableshops ( [ script:renzu_shops] identifier varchar(64) DEFAULT NULL, [ script:renzu_shops] owner varchar(64) DEFAULT NULL, [ script:renzu_shops] money longtext DEFAULT NULL, [ script:renzu_shops] items longtext DEFAULT NULL, [ script:renzu_shops] plate varchar(64) DEFAULT NULL, [ script:renzu_shops] type varchar(64) DEFAULT NULL, [ script:renzu_shops] shopname varchar(64) DEFAULT NULL, [ script:renzu_shops] UNIQUE KEY identifier (identifier) [ script:renzu_shops] )]]) [ script:renzu_shops] end [ script:renzu_shops] [ script:renzu_shops] local success, result = pcall(MySQL.scalar.await, 'SELECT 1 FROM financedata') [ script:renzu_shops] [ script:renzu_shops] if not success then [ script:renzu_shops] MySQL.query([[CREATE TABLE financedata ( [ script:renzu_shops] identifier varchar(64) DEFAULT NULL, [ script:renzu_shops] max INT(64) DEFAULT NULL, [ script:renzu_shops] financed longtext DEFAULT NULL, [ script:renzu_shops] UNIQUE KEY identifier (identifier) [ script:renzu_shops] )]]) [ script:renzu_shops] end [ script:renzu_shops] [ script:renzu_shops] local success, result = pcall(MySQL.scalar.await, 'ALTER TABLE movableshops MODIFY COLUMN identifier VARCHAR(100)') [ script:renzu_shops] [ script:renzu_shops] local convert = function() [ script:renzu_shops] if GetResourceKvpString('renzu_stores') then [ script:renzu_shops] for k,v in pairs(json.decode(GetResourceKvpString('renzu_stores'))) do [ script:renzu_shops] local columns = {} [ script:renzu_shops] columns['shop'] = k [ script:renzu_shops] local data = {} [ script:renzu_shops] for k,v in pairs(v) do [ script:renzu_shops] columns[k] = v [ script:renzu_shops] end [ script:renzu_shops] Sql.insert('renzu_stores',{ [ script:renzu_shops] columns['shop'], [ script:renzu_shops] columns['owner'], [ script:renzu_shops] json.encode(columns['money'] or {}), [ script:renzu_shops] json.encode(columns['items'] or {}), [ script:renzu_shops] json.encode(columns['employee'] or {}), [ script:renzu_shops] json.encode(columns['cashier'] or {}), [ script:renzu_shops] json.encode(columns['customitems'] or {}), [ script:renzu_shops] columns['job'], [ script:renzu_shops] }) [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] [ script:renzu_shops] if GetResourceKvpString('movableshops') then [ script:renzu_shops] for k,v in pairs(json.decode(GetResourceKvpString('movableshops'))) do [ script:renzu_shops] local columns = {} [ script:renzu_shops] columns['shopidentifier'] = k [ script:renzu_shops] local data = {} [ script:renzu_shops] for k,v in pairs(v) do [ script:renzu_shops] columns[k] = v [ script:renzu_shops] end [ script:renzu_shops] Sql.insert('movableshops',{ [ script:renzu_shops] columns['shopidentifier'], [ script:renzu_shops] columns['identifier'], [ script:renzu_shops] json.encode(columns['money'] or {}), [ script:renzu_shops] json.encode(columns['items'] or {}), [ script:renzu_shops] columns['plate'], [ script:renzu_shops] columns['type'], [ script:renzu_shops] columns['shopname'], [ script:renzu_shops] }) [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] if GetResourceKvpString('financedata') then [ script:renzu_shops] for k,v in pairs(json.decode(GetResourceKvpString('financedata'))) do [ script:renzu_shops] local columns = {} [ script:renzu_shops] columns['identifier'] = k [ script:renzu_shops] local data = {} [ script:renzu_shops] for k,v in pairs(v) do [ script:renzu_shops] columns[k] = v [ script:renzu_shops] end [ script:renzu_shops] Sql.insert('financedata',{ [ script:renzu_shops] columns['identifier'], [ script:renzu_shops] tonumber(columns['max']), [ script:renzu_shops] json.encode(columns['financed'] or {}), [ script:renzu_shops] }) [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] --DeleteResourceKvp('renzu_stores_convert') [ script:renzu_shops] if not GetResourceKvpString('renzu_stores_convert') then [ script:renzu_shops] convert() [ script:renzu_shops] SetResourceKvp('renzu_stores_convert', 'true') [ script:renzu_shops] end [ script:renzu_shops] [ script:renzu_shops] local Stores = {} [ script:renzu_shops] for k,v in pairs(MySQL.query.await('SELECT FROM renzu_stores', { }) or {}) do [ script:renzu_shops] Stores[v.shop] = {} [ script:renzu_shops] for column,data in pairs(v) do [ script:renzu_shops] if string.find(data, '{') then [ script:renzu_shops] Stores[v.shop][column] = json.decode(data) [ script:renzu_shops] elseif data == '[]' then [ script:renzu_shops] Stores[v.shop][column] = {} [ script:renzu_shops] else [ script:renzu_shops] Stores[v.shop][column] = data [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] [ script:renzu_shops] local Movable = {} [ script:renzu_shops] for k,v in pairs(MySQL.query.await('SELECT FROM movableshops', { }) or {}) do [ script:renzu_shops] Movable[v.identifier] = {} [ script:renzu_shops] for column,data in pairs(v) do [ script:renzu_shops] if string.find(data, '{') then [ script:renzu_shops] Movable[v.identifier][column] = json.decode(data) [ script:renzu_shops] elseif data == '[]' then [ script:renzu_shops] Movable[v.identifier][column] = {} [ script:renzu_shops] else [ script:renzu_shops] Movable[v.identifier][column] = data [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] [ script:renzu_shops] local Financed = {} [ script:renzu_shops] for k,v in pairs(MySQL.query.await('SELECT FROM financedata', { }) or {}) do [ script:renzu_shops] Financed[v.identifier] = {} [ script:renzu_shops] for column,data in pairs(v) do [ script:renzu_shops] if string.find(data, '{') then [ script:renzu_shops] Financed[v.identifier][column] = json.decode(data) [ script:renzu_shops] elseif data == '[]' then [ script:renzu_shops] Financed[v.identifier][column] = {} [ script:renzu_shops] else [ script:renzu_shops] Financed[v.identifier][column] = data [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] [ script:renzu_shops] for k,v in pairs(shared.OwnedShops) do [ script:renzushops] local str = 'Stores%s' [ script:renzu_shops] for k,v in pairs(v) do [ script:renzu_shops] GlobalState[str:format(v.label)] = nil [ script:renzu_shops] end [ script:renzu_shops] end [ script:renzu_shops] AddStateBagChangeHandler("Stores", "global", function(bagName, key, value) [ script:renzu_shops] Wait(0) [ script:renzu_shops] if not value then return end [ script:renzu_shops] for shop,data in pairs(value) do -- Split datas to dedicated bags to prevent byte size limits [ script:renzushops] local str = 'Stores%s' [ script:renzu_shops] GlobalState[str:format(shop)] = data [ script:renzu_shops] end [ script:renzu_shops] end) [ script:renzu_shops] [ script:renzu_shops] GlobalState.Shipping = json.decode(GetResourceKvpString('shippingcompany') or '[]') or {} [ script:renzu_shops] GlobalState.Stores = Stores [ script:renzu_shops] GlobalState.MovableShops = Movable [ script:renzu_shops] GlobalState.FinanceData = Financed [ script:renzu_shops] GlobalState.JobShop = {} [ script:renzu_shops] return Sql:201) [ script:renzu_shops] > fn (@renzu_shops/server/main.lua:16) [ script:renzu_shops] > (@oxmysql/dist/build.js:21810) [ script:renzu_shops] > processTicksAndRejections (node:internal/process/task_queues:96)