MySQL Issue
#3

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.

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.

And the third query just freezes the script after login and doesn't process any queries after it.
Reply


Messages In This Thread
MySQL Issue - by CoCo-Corello - 31.07.2012, 00:11
Re: MySQL Issue - by Revo - 31.07.2012, 00:17
Re: MySQL Issue - by CoCo-Corello - 31.07.2012, 00:20

Forum Jump:


Users browsing this thread: 2 Guest(s)