MYSQL Help! - 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 Help! (
/showthread.php?tid=620891)
MYSQL Help! -
Darkers - 04.11.2016
When I hosted my server via my PC with xampp, it work fine but when I host my server to be online and setup mysql as I do with xampp, it doesn't work like I want it to work.
Heres the different between XAMPP and the host mysql (every host I tried is just same)
Re: MYSQL Help! -
Sithis - 04.11.2016
Clearly your tables don't exist, or you are connecting to the wrong database.
Re: MYSQL Help! -
Vince - 04.11.2016
This is the fourth topic in as many days about the exact same issue
http://forum.sa-mp.com/showthread.ph...ghlight=HQInfo
http://forum.sa-mp.com/showthread.ph...ghlight=HQInfo
http://forum.sa-mp.com/showthread.ph...57#post3791657
Go to that gamemode's topic and tell them to fix their SQL script.
Re: MYSQL Help! -
Darkers - 04.11.2016
Quote:
Originally Posted by Sithis
Clearly your tables don't exist, or you are connecting to the wrong database.
|
I don't think it's connected to the wrong database nor the tables doesn't exist because it work fine in my windows.
Quote:
Originally Posted by Vince
Tables names may or may not be case sensitive. This is usually not a problem on a Windows machine but Linux handles things differently and importing a database dump from a Windows machine in a Linux machine may cause trouble (experienced this myself).
What you should do, if possible, is edit the .sql file so the table names in there match the table names in your script.
|
What do you mean by here?
Re: MYSQL Help! -
Darkers - 05.11.2016
EDIT: Fixed, thanks Vince! Now I fully understand why!