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

Yup I have all the above done like posted I’m have sql errors that’s my only issue, No console errors shop opens I see shop but no items listed.

2 Likes

Can you send me the sqlp erros?

1 Like

yep and no errors
20Characters

2 Likes

Do you have more items on the shop or only those?
and did you managed to add the sql files?

1 Like

Yup ill send you my errors here soon.

1 Like

Shops sql installed just fine but basicneeds throws this error for me.

2 Likes

Why would you add bread & water if it’s already added…?

2 Likes

I was only loading the sqls that came in the zip. My bad.

Removed them and still errors.

And I see there are doubles here so I guess I rewrite the sql then…

So removing shops sql and adding basicneeds sql still errors with no food in my database at all. Not sure why just keeps saying syntax error. like above. NO matter what I remove.

3 Likes
  • there is people that don’t have this mods, and i think people have the enough brain to see that :stuck_out_tongue:
3 Likes

esx_basicneeds.sql

INSERT INTO `items` (name, label) VALUES 
    ('bread', 'Bread'),
    ('water', 'Water'),
    ('wine', 'Wine'),
    ('beer', 'Beer'),
    ('vodka', 'Vodka'),
    ('chocolate', 'Chocolate'),
    ('sandwich', 'Sandwich'),
    ('hamburger', 'Hamburger'),
    ('tequila', 'Tequila'),
    ('whisky', 'Whisky'),
    ('cupcake', 'Cupcake'),
    ('cocacola', 'Coca-Cola'),
    ('icetea', 'Ice-Tea'),
    ('redbull', 'Coffe')
;

esx_shops.sql

INSERT INTO `shops` (name, item, price) VALUES
	('Bar', 'wine', 50),
	('Bar', 'beer', 50),
	('Bar', 'vodka', 50),
	('TwentyFourSeven', 'chocolate', 20),
	('RobsLiquor', 'chocolate', 20),
	('LTDgasoline', 'chocolate', 20),
	('TwentyFourSeven', 'sandwich', 30),
	('RobsLiquor', 'sandwich', 30),
	('LTDgasoline', 'sandwich', 30),
	('TwentyFourSeven', 'hamburger', 30),
	('RobsLiquor', 'hamburger', 30),
	('LTDgasoline', 'hamburger', 30),
	('Bar', 'tequila', 40),
	('Bar', 'whisky', 40),
	('TwentyFourSeven', 'cupcake', 15),
	('RobsLiquor', 'cupcake', 15),
	('LTDgasoline', 'cupcake', 15),
	('TwentyFourSeven', 'cocacola', 25),
	('RobsLiquor', 'cocacola', 25),
	('LTDgasoline', 'cocacola', 25),
	('TwentyFourSeven', 'icetea', 20),
	('RobsLiquor', 'icetea', 20),
	('LTDgasoline', 'icetea', 20),
	('TwentyFourSeven', 'redbull', 30),
	('RobsLiquor', 'redbull', 30),
	('LTDgasoline', 'redbull', 30)
;

This sould work

2 Likes

Thanks will give this a try. I realize people use different scripts excet. Sorry for any inconvenience.

1 Like

Basicneeds sql is saying. SQL Error (1364): Field ‘id’ doesn’t have default value. Sorry still learning sql here.

1 Like

This changes the menu to?

2 Likes

No sir xD That menu is a private menu that I use on my server

1 Like

nice look menus, but if it dont have nothing to do with the resource why you posted? i got confused when saw the topic

2 Likes

Because those menus are in my extended itself, all menus on extended are like this ones on my server xD

3 Likes

Does anybody know?
[ERROR] [MySQL] An critical error happens on MySQL for query “UPDATE users SET status = @status WHERE identifier = @identifier {@identifier=steam:11000011638ab5a;@status=[{“val”:790400,“name”:“hunger”,“percent”:79.04},{“val”:815000,“name”:“thirst”,“percent”:81.5},{“val”:0,“name”:“drunk”,“percent”:0.0}]}”: Value does not fall within the expected range. at System.Net.Sockets.Socket.SetSocketOption (System.Net.Sockets.SocketOptionLevel optionLevel, System.Net.Sockets.SocketOptionName optionName, System.Int32 optionValue) [0x00023] in <7d13762c3f3046279fc4d30c52f6f595>:0
at System.Net.Sockets.Socket.SetSocketOption (System.Net.Sockets.SocketOptionLevel optionLevel, System.Net.Sockets.SocketOptionName optionName, System.Boolean optionValue) [0x00008] in <7d13762c3f3046279fc4d30c52f6f595>:0
at MySql.Data.Serialization.SerializationUtility.SetKeepalive (System.Net.Sockets.Socket socket, System.UInt32 keepAliveTimeSeconds) [0x00000] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0
at MySql.Data.Serialization.MySqlSession+d__58.MoveNext () [0x003bd] in <5d2e43c2aa6f4da0bb43a6a12077ad51>: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.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at MySql.Data.Serialization.MySqlSession+<ConnectAsync>d__49.MoveNext () [0x000ed] in <5d2e43c2aa6f4da0bb43a6a12077ad51>: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.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at MySql.Data.MySqlClient.ConnectionPool+<GetSessionAsync>d__0.MoveNext () [0x00467] in <5d2e43c2aa6f4da0bb43a6a12077ad51>: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.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at MySql.Data.MySqlClient.MySqlConnection+d__68.MoveNext () [0x00102] in <5d2e43c2aa6f4da0bb43a6a12077ad51>: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.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at MySql.Data.MySqlClient.MySqlConnection+<OpenAsync>d__19.MoveNext () [0x000cb] in <5d2e43c2aa6f4da0bb43a6a12077ad51>: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.GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at MySQLAsync.Operation1+d__3[TResult].MoveNext () [0x000aa] in <6b79789832b34a31961dbb39358e1b3f>:0

1 Like

That error is from esx_status

Hmm, do you have any clue why?

1 Like

do you have esx_status updated? starting on the rigth spot on the server.cfg file? Do you have the requirements for esx_status if they exist?