Jump to content
Phishing - Beware of identity theft... ×
  • 0

how to fix? player // monarch.sql


Traceur3RUN

Question

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

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

 

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)

Link to comment
Share on other sites

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


×
×
  • 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.