how to fix? player // monarch.sql

[Traceur3RUN 65]

hi someone know how to fix?

 

SYSERR: Dec 31 12:50:31 :: pid_init:
Start of pid: 895

SYSERR: Dec 31 12:50:32 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player  b where a.pid=b.id
SYSERR: Dec 31 12:50:41 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Dec 31 12:50:41 :: pid_deinit:
End of pid

[flygun 266]

may help you

[Shogun 3804]

Delete the field "name" from player.monarch table structure

[metin2team 675]

if you're using the source

 

You'll find it fixed in Novaline,

DB/Monarch.cpp

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

[Traceur3RUN 65]

 

if you're using the source

 

You'll find it fixed in Novaline,

DB/Monarch.cpp

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

now : SYSERR: Dec 31 14:32:40 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

[Shogun 3804]

You can safely ignore that one.