FiveM can't get user data ,error about Buffer Shortage

FiveM Server Development ES/ESX
1

I was creating my own server.

And I tried so many times,it still couldn’t get the user’s data in the “users” table in my database.

When I entered my server, it always shows “Buffer_Shortage”.

Error running call reference function for resource esx_identity: citizen:/scripting/lua/scheduler.lua:405: @esx_identity/server/main.lua:11: attempt to index a nil value (field ‘?’)
stack traceback:
@esx_identity/server/main.lua:11: in upvalue ‘ref’
citizen:/scripting/lua/scheduler.lua:391: in function citizen:/scripting/lua/scheduler.lua:390
[C]: in function ‘xpcall’
citizen:/scripting/lua/scheduler.lua:390: in function citizen:/scripting/lua/scheduler.lua:389
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:405: in function citizen:/scripting/lua/scheduler.lua:374
Error: Unhandled error in timer: Error: BUFFER_SHORTAGE
Error: BUFFER_SHORTAGE
at n.e [as reserve] (citizen:/scripting/v8/msgpack.js:29:12766)
at h (citizen:/scripting/v8/msgpack.js:29:15761)
at n.r [as decode] (citizen:/scripting/v8/msgpack.js:29:13908)
at n.fetch (citizen:/scripting/v8/msgpack.js:29:6972)
at n.u [as read] (citizen:/scripting/v8/msgpack.js:29:12076)
at Object.n [as decode] (citizen:/scripting/v8/msgpack.js:29:7097)
at unpack (citizen:/scripting/v8/main.js:20:33)
at citizen:/scripting/v8/main.js:51:20
at setImmediate (mysql-async.js:5140:7)
at Object.callback (citizen:/scripting/v8/timer.js:96:21)
Error running call reference function for resource es_extended: citizen:/scripting/lua/scheduler.lua:405: @es_extended/server/main.lua:133: attempt to index a nil value (field ‘?’)
stack traceback:
@es_extended/server/main.lua:133: in upvalue ‘ref’
citizen:/scripting/lua/scheduler.lua:391: in function citizen:/scripting/lua/scheduler.lua:390
[C]: in function ‘xpcall’
citizen:/scripting/lua/scheduler.lua:390: in function citizen:/scripting/lua/scheduler.lua:389
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:405: in function citizen:/scripting/lua/scheduler.lua:374
Error: Unhandled error in timer: Error: BUFFER_SHORTAGE
Error: BUFFER_SHORTAGE
at n.e [as reserve] (citizen:/scripting/v8/msgpack.js:29:12766)
at h (citizen:/scripting/v8/msgpack.js:29:15761)
at n.r [as decode] (citizen:/scripting/v8/msgpack.js:29:13908)
at n.fetch (citizen:/scripting/v8/msgpack.js:29:6972)
at n.u [as read] (citizen:/scripting/v8/msgpack.js:29:12076)
at Object.n [as decode] (citizen:/scripting/v8/msgpack.js:29:7097)
at unpack (citizen:/scripting/v8/main.js:20:33)
at citizen:/scripting/v8/main.js:51:20
at setImmediate (mysql-async.js:5140:7)
at Object.callback (citizen:/scripting/v8/timer.js:96:21)
server thread hitch warning: timer interval of 2736 milliseconds

And it’s my server.cfg server.cfg (3.9 KB)

I really don’t know what;s wrong and how to solve it.

2

Make sure your SQL connection is set up properly.

3

I’m sure that the connection is correct.

And I found that when I entered my server,I found my steamID in the “user_inventory” table.

Only the “users” table had no data.

So I tried to create a line and type my steamID and name,it Worked.

But I still don’t know why.

And it would be complicated if I have to add the player data by myself.

4

In your SQL make sure users and all the tables are put under “essentialmode”.
Also, please check if the part that inputs into your SQL users table in your scripts is working correctly and not broken.
Good luck

5

I could store my data into the database.

But there is another problem,I can’t set myself as the admin of my server.

I change the permission level and group in the users table,or edit the server.cfg.

Both of these didn’t work.

6

Do it through the console. Setgroup “id” superadmin

And setuser “id” 4 (I think it’s setuser not sure tho)

7

You say the console in game?

But I don’t have the permission.I can’t use most of commands.

8

Server console. I’m guessing it’s locally hosted ?

9

But I’m playing with my friend.

Is server console that I press F8 in the game?

10

No, the console you start the server with.

11

Can you tell me more details? I really don’t understand it.

12

Can I ask one more question?

I installed the esx_phone but I could only call the ambulance and the mechanic.

When I sent the message, who had these jobs would receive it.

But if I sent to the police and the taxi, there’s no responding.

Do I just reinstall the esx_taxijob and esx_policejob?

13

I don’t use esx_phone, if you could attach some info relating to that issue that’d be great.

14

But it didn’t display any error while I startup the server or send text to taxi.

it seems that it is associated with esx_society

And I’m still not the admin of my server 0.0

15

Weirdly enough I’m getting both of these issues. I can’t set my self admin (console returns: access denied add_principal) and I get a Buffer Shortage error in console when someone connects although, the data does get retrieved. Some help would be great.

16

My solution about Buffer shortage is that I typed the player’s steam id in advance.

And they could join the server successfully.

I’m not sure what’s wrong with it.

And about the admin permission, I found that I typed add_principal and I have most of the permission.

But when I typed /admin in the game, it still shows my level 0 and group user.

I still can setmoney, setjob, and others can’t do that.

But I can’t stop the resources in the game.