Unknown column 'price' in 'field list' ERROR

[Pipi_pipi]

Hi, today I tried to install this pack of McDonald’s items, but when I install them on the Database I get this error. Help me pls!

Error Code: 1054. Unknown column ‘price’ in ‘field list’

How can I fix this error?

[The_Sibrev]

“this pack of mcdonalds items” doesnt rly help to give you a posible solution.
as far as i understand the sql file dont match with the items in your database
it has 1 column too much or too less wich you dont give information, in this case should be price.
a screen of your database “items” and the sql file would help us to help you

[Pipi_pipi]

Oh sorry, sometimes i’m very stupid…

This is the pack: GitHub - ashton1cav/esx_mcdonalds_items: Mcdonalds Items for ESX
And the screenshot

:

[The_Sibrev]

as you can see the sql file dont match with your columns or tables i dont know how they called…

try to insert the items only with the values you have in your databse : name,label,weight,canremove,limit

btw why would you use limit and weight?

or add the column “price” into your database and the insert the items.

INSERT INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`, `limit`) VALUES ('MCDS_BIG_BREAKFAST', 'McDonalds Big Breakfast', 1, 0, 1, 1), ('MCDS_HOTCAKES', 'McDonalds Hotcakes', 1, 0, 1, 1) ;

this is just an example tha should work on your database

[Pipi_pipi]

@The_Sibrev

INSERT INTO items (name, label, weight, rare, can_remove, limit)

Thank you! I just did that and its ok!