SA-MP Forums Archive
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)

Код:
MYSQL from XAMPP (MY PC) - http://pastebin.com/yTEpkQE3

MYSQL from Every SAMP Host - http://pastebin.com/Y5ng7WED



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!