Getting Error in console of FivePD

[chrissword30 0]

I have setup fivepd and it loads up fine, and I can go on duty however I dont seem to get any calls and when I checked my console i see this error

 

[ FivePD ] An error has occured: Could not check player registration status for player `J.Julian | X-10`. Message: MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'id' in 'field list'

at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00026] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.Driver.GetResult (System.Int32 statementId, System.Int32& affectedRows, System.Int64& insertedId) [0x00000] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00023] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00205] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0030c] in <c17c8d07cfd740ad931906166ef04bff>:0

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <c17c8d07cfd740ad931906166ef04bff>:0

at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()

at Ul29xmGv62Xl120Qs㲽立䞈㬊䃊⤚�㎸䦍㸲䈲㩑㷮�䎳㑲喇㧨䔌㳎呂猪䶮䮬䑇䡸�䖨�䗳.Ul29xmGv62Xl120Qs䗁䗼�䞙䙀㫀䤣㣸㮴㍰㾏䌚㌛㬏㳤㶽�㨐⥂䯆㑐�㾕㝑�㰛 (CitizenFX.Core.Player 〮) [0x00130] in <80c8bb28078d4213802fb1796440c2c4>:0

at Ul29xmGv62Xl120Qs㲽立䞈㬊䃊⤚�㎸䦍㸲䈲㩑㷮�䎳㑲喇㧨䔌㳎呂猪䶮䮬䑇䡸�䖨�䗳.Ul29xmGv62Xl120Qs䩴Ｙ㠋䩚㘵理㦓㙙㜐㛿㨸䳣䶎䌺⎫�㩡㎘㹭䕩鍊ｑ㐉䞲 (CitizenFX.Core.Player ⤍) [0x0017f] in <80c8bb28078d4213802fb1796440c2c4>:0

server thread hitch warning: timer interval of 355 milliseconds

[ FivePD ] An error has occured: Could not save settings: Languages for user J.Julian | X-10. Error: System.Exception: Could not update the record in the database

at Ul29xmGv62Xl120Qs㲽立䞈㬊䃊⤚�㎸䦍㸲䈲㩑㷮�䎳㑲喇㧨䔌㳎呂猪䶮䮬䑇䡸�䖨�䗳.Ul29xmGv62Xl120Qs�䓈�㦊䤬䑼ﾟ㈪㏐�㍅�䮴䆩ﾸ㮿㒂㯇שּׁ䁏䶂�㕴䲆Ｊ (CitizenFX.Core.Player ⥭, System.String ⥮) [0x00173] in <80c8bb28078d4213802fb1796440c2c4>:0

at Ul29xmGv62Xl120Qs㲽立䞈㬊䃊⤚�㎸䦍㸲䈲㩑㷮�䎳㑲喇㧨䔌㳎呂猪䶮䮬䑇䡸�䖨�䗳.Ul29xmGv62Xl120Qs�䔸䴸⏈䇐ￇ䑒癩㕮㩣䝬䮭�䛅类䓯㘈䲯﭅䠔㰫㚧㐫䪲㎞㏯㵑סּ⏺㥸醴䦜 (CitizenFX.Core.Player ⥫, System.String ⥬) [0x00026] in <80c8bb28078d4213802fb1796440c2c4>:0 Any help would be appreciated, (Im new at this and I see something with MYSQL but not sure what any of that means

[Conway 162]

Just now, chrissword30 said:

yes i did that first, becasue I have done it before doing esx first and it overrides my created char, I have done it sucessfully in Zap Hosting with secondary db with no issues

Yea, keep in mind you CANT use the same database for ESX and FivePD, they need to be different - they both have "users" tables, and such. We don't mess with ESX, and FivePD has no compatibility with it. 

[Daniel K. 618]

You did not set up the database properly.

[chrissword30 0]

I went into fivepd folder and edited the config.json file to {
  "database": {
    "username": "u4704_8SR5XSRHHz",
    "password": "mypassword,
    "host": "game-db-ca-1.iceline.host",
    "port": 3306,
    "database": "s4704_MaricopaDev"

 

Then i imported the sql file into my database, before putting esx files in.

[Conway 162]

1 hour ago, chrissword30 said:

before putting esx files in.

Note that ESX is not tested for FivePD and has been known to cause issues. WITH that being said - 

 

1 hour ago, chrissword30 said:

  "password": "mypassword,

You're missing a quotation mark.

[Conway 162]

This content has been moved to the correct section by the Community Team. Next time please post in the correct section.

If you feel this was a mistake, please report this reply with a valid reason.

[chrissword30 0]

lol i must have deleted that part when i was editing out the password, bc the end " is actually in the main config

 

[Conway 162]

2 minutes ago, chrissword30 said:

lol i must have deleted that part when i was editing out the password, bc the end " is actually in the main config

 

All good - just to double check, you've imported the .sql into the database?

[chrissword30 0]

yes i did that first, becasue I have done it before doing esx first and it overrides my created char, I have done it sucessfully in Zap Hosting with secondary db with no issues. now im using iceline hosting and it only allows one db so I cant do secondary db as in zap hosting

 

Edited September 23, 2020 by chrissword30

[Conway 162]

This content has been locked by the Community Team. If you feel this was a mistake, please report this reply with a valid reason.