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

FivePD works with sqlite but not mysql


TF1A3
 Share

Reason for Locking
Solved

By TheCipher01, on 06/15/21 05:08 PM.

Question

Hello so I use zaphosting as my server hosting platform. When I go to switch the db to mysql fivepd stops working but when i have it as sqlite it works. But when i go to my phpadmin nothing is being tracked or recorded in the database. users doesnt show anyone who has joined the server, pedcitations are not being saved same with depts etc. I run the latest 1.4.1 of FivePD. But i guess what i am asking is am i doing something wrong? I imported fivepd.sql i tried resetting the database and restarting and reinstalling fivepd and nothing works when its under mysql. 

TF1A3

Link to post
Share on other sites

17 answers to this question

Recommended Posts

  • 0
  • Community Administrator

We'll need error logs to be able to help more, though this is a first because all we've seen is sqlite causing zaphosting servers to crash and not work.

Cipher2.png

 

Community Administrator

Link to post
Share on other sites

  • 0
  • Community Administrator

In that second screenshot FivePD appears to be having issues connecting to the database, but the only other MySQL errors are related to dpkeybinds, I would ensure that those aren't interfering with each other and verify that your information in your config.json matches what zap provides you.

Though honestly if sqlite is working for you, I'd suggest using it.

Cipher2.png

 

Community Administrator

Link to post
Share on other sites

  • 0
  • Community Administrator

If you could get a full screenshot of that mysql error that pops up when fivepd restarts that would help some, cause all I can see right now is that it's having a query error which could be a multitude of things.

Cipher2.png

 

Community Administrator

Link to post
Share on other sites

  • 0

But i have the dept table. fivepd.sql was imported and my config.json is the same as the info in the database section. 

TF1A3

Link to post
Share on other sites

  • 0

I really dont know cause all i want is for citations to be recorded as well as having access to users that join the server. And from my eyes at least i felt like i did everything correctly but apparently not lol. I mean i could just run it in sqlite and not have those things but it would be nice to run it as mysql as im pretty sure thats how its supposed to be ran through zaphosting

 

TF1A3

Link to post
Share on other sites

  • 0
  • Community Administrator

I'm not sure what's not working Zap tends to create issues with FivePD regardless it seems. If sqlite works for you then I would use it, there are programs that allow you to browse the sqlite database such as DB Browser for SQLite (https://sqlitebrowser.org/)

Cipher2.png

 

Community Administrator

Link to post
Share on other sites

  • 0

Alrighty.. Appreciate Cipher thanks for the help im sorry for all of this but i guess Zap just doesnt like FivePD sadly... ? 

TF1A3

Link to post
Share on other sites

  • 0
  • Community Administrator

Zap seems to create issues of their own somehow, it is what it is. My only other suggestion would be to once again delete the current database remake it and maybe something will tick and work that time.

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.