emanuel 18 Posted September 17, 2018 Share Posted September 17, 2018 Hi,someone know something about this sysser and code ? Sysser : SYSERR: Sep 17 10:14:39 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '=' query: SELECT `empire` FROM player.player_index INNER JOIN player.player ON player.player.account_id = player.player_index.id WHERE player.player.`name` = 'yœ•¥' Function : std::string CInputMain::GetEmpireFlag(const char* c_pszName) { char newName[CHARACTER_NAME_MAX_LEN+1]; DBManager::instance().EscapeString(newName, sizeof(newName), c_pszName, sizeof(c_pszName)); std::auto_ptr<SQLMsg> pMsg(DBManager::instance().DirectQuery("SELECT `empire` FROM player.player_index INNER JOIN player.player ON player.player.account_id = player.player_index.id WHERE player.player.`name` = '%s'", newName)); MYSQL_ROW row = mysql_fetch_row(pMsg->Get()->pSQLResult); int iEmpireIndex = 0; if (pMsg->Get()->uiNumRows) { str_to_number(iEmpireIndex, row[0]); return ConvertEmpireIndexToStr(iEmpireIndex).c_str(); } else { sys_err("QUERY ERROR ON::SELECT `language` FROM account.account"); } return ""; } Link to comment Share on other sites More sharing options...
Contributor MrQuin 6463 Posted September 17, 2018 Contributor Share Posted September 17, 2018 Dude check the table from navicat player_index Design table and check the collation maybe it is wrong .. My only accounts are here and on M2D, Don't trust anyone else from other shitty sites. Link to comment Share on other sites More sharing options...
emanuel 18 Posted September 17, 2018 Author Share Posted September 17, 2018 Acum 14 minute, MrQuin a spus: Dude check the table from navicat player_index Design table and check the collation maybe it is wrong .. Humm,let's see,thx. Edit: Player_index->empire not have collation :-? Link to comment Share on other sites More sharing options...
emanuel 18 Posted September 18, 2018 Author Share Posted September 18, 2018 bump Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now