FivePD Error Message

[GregP]

Hello. I recently updated FivePD, and whenever trying to start the server up, I always get this error message. 

Any help would be appreciated!

[TheCipher01]

What version did you update from?

[DarkXess]

isn't this a MySQL error? you are loading your database too, and have you set the database up correctly to work with fivepd as such:

# DB connection string
set mysql_connection_string "server=127.0.0.1;database=fivepd;userid=root;password="
set es_enableCustomData 1

I've had the same error when I forgot to load up the db  

Edited July 28, 2020 by DarkXess

[TheCipher01]

1 hour ago, DarkXess said:

isn't this a MySQL error? you are loading your database too, and have you set the database up correctly to work with fivepd as such:

# DB connection string
set mysql_connection_string "server=127.0.0.1;database=fivepd;userid=root;password="
set es_enableCustomData 1

I've had the same error when I forgot to load up the db  

This likely isnt their issue. As the db is connected to and exists, but something exists in a table that shouldn't. Likely an error in updating.

[Natixco]

1 hour ago, DarkXess said:

isn't this a MySQL error? you are loading your database too, and have you set the database up correctly to work with fivepd as such:

# DB connection string
set mysql_connection_string "server=127.0.0.1;database=fivepd;userid=root;password="
set es_enableCustomData 1

I've had the same error when I forgot to load up the db  

 

You don't need to set up anything like this. FivePD uses it's own config.json file.

[GregP]

14 hours ago, TheCipher01 said:

What version did you update from?

I honestly don't remember. It might of been from 1.1 to 1.1.2.1.

[TheCipher01]

15 minutes ago, GregP said:

I honestly don't remember. It might of been from 1.1 to 1.1.2.1.

1.1.4 is the latest version, I would either read the release notes as one of the versions changed how the database is set up. Or just start fresh with a new database and install.

[BGHDDevelopment]

For this issue a full reinstall would be the best bet just due to the amounts of updates sense 1.1. Make sure you import the correct .sql file for FivePD and all the details are correct.

[GregP]

Alright, so I reinstalled FivePD with the latest version (1.1.4), and I connected it through my server and everything looks fine in the CMD prompt, but when I launch into my server, I am not seeing the "Your off duty" thing on the top left to show if I am on duty or not. I cannot tell if this is a new update, or something went wrong again.

[TheCipher01]

49 minutes ago, GregP said:

Alright, so I reinstalled FivePD with the latest version (1.1.4), and I connected it through my server and everything looks fine in the CMD prompt, but when I launch into my server, I am not seeing the "Your off duty" thing on the top left to show if I am on duty or not. I cannot tell if this is a new update, or something went wrong again.

Sounds like an install issue. Or you don't have FivePD started.

[GregP]

26 minutes ago, TheCipher01 said:

Sounds like an install issue. Or you don't have FivePD started.

How would I install it?

[BGHDDevelopment]

On 7/28/2020 at 7:15 PM, GregP said:

How would I install it?

Any errors in the console?

[GregP]

21 hours ago, BGHDDevelopment said:

Any errors in the console?

Nope, all good.

[BGHDDevelopment]

On 7/30/2020 at 5:32 PM, GregP said:

Nope, all good.

Does it show all the FivePD loading messages in console?

[GregP]

On 8/3/2020 at 11:54 AM, BGHDDevelopment said:

Does it show all the FivePD loading messages in console?

Yes, everything looks good now, at least I hope. I took a screenshot to show.

[TheCipher01]

38 minutes ago, GregP said:

Yes, everything looks good now, at least I hope. I took a screenshot to show.

Looks like it should be working, just let us know if it works in game.

[GregP]

1 hour ago, TheCipher01 said:

Looks like it should be working, just let us know if it works in game.

So, when I start up my server, in the loading screen comes up FIvePD, so I assume it's working from that point. As soon as I get into the game, nothing pops up regarding FivePD, like it usually does on the top left showing if you are on duty or off duty. I hit F11 which I think is the button for the menu, but nothing happens. So, I don't know what's going on. This is on the latest version too.

Edited August 4, 2020 by GregP

[DarkXess]

Would be helpful if you posted a screenshot of your server-data > resources folder and also the server.cfg

[GregP]

4 hours ago, DarkXess said:

Would be helpful if you posted a screenshot of your server-data > resources folder and also the server.cfg

Here is the link to my server.cfg

[NorthCam18]

Are you still encountering this error?

[GregP]

On 8/12/2020 at 10:03 PM, NorthCam18 said:

Are you still encountering this error?

Yes.

[BGHDDevelopment]

21 hours ago, GregP said:

Yes.

Your using a localhost not zap right?

[GregP]

On 8/14/2020 at 10:20 PM, BGHDDevelopment said:

Your using a localhost not zap right?

Yes.

[GregP]

Any help?

[Natixco]

Try to reinstall your FivePD and the database.

[GregP]

16 hours ago, Natixco said:

Try to reinstall your FivePD and the database.

Okay, so everything works again, woohoo, but the only issue now that I am having is, when I put in the DepartmentDatabase file into phpMyAdmin, and drag the departments.sql into my game, it gives me a error.

Quote

 INSERT INTO `departments` (`id`, `name`, `shortname`, `icon`, `background`, `wallpaper`, `requiresApplication`, `hiring`, `area`) VALUES(1, 'Los Santos Police Department', 'LSPD', 'https://static.secure.website/wscfus/9560237/uploads/ea16b2393c284239744c2269de516a5b36e5466a_1024__1_.png', '', '', 0, 1, 1)

This is what I am referring to: 

 

Edited August 30, 2020 by GregP