[HELP] strange errors

Today I was developing my server when I accidentally broke my server. I was messing in my server.cfg when the error appeared. I tried reverting the changes in server.cfg but it didn’t work. I also deleted my database and the server, and basically started from scratch again. I searched for the error but it didn’t work neither.

server.cfg:

 Only change the IP if you're using a server with multiple network interfaces, otherwise change the port only.
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"

set mysql_connection_string "server=localhost;uid=uid;password=pass;database=essentialmode"
set es_enableCustomData 1

# These resources will start by default.
ensure mapmanager
ensure chat
ensure spawnmanager
ensure sessionmanager
ensure fivem
ensure hardcap
ensure ■■■■■■■
ensure scoreboard

# This allows players to use scripthook-based plugins such as the legacy Lambda Menu.
# Set this to 1 to allow scripthook. Do note that this does _not_ guarantee players won't be able to use external plugins.
sv_scriptHookAllowed 0

# Uncomment this and set a password to enable RCON. Make sure to change the password - it should look like rcon_password "YOURPASSWORD"
rcon_password "pass"

# A comma-separated list of tags for your server.
# For example:
# - sets tags "drifting, cars, racing"
# Or:
# - sets tags "roleplay, military, tanks"
sets tags "default"

# A valid locale identifier for your server's primary language.
# For example "en-US", "fr-CA", "nl-NL", "de-DE", "en-GB", "pt-BR"
sets locale "bg-BG" 
# please DO replace root-AQ on the line ABOVE with a real language! :)

# Set an optional server info and connecting banner image url.
# Size doesn't matter, any banner sized image will be fine.
sets banner_detail "https://i.imgur.com/8wh6qDL.png"
sets banner_connecting "https://i.imgur.com/v7xIXnq.png"

# Set your server's hostname
sv_hostname "PRIVATE(ESX)"

# Nested configs!
#exec server_internal.cfg

# Loading a server icon (96x96 PNG file)
#load_server_icon myLogo.png

# convars which can be used in scripts
set temp_convar "hey world!"

# Uncomment this line if you do not want your server to be listed in the server browser.
# Do not edit it if you *do* want your server listed.
sv_master1 ""

# Add system admins
add_ace group.admin command allow # allow all commands
add_ace group.admin command.quit deny # but don't allow quit
add_principal identifier.fivem:1 group.admin # add the admin to the group
add_principal identifier.steam: group.admin
add_ace resource.essentialmode command.sets allow
add_ace resource.essentialmode command.add_principal allow
add_ace resource.essentialmode command.add_ace allow
add_principal group.admin group.user
add_ace resource.es_extended command.add_ace allow
add_ace resource.es_extended command.add_principal allow
add_ace resource.es_extended command.remove_principal allow
set es_enableCustomData 1

# Hide player endpoints in external log output.
sv_endpointprivacy true

# Server player slot limit (must be between 1 and 32, unless using OneSync)
sv_maxclients 32

# Steam Web API key, if you want to use Steam authentication (https://steamcommunity.com/dev/apikey)
# -> replace "" with the key
set steam_webApiKey ""

# License key for your server (https://keymaster.fivem.net)
sv_licenseKey 

start mysql-async
start essentialmode
start esplugin_mysql
start es_extended
start es_admin2

start esx_menu_default
start esx_menu_list
start esx_menu_dialog
start esx_identity
start skinchanger
start esx_skin

Output errors:

[ERROR] [MySQL] [esplugin_mysql] An error happens on MySQL for query "INSERT INTO users (`identifier`, `money`, `bank`, `group`, `permission_level`, `license`) VALUES ('steam:11000013eb37e68', 0, 0, 'user', 0, 'license:082079cfa99ea61c5c383bee37bfe50564dd9935');": ER_BAD_FIELD_ERROR: Unknown column 'money' in 'field list'
SCRIPT ERROR: @essentialmode/server/player/login.lua:13: attempt to index a boolean value (local 'user')
> ref (@essentialmode/server/player/login.lua:13)
> ref (@esplugin_mysql/server.lua:20)
>  (@mysql-async/mysql-async.js:14959)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:125: attempt to index a nil value (upvalue 'user')
> ref (@es_admin2/server.lua:125)
> handler (@essentialmode/server/player/login.lua:134)
> ref (@es_admin2/server.lua:124)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:123)
SCRIPT ERROR: @es_admin2/server.lua:106: attempt to index a nil value (local 'user')
> ref (@es_admin2/server.lua:106)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:105)
SCRIPT ERROR: @es_admin2/server.lua:106: attempt to index a nil value (local 'user')
> ref (@es_admin2/server.lua:106)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:105)
SCRIPT ERROR: @es_admin2/server.lua:106: attempt to index a nil value (local 'user')
> ref (@es_admin2/server.lua:106)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:105)
SCRIPT ERROR: @es_admin2/server.lua:106: attempt to index a nil value (local 'user')
> ref (@es_admin2/server.lua:106)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:105)
SCRIPT ERROR: @es_admin2/server.lua:106: attempt to index a nil value (local 'user')
> ref (@es_admin2/server.lua:106)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:105)
SCRIPT ERROR: @es_admin2/server.lua:106: attempt to index a nil value (local 'user')
> ref (@es_admin2/server.lua:106)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:105)
SCRIPT ERROR: @es_admin2/server.lua:106: attempt to index a nil value (local 'user')
> ref (@es_admin2/server.lua:106)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:105)
SCRIPT ERROR: @es_admin2/server.lua:106: attempt to index a nil value (local 'user')
> ref (@es_admin2/server.lua:106)
> handler (@essentialmode/server/player/login.lua:134)
> handler (@es_admin2/server.lua:105)

Do you have a ‘money’ column in your users table located in your database?

no

I am also facing that exact issue!

Try running this in your SQL Query:

ALTER TABLE users
ADD COLUMN money INT(11)
;

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