Having trouble with es_extended colliding with other resources / not working. would love some help.
[SCREENSHOT ATTACHED]
Technically, this implies a user has an inventory item that does not exist in the items table, in short: some sort of data mismatch.
1 Like
How do I figure out which item it is?
Also, does this error mean it’s an item from es_extended ?
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.
3 Likes
The SQL asks me to specify a database, how do I specify “essentialmode” as the database for the command?
This depends on the specific SQL tool you’re using to run queries - but try USE essentialmode; before the SELECT statement.
1 Like
2 Results came out:
Water, Bread.
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.
1 Like
You guys are beasts. thanks for all the help!
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. 
1 Like
Alright, I’ll try figuring it out.
Btw, is asking for outside communication programs not allowed in these forums?
Correct - outside of Server Bazaar, any offering/requesting direct services is disallowed.
Even in private messages? because if both parties agree I don’t see the hassle in disabling it.
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.
Jeez why are people so nice in these forums lol. <3
1 Like
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
hello i have same problem
i do what he say but anything not coming for me
no any bread / water or …
can help me?