search

pBlueG / SA-MP-MySQL

MySQL plugin for San Andreas Multiplayer
BSD 3-Clause "New" or "Revised" License
194 stars 81 forks source link

error will be triggered in OnQueryError #269

Open raymand211092 opened 2 years ago

raymand211092 commented 2 years ago

I have a problem with a mod that uses authentication via mysql... in windows it does not give this error, but linux if it gives that error, I suspect that it is some config in the mysql server...any suggestions

WINDOWS [08:48:59] [DEBUG] mysql_tquery - connection: 1, query: "SELECT FROM users WHERE Username = 'Prueba_CU'", callback: "WhenAccountCheck", format: "i" [08:48:59] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [08:48:59] [DEBUG] CMySQLQuery::Execute[WhenAccountCheck] - starting query execution [08:48:59] [DEBUG] CMySQLQuery::Execute[WhenAccountCheck] - query was successfully executed within 0.364 milliseconds [08:48:59] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [08:48:59] [DEBUG] Calling callback "WhenAccountCheck".. [08:48:59] [DEBUG] cache_get_data - connection: 1 [08:48:59] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [08:49:07] [DEBUG] mysql_escape_string - source: "123456", connection: 1, max_len: 64 [08:49:07] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO users (Username,Password,IP) VALUES ('Prueba_CU', ", callback: "(null)", format: "(null)" [08:49:07] [DEBUG] CMySQLQuery::Execute[] - starting query execution [08:49:07] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 108.9 milliseconds [08:49:07] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving [08:49:09] [DEBUG] mysql_escape_string - source: "123456", connection: 1, max_len: 64 [08:49:09] [DEBUG] mysql_tquery - connection: 1, query: "SELECT FROM users WHERE Username= 'Prueba_CU' AND `Passwor", callback: "WhenPlayerLogin", format: "i" [08:49:09] [DEBUG] CMySQLQuery::Execute[WhenPlayerLogin] - starting query execution [08:49:09] [DEBUG] CMySQLQuery::Execute[WhenPlayerLogin] - query was successfully executed within 26.515 milliseconds [08:49:09] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

LINUX [14:32:37 02/18/22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT FROM users WHERE Username = 'Copia_Test'", callback: "WhenAccountCheck", format: "i" [14:32:37 02/18/22] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [14:32:37 02/18/22] [DEBUG] CMySQLQuery::Execute[WhenAccountCheck] - starting query execution [14:32:37 02/18/22] [DEBUG] CMySQLQuery::Execute[WhenAccountCheck] - query was successfully executed within 48.127 milliseconds [14:32:37 02/18/22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [14:32:37 02/18/22] [DEBUG] Calling callback "WhenAccountCheck".. [14:32:37 02/18/22] [DEBUG] cache_get_data - connection: 1 [14:32:37 02/18/22] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [14:32:47 02/18/22] [DEBUG] mysql_escape_string - source: "001130", connection: 1, max_len: 64 [14:32:47 02/18/22] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO users (Username,Password,IP) VALUES ('Copia_Test',", callback: "(null)", format: "(null)" [14:32:47 02/18/22] [DEBUG] CMySQLQuery::Execute[] - starting query execution [14:32:47 02/18/22] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError [14:32:52 02/18/22] [DEBUG] mysql_escape_string - source: "001130", connection: 1, max_len: 64 [14:32:52 02/18/22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT FROM users WHERE Username= 'Copia_Test' AND `Passwo", callback: "WhenPlayerLogin", format: "i" [14:32:52 02/18/22] [DEBUG] CMySQLQuery::Execute[WhenPlayerLogin] - starting query execution [14:32:52 02/18/22] [DEBUG] CMySQLQuery::Execute[WhenPlayerLogin] - query was successfully executed within 5.196 milliseconds [14:32:52 02/18/22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called