Hello all, i have this little problem here.
this is what i get to console when org member writes !online in org channel:
bot [2007-05-31 17:08:50] [GROUP] [MSG] [org] member: !online
MySQL error (# 0) on query: SELECT t1.nickname, level, org_rank, org_name, profession, defender_rank_id FROM online AS t1 LEFT JOIN whois AS t2 ON t1.nickname = t2.nickname WHERE status_gc=1 AND botname='bot' ORDER BY profession ASC,t1.nickname ASC
Column 'level' in field list is ambiguous
MySQL error (# 1) on query: SELECT t1.nickname, level, org_rank, org_name, profession, defender_rank_id FROM online AS t1 LEFT JOIN whois AS t2 ON t1.nickname = t2.nickname WHERE status_pg=1 AND botname='bot' ORDER BY profession ASC,t1.nickname ASC
Column 'level' in field list is ambiguous
bot [2007-05-31 17:08:51] [GROUP] [MSG] [org] bot: 0 members online in Guild. 0 members in Privategro
up. :: [link]click to view[/link]
i updated latest svn files just a moment ago and thats when i got this problem.
Edit: nvm, solved the problem by dropping old online table