So, as of yesterday I am just done with zap… It just didnt work out with their service.
Still we have built a pretty damn big server and I rented a new VPS installed Ubuntu + mysql, apache and phpmyadmin.
Downloaded the same artifacts version, exported the resources and imported them on the new VPS.
Exported and imported the database to the new mysql server via phpmy admin.
I got everything working except im getting this error:
It’s says in the top: error, no such table: players
I have never even seen a table called players in my zap database? does anyone know what could be causing this?
If it’s the same resource I’m thinking of, players table is used for a web panel. You can try to use this sql to see if it resolves your issue:
CREATE TABLE `players` (
`ID` int(255) NOT NULL,
`name` varchar(255) NOT NULL,
`license` varchar(255) NOT NULL,
`steam` varchar(255) NOT NULL,
`playtime` int(255) NOT NULL DEFAULT '1',
`firstjoined` varchar(255) NOT NULL,
`lastplayed` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Well, wont that mean players will need to gear up, get cash / bank all over again @schwim??
Serrver have been live for about 2 weeks before exporting it from zap.
ESX users the users table and not a table named “players”. Adding the players table will do nothing to the operation of the server. You have a resource expecting a table named “players” so your two solutions are to either provide the table it’s expecting or to find the resource expecting it and removing the resource.
Well it’s wierd, since I just took the resources of zap, downloading the exact same artifacts version.
idk why it would behave like this? no table named players in the old database either… @schwim
I can’t tell you why the resources you installed don’t match the database you installed. I can only tell you the two options you have for resolving your current issue.
Even though I made the new table, still getting the same error .
Is there any chance this could be a file permission problem?
I’d like to see the entire startup prior to that error.
This is the same config as I had on zap.
I saw somehwere in essential config that there was a couchdb adress and port + password
Could that be the issue? that I do not have couch db on my VPS?
On ZAP i always used the mysql phpmyadmin to work with DBS. I have never heard of couchdb.
Server.cfg slightly modified so you all wont see the private stuff. ex: database pass and user etc.
set es_enableCustomData 1
set mysql_connection_string "server=127.0.0.1;uid=MYUSER;password=MYPASS;database=MYDATABASE"
endpoint_add_tcp "IP:30120"
endpoint_add_udp "IP:30120"
sv_maxclients 32
# You probably don't want to change these!
# Only change them if you're using a server with multiple network interfaces.
## From ESX Pack ##
start baseevents
start async
start cron
start es_extended
start instance
start es_camera
start esx_phone3
start esx_kashacters
start skinchanger
start esx_accessories
start esx_addonaccount
start esx_addoninventory
start esx_society
start esx_ambulancejob
start esx_duty
start esx_bankerjob
start esx_barbershop
start esx_basicneeds
start esx_billing
##start esx_boat
start esx_boilerplate
start esx_clotheshop
start esx_datastore
start esx_dmvschool
start esx_holdup
##start esx_identity
##start esx_weaponshop
start samme-blackmarket
start esx_joblisting
start esx_jobs
start esx_aiTaxi
##start esx_byggfirman
start whistle
start esx_license
start esx_lscustom
start esx_mechanicjob
start esx_menu_default
start esx_menu_dialog
start esx_menu_list
start esx_migrate
##start esx_optionalneeds
start esx_policejob
start esx_rpchat
start esx_service
start esx_shops
start esx_scoreboard
start esx_skin
start esx_status
start esx_vehicleshop
start esx_voice
start esx-kr-vehicle-push
start esx-checkdeathcause
start esx_sit
start idonlyforadmin
start esx_thief
start esx_legacyfuel
start esx_TheLostMC
start esx_mafiajob
start esx_cartel
start esx_drp_garage
start esx_plasticsurgery
start esx_spectate
start esx_doorlock
##start esx_jail
start esx_qalle-jail
start esx_carshowroom
start esx_personmeny
start esx_animations
start esx_sommen_queest
start esx-Zeaqy-ER
start esx_tattooshop
start esx_legacyfuel
start new_banking
start esx_barbie_lyftupp
start esx_speedcamera
start esx_carwash
start esx_vehiclespawner
start vSync
start esx_teleports
## End of ESX Pack ##
# These resources will start by default.
start mapmanager
start chat
start spawnmanager
start sessionmanager
start fivem
start hardcap
start ■■■■■■■
start trafficadjuster
start mysql-async
start essentialmode
start esplugin_mysql
start es_admin2
start es_ui
start hav_whitelistdb
start radio
start p-load-2
start Repairkit
start fs_gang
start jsfour-blindfold
start jsfour-idcard
start jsfour-register
start jsfour-criminalrecord
start discord
start assets
start pNotify
start noradar_speedometer
start maildelivery
start esx-maildelivery
start scrp-scripts
start fivem-realisticvehicle
start crouch
start ToTT-Minimap
start loffe_fishing
start ragdoll
start 3dme
start salty_vehicleblackout
start albingetchords
start bedcommand
start handling_mod
start interact-sound
start malteser_cinema
start newspaper
start els-fivem
start f9reset
start semarmasreward
start Ericbilbana
##DRUGS
start heaven-selldrugs
start heaven-drugs
start hazze-usabledrugs
start heaven-specshop
start esx_cigarett
## råna + shop
start loffe_burglary
start heaven-inbrottshop
#map
start PillboxHospital
start bob74_ipl
start heaven-polisstation
start heaven-bilcenter
start polisutsida
start prison-map-addon
start tuben-map-addons
# <bilar>
start volvo242
start fatboy
start kart3
start volvo850
start audi-tt
start supra
start bmw-m3
start 600sel
## kleder
start heaven-ambulans
start heaven-polis
start supremeHoods
start LOSTmc
#/test
add_ace resource.essentialmode command.add_principal allow
add_ace resource.essentialmode command.add_ace allow
# This allows players to use scripthook based plugins such as lambda menu.
# Set this to 0 to disallow scripthook.
sv_scriptHookAllowed 0
# Uncomment this to enable RCON. Make sure to change the password.
rcon_password PASSWORD
# A comma-separated list of tags for your server.
# For example:
# - sets tags "drifting, cars, racing"
# Or:
# - sets tags "roleplay, military, tanks"
sets tags "ParkenRP, Svensk Roleplay"
# Set an optional server info and connecting banner image url.
# Size doesn't matter, any banner sized image will be fine.
#sets banner_detail "http://url.to/image.png"
#sets banner_connecting "http://url.to/image.png"
# Set your server's hostname
sv_hostname "DEV"
# Nested configs!
#exec server_internal.cfg
# Loading a server icon (96x96 PNG file)
load_server_icon rp.png
# convars which can be used in scripts
set temp_convar "Pa funkar!"
set mail_rental_amount 150
set mail_min_payment 5
set mail_max_payment 30
# Uncomment this line if you do not want your server to be listed in the server browser.
#sv_master1 ""
# Want to only allow players authenticated with a third-party provider like Steam?
# Don't forget Social Club is a third party provider too!
#sv_authMaxVariance 1
#sv_authMinTrust 5
# 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.steam:110000112345678 group.admin # add the admin to the group
# Hide player endpoints in external log output.
sv_endpointprivacy true
#This is an official FiveM server hosted by ZAP-Hosting.com. You do not need to put a license key here.
# license key for server (https://keymaster.fivem.net)
sv_licenseKey MY KEY
restart sessionmanager
Fixed it!
The problem was the essentails.db directly in my server directory.
I noticed that after setting up the server on my VPS, when starting the server, it automatically created a file called “essentials.db” and this was nowhere to be found on ZAP.
And this file had the file permission 644 which mean it can’t write stuff to the file due to permissions.
I deleted the file on my VPS rebooted the VPS, gave the directory permissions 0770. After that when starting the server, it automatically created a new file will all the necessary things in it.
