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

Database Error


Reason for Locking
Solved/No Response

By Conway, on 04/30/21 02:30 AM.

Question

I use ZAP Hosting and am having these errors when I am in FivePD:

Creating script environments for fivepd
Instantiated instance of script HjGl21xmnGv62Xl120Qtr�㞭��䮲㜋㕾䝤⎃ヤ㈤䵻と㏭㮒㹟㚨㵴�䮪㦠㣺䘰㡉㠶⤑䚐㩍㺣㈊㋏﹆.
Instantiated instance of script HjGl21xmnGv62Xl120Qtr�㞭��䮲㜋㕾䝤⎃ヤ㈤䵻と㏭㮒㹟㚨㵴�䮪㦠㣺䘰㡉㠶⤑䚐㩍㺣㈊㋏$.
[ FivePD ] ==== Validating Config Files ====
[ FivePD ] Validated `callouts.json`.
[ FivePD ] Validated `charges.json`.
[ FivePD ] Validated `disabled_callouts.json`.
[ FivePD ] Validated `items.json`.
[ FivePD ] Validated `vehicles.json`.
[ FivePD ] Validated `loadouts.json`.
[ FivePD ] Validated `coordinates.json`.
[ FivePD ] Validated `menu.json`.
[ FivePD ] Validated `questions.json`.
[ FivePD ] Validated `scene_management.json`.
[ FivePD ] Selected database type: MySQL
[ FivePD ] Loaded charges.json
[ FivePD ] ==== Loading Departments ====
[ FivePD ] Department: Los Santos Police Department has been loaded
[ FivePD ] Department: Blaine County Sheriff's Office has been loaded
[ FivePD ] Department: San Andreas Highway Patrol has been loaded
Instantiated instance of script HjGl21xmnGv62Xl120Qtr�㞭��䮲㜋㕾䝤⎃ヤ㈤䵻と㏭㮒㹟㚨㵴�䮪㦠㣺䘰㡉㠶⤑䚐㩍㺣㈊㋏&.
Instantiated instance of script HjGl21xmnGv62Xl120Qtr�㞭��䮲㜋㕾䝤⎃ヤ㈤䵻と㏭㮒㹟㚨㵴�䮪㦠㣺䘰㡉㠶⤑䚐㩍㺣㈊㋏9.
Instantiated instance of script HjGl21xmnGv62Xl120Qtr�㞭��䮲㜋㕾䝤⎃ヤ㈤䵻と㏭㮒㹟㚨㵴�䮪㦠㣺䘰㡉㠶⤑䚐㩍㺣㈊㋏<+HjGl21xmnGv62Xl120Qtr﬉䀌�䈤㟊㱹䑔䛔㟧索䌈㟂⤷䋯�㠺䙟䑘㦂﬉﩯�⤌㪩䘺䧠既㑫聆䠙.
Instantiated instance of script HjGl21xmnGv62Xl120Qtr�㞭��䮲㜋㕾䝤⎃ヤ㈤䵻と㏭㮒㹟㚨㵴�䮪㦠㣺䘰㡉㠶⤑䚐㩍㺣㈊㋏A.
Started resource fivepd
server thread hitch warning: timer interval of 4936 milliseconds
server thread hitch warning: timer interval of 152 milliseconds
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Connection must be valid and open.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Out of sync with server
[ FivePD ] An error has occured: Could not execute MySql query (UPDATE). Error: There is already an open DataReader associated with this Connection which must be closed first.
server thread hitch warning: timer interval of 423 milliseconds
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Object reference not set to an instance of an object
[ FivePD ] An error has occured: Could not register player `[X-1] A. Merrifield`. Message: Could not insert record.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not register player `N. Mariah`. Message: Could not insert record.
[ FivePD ] An error has occured: Could not execute MySql query (UPDATE). Error: Object reference not set to an instance of an object
[ FivePD ] An error has occured: Could not execute MySql query (UPDATE). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Connection must be valid and open.
[ FivePD ] An error has occured: Could not get department member status for `N. Mariah`. Message: $result_null || row_null
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not register player `~b~ [A] [1E-03] Evil.`. Message: Could not insert record.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Object reference not set to an instance of an object
[ FivePD ] An error has occured: Could not get department member status for `~b~ [A] [1E-03] Evil.`. Message: $result_null || row_null
[ FivePD ] An error has occured: Could not get department member status for `[X-1] A. Merrifield`. Message: $result_null || row_null
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[DiscordAcePerms] (playerConnecting) Added N. Mariah to role group group.fivepd
[DiscordAcePerms] (playerConnecting) Added N. Mariah to role group group.moderator
[DiscordAcePerms] (playerConnecting) Player N. Mariah has been granted their permissions...
server thread hitch warning: timer interval of 425 milliseconds
Sending heartbeat to https://servers-ingress-live.fivem.net/ingress
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not register player `N. Mariah`. Message: Could not insert record.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not get department member status for `N. Mariah`. Message: $result_null || row_null
[ FivePD ] An error has occured: Could not execute MySql query (UPDATE). Error: Index was outside the bounds of the array.
Sending heartbeat to https://servers-ingress-live.fivem.net/ingress
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (UPDATE). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (UPDATE). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (UPDATE). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (UPDATE). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (UPDATE). Error: Index was outside the bounds of the array.
[ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Index was outside the bounds of the array.
 

 

Here's my config.json:

{
  "db": "mysql",
  "database": {
    "username": "username",
    "password": "xxxxxxxxxxx",
    "host": "mysql-mariadb-dal01-9-101.zap-hosting.com",
    "port": 3306,
    "database": "dbname"
  },
  "stationBlips": true,
  "maxReportLength": 1000,
  "maxFine": 1000000,
  "maxFinePoint": 100,
  "maxCallLength": 125,
  "maxOfficerNameLength": 125,
  "maxAINameLength": 50,
  "maxNumberOfInvolvedOfficers": 32,
  "maxNumberOfSuspects": 32,
  "maxNumberOfVictims": 32,
  "maxViolationCount": 32,
  "isSignatureEnabled": true,
  "maxSignatureSize": 10.0,
  "maxStreetNameLength": 25,
  "maxCityNameLength": 30,
  "maxZIPLength": 10,
  "maxChargeCount": 15,
  "maxReportCount": 100,
  "maxCitationCount": 100,
  "minCallsignLength": 1,
  "maxCallsignLength": 15,
  "adminCode": "admin",
  "discord": {
    "enable": true,
    "token": ""
  },
  "dutyNotification": true,
  "observation": true,
  "allowlist": false
}

 

Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

So I got an answer from ZAP Hosting: 

"I would recommend contacting FivePD Support about this, your Database Configuration seems to be correct but this error appears:
https://screensaver01.zap-hosting.com/index.php/s/GAiFgLESq825bo8/preview

Usually this means that the mysql connector of fivepd is trying to run queries before the connection is ready, and then tries establishing another connection, most likely this is a bug in FivePD"

Link to post
Share on other sites
  • 0

This isn't a bug within FivePD, it's only been reported by people who use zap hosting. The only thing I could suggest is shut the server down then start it up, if it happens again, stop the FivePD resource wait for a bit and start it again.

TheCipher01

Community Administrator

Link to post
Share on other sites
  • 0

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