SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 10/06/2018, 03:00 PM   #1
darkhunter332
Huge Clucker
 
darkhunter332's Avatar
 
Join Date: Aug 2013
Posts: 304
Reputation: 29
Default 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 is online now   Reply With Quote
Old 10/06/2018, 08:17 PM   #2
darkhunter332
Huge Clucker
 
darkhunter332's Avatar
 
Join Date: Aug 2013
Posts: 304
Reputation: 29
Default Re: Mysql is connected properly, what so ever, database is not working well.

Like only half database is loading, why is it happening?
darkhunter332 is online now   Reply With Quote
Old 12/06/2018, 01:40 AM   #3
AzaMx
Huge Clucker
 
Join Date: Aug 2014
Location: Home.
Posts: 353
Reputation: 63
Default 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.
AzaMx is offline   Reply With Quote
Old 12/06/2018, 05:39 AM   #4
Sew_Sumi
Banned
 
Join Date: Jun 2008
Location: Azerbaijan
Posts: 6,469
Reputation: 525
Default 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?
Sew_Sumi is offline   Reply With Quote
Old 12/06/2018, 12:25 PM   #5
JasonRiggs
Gangsta
 
Join Date: Jul 2016
Location: My bedroom.
Posts: 743
Reputation: 39
Default 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.
__________________


Discord: Riggs #5210
JasonRiggs is offline   Reply With Quote
Old 12/06/2018, 12:40 PM   #6
Sithis
Gangsta
 
Join Date: Mar 2013
Location: the Netherlands
Posts: 925
Reputation: 79
Default 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.
__________________
Developer and owner of https://trinityrpg.com
Sithis is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL database stops working sjames Scripting Help 8 07/08/2015 12:09 PM
mysql rename not working properly kampuman Scripting Help 2 08/12/2014 03:48 PM
Registration ain't showing... Even ain' t printing if the database is connected... Scrillex Scripting Help 4 29/03/2014 06:14 AM
Gates loading properly out of database yet for loop not showing all. SomebodyAndMe Scripting Help 1 21/05/2013 07:17 AM
houses are not loading from database properly[REP +] rati555 Scripting Help 4 10/02/2012 04:58 PM


All times are GMT. The time now is 05:01 AM.


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