build the sql db server (phpmyadmin/sql @port 3306,
yet when i start the server, it still tells me im using false credentials… (build same name on db, giving all permissions on wildcard, and even global)
im feeling like it is still trying to use couchdb (also running for essentials) for some reason…
kind of stuck at this point, any further advise ?
@Qpanther I’ve only ever installed it once so my memory of how to get it working isn’t perfect. If I recall correctly you’ll need mysql-async if you don’t already have it. Then you’ll want to put the following in your main server.cfg
set mysql_connection_string "server=127.0.0.1;database=<schema>;userid=<user>;password=<password>"
replacing everything in angular brackets with the proper settings for your database. (change the 127.0.0.1 too, if your SQL server isn’t on the same machine)
alright i’ll try that yet again, i do appreciate the help don’t feel like i’m not appreciating it, thank you in advance mate
No problem! Hope it all worked out for you.
Where to find the 1.4.1 version, cause on github i only can find 1.4.0 ??
It’s the dev branch : https://github.com/Kyominii/Cops_FiveM/tree/dev
How to setup the whitelist database? Because when I put in my steam id the 1100000… it gives me a ton of code in chat… any help plz?
you have to put steam:11000000… in your table
And can you post here the ton of code in chat here ?
Yes here you go
Error running call reference function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:348: server/main.lua:212: attempt to index a nil value (field ‘?’)
stack traceback:
server/main.lua:212: in upvalue ‘ref’
citizen:/scripting/lua/scheduler.lua:334: in function citizen:/scripting/lua/scheduler.lua:333
[C]: in function ‘xpcall’
citizen:/scripting/lua/scheduler.lua:333: in function citizen:/scripting/lua/scheduler.lua:332
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:348: in function citizen:/scripting/lua/scheduler.lua:319
I get that code when I try and do /copadd 110000000 …
but what do you mean add to table?
HI, im trying to use this mod on my server but every time all i get is “couldnt load resource police :(”. I have followed the setup tutorial but i still get this. Does anyone know why this is happening and what should i do to fix it?
@Andrew_Schweitzer_bl : the error is related to essentialmode, not police. And you can use /copadd with the in-game ID, not steamID
@Rikky : Please check you have __resource.lua in your resources/police folder
@Kyominii hey, i got a __resource.lua in police/police where you find the maps client, config and server. I cant find any other __resource.lua
Resource loading for police failed:
Could not open resource metadata file C:/cygwin\home\zap337502\g19163\gta5-fivem\server-data/resources//police/__resource.lua.
?
@Rikky @Oskari_Saarinen you have to drop in resources folder the police folder in Cops-FiveM, not rename it
Anyway you can use it without MySQL … I got couchDB
^^ scratch that question… once I add someone using “/copadd [id]” they can join the police but once they leave they are removed any help?
No, you can’t use it without MySQL, but you can install a mysql server next to couchdb
And please check you have no error when you use /copadd command
no error its just once I add someone they can join the police force but when they disconnect and re-join it resets and I have to re-add them. any help?
Can anyone help me install it, stuck on sql part?