FivePD works with sqlite but not mysql

[TF1A3]

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. 

[TheCipher01]

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.

[TF1A3]

[TheCipher01]

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.

[TF1A3]

[TheCipher01]

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.

[TF1A3]

[TF1A3]

[TF1A3]

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

[TheCipher01]

Can you screenshot your fivepd config.json?

[TF1A3]

[TF1A3]

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

 

[TheCipher01]

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/)

[TF1A3]

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

[TheCipher01]

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.

[TF1A3]

i think im getting somewhere let me take a screenshot

[TF1A3]

Nope nevermind same error :,( sqlite it is

 

[TheCipher01]

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