31.07.2012, 00:20
The table structure and case is correct, I've made sure of that already.
Pretty much, the first query works, it loads the characters and continues the script to do as it should.
The second obviously, has the MySQL issue which then stops the characters loading and then successfully loads later queries.
And the third query just freezes the script after login and doesn't process any queries after it.
Pretty much, the first query works, it loads the characters and continues the script to do as it should.
The second obviously, has the MySQL issue which then stops the characters loading and then successfully loads later queries.
Quote:
[01:23:02] CMySQLHandler::Query(SELECT ID,Username,Registered,FirstLogin,LastLogin,Regist eredIP,CharacterSlots,Banned,LastCreated,Muted,Gro up FROM Accounts WHERE `Username` = 'Corello') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Group FROM Accounts WHERE `Username` = 'Corello'' at line 1) [01:23:02] >> mysql_store_result( Connection handle: 1 ) [01:23:02] CMySQLHandler::StoreResult() - No data to store. [01:23:02] >> mysql_fetch_row_format( Connection handle: 1 ) [01:23:02] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result) [01:23:02] >> mysql_free_result( Connection handle: 1 ) [01:23:02] CMySQLHandler::FreeResult() - The result is already empty. |