Mysql Query Returning Nil

FiveM Resource Development & Modding Discussion
1

Basically Ive had this problem before and tried to using the help I had before from Mobius but it still doesn’t work I have data in the table but it doesn’t work.

QBCore.Commands.Add('pickupminer', "Pickup your nearby miner!", { }, false, function(source, _)
    
    local Player = QBCore.Functions.GetPlayer(source)
    local fn, ln = Player.PlayerData.charinfo.firstname, Player.PlayerData.charinfo.lastname
    
    local pickupminers = MySQL.query.await('SELECT * FROM hawscryptominer WHERE creator = ?', {tostring(fn.." "..ln)})
    if pickupminers ~= nil then TriggerClientEvent('okokNotify:Alert', source, "Haws Miner", "You have no miners!", 5000, 'error') end
    for n, v in pairs(pickupminers) do

Screenshot_11
Screenshot_111803×293 232 KB

Screenshot_10
Screenshot_101919×1079 347 KB

2

This makes no sense:

if pickupminers ~= nil then

Change it to this:

if pickupminers == nil or #pickupminers == 0 then
3

Ffs I just spent an hr looking for that mistake ahhhhhhhh. Sometimes you just need someone else to look at it