I am trying to add DOUBLE JOB

StonebridgeGR · December 25, 2020, 6:24pm

Hey i am using this resources to add double job fuction into my server,
https://github.com/Sph3x/ESX-DoubleJob Screenshot_4

but i am getting this error into console, any help ?
Thanks

SCRIPT ERROR: @es_extended/server/main.lua:142: attempt to index a nil value (field ‘?’)

ref (@es_extended/server/main.lua:142)
(@mysql-async/mysql-async.js:15543)

Enz0Z · December 25, 2020, 8:39pm

Hey! Did you check if job2 is defined and has any value in the database?

StonebridgeGR · December 26, 2020, 12:57am

nope, there is no such a sql in his file ?!
or i am missing something ?

Enz0Z · December 27, 2020, 12:25am

Actually yes, look at this url

github.com

Sph3x/ESX-DoubleJob/blob/master/ESX-DoubleJob/ESX-DoubleJob.sql

ALTER TABLE jobs add SecondaryJob BOOLEAN NOT NULL DEFAULT FALSE;

INSERT INTO `jobs` (`name`, `label`, `whitelisted`,`SecondaryJob` ) VALUES
('unemployed2',	'Sans emplois',	0, 1);

INSERT INTO `job_grades` (`job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
('unemployed2',	0,	'rsa',	'Secondaire',	0,	'{}',	'{}');

ALTER TABLE `users`

	ADD COLUMN `job2` varchar(255) NULL DEFAULT 'unemployed2' AFTER `job_grade`,

	ADD COLUMN `job2_grade` INT NULL DEFAULT 0 AFTER `job2`

;

StonebridgeGR · December 28, 2020, 4:17pm

the column job and job grade i am missing?

Enz0Z · December 29, 2020, 1:05am

You have to execute that SQL Command on your MySQL server to add those columns.

StonebridgeGR · December 29, 2020, 1:07am

I did that

system · January 28, 2021, 1:12am

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