Safebox Error

[Amok 28]

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

[Evor 72]

Did u write the correct table prefix name in the db/conf.txt file?

TABLE_PREFIX : or sth like that.

[Amok 28]

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);

[Shogun 4481]

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"