Gcphone mysql error

[sync_damjan]

Hey, I have an error with gcphone, when I type a message or send or call somebody, I get an error in console, it says [ERROR] [MySQL] [gcphone] An error happens on MySQL for query “INSERT INTO phone_messages (transmitter, receiver,message, isRead,owner) VALUES(‘police’, @receiver, ‘GPS: -2128.2749023438, -1952.4270019531’, 1, 1);”: ER_BAD_NULL_ERROR: Column ‘receiver’ cannot be null

Help anyone??!

[Lorenc]

@sync_damjan

ER_BAD_NULL_ERROR: Column ‘receiver’ cannot be null

Thats ur issue, check what its trying to input into the receiver column by printing the value.

[sync_damjan]

I didn’t change anything, but I changed only the languange

[White_01]

I have the same problem, I changed only

es:playerLoaded

to

esx:playerLoaded

to adapt gcphone with the new esx
sync_damjan do you use also the last esx version ?

[White_01]

I found the solution, I made a post here:

[Q&A] GCPhone Questions? Ask them here, Will update main post frequently with updates

I tried this and it worked for me: in server.lua, add this at the beginning local ESX = nil TriggerEvent('esx:getSharedObject', function(obj) ESX = obj end) Replace function getPlayerID(source) local identifiers = GetPlayerIdentifiers(source) local player = getIdentifiant(identifiers) return player end by function getPlayerID(source) local xplayer = ESX.GetPlayerFromId(source) local player = xplayer.identifier return player end and if the phone numbers aren’t …

[sync_damjan]

yea, I have. I’ll take a look

[sync_damjan]

Thanks man, it is working, but there is a delay when sending messages and when Im calling someone, it dosen’t ring and I get this error SCRIPT ERROR: @gcphone/server/server.lua:80: attempt to index a nil value (local ‘xplayer’)

[sync_damjan]

And is this the same fix for es_admin2

[White_01]

I just tested this fix with another player and I have the same problem than you …
I didn’t try with es_admin2

[sync_damjan]

And did u resolve it??

[White_01]

Not for the moment … i’m only a “beginner”