I figured that out myself as well. Entering the information manually into the database was my workaround. Did you find the specific issue with the database? I would like to not have to manually enter the persons information every time.
I wanted to drop this here in hopes that maybe the creator of this wonderful script could find a solution.
Error running call reference function for resource essentialmode: server/main.lua:212: attempt to index a nil value (field '?')
stack traceback:
server/main.lua:212: in local 'ref'
citizen:/scripting/lua/scheduler.lua:277: in function <citizen:/scripting/lua/scheduler.lua:268>
This is an error message I receive when I attempt to add or remove anyone from a whitelist through IceCon (rCon). The workaround is to manually copy one of the existing fields in the database and edit the steamID or IP to match the one you wish to add.
However, this limits me as the only member to be able to give or remove those who are whitelisted as I am not giving access to the database to anyone else. Anyone out there have a solution?
I need help installing this.
Hey, where do you put the steam hexadecimal in the sql database??
If you look there will be a user_whitelist sheet.
These are the properties of the entry:
identifier varchar(255) Value (ENTER steamID here)
whitelisted tinyint(1) Value 1
You can see below (the picture) of what one of my entries looks like.
Hey. It still doesnāt work for me!
566953] [ERROR] [MySQL] An error happens on MySQL for query āSELECT whitelisted FROM user_whitelist WHERE identifier = @username AND whitelisted = 1 {@username=steam:11000010c865645}ā: Unable to connect to any of the specified MySQL hosts.
The issue is then something with connecting to the database. Itās not finding anything in the database. Make sure you added the line in the server.cfg that connects to your database.
wladd steam:11000010fcfac54
[ERROR] [MySQL] An error happens on MySQL for query "SELECT whitelisted FROM user_whitelist WHERE identifier = @username AND whitelisted = 1 {@username=steam:11000010fcfac54}": Table 'db516.user_whitelist' doesn't exist
[ERROR] [MySQL] An error happens on MySQL for query "INSERT INTO user_whitelist (`identifier`, `whitelisted`) VALUES (@identifier, @whitelisted) {@identifier=steam:11000010fcfac54;@whitelisted=1}": Table 'db516.user_whitelist' doesn't exist
steam:11000010fcfac54 has been whitelisted!
guy i am getting this error. What cause this ? i am stuck. i need help. Thanks
@HavannaPC can you add SteamID64 support ?
@HavannaPC Tried this Whitelist, hot it to DB and everything but when i tried to add me to the whielist i got this
I donāt understand how to make people Whitelisted?
Command is not working for me. I use wladd and nothing happens. Please help me!
pay attention if you use es5ā¦
ERROR PLS HELP ME
You entered your username and/or password and/or server wrong for your databaseā¦
What? I did not understand, did you have any disagreement to help me?
ā¦ I never had any disagreement to help you. I said the username or password for your database are incorrect. Or you entered the wrong server. Follow the documentation for MySQL Async. https://github.com/brouznouf/fivem-mysql-async
Also, donāt jump to conclusions.
Could someone help me install this please iām begging you
If any of you having problems or you donāt have a database, then I suggest that you use ACL-FX. This isnāt advertising, I am trying to help people if they donāt have the resources or it just isnāt working. More updates are coming to the ACL-FX.