Error upon server launch: MySQL BUFFER shortage

Th3Cha0s · 2019-04-21T10:04:56.098Z

Having trouble with es_extended colliding with other resources / not working. would love some help.

[SCREENSHOT ATTACHED]

praseodymium · 2019-04-21T10:12:14.358Z

Technically, this implies a user has an inventory item that does not exist in the items table, in short: some sort of data mismatch.

Th3Cha0s · 2019-04-21T10:16:32.989Z

How do I figure out which item it is?
Also, does this error mean it’s an item from es_extended ?

boron · 2019-04-21T10:19:51.809Z

Th3Cha0s:

How do I figure out which item it is?

Try this SQL query;

SELECT DISTINCT item FROM user_inventory WHERE item NOT IN (
    SELECT name FROM items
);

It should return which items are referenced, but yet non-existent.

Th3Cha0s · 2019-04-21T10:23:40.875Z

The SQL asks me to specify a database, how do I specify “essentialmode” as the database for the command?

rutherfordium · 2019-04-21T10:24:16.907Z

This depends on the specific SQL tool you’re using to run queries - but try USE essentialmode; before the SELECT statement.

Th3Cha0s · 2019-04-21T10:28:56.029Z

2 Results came out:
Water, Bread.

I emptied both from table but error still exists?

lithium · 2019-04-21T10:30:58.465Z

Th3Cha0s:

I emptied both from table but error still exists?

This specific SELECT query will only return one instance per missing item, remove the DISTINCT if you want to act based on the results.

Th3Cha0s · 2019-04-21T10:32:21.847Z

You guys are beasts. thanks for all the help!

One last issue though, how the f*** do I get water and bread now? lol.

element.22 · 2019-04-21T10:33:15.132Z

Th3Cha0s:

One last issue though, how the f*** do I get water and bread now? lol.

It’s probably the case that whatever ESX addon that includes water/bread (basicneeds, maybe?) has a .sql file you might’ve forgotten to import.

It’d be neat if ESX warned on missing items instead of failing user load and would automatically execute migrations, though.

Th3Cha0s · 2019-04-21T10:36:33.933Z

Alright, I’ll try figuring it out.

Btw, is asking for outside communication programs not allowed in these forums?

barium · 2019-04-21T10:39:55.528Z

Th3Cha0s:

Btw, is asking for outside communication programs not allowed in these forums?

Correct - outside of Server Bazaar, any offering/requesting direct services is disallowed.

Th3Cha0s · 2019-04-21T10:41:06.114Z

Even in private messages? because if both parties agree I don’t see the hassle in disabling it.

oxygen · 2019-04-21T10:42:07.993Z

Th3Cha0s:

Even in private messages?

Yes, you’re allowed to send people messages, of course - just avoid asking for such in the public sections.

There’s a quick button behind the icon to send a user a message about their post.

Th3Cha0s · 2019-04-21T10:43:10.384Z

Jeez why are people so nice in these forums lol. <3

Hawaii_Beach · 2019-04-22T09:08:00.091Z

element.22:

It’d be neat if ESX warned on missing items instead of failing user load and would automatically execute migrations, though.

I’ll take a look implementing just that, or at least warn & ignore invalid items.

EDIT: https://github.com/ESX-Org/es_extended/commit/166d8c17a6f5cd78f0bf1264c795abd06457274a

YasharInfeRnal · 2019-08-25T23:47:59.204Z

hello i have same problem
i do what he say but anything not coming for me
no any bread / water or …
can help me?

YasharInfeRnal · 2019-08-26T00:02:07.116Z

Error: BUFFER_SHORTAGE | I Have This Error My Data Not Loaded Please FIX ES/ESX

Error: BUFFER_SHORTAGE [image] 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:/s…