error with admin_index.php (Page 1 of 2)

If you haven't modified anything, then it should work, what version of MySQL do you have?
This error means that the select count query returned an error.
You can try bypassing it, but I strongly recommend that you find out why is this error appearing, or you might find yourself in trouble elsewhere.

To bypass it, edit the mentioned file and instead of:

// Get number of current visitors
$result = $db->query('SELECT COUNT(user_id) FROM '.$db->prefix.'online') or error('Unable to fetch online count', __FILE__, __LINE__, $db->error());
$num_online = $db->result($result, 0);

write:

// Get number of current visitors
//$result = $db->query('SELECT COUNT(user_id) FROM '.$db->prefix.'online') or error('Unable to fetch online count', __FILE__, __LINE__, $db->error());
$num_online = 0;

I'm not sure, even if there's no visitor there, you should be able to retrieve it. Are all tables there? Chech if there's any kind of problem with the (prefix)online table.

I use netfirms.com as a webhost..  I do not have root access to the mysql server, which is version 3.23.55
I'm new to the whole PHP & mySQL development stuff..   I use phpmyadmin to administer my dbases..   I'll temporarily try MarcB's bypass..

::Edit::
MarcB's bypass did not work.   

It's an interesting problem..

thanks for the advice.  I'll try that..  see if they can do it..   knowing corporate america, I'll not hold my breath though.

Is there anyway to work around that issue temporarily?

would calling the database connection function *or whatever it's called*  before getting the online count help out?

Since MySQL 3.23.37 works fine, you could be right and it might be OS dependant (or OS-configuration dependant).
You can try asking them to upgrade the DB, or upgrade the OS... I guess that would make the decision easier...

You shouldn't receive that error message if you did what MarcB suggested. Did you really put // in front of the row like he suggested?

... I thought I hit a wall...  but I may have gotten around it...

I reported one of my messages...   and clicked on the link it put under my name...

thanks for the help...  hopefully my webhost pulls it's head out of it's arse and upgrades...

yup...

Only admin_index.php

Everything else seems to be working fine now..  except for that..

*update*

I've updated from 1.1.2 to 1.1.3..  same error..

1.1.3 to 1.1.4 same thing.

I haven't yet tried the work around above..  I will when I get a chance.

BreCalmor: First, we need to figure out why there is a connection issue in that code. It's very odd.

Hi

I also have this problem (running 1.2.10) on netfirms. ^^ From my experience they have very bad support but I will also contact them.

No one found a fix then?

Update: I contacted Netfirms in request of an upgrade. (This isn't the first time i've requested something though...)

farooq - in all honesty I already have ditched Netfirms - but for the use of Wordpress (mod_rewrite not availiable on netfirms!) and now this...I still have the account on there, but I'm slowly edging my other sites away .