Can't connect to my server after implementing essentialmode

FiveM Client Support
1

Hi, I just implemented essentialmode into my server. Rather than me try to explain I have some pictures that will probably be of more use.

FiveReborn Server console when I try to connect:
https://gyazo.com/38525b7f16b5625b38400d00bfe35176

My citmp:
https://gyazo.com/17d54f75c0f58735a84a97d0d580fce7

fivem-map-skater __resource.lua:
https://gyazo.com/da4cc8a1b5f4c2c59dc478d531f8e23d

Thats all I can think of that would be useful. If you need more info to help me out I’d be happy to oblige. Any help in this matter would be greatly appreciated!

2

Essentialmode = true is incorrect. Replace with the name of your gamemode. Did you unblock the .DLL?

3

Which .DLL? Also I just implemented es_freeroam so its now “es_freeroam = true”. I’m able to get into the server but my database isn’t updating.

4

also unblocked the bc.dll and the MySqlData.dll and the database still isn’t updating.

5

new console stuff:
https://gyazo.com/74b899994868162e1783349ebc92cba8

6

Looks like you don’t have a column ‘group’ in your users table in the database… Dit you run the correct sql ?

7

this is my sql atm:
https://gyazo.com/7acf8e3e83d464bb2a8b0d44f09366b2

should i add ‘group’? What datatype and length/set should it be?

8

Not sure where you got that sql from, but the correct one looks like this :

CREATE TABLE IF NOT EXISTS `users` (
  `identifier` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `group` varchar(50) NOT NULL DEFAULT '0',
  `permission_level` int(11) NOT NULL DEFAULT '0',
  `money` double NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

https://github.com/FiveM-Scripts/essentialmode

9

@Swife once you fix that SQL you also need to allow personal vehicle to be null.