Erro na db (syserr)

[Requiem]

Pode alguém me ajudar?

Já corri querys e tudo, mas o erro mantém-se

 

 

SYSERR: Mar 13 20:16:34.239609 :: pid_init:Start of pid: 1339SYSERR: Mar 13 20:16:34.239701 :: Start: TABLE_POSTFIX not configured use defaultSYSERR: Mar 13 20:16:40.118883 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'money' in field list is ambiguousquery: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.idSYSERR: Mar 13 20:16:40.122767 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)SYSERR: Mar 13 20:16:40.771508 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)SYSERR: Mar 13 20:16:41.153701 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)SYSERR: Mar 13 20:16:45.577004 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)SYSERR: Mar 13 20:16:45.681971 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)

 

[[Admin] tierrilopes]

Na query, onde está money, muda para:

monarch.money

[juniorsilva]

 

SYSERR: Mar 13 20:16:34.239609 :: pid_init:Start of pid: 1339SYSERR: Mar 13 20:16:34.239701 :: Start: TABLE_POSTFIX not configured use defaultSYSERR: Mar 13 20:16:40.118883 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'money' in field list is ambiguousquery: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.idSYSERR: Mar 13 20:16:40.122767 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)SYSERR: Mar 13 20:16:40.771508 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)SYSERR: Mar 13 20:16:41.153701 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)SYSERR: Mar 13 20:16:45.577004 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)SYSERR: Mar 13 20:16:45.681971 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)

 

 

1 - DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

 

correção:

 

INSERT INTO `new_account.iptocountry` (`IP_FROM`, `IP_TO`, `COUNTRY_NAME`) VALUES('192.168.100.10', '192.168.201.10', 'BRAZIL');

 

//////////////////////////////////////////////////////////////////////////////////////////////////////////

2 - DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'money' in field list is ambiguous query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id

 

correção:

 

CREATE TABLE `new_monarch` ( `empire` int(10) UNSIGNED NOT NULL DEFAULT '0', `pid` int(10) UNSIGNED DEFAULT NULL, `windate` datetime DEFAULT NULL, `money` bigint(20) UNSIGNED DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;INSERT INTO `new_monarch` (`empire`, `pid`, `windate`, `money`) VALUES(1, 100001, '2016-03-11 20:11:36', 1999999999),(2, 100002, '2016-03-11 20:11:36', 1999999999),(3, 100003, '2016-03-11 20:11:36', 1999999999);

 

 

In source db/src/Monarch.cpp (base novaline)

 

bool CMonarch::LoadMonarch(){MonarchInfo * p = &m_MonarchInfo;   char szQuery[256];snprintf(szQuery, sizeof(szQuery), "SELECT a.empire, a.pid, b.name, a.money, a.windate FROM monarch a, player%s b WHERE a.pid=b.id", GetTablePostfix());

 

//////////////////////////////////////////////////////////////////////////////////////////////////////////

3 - __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)

 

correção:

 

CREATE TABLE `new_gmhost` ( `mIP` varchar(16) NOT NULL DEFAULT '') ENGINE=MyISAM DEFAULT CHARSET=latin1;INTO `gmhost` (`mIP`) VALUES('192.168.233.100');