Problem więcej info w syserr

[OnlyShift]

Mam problem, pada logowanie, mysle ze to wina... syserr z db 

SYSERR: Oct 23 09:37:49 :: pid_init: 
Start of pid: 1620

SYSERR: Oct 23 09:37:49 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 23 09:37:55 :: 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: Oct 23 09:37:56 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Oct 23 09:37:56 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='25.96.96.100')
SYSERR: Oct 23 09:37:59 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Oct 23 09:37:59 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='25.96.96.100')
SYSERR: Oct 23 09:37:59 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Oct 23 09:37:59 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='25.96.96.100')

Pomoze ktos ? ;c

 

[Matix8981]

Nie może pobrać tabeli mID oraz gmhost

[OnlyShift]

dzieki za pomoc ale jesli chodzi jeszcze o to 

SYSERR: Oct 23 09:37:49 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 23 09:37:55 :: 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

nawet jak zmienie nazwe tabelki z name na user nie pomaga ;/ 

[Salur]

Określ w zapytaniu alias dla kolumny `name`.

[OnlyShift]

Mozesz troszkę jasniej dla zielonego ?

[Salur]

Kolumnę `name` masz zarówno w tabeli monarch jak i player, musisz określić z której tabeli chcesz pobrać tą kolumnę.

[_*KizioRCK*_]

brakuje cos od monarch w mysql