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 successful but cant register/login in game? (https://forum.sa-mp.com/showthread.php?t=675968)

Kursed 25/05/2020 09:15 PM

Mysql successful but cant register/login in game?
 
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

Calisthenics 25/05/2020 09:19 PM

Re: Mysql successful but cant register/login in game?
 
Check mysql logs. If host is Linux, table names must be exact same because it is case-sensitive.

Kursed 25/05/2020 09:56 PM

Re: Mysql successful but cant register/login in game?
 
how to check mysql logs?

Calisthenics 25/05/2020 10:00 PM

Re: Mysql successful but cant register/login in game?
 
logs\plugins for R40+ or mysql_log.txt/mysql_log.html for R33+

Note `mysql_log` should not be set to none.

Kursed 25/05/2020 10:25 PM

Re: Mysql successful but cant register/login in game?
 
I just created a mysql_log.txt to scriptfiles it does not show up anything

KevTheJoker 02/06/2020 01:15 AM

Re: Mysql successful but cant register/login in game?
 
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:
Code:

mysql_log(LOG_WARNING | LOG_ERROR);


All times are GMT. The time now is 09:04 PM.

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