Mysql successful but cant register/login in game? - 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 successful but cant register/login in game? (/showthread.php?tid=675968)

---

Mysql successful but cant register/login in game? - Kursed - 25.05.2020

Mysql successful but cant register/login in game?
It dont show a dialog to register or login, i tried on external host same error. Is it because the mysql is for webhosts?

when i host it on my pc its fine

---

Re: Mysql successful but cant register/login in game? - Calisthenics - 25.05.2020

Check mysql logs. If host is Linux, table names must be exact same because it is case-sensitive.

---

Re: Mysql successful but cant register/login in game? - Kursed - 25.05.2020

how to check mysql logs?

---

Re: Mysql successful but cant register/login in game? - Calisthenics - 25.05.2020

logs\plugins for R40+ or mysql_log.txt/mysql_log.html for R33+

Note `mysql_log` should not be set to none.

---

Re: Mysql successful but cant register/login in game? - Kursed - 25.05.2020

I just created a mysql_log.txt to scriptfiles it does not show up anything

---

Re: Mysql successful but cant register/login in game? - KevTheJoker - 02.06.2020

The file does not have to be created in the scriptfiles directory. It needs to be in the root directory of your server.

Also, adding this to your public OnGameModeInit() before mysql_connect is called can show you errors, when encountered:

---