DB syerrr error

[gregoryajram]

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

SYSERR: Jul 17 02:35:00 :: DirectQuery: AsyncSQL:irectQuery : 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

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

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

[info.student]

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

SELECT <tablename>.<columnname> FROM ....

[gregoryajram]

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:

SELECT <tablename>.<columnname> FROM ....

uhmm alright i can try to add tablename ...

[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

[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

[gregoryajram]

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 ?

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.