1 Topic by BarryK (edited by BarryK 2006-06-01 10:27)

  • BarryK
  • Junior Member
  • Offline
  • Registered: 2006-06-01
  • Posts: 3

Topic: Error: unable to fetch online count

Hi,
I've just installed punbb, it was no trouble at all, and I was able to login as
Administrator.
However, when I click on the "Administation" button, I get the error message
shown in the title.

Anyone got an idea what this bug is and what is causing it?

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Error: unable to fetch online count

Enable debug mode and post the full error

  • BarryK
  • Junior Member
  • Offline
  • Registered: 2006-06-01
  • Posts: 3

Re: Error: unable to fetch online count

I found this thread:
http://punbb.org/forums/viewtopic.php?id=3342

I also use netfirms.com, and it seems the bug is still unresolved.

phpbb works on netfirms.com.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Error: unable to fetch online count

I'm afraid that's a problem with NetFirms and the old version of MySQL they use, not with PunBB wink

5 Reply by kberry79 (edited by kberry79 2006-09-18 21:27)

  • Registered: 2006-09-18
  • Posts: 1

Re: Error: unable to fetch online count

I recently came across this same problem (I'm using Netfirms as well). I modified the following line and it seems to work:

$result = $db->query('SELECT COUNT(user_id) FROM '.$db->prefix.'online WHERE idle=0');// or error('Unable to fetch online count', __FILE__, __LINE__, $db->error());

I commented out the rest of the line after the select query.

  • From: Ottawa, Canada
  • Registered: 2006-09-05
  • Posts: 308

Re: Error: unable to fetch online count

Hurmm... "SELECT COUNT(x) FROM y" is used in a few places in punbb... you might want to grep through the code... I think it's used to find out the next valid topic id, post id,  forum id, user id, etc...

echo "deadram"; echo; fortune;

7 Reply by Smartys (edited by Smartys 2006-09-18 22:54)

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Error: unable to fetch online count

Yes, commenting out the thing that shows the error is likely to remove the error (but it still won't show the data) tongue

  • From: Ottawa, Canada
  • Registered: 2006-09-05
  • Posts: 308

Re: Error: unable to fetch online count

Try this instead, where you see the "SEECT COUNT(x) FROM y WHERE x"

$result = $db->query("SELECT x FROM y WHERE x") or error("message");

// Now you should see something along the lines of this:
// $num_online = $db->result($result);
// Change to this:
$num_online = $db->num_rows($result);

Now there is the occational COUNT(x)-1 or SELECT COUNT(x), z FROM y... so yah... this is just a tip to get you in the right direction...

echo "deadram"; echo; fortune;