MYSQL Select query is not working help please?

FiveM Resource Development Discussion
1

I get this error

InvokeNative: execution failed: Argument at index 1 was null.
Error running call reference function for resource vs_cad: citizen:/scripting/lua/scheduler.lua:348: Execution of native 000000002f7a49e6 in script host failed.
stack traceback:
        [C]: in upvalue '_in'
        citizen:/scripting/lua/natives_server.lua:238: in function 'TriggerClientEventInternal'
        (...tail calls...)
        sv_main.lua:16: in upvalue 'ref'
        citizen:/scripting/lua/scheduler.lua:334: in function <citizen:/scripting/lua/scheduler.lua:333>
        [C]: in function 'xpcall'
        citizen:/scripting/lua/scheduler.lua:333: in function <citizen:/scripting/lua/scheduler.lua:332>
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:348: in function <citizen:/scripting/lua/scheduler.lua:319>
[ERROR] [MySQL] Check the error above, an error happens when executing the callback from the query : "SELECT * FROM characters WHERE uniqueUsername=@username OR phoneNumber=@phone {@username=e;@phone=e}"

server file is:

RegisterServerEvent("character:create")
AddEventHandler("character:create", function(fname, lname, age, gender, Username, Phone)
	local player = source
	local uniqueUsername = uniqueUsername
	local phoneNumber = phoneNumber
    local Name = GetPlayerName(player)
    local identifier = GetPlayerIdentifiers(player)[1]
    local cash = 3000
    local bank = 17000
    local job = "Unemployed"
	local result = MySQL.Async.fetchAll('SELECT * FROM characters WHERE uniqueUsername=@username OR phoneNumber=@phone', {['@username'] = Username, ['@phone'] = Phone}, function (result)
		if(result[1] == nil) then
			MySQL.Async.execute("INSERT INTO characters (identifier, fname, lname, age, gender, uniqueUsername, phoneNumber, job, cash, bank) VALUES (@identifier, @fname ,@lname,@age,@gender,@uniqueUsername,@phoneNumber,@job,@cash,@bank)", {['@identifier'] = identifier, ['@fname'] = fname, ['@lname'] = lname, ['@age'] = age, ['@gender'] = gender, ['@uniqueUsername'] = uniqueUsername, ['@phoneNumber'] = phoneNumber, ['@job'] = job, ['@cash'] = cash, ['@bank'] = bank})
			TriggerClientEvent("nuiFocusAndHudOff")
		else
		    TriggerClientEvent("error:nameExists")
		end
    end)
end)```
2

I think you forgot an @ for your parameter:

['phone'] = phoneNumber

to

['@phone'] = phoneNumber
3

That’s not the problem I realized that and fixed it but still didn’t work

4

change it to

'SELECT * FROM users WHERE uniqueUsername=@username AND phoneNumber=@phone'
5 
InvokeNative: execution failed: Argument at index 1 was null.
Error running call reference function for resource vs_cad: citizen:/scripting/lua/scheduler.lua:348: Execution of native 000000002f7a49e6 in script host failed.
stack traceback:
        [C]: in upvalue '_in'
        citizen:/scripting/lua/natives_server.lua:238: in function 'TriggerClientEventInternal'
        (...tail calls...)
        sv_main.lua:16: in upvalue 'ref'
        citizen:/scripting/lua/scheduler.lua:334: in function <citizen:/scripting/lua/scheduler.lua:333>
        [C]: in function 'xpcall'
        citizen:/scripting/lua/scheduler.lua:333: in function <citizen:/scripting/lua/scheduler.lua:332>
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:348: in function <citizen:/scripting/lua/scheduler.lua:319>
[ERROR] [MySQL] Check the error above, an error happens when executing the callback from the query : "SELECT * FROM characters WHERE uniqueUsername=@username OR phoneNumber=@phone {@username=e;@phone=e}"

Sry didn’t relies this but that’s the full error I am getting any ideas?

6

Try to remove the local result = as it might be conflicting with the function(result). You don’t need to assign it to a local variable.

7

I have fixed the issue it is because I am calling a client event how can I can client event it is not letting me it throws an error when calling a trigger client event

8

You are forgetting the second argument in TriggerClientEvent, you need to specify who you are triggering it on.