QB-Phone error

Kiwi · June 8, 2022, 7:17pm

I keep getting the below error with QB-Phones

does anyone have any ideas?

Kakarot · June 8, 2022, 7:22pm

I’m not seeing anything related to query on my end at that line?

qbcore-framework/qb-phone/blob/d747d9c94c586cea56aa22c07f7b9b694d4e3626/server/main.lua#L268

      
        
            end)
            
            
QBCore.Functions.CreateCallback('qb-phone:server:PayInvoice', function(source, cb, society, amount, invoiceId, sendercitizenid)
                local Invoices = {}
                local Ply = QBCore.Functions.GetPlayer(source)
                local SenderPly = QBCore.Functions.GetPlayerByCitizenId(sendercitizenid)
                local invoiceMailData = {}
                if SenderPly and Config.BillingCommissions[society] then
                    local commission = round(amount * Config.BillingCommissions[society])
                    SenderPly.Functions.AddMoney('bank', commission)
                    invoiceMailData = {
                        sender = 'Billing Department',
                        subject = 'Commission Received',
                        message = string.format('You received a commission check of $%s when %s %s paid a bill of $%s.', commission, Ply.PlayerData.charinfo.firstname, Ply.PlayerData.charinfo.lastname, amount)
                    }
                elseif not SenderPly and Config.BillingCommissions[society] then
                    invoiceMailData = {
                        sender = 'Billing Department',
                        subject = 'Bill Paid',
                        message = string.format('%s %s paid a bill of $%s', Ply.PlayerData.charinfo.firstname, Ply.PlayerData.charinfo.lastname, amount)
                    }

Kiwi · June 8, 2022, 9:30pm

This is line 258 on my end mate,

local result = MySQL.query.await(‘SELECT * FROM player_contacts WHERE citizenid = ? ORDER BY name ASC’, {Player.PlayerData.citizenid})
local Contacts = {}
if result[1] ~= nil then
for k, v in pairs(result) do
v.status = GetOnlineStatus(v.number)
end

258 being the too

Kakarot · June 8, 2022, 9:32pm

Is your oxmysql up to date? Release v2.3.1 · overextended/oxmysql (github.com)

Kiwi · June 9, 2022, 7:40am

Hi, yes i can confirm this is up to date

system · July 9, 2022, 7:41am

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.