Saving Issue

[Kyle47650]

When I add a cop to the database and that person leaves and joins back the blue circles at the police stations are no longer there for that person. FYI, the user data is being uploaded to the MySQL database.

[t-valette]

Which version are you using ? Please send a console log when police is launching and when a player is connecting

[Kyle47650]

I am using latest version (FXServer) and in the console it says started resource police and when someone connecting it says Connecting:(The Player). Could it be that my MySQL database is only writing and not reading? Also has anyone else reported this issue?

[t-valette]

Can I have the screenshot ? Because I can't see if there's is any error. And no one has reporte this issue so you probably failed the installation. Let's see where ^^

[Kyle47650]

Can we team viewer it would make things a lot more easier?

[GlimtechArms]

Are you using the Hands Up and Handcuff add-on’s??? Since I installed those mods mine doesn’t work either, there is a conflict there somewhere but no one can seem to find where…

From: Kyle47650 [mailto:notifications@github.com] Sent: Wednesday, August 02, 2017 15:11 To: Kyominii/Cops_FiveM Cc: Subscribed Subject: Re: [Kyominii/Cops_FiveM] Saving Issue (#67)

I am using the latest version and it does not say any errors about the resource police. I am now having another problem where anyone can go on duty and the copadd command does not work anymore. If you could private message me to discuss these problems I would very much appreciate it.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Kyominii/Cops_FiveM/issues/67#issuecomment-319813317 , or mute the thread https://github.com/notifications/unsubscribe-auth/AdE5VZ4mbsVeaeoJZPS_SijalvbYeiHWks5sUPP4gaJpZM4OqlYj . https://github.com/notifications/beacon/AdE5VeB4WAuUF8yLqyf_b1wPUHaVmlrSks5sUPP4gaJpZM4OqlYj.gif

[Kyle47650]

add me on discord - Avg_Playa#7510

[Kyle47650]

BTW there are no errors Kyominii

[Kyle47650]

When the player does copadd (the id) it says the message, show the blue circles, and uploads the user data to the MySQL database but when the player leaves and joins back he is not a cop anymore.

[Kyle47650]

We can teamviewer if needed.

[ghost]

Having the same issue, seems to be an async problem, setting it to couchdb works, which is a problem as I can't use some mods.

[t-valette]

It seems to be async yes Add this in your server.cfg : set mysql_debug true It enable logs

[ghost]

Did you find out the solution to this issue? I have had the same thing for a while now and have even tried reinstalling old versions of async that I know had been working with it before. I have tried using "set mysql_debug true" but no issues have been shown.

EDIT: A solution that does not require moving to couch db for this Database.

[t-valette]

I haven't find solution at this problem. It's working with some ppl, and not working with others. I still search why ...

[t-valette]

It's maybe from MySQL-Async, there's a bug in last version (on Linux), try to downgrade MySQL-Async and retry

[ghost]

This issue also occurs with couchdb but isn't as often. any ideas? Running the server on the same machine as the CFX server ran on which didn't have this problem. it has only been since FX released.

[t-valette]

still open with 1.4 ?

[ghost]

I am unable to test due to being unwilling to add a reletively untested version on our released server. If I find time to setup a private test server, I will.

[ghost]

Fully working 1.4