aber wie behebe ich das am besten.
Hier der sysserlog
Code:
SYSERR: Mar 27 13:29:56 :: Start: TABLE_POSTFIX not configured use default SYSERR: Mar 27 13:29:57 :: 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: Mar 27 13:29:57 :: 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
Hi !
Column name missing, create sql file and put this command :
Code:
ALTER TABLE `monarch` ADD name varchar(16) DEFAULT NULL;
Code:
mysql> ALTER TABLE `monarch` ADD name varchar(16) DEFAULT NULL; 1060 - Duplicate column name 'name' mysql>