Error with es_extended on the console

[Martillon]

Guys I try to start my server but this pops up in the console

And if I go to the references

If you need any more images, tell me. Idk how to solve this error

[VinaStar]

In the first screenshot it say Error no such table, fivem.items

Can you confirm that table exist in the database?

[Martillon]

No, but from the video I’m following, it works, it doesn’t give a problem

[Crutchie]

Check your mysql connection. It’s looking in your fivem database not your essentialmode one. So change the string to look in essentialmode in your server.cfg

[Martillon]

This is how I have my server.cfg

[SuperSaiyan]

Set mysql_connection_strin ‘sever=127.0.0.1;uid=root;password=;databese=essentialmode’
Set es_enableCustomData 1

[Martillon]

This solved the connection, but it didn’t solved the other problems.

[Nekix]

The tables doesn’t exit, send a photo of your server.cfg complete

[NightShadow_S]

Your problem coming from database.First you doesn’t have tables like items and second “Attempt to get length of a nil value” mean that some column was set to NULL and you need to change it to NOT NULL (I’m not fully sure about this but actually its a database problem).

[SuperSaiyan]

you don’t need 7 until 9 lines