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.
Can you send me the sqlp erros?
yep and no errors
20Characters
Do you have more items on the shop or only those?
and did you managed to add the sql files?
Yup ill send you my errors here soon.
Why would you add bread & water if it’s already added…?
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.
- there is people that don’t have this mods, and i think people have the enough brain to see that
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
Thanks will give this a try. I realize people use different scripts excet. Sorry for any inconvenience.
Basicneeds sql is saying. SQL Error (1364): Field ‘id’ doesn’t have default value. Sorry still learning sql here.
This changes the menu to?
No sir xD That menu is a private menu that I use on my server
nice look menus, but if it dont have nothing to do with the resource why you posted? i got confused when saw the topic
Because those menus are in my extended itself, all menus on extended are like this ones on my server xD
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.ConfiguredTaskAwaitable
1+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.Operation
1+d__3[TResult].MoveNext () [0x000aa] in <6b79789832b34a31961dbb39358e1b3f>:0
That error is from esx_status
Hmm, do you have any clue why?
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?