BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.3 support => Topic started by: Mobsters on May 31, 2007, 07:24:50 pm

Title: !online problem
Post by: Mobsters on May 31, 2007, 07:24:50 pm

Hello all, i have this little problem here.
this is what i get to console when org member writes !online in org channel:

Code: [Select]

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

Title: Re: !online problem
Post by: Alreadythere on May 31, 2007, 08:56:47 pm

Thanks for catching that, added table version tracking to the online module to solve it for other users.