DB syerrr error

is it possible to someone help me to resolve the below errors :

Quote:

SYSERR: Jul 17 02:35:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id

Quote:

SYSERR: Jul 17 02:35:00 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

Quote:

SYSERR: Jul 17 02:35:00 :: LoadMonarchCandidacy: DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)

this is a MySQL error. You need to write the tables name in front of your columun names. Something like this:

Quote:

Originally Posted by info.student this is a MySQL error. You need to write the tables name in front of your columun names. Something like this: Code: SELECT <tablename>.<columnname> FROM ....

uhmm alright i can try to add tablename ...

SYSERR: Jul 17 02:35:00 :: DirectQuery: AsyncSQL:irectQuery : mysql_query error: Column 'name' in field list is ambiguous

That is telling you that the Column "name" is not unique
From your query : SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id

i can tell u that there is a name column in the player and in the monarch_candidacy table

to solve the problem change the query to

SELECT pid, player.name, date FROM monarch_candidacy a, player b where a.pid = b.id

or

SELECT pid, monarch_candidacy.name, date FROM monarch_candidacy a, player b where a.pid = b.id

Learning English, the rest doesnt even matter, also it exist a lot of topic because of that Errors.

Go to Account Db there is a table called Iptocountry 127.0.0.1 as ip in both columns, None as Name

Quote:

Originally Posted by Aerociety SYSERR: Jul 17 02:35:00 :: DirectQuery: AsyncSQL:irectQuery : mysql_query error: Column 'name' in field list is ambiguous That is telling you that the Column "name" is not unique From your query : SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id i can tell u that there is a name column in the player and in the monarch_candidacy table to solve the problem change the query to SELECT pid, player.name, date FROM monarch_candidacy a, player b where a.pid = b.id or SELECT pid, monarch_candidacy.name, date FROM monarch_candidacy a, player b where a.pid = b.id

how am i suppose to edit the monarch_candidacy ?

Quote:

Originally Posted by BizepsSupportAccount Learning English, the rest doesnt even matter, also it exist a lot of topic because of that Errors. Go to Account Db there is a table called Iptocountry 127.0.0.1 as ip in both columns, None as Name

Iptocountry table has 3 columns but all of them are empty.