$200 Steam Giftcard Raffle | Sponsored by TF1A3 ×
Jump to content
×
×
  • Create New...
  • 0

Possible database issue?


Mark Davison
 Share

Reason for Locking
Update to 1.5. If issues persist open a new thread.

By TheCipher01, on 07/25/21 06:20 AM.

Question

[       script:fivepd] [ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: Connection must be valid and open.
[       script:fivepd] [ FivePD ] An error has occured: Could not get department member status for `Mark Davison`. Message: $result_null || row_null
[      script:monitor] [txAdminClient] Admin Broadcast - txAdmin: This server is scheduled to restart in 15 minutes.
[      script:monitor] [txAdminClient] Admin Broadcast - txAdmin: This server is scheduled to restart in 10 minutes.
[       script:fivepd] [ FivePD ] An error has occured: Could not execute MySql query (SELECT). Error: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'fivepd.users.id'; this is incompatible with sql_mode=only_full_group_by

 

Any idea how to fix this (don't mind the TXAdmin restarts)
 

Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0
  • Community Administrator

Please update to 1.5 and see if this issue persists. If it does please ope a new thread so we can continue to try and help you out. If you're not using ZapHosting you can also try using sqlite as a database instead.

Cipher2.png

 

Community Administrator

Link to post
Share on other sites

  • 0
  • Community Administrator

The first line leads me to believe that your database isn't running so it couldn't connect. How are you hosting the server? A reinstall of the database might resolve the issue, or if you don't need a mysql database (ie you're not using a game server from zaphosting), you could set the first line in your config to sqlite.

Cipher2.png

 

Community Administrator

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.

Cipher2.png

 

Community Administrator

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

Thanks for visiting GPM. As a user of the GTAPoliceMods platform, we ask that you review the Terms of Use, Privacy Policy, and Guidelines. These principles allow us to continue fostering a great community. We have placed cookies on your device to help improve your experience. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.