TrinityCore/TrinityCore — Issue #4500: [MySQL][Error] Commands out of sync
Author: chuckyblack
Created: 2011-12-27 13:25:53+00:00
State: open

It isn't possible to load characters from DB.

Terminal output:

TC>TrinityCore rev. 2011-12-27 11:21:12 +0100 (72f6a7a11862) (Unix, Release) (worldserver-daemon) ready...
TC>SQL(p): UPDATE character_banned SET active = 0 WHERE unbandate <= UNIX_TIMESTAMP() AND unbandate <> bandate
[ERROR]: [2014] Commands out of sync; you can't run this command now
Unhandled MySQL errno 2014. Unexpected behaviour possible.
SQL(p): SELECT c.guid, c.name, c.race, c.class, c.gender, c.playerBytes, c.playerBytes2, c.level, c.zone, c.map, c.position_x, c.position_y, c.position_z, gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid FROM characters AS c LEFT JOIN character_pet AS cp ON c.guid = cp.owner AND cp.slot = '0' LEFT JOIN guild_member AS gm ON c.guid = gm.guid LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.account = '22' ORDER BY c.guid
[ERROR]: [2014] Commands out of sync; you can't run this command now
Unhandled MySQL errno 2014. Unexpected behaviour possible.

MySQL version:
ii mysql-client 5.1.58-1ubuntu1 MySQL database client (metapackage depending on the latest version)
ii mysql-client-5.1 5.1.58-1ubuntu1 MySQL database client binaries
ii mysql-client-core-5.1 5.1.58-1ubuntu1 MySQL database core client binaries
ii mysql-common 5.1.58-1ubuntu1 MySQL database common files, e.g. /etc/mysql/my.cnf
ii mysql-server 5.1.58-1ubuntu1 MySQL database server (metapackage depending on the latest version)
ii mysql-server-5.1 5.1.58-1ubuntu1 MySQL database server binaries and system database setup
ii mysql-server-core-5.1 5.1.58-1ubuntu1 MySQL database server binaries