I have a problem with my items not showing ingame in any shop and dont know how to fix it! It looks like this https://imgur.com/a/ubgTE0a and i can’t find any error except this one https://imgur.com/a/reOBzqx. I got 0 errors when I re imported the esx_shops sql file into the data base and all my items is in the item table and my shop table looks like this https://imgur.com/a/qWRLLeR ! I found something like remove [0].scrollIntoView(); from the app.js but that didn’t fix my problem with my items. Please help
Add the items to item database, like this…
INSERT INTO items
(name
, label
) VALUES
(‘bread’, ‘Bread’),
(‘water’, ‘Water’)
;
Do it the same as i posted…
likely an issue with the quotes - when you copy/paste them from the forums it turns them into some other symbol. Let me see if putting @AshleyIn1080p 's answer in code block helps:
INSERT INTO items (name, label) VALUES
('bread', 'Bread'),
('water', 'Water')
;
Yeah, looks like the code block fixes the single quote replacement.
thank you! it worked to import the items to the item table like that now. if I import all my items to the item table and then the same way to the shop table it should work?
It should. I’d test your store now to make sure you can buy bread and water to start before you get too much farther.
Even though I don’t have anything in my shop table anymore? I cleared it all to start over before when i tried this method.
Looks like the tables are fine. How old is your version of es_extended? That seems to have been the issue on a couple of other mods where users were getting that error.
Interestingly, your items table also has a price column, which mine doesn’t have. I don’t see that in this history of the .sql file on the git repository, so some other mod must have added the column. Having an extra column shouldn’t affect reading the table, though.
This is the es_Extended I have https://github.com/ESX-Org/es_extended . But every time i press E in any shop this comes up still
Could you upload your app.js file from the path specified in the error?
Try to redownload the script?
This is line 69 which it says the error is on
I have reinstalled the script like 25 times already and cleared the DB everytime and inserted the sql over and over
There is no error there.
ESX_MENU.render();
$(’#menu_’ + namespace + ‘_’ + name).find(’.menu-item.selected’)[0].scrollIntoView();
};
This is what my esx_menu_default has. So it is the same.
Is there maybe a script interfering with the script you currently have?
I don’t know and that might be my problem
Try to look trough your scripts.