SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 25/05/2020, 09:15 PM   #1
Kursed
Big Clucker
 
Kursed's Avatar
 
Join Date: Jan 2015
Posts: 187
Reputation: 25
Default 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
__________________

Founder of Darkside: Darkside - 144.217.19.104:7777
Kursed is offline   Reply With Quote
Old 25/05/2020, 09:19 PM   #2
Calisthenics
High-roller
 
Join Date: May 2018
Posts: 1,228
Reputation: 205
Default 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.
__________________
Calisthenics is offline   Reply With Quote
Old 25/05/2020, 09:56 PM   #3
Kursed
Big Clucker
 
Kursed's Avatar
 
Join Date: Jan 2015
Posts: 187
Reputation: 25
Default Re: Mysql successful but cant register/login in game?

how to check mysql logs?
__________________

Founder of Darkside: Darkside - 144.217.19.104:7777
Kursed is offline   Reply With Quote
Old 25/05/2020, 10:00 PM   #4
Calisthenics
High-roller
 
Join Date: May 2018
Posts: 1,228
Reputation: 205
Default 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.
__________________
Calisthenics is offline   Reply With Quote
Old 25/05/2020, 10:25 PM   #5
Kursed
Big Clucker
 
Kursed's Avatar
 
Join Date: Jan 2015
Posts: 187
Reputation: 25
Default Re: Mysql successful but cant register/login in game?

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

Founder of Darkside: Darkside - 144.217.19.104:7777
Kursed is offline   Reply With Quote
Old 02/06/2020, 01:15 AM   #6
KevTheJoker
Big Clucker
 
KevTheJoker's Avatar
 
Join Date: Dec 2018
Location: South America
Posts: 80
Reputation: 7
Default 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);
KevTheJoker 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 Register/ Login DerickClark Scripting Help 6 10/01/2017 10:13 PM
guys i have a problem with register/login in the game kevi11 Scripting Help 2 11/03/2016 01:15 PM
Successful login doesn't go to class selection Aerotactics Scripting Help 7 25/02/2014 06:10 AM
MYsql login/register won't login KickInTheMick Scripting Help 5 13/12/2013 06:07 PM
MySQL Register & Login [wip] Mitchy Scripting Help 1 14/07/2013 12:48 PM


All times are GMT. The time now is 06:15 PM.


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