(UPDATE-11/12/2019) [Release] [ESX] Shops with bars (V.1.7) (OLD ESX)

People v.1.3 is made for the new versions of extended, and the new versions of extendes changed alot of thins on the database so the sql files of course will not work if you have old versions…so people update everything first if the error keeps showing then i can give you some support xD

ok and i thought i did have the new one.do u have a link for the new one because i downloaded a new and redid my database and it still did the same thing

1 Like

You have to make sure you have everything updated, essentialmode, extended and everything that has esx on their name

I get the same error - i have everything updated

The error on the database trying to add the sql files or in game?

I searched the entire thread and didn’t see it asked. How do you slow down how often you eat and drink? I’m asking here because your release also has basicneeds attached to it. Thanks in advance.

1 Like

im getting this error in from async and don’t know if it is a shop or async error

[ERROR] [MySQL] An critical error happens on MySQL for query “SELECT * FROM shops LEFT JOIN items ON items.name = shops.item {=}”: An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException (System.ExceptionResource resource) [0x0000b] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Collections.Generic.Dictionary 2[TKey,TValue].Insert (TKey key, TValue value, System.Boolean add) [0x0007c] in &lt;0123fd5b1a1040fe9d70a7e0d4b28acb&gt;:0 at System.Collections.Generic.Dictionary 2[TKey,TValue].Add (TKey key, TValue value) [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at MySQLAsync.FetchAll+<ReaderAsync>d__2.MoveNext () [0x000e9] in <6b79789832b34a31961dbb39358e1b3f>:0
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter 1[TResult].GetResult () [0x00000] in &lt;0123fd5b1a1040fe9d70a7e0d4b28acb&gt;:0 at MySQLAsync.Operation 1+<ExecuteAsync>d__3[TResult].MoveNext () [0x00169] in <6b79789832b34a31961dbb39358e1b3f>:0

If this has been posted already i’m sorry… the basicneeds sql is not working right i found the fix and wanted to share. i found a , at the end that was not suppose to be and you forgot some labels at the top. this will fix the sql importing for anyone who is having issues.

Here is the corrected SQL

esx_basicneeds sql
USE `essentialmode`;

INSERT INTO `items` (`name`, `label`, `limit`, `rare`, `can_remove`) VALUES
('beer', 'Beer', 15, 0, 1),
('bread', 'Bread', 15, 0, 1),
('chocolate', 'Chocolate', 10, 0, 1),
('cigarett', 'Cigarett', 20, 0, 1),
('cocacola', 'Coca-Cola', 15, 0, 1),
('coffe', 'Coffe', 15, 0, 1),
('cupcake', 'Cupcake', 15, 0, 1),
('hamburger', 'Hamburger', 15, 0, 1),
('icetea', 'Ice-Tea', 15, 0, 1),
('lighter', 'Lighter', 1, 0, 1),
('milk', 'Milk', 15, 0, 1),
('sandwich', 'Sandwich', 15, 0, 1),
('tequila', 'Tequila', 15, 0, 1),
('vodka', 'Vodka', 15, 0, 1),
('water', 'Water', 5, 0, 1),
('whisky', 'Whisky', 15, 0, 1),
('wine', 'Wine', 15, 0, 1)
;

-- You can translate the items name to your languange in the "label" section --
1 Like

In esx_status not basicneeds

Thanks sir xD

SQL Files fixed

Guys i need help im getting error
cannot read property ‘scrollintoview’ of undefined
can some one help me ? :frowning:

1 Like

That is an error from esx_menu not the shops

But i cant handle that error, it makes me crazy, can you help me please?

1 Like

The menus still work? just asking because a few months ago i had the same error and everything worked fine sir xD
Make sure you have the 3 esx_menu scripts updated and don’t download them from the esx_base link go to the esx_menu themselfs

Good evening I have a little worries when I buy a product at the store I have an error that appears in my console I can buy but still an error that appears I try to change the esx_menu_default is es_extended but same I always have the same mistake if someone has a small idea on his thanks to all

I would like to have shop were you can collect items you wanna buy from the shelf and then you have option to steal that food or pay it but if you steal you will alert police to the shop you stole from :smile: or shop were every shelf has own different items, that would be cool too

I do everything ok but i don’t have anything in shop and problem with ScrolIntoView

1 Like

Hello in store items are not popping up like shop is empty

1 Like

Version 1.4 is out, this should fix some problems that people are having with the items not showing up

IMPORTANT thing that some people don’t get:

The new version is made for THE NEW VERSIONS OF EXTENDED

1 Like