Mysql is connected properly, what so ever, database is not working well. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Mysql is connected properly, what so ever, database is not working well. (/showthread.php?tid=654973)

---

Mysql is connected properly, what so ever, database is not working well. - darkhunter332 - 10.06.2018

It might be a common proble, aint sure.
I have a server hosted on my computer, mysql database was running well, no problem, cars, houses and businesses, all are loaded currectly, when I moved to a hosted server, I did everything correct, although cars are not appearing, I was looking on the logs, nothing is wrong, same plugin is used, I don't know the problem, the database was working on my home server, on a hosted server it aint working.

Any solutions?

---

Re: Mysql is connected properly, what so ever, database is not working well. - darkhunter332 - 10.06.2018

Like only half database is loading, why is it happening?

---

Re: Mysql is connected properly, what so ever, database is not working well. - AzaMx - 12.06.2018

Maybe because your database was in case sensitive?

For example,
In your script, it's 'PlayerName' but in your database it's 'playername' and it should be 'PlayerName' aswell as in your script.

---

Re: Mysql is connected properly, what so ever, database is not working well. - Sew_Sumi - 12.06.2018

Also check the formats of the tables themselves, you may have mixed floats with integers and such others.

How'd you export and import the database? or did you simply create a new DB on the host?

---

Re: Mysql is connected properly, what so ever, database is not working well. - JasonRiggs - 12.06.2018

Did you check "mysql_log"? and If you didn't find anything, then go to your gamemode, under OnGameModeInIt add the line "mysql_log(LOG_ALL);" It'll show you everything happened in the server.

---

Re: Mysql is connected properly, what so ever, database is not working well. - Sithis - 12.06.2018

You should start by showing what specific queries are not producing the desired results for you.

---