I canât access the money from the billing in the boss menu, withdraw and deposit function does not do anything, not even returning an error. Any ideas?
Iâve also seen an issue with the job related market missing the items to choose from. When implementing, I tested and it worked great. Has there been any changes?
How can I open the food menu and cook the beef? I love the script btw.I can open the menu with F6 and I got all the stuff from the market but how can I open other stuff?And is there any way I can go inside the car to sell things from there or no?
Has anyone managed to add extra items and managed got it to work. Iâm having trouble loading the props for hotdog and different burgers and tacos. No errors are showing.
Iâll make a burger and it will take the ingredients. No steak will show. Then it will say itâs cooked.
If I cooked a hotdog, I will see the steak, but at the end there wonât be a hotdog to pick up.
This my problem [ERROR] [MySQL] An error happens on MySQL for query âSELECT * FROM shops WHERE name = âMarketâ {=}â: Unknown column ânameâ in âwhere clauseâ
This is actually a really simple fix, first of all go to esx_foodtruck/server/main.lua and find the line MySQL.Async.fetchAll(âSELECT * FROM shops WHERE name = âMarketââ, change name to store so it will look like this: MySQL.Async.fetchAll(âSELECT * FROM shops WHERE store = âMarketââ,
EDIT: Ignore all of that as having âMarketâ in your db causes serious issues and instead do this:
In Server/Main.lua(not 100% sure this is even needed):
MySQL.Async.fetchAll(âSELECT * FROM shops WHERE store = âTwentyFourSevenââ, (Used to be Market)
Now I can sell those items in TwentyFourSeven/LTDgasoline without any issues. The Market never worked for me and as Iâve said caused serious headaches so I just disabled it.
Here is the result:
The easy fix to the market:in the Server file look for
AddEventHandler(âonMySQLReadyâ, function ()
MySQL.Async.fetchAll(âSELECT * FROM shops WHERE name = âMarketââ,
{},
function(result)
Change ânameâ to âstoreâ
Make sure you check in your shops table in the SQL database to see column header for the TwentyFourSeven, RobsLiquor, Market, etc
In my shops table the column header was store. Once I changed from ânameâ to âstoreâ the market worked as expected.