Fatal Error with the Counter.php

Fatal error: Call to a member function Execute() on a non-object in /home/.ambale/whiskeyb/dicksgeneral.com/includes/counter.php on line 23

$date_now = date('Ymd');
$counter_query = "select startdate, counter, session_counter from " . TABLE_COUNTER_HISTORY . " where startdate='" . $date_now . "'";
[b]LINE 23 ---->[/b] $counter = $db->Execute($counter_query); [b]<---- LINE 23[/b]
if ($counter->RecordCount() <= 0) {
  $date_now = date('Ymd');
  $sql = "insert into " . TABLE_COUNTER_HISTORY . " (startdate, counter, session_counter) values ('" . $date_now . "', '1', '1')";
  $db->Execute($sql);
  $counter_startdate = $date_now;
  $counter_now = 1;
} else {
  $counter_startdate = $counter->fields['startdate'];
  $counter_now = ($counter->fields['counter'] + 1);
  $session_counter_now = ($counter->fields['session_counter'] + $session_counter);
  $sql = "update " . TABLE_COUNTER_HISTORY . " set counter = '" . $counter_now . "', session_counter ='" . $session_counter_now . "' where startdate='" . $date_now . "'";
  $db->Execute($sql);
}

How do I fix this error?

Much Thanks!

Which version of PHP?

PHP v5.1.2

Ok
Does this error occurs only for counter?
Are all other pages working fine?
San

As far as I know, everything else works fine.

I just applied the new security update (which doens't touch the coutner.php file) and when I went to load the page to see if there way anything I need to fix and I got hit with the error.

can you post the complete counter.php file here?

<?php
/**
 * counter.php
 *
 * @package general
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: counter.php 3194 2006-03-15 23:17:53Z wilt $
 * @private
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}
if (isset($_SESSION['session_counter']) && $_SESSION['session_counter'] == true) {
  $session_counter = 0;
} else {
  $session_counter = 1;
  $_SESSION['session_counter'] = true;
}
$date_now = date('Ymd');
$counter_query = "select startdate, counter, session_counter from " . TABLE_COUNTER_HISTORY . " where startdate='" . $date_now . "'";
$counter = $db->Execute($counter_query);
if ($counter->RecordCount() <= 0) {
  $date_now = date('Ymd');
  $sql = "insert into " . TABLE_COUNTER_HISTORY . " (startdate, counter, session_counter) values ('" . $date_now . "', '1', '1')";
  $db->Execute($sql);
  $counter_startdate = $date_now;
  $counter_now = 1;
} else {
  $counter_startdate = $counter->fields['startdate'];
  $counter_now = ($counter->fields['counter'] + 1);
  $session_counter_now = ($counter->fields['session_counter'] + $session_counter);
  $sql = "update " . TABLE_COUNTER_HISTORY . " set counter = '" . $counter_now . "', session_counter ='" . $session_counter_now . "' where startdate='" . $date_now . "'";
  $db->Execute($sql);
}

$counter_query = "select startdate, counter from " . TABLE_COUNTER;
$counter = $db->Execute($counter_query);
if ($counter->RecordCount() <= 0) {
  $date_now = date('Ymd');
  $sql = "insert into " . TABLE_COUNTER . " (startdate, counter) values ('" . $date_now . "', '1')";
  $db->Execute($sql);
  $counter_startdate = $date_now;
  $counter_now = 1;
} else {
  $counter_startdate = $counter->fields['startdate'];
  $counter_now = ($counter->fields['counter'] + 1);
  $sql = "update " . TABLE_COUNTER . " set counter = '" . $counter_now . "'";
  $db->Execute($sql);
}

$counter_startdate_formatted = strftime(DATE_FORMAT_LONG, mktime(0, 0, 0, substr($counter_startdate, 4, 2), substr($counter_startdate, -2), substr($counter_startdate, 0, 4)));
?>

File looks fine
Somehow $db is not getting initialised!

Lovely.

I've dropped a line to my hosting company. I'll post an update if they reply.

Tig:

Lovely.

I've dropped a line to my hosting company. I'll post an update if they reply.

It seems that some problem happened while doing the upgrade
Who did the upgrade?
Can you show me the steps?

I followed the steps detailed in this thread.

I think I did everything right. I even double-checked before I saved.

Same problem for me - applied the patch, then Fatal Error. Everywhere!

I had to restore the old files - a chance i have to take - too late in the evening to start debugging... I'll keep an eye on the thread and hopefully The Answer will be forthcoming!

Thanks,
Cosmo

when you edited application_top.php ... did you INSERT the new line, or replace the existing line?
The instructions are to add the new line.

I expect it should look like this (at least mine does and eliminated the error):

$autoLoadConfig = array();  // Security addition 8-2006
include($base_dir . $loader_file);
if ($loader_dir = dir(DIR_WS_INCLUDES . 'auto_loaders')) {
  while ($loader_file = $loader_dir->read()) {
    if ((preg_match('/^config\./', $loader_file) > 0) && (preg_match('/\.php$/', $loader_file) > 0)) {
      if ($loader_file != 'config.core.php') {
        $base_dir = DIR_WS_INCLUDES . 'auto_loaders/';
        if (file_exists(DIR_WS_INCLUDES . 'auto_loaders/overrides/' . $loader_file)) {
          $base_dir = DIR_WS_INCLUDES . 'auto_loaders/overrides/';
        }

Ah ha!

I'm just this side of an idiot. I placed it below where it was supposed to go and forgot the ';'.

Yeesh. I've got to stop doing updates when I'm half asleep.

Thanks guys!

Glad to hear that you got it resolved! :)

Just upgraded to 1.36 from 1.35 and have the same error message. My server is still using PHP version 4.4.3, however. What can I do to get the site working again?

What EXACTLY did you do to perform the upgrade?
What contributions and customizations are installed on your site?
It seems like you've missed a file or have customizations that are conflicting with normal flow of activating the database subsystem.