@mrdigital01
The sql file originally dind’t have those from esx oficial github but its fixed now, thanks sir! xD
You can’t even see the markers? ok now the problems is from esx_shops itself yeah.
So some steps so you can fix that, make sure your es_extended is updated and all other recources, now you need to make sure you have esx_status(don’t forget esx_status sql) installed and working/updated, then you need to instal esx_basicneeds and esx_shops that’s easy, then in the server.cfg make sure you have the right order, requirements always first! xD
Okay lets try
1 Like
Fixed i have a outdated es_extended --" my bad srry guys for your time
1 Like
No problem, and thanks for using this script!
1 Like
NEW UPDATE AVAILABLE ON GITHUB!
New drinks and foods added to the shops, props now are the rights one for the items, hunger and thirst values changed for each item
More to come very soon!
1 Like
How do you cancel the smoking animation when you use the cigarette?
1 Like
Well if you read the entire post you could already know that, because I have a “notes” part for some reason…but just press " X " sir! xD
Sorry about that i normally see that kind of stuff. It slipped my eyes. Thank you.
1 Like
when trying to apply a new resource to my database (esx_shops.sql) an error pops up
"
SQL Error (1044): Access denied for user
‘zap405342-1’@’%’ to database ‘essentialmode’
"
~ I’ve restarted my server a dozen times since
~ I’ve changed passwords and relogged in and restarted HeidiSQL and combinations of them
~ been looking around videos of Fivem and even HeidiSQL and SQL in general
~ repeat 1, 2 and 3 a few more times
~ any help?
1 Like
Ahahah no problem sir!
In the sql file delete the line that says “use essentialmode”
Error
SQL query:
``
INSERT INTO `shops` (id, store, item, price) VALUES
(1, 'TwentyFourSeven', 'bread', 30),
(2, 'TwentyFourSeven', 'water', 15),
(3, 'RobsLiquor', 'bread', 30),
(4, 'RobsLiquor', 'water', 15),
(5, 'LTDgasoline', 'bread', 30),
(6, 'LTDgasoline', 'water', 15),
(7, 'TwentyFourSeven', 'chocolate', 10),
(8, 'RobsLiquor', 'chocolate', 10),
(9, 'LTDgasoline', 'chocolate', 10),
(10, 'TwentyFourSeven', 'sandwich', 10),
(11, 'RobsLiquor', 'sandwich', 10),
(12, 'LTDgasoline', 'sandwich', 10),
(13, 'TwentyFourSeven', 'hamburger', 15),
(14, 'RobsLiquor', 'hamburger', 15),
(15, 'LTDgasoline', 'hamburger', 15),
(16, 'TwentyFourSeven', 'cupcake', 10),
(17, 'RobsLiquor', 'cupcake', 10),
(18, 'LTDgasoline', 'cupcake', 10),
(19, 'TwentyFourSeven', 'cocacola', 15),
(20, 'RobsLiquor', 'cocacola', 15),
(21, 'LTDgasoline', 'cocacola', 15),
(22, 'TwentyFourSeven', 'icetea', 10),
(23, 'RobsLiquor', 'icetea', 10),
(24, 'LTDgasoline', 'icetea', 10),
(25, 'TwentyFourSeven', 'coffe', 10),
(2[...]
MySQL said: 
#1062 - Duplicate entry '1' for key 'PRIMARY'
you need to change the collation of the name collumn to utf8mb4, you can do that in the “structure” tab, click on change in the label row. then it should work 
1 Like
Same error here.
1 Like
Are you deleting also the old shops table in the dabatase then add the new one?
https://cdn.discordapp.com/attachments/417795250179014656/559027458696019980/unknown.png getting this error when trying to click into the menu 2nd. im not getting a error on line 15 of the basic needs sql
i have had many problems with your script, but its worth the time
1 Like
Hi fella quick ? this works great np but i dont know what i might of missed but the menu is standard like old shop no color or food icons what do i need to do or update to fix this bit seeing as its all working ok lol
1 Like
Hey sir! Its nice to ear that, the colored menu is an custom esx_menu that i made for my server, the icons/emojis you can insert them in the database