collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: !online problem  (Read 1907 times)

0 Members and 1 Guest are viewing this topic.

Offline Mobsters

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
!online problem
« 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
« Last Edit: May 31, 2007, 08:00:44 pm by Mobsters »

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: !online problem
« Reply #1 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.

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 671
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal