Jump to content
×
×
  • Create New...
  • 0

Getting Error in console of FivePD


chrissword30
 Share

Reason for Locking
Solved

By Conway, on 09/25/20 04:46 PM.

Question

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䩴Y㠋䩚㘵理㦓㙙㜐㛿㨸䳣䶎䌺⎫�㩡㎘㹭䕩鍊q㐉䞲 (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�䓈�㦊䤬䑼゚㈪㏐�㍅�䮴䆩ᄌ㮿㒂㯇שּׁ䁏䶂�㕴䲆J (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
Link to post
Share on other sites

9 answers to this question

Recommended Posts

  • 0
  • Community Administrator
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. 

  • Like 1

1181375915_ConwayGPMSign(2).png.222b6b96fc398f6107b76f0b800e9e59.png

 

Community Administrator and FivePD Support Guru

gpm_animated.gif

 

Link to post
Share on other sites

  • 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.

Link to post
Share on other sites

  • 0
  • Community Administrator
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.

  • Like 1

1181375915_ConwayGPMSign(2).png.222b6b96fc398f6107b76f0b800e9e59.png

 

Community Administrator and FivePD Support Guru

gpm_animated.gif

 

Link to post
Share on other sites

  • 0
  • Community Administrator

Content_moved.png

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.

1181375915_ConwayGPMSign(2).png.222b6b96fc398f6107b76f0b800e9e59.png

 

Community Administrator and FivePD Support Guru

gpm_animated.gif

 

Link to post
Share on other sites

  • 0
  • Community Administrator
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?

1181375915_ConwayGPMSign(2).png.222b6b96fc398f6107b76f0b800e9e59.png

 

Community Administrator and FivePD Support Guru

gpm_animated.gif

 

Link to post
Share on other sites

  • 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 by chrissword30
Link to post
Share on other sites

  • 0
  • Community Administrator

content_locked.png

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

1181375915_ConwayGPMSign(2).png.222b6b96fc398f6107b76f0b800e9e59.png

 

Community Administrator and FivePD Support Guru

gpm_animated.gif

 

Link to post
Share on other sites

Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

Important Information

Please view the site: Terms of Use, Privacy Policy, and Guidelines. // IMPORTANT: We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.