SA-MP Forums

SA-MP Forums (https://forum.sa-mp.com/index.php)
-   Server Support (https://forum.sa-mp.com/forumdisplay.php?f=19)
-   -   Mysql is connected properly, what so ever, database is not working well. (https://forum.sa-mp.com/showthread.php?t=654973)

darkhunter332 10/06/2018 04:00 PM

Mysql is connected properly, what so ever, database is not working well.
 
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?

darkhunter332 10/06/2018 09:17 PM

Re: Mysql is connected properly, what so ever, database is not working well.
 
Like only half database is loading, why is it happening?

AzaMx 12/06/2018 02:40 AM

Re: Mysql is connected properly, what so ever, database is not working well.
 
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.

Sew_Sumi 12/06/2018 06:39 AM

Re: Mysql is connected properly, what so ever, database is not working well.
 
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?

JasonRiggs 12/06/2018 01:25 PM

Re: Mysql is connected properly, what so ever, database is not working well.
 
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.

Sithis 12/06/2018 01:40 PM

Re: Mysql is connected properly, what so ever, database is not working well.
 
You should start by showing what specific queries are not producing the desired results for you.


All times are GMT. The time now is 03:18 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.