Register/Login func. not being called [MySQL - Scratch]
#4

Quote:
Originally Posted by rickisme
Посмотреть сообщение
edit :
pawn Код:
mysql_connect( MYSQL_HOST, MYSQL_USER, MYSQL_DATABASE, MYSQL_PASS);
to :
pawn Код:
MySQL = mysql_connect( MYSQL_HOST, MYSQL_USER, MYSQL_DATABASE, MYSQL_PASS);
Recompile and try again
Quote:
Originally Posted by BroZeus
Посмотреть сообщение
Show us mysql_log.txt file which you will find in your server log..
I did it, I checked the MySQL_Log and realized that I didn't defined the connectionHandle, However I'm getting Query error now and BTW the Registration Dialog pops up when i entered a password, it didn't continued. & I had a Query error in the mysql_log.txt

Here it is

Код:
[20:04:14] [DEBUG] CMySQLConnection::Connect - connection was successful
[20:04:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[20:04:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[20:04:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[20:05:03] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `accounts` WHERE `Username` = '%e' LIMIT 1"
[20:05:03] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `accounts` WHERE `Username` = 'j0ke", callback: "OnAccountCheck", format: "i"
[20:05:03] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[20:05:03] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.728 milliseconds
[20:05:03] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[20:05:03] [DEBUG] Calling callback "OnAccountCheck"..
[20:05:03] [DEBUG] cache_get_data - connection: 1
[20:05:03] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[20:05:08] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `accounts` (`ID`, `Online`, `Password`, `IP`, `Admin", callback: "OnAccountRegister", format: "i"
[20:05:08] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution
[20:05:08] [ERROR] CMySQLQuery::Execute[OnAccountRegister] - (error #1054) Unknown column '' in 'field list'
[20:05:08] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - error will be triggered in OnQueryError
BTW my Username was J0ker_2k.
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)