Jump to content
  • 0
Sign in to follow this  
Amok

Safebox Error

Question

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

Share this post


Link to post

3 answers to this question

Recommended Posts

  • 0

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

TABLE_PREFIX : or sth like that.

Share this post


Link to post
  • 0

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

Share this post


Link to post
  • 0

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"

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.