[REQUEST] got a problem with database then try ensure the script

FiveM Server Development ES/ESX
, ,
1

[ script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: esx_vex_trucker was unable to execute a query!
[ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘CREATE TABLE IF NOT EXISTS trucker_drivers (
[ script:oxmysql] driver_id INT(10) UNSIGNE…’ at line 19
[ script:oxmysql] CREATE TABLE IF NOT EXISTS trucker_available_contracts (
[ script:oxmysql] contract_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:oxmysql] contract_type BIT(1) NOT NULL DEFAULT b’0’,
[ script:oxmysql] contract_name VARCHAR(50) NOT NULL DEFAULT ‘’ COLLATE ‘utf8mb4_general_ci’,
[ script:oxmysql] coords_index SMALLINT(6) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] price_per_km INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] cargo_type TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] fragile BIT(1) NOT NULL DEFAULT b’0’,
[ script:oxmysql] valuable BIT(1) NOT NULL DEFAULT b’0’,
[ script:oxmysql] fast BIT(1) NOT NULL DEFAULT b’0’,
[ script:oxmysql] truck VARCHAR(50) NULL DEFAULT NULL COLLATE ‘utf8mb4_general_ci’,
[ script:oxmysql] trailer VARCHAR(50) NOT NULL COLLATE ‘utf8mb4_general_ci’,
[ script:oxmysql] PRIMARY KEY (contract_id) USING BTREE
[ script:oxmysql] )
[ script:oxmysql] COLLATE=‘utf8mb4_general_ci’
[ script:oxmysql] ENGINE=InnoDB
[ script:oxmysql] ;
[ script:oxmysql]
[ script:oxmysql] CREATE TABLE IF NOT EXISTS trucker_drivers (
[ script:oxmysql] driver_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:oxmysql] user_id VARCHAR(50) NULL DEFAULT NULL,
[ script:oxmysql] name VARCHAR(50) NOT NULL DEFAULT ‘’ COLLATE ‘utf8mb4_general_ci’,
[ script:oxmysql] product_type TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] distance TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] valuable TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] fragile TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] fast TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] price INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] price_per_km INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] img VARCHAR(50) NULL DEFAULT NULL COLLATE ‘utf8mb4_general_ci’,
[ script:oxmysql] PRIMARY KEY (driver_id) USING BTREE
[ script:oxmysql] )
[ script:oxmysql] COLLATE=‘utf8mb4_general_ci’
[ script:oxmysql] ENGINE=InnoDB
[ script:oxmysql] ;
[ script:oxmysql]
[ script:oxmysql] CREATE TABLE IF NOT EXISTS trucker_loans (
[ script:oxmysql] id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:oxmysql] user_id VARCHAR(50) NOT NULL,
[ script:oxmysql] loan INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] remaining_amount INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] day_cost INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] taxes_on_day INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] timer INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] PRIMARY KEY (id) USING BTREE
[ script:oxmysql] )
[ script:oxmysql] COLLATE=‘utf8mb4_general_ci’
[ script:oxmysql] ENGINE=InnoDB
[ script:oxmysql] ;
[ script:oxmysql]
[ script:oxmysql] CREATE TABLE IF NOT EXISTS trucker_trucks (
[ script:oxmysql] truck_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:oxmysql] user_id VARCHAR(50) NOT NULL,
[ script:oxmysql] truck_name VARCHAR(50) NOT NULL COLLATE ‘utf8mb4_general_ci’,
[ script:oxmysql] driver INT(10) UNSIGNED NULL DEFAULT NULL,
[ script:oxmysql] body SMALLINT(5) UNSIGNED NOT NULL DEFAULT ‘1000’,
[ script:oxmysql] engine SMALLINT(5) UNSIGNED NOT NULL DEFAULT ‘1000’,
[ script:oxmysql] transmission SMALLINT(5) UNSIGNED NOT NULL DEFAULT ‘1000’,
[ script:oxmysql] wheels SMALLINT(5) UNSIGNED NOT NULL DEFAULT ‘1000’,
[ script:oxmysql] PRIMARY KEY (truck_id) USING BTREE
[ script:oxmysql] )
[ script:oxmysql] COLLATE=‘utf8mb4_general_ci’
[ script:oxmysql] ENGINE=InnoDB
[ script:oxmysql] ;
[ script:oxmysql]
[ script:oxmysql] CREATE TABLE IF NOT EXISTS trucker_users (
[ script:oxmysql] user_id VARCHAR(50) NOT NULL,
[ script:oxmysql] money INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] total_earned INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] finished_deliveries INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] exp INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] traveled_distance DOUBLE UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] skill_points INT(10) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] product_type TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] distance TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] valuable TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] fragile TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] fast TINYINT(3) UNSIGNED NOT NULL DEFAULT ‘0’,
[ script:oxmysql] loan_notify BIT(1) NOT NULL DEFAULT b’0’,
[ script:oxmysql] PRIMARY KEY (user_id) USING BTREE
[ script:oxmysql] )
[ script:oxmysql] COLLATE=‘utf8mb4_general_ci’
[ script:oxmysql] ENGINE=InnoDB
[ script:oxmysql] ;
[ script:oxmysql]
[ script:oxmysql] []
[ script:oxmysql] > (@oxmysql/dist/build.js:21745)
[ script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[ script:oxmysql] > async rawQuery (@oxmysql/dist/build.js:21734)
[ script:oxmysql]
[ script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: esx_vex_trucker was unable to execute a query!
[ script:oxmysql] Table ‘esxlegacy_95caca.trucker_drivers’ doesn’t exist
[ script:oxmysql] SELECT COUNT(driver_id) as qtd FROM trucker_drivers WHERE user_id IS NULL []
[ script:oxmysql] > (@oxmysql/dist/build.js:21745)
[ script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[ script:oxmysql] > async rawQuery (@oxmysql/dist/build.js:21734)
[ script:oxmysql]
[ script:oxmysql]
[ script:oxmysql]
[ script:oxmysql]

I get this fault and its strange in another server before there i building for fun for my self, its be absolutely fine. Server same both (esx legacy). can someone help me to find a problem please?

2

It tells you quite clearly what your problem is: esx_vex_trucker was unable to execute a query and You have an error in your SQL syntax then further down it tells you Table ‘esxlegacy_95caca.trucker_drivers’ doesn’t exist.

In summary, you’re trying to create a table and that statement is failing, so the rest of your SQL statement also fails because the first criteria was not met/achieved.

To fix the problem, take a look in oxmysql for the SQL statement that creates table trucker_drivers and post your code here.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.