Ox_inventory error: ox_inventory was unable to execute a query!

FiveM Resource Development Discussion
, ,
1

11:17:13 [ resources] Stopping resource ox_inventory
11:17:13 [ c-scripting-core] Creating script environments for ox_inventory
11:17:13 [ resources] Started resource ox_inventory
11:17:13 [ script:oxmysql] Error: ox_inventory was unable to execute a query!
11:17:13 [ script:oxmysql] Query: INSERT IGNORE INTO licenses (type, label) VALUES (?, ?)
11:17:13 [ script:oxmysql] [“weapon”,“Weapon License”]
11:17:13 [ script:oxmysql] Table ‘FiveM.licenses’ doesn’t exist
11:17:13 [ script:ox_inventory] SCRIPT ERROR: @ox_inventory/modules/mysql/server.lua:87: ox_inventory was unable to execute a query!
11:17:13 [ script:ox_inventory] Query: SHOW COLUMNS FROM owned_vehicles
11:17:13 [ script:ox_inventory]
11:17:13 [ script:ox_inventory] Table ‘FiveM.owned_vehicles’ doesn’t exist
11:17:13 [ script:ox_inventory] > fn (@ox_inventory/modules/mysql/server.lua:87)
11:17:13 [ script:ox_inventory] > logError (@oxmysql/dist/build.js:25870)
11:17:13 [ script:ox_inventory] > rawQuery (@oxmysql/dist/build.js:26053)
11:17:13 [ script:ox_inventory] > processTicksAndRejections (node:internal/process/task_queues:96)
11:17:13 [ TXADMIN] txaReportResources
11:17:14 [ script:monitor] [txAdmin] Sending resources list to txAdmin.
11:17:14 [ script:ox_inventory] SCRIPT ERROR: @ox_inventory/modules/bridge/esx/server.lua:16: No such export getSharedObject in resource es_extended
11:17:15 [ script:ox_inventory] [ox_inventory] [INFO] Inventory has loaded 218 items

2

Table fivem.licenses does not exist.

Did u make sure to execute the included sql file in your database?

3

checking

4

i imported every single sql but theres no lisances or other table.

5

Then you found the issue!
11:17:13 [ script:oxmysql] Table ‘FiveM.licenses’ doesn’t exist
This is shown in the above error, so i would contact the resource author for support in this case.

6

ox_inventory doesn’t come with any sql files at all. You get the sql files from whatever framework your running. Did you follow install docs for ox_inventory?

7

How did you fix it

8

I did not fix it, i read the error and i know whats wrong.

The table fivem.licenses does not exist in the database, so this has to be fixed.
Nonetheless contact the resource creator for assistance with this as i do not know alot about ox_ stuff.

9 


CREATE TABLE `licenses` (
    `type` VARCHAR(255) NOT NULL PRIMARY KEY,
    `label` VARCHAR(255) NOT NULL
);

CREATE TABLE `owned_vehicles` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `owner` VARCHAR(255) NOT NULL,
    `plate` VARCHAR(10) NOT NULL UNIQUE,
    `vehicle` TEXT NOT NULL,
    `stored` TINYINT(1) DEFAULT 1
);
4 Likes
10

where would these go ?

11

where do these go

12

To sql database query you should do it

13

Error: ox_inventory was unable to execute a query!
[ script:oxmysql] Query: INSERT IGNORE INTO licenses (type, label) VALUES (?, ?)
[ script:oxmysql] [“weapon”,“Weapon License”]
[ script:oxmysql] Table ‘s15978_DELMARVA_RP.licenses’ doesn’t exist

is what keeps coming up no matter what i do and still no inventory in game thats only error besides this one

SCRIPT ERROR: @ox_inventory/modules/bridge/esx/server.lua:18: No such export getSharedObject in resource es_extended

14

Which version do you use ox inventory and esx?

15

did you end up fixing it?