Premium Amok 28 Posted February 27, 2014 Premium Share Posted February 27, 2014 When i open Safebox i get this error: SYSERR: Feb 27 20:04:08 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.item_proto' doesn't exist query: INSERT INTO item (id, owner_id, window, pos, vnum, count, socket0, socket1, socket2) VALUES(2000000, 1, 'MALL', 0, 11971, 1, 0, 0, 0) Feb 27 20:04:08 :: SAFEBOX Query : [INSERT INTO item (id, owner_id, window, pos, vnum, count, socket0, socket1, socket2) VALUES(2000000, 1, 'MALL', 0, 11971, 1, 0, 0, 0)] Problem: SYSERR: Feb 27 20:04:08 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.item_proto' doesn't exist but the mysql server database is named m2_player .. I searched full source but didnt find something which could explain the problem maybe someone of you could help ..,- Link to comment Share on other sites More sharing options...
Evor 72 Posted February 27, 2014 Share Posted February 27, 2014 Did u write the correct table prefix name in the db/conf.txt file? TABLE_PREFIX : or sth like that. Link to comment Share on other sites More sharing options...
Premium Amok 28 Posted February 27, 2014 Author Premium Share Posted February 27, 2014 TABLE_POSTFIX = "" this is my config here the error must be but didnt find some: snprintf(szQuery, sizeof(szQuery), "INSERT INTO item%s (id, owner_id, window, pos, vnum, count, socket0, socket1, socket2) " "VALUES(%u, %u, '%s', %d, %u, %u, %u, %u, %u)", GetTablePostfix(), GainItemID(), pi->account_id, pi->ip[0] == 0 ? "SAFEBOX" : "MALL", iPos, pItemAward->dwVnum, pItemAward->dwCount, pItemAward->dwSocket0, pItemAward->dwSocket1, dwSocket2); } std::auto_ptr<SQLMsg> pmsg(CDBManager::instance().DirectQuery(szQuery)); SQLResult * pRes = pmsg->Get(); sys_log(0, "SAFEBOX Query : [%s]", szQuery); ..,- Link to comment Share on other sites More sharing options...
Premium Shogun 4587 Posted February 28, 2014 Premium Share Posted February 28, 2014 You are missing a few things in conf.txt, namely SQL_ACCOUNT = "127.0.0.1 dbname user pass 0" SQL_COMMON = "127.0.0.1 dbname user pass 0" SQL_HOTBACKUP = "127.0.0.1 dbname user pass 0" SQL_PLAYER = "127.0.0.1 dbname user pass 0" 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