Urgent help required.. Website all blank after editing configure.php to add SSL

[hamid84]

Hi,

Don't know why but all of sudden my website has gone down since morning and only showing blank page.

I was trying to make changes in both configure.php file to enable ssl. That's all

I have also restored these files from previous back up but no luck. My hosting company has been very useful and provided the following error.

PHP Fatal error: Call to a member function Execute() on a non-object in public_html/includes/classes/currencies.php on line 31

I have replaced currencies.php but no luck.

My website is here

Urgent help is required please.

Thanks

[hamid84]

I purchased static ip address for ssl... Could this be issue?

I have asked host company to change my ip address...

[Ajeh]

You might try a search on that error such as on:
Call to a member function Execute()

this post comes up for me that may be helpful ...
http://www.zen-cart.com/forum/showth...+Execute%28%29

[hamid84]

I have gone through so many posts but no luck.

Need quick fix

[DrByte]

There's a handy FAQ article which provides a utility to help you find out what exact errors are occurring on your site. I found it by simply searching the FAQs area for "blank page": https://www.zen-cart.com/tutorials/index.php?article=82

The debug logs that the mentioned utility will generate are likely going to point you to an error which this additional FAQ article will help you sort out: https://www.zen-cart.com/tutorials/index.php?article=87

[hamid84]

Dr Byte,

This is what im getting from debug error logging

[22-Mar-2010 23:56:00] PHP Fatal error: Call to a member function Execute() on a non-object in /home/softhand/public_html/includes/classes/currencies.php on line 31

I am just lost

[hamid84]

This is my currencies.php

 
<?php
/**
 * currencies Class.
 *
 * @package classes
 * @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: currencies.php 3041 2006-02-15 21:56:45Z wilt $
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}
/**
 * currencies Class.
 * Class to handle currencies
 *
 * @package classes
 */
class currencies extends base {
  var $currencies;
  // class constructor
  function currencies() {
    global $db;
    $this->currencies = array();
    $currencies_query = "select code, title, symbol_left, symbol_right, decimal_point,
                                  thousands_point, decimal_places, value
                          from " . TABLE_CURRENCIES;
    $currencies = $db->Execute($currencies_query);
    while (!$currencies->EOF) {
      $this->currencies[$currencies->fields['code']] = array('title' => $currencies->fields['title'],
      'symbol_left' => $currencies->fields['symbol_left'],
      'symbol_right' => $currencies->fields['symbol_right'],
      'decimal_point' => $currencies->fields['decimal_point'],
      'thousands_point' => $currencies->fields['thousands_point'],
      'decimal_places' => $currencies->fields['decimal_places'],
      'value' => $currencies->fields['value']);
      $currencies->MoveNext();
    }
  }
...

[DrByte]

The $db->Execute is the statement that's triggering the error.
That can only be caused if the $db variable isn't properly initialized as a database object.
And, since $db is the database object that drives *everything* in Zen Cart, it doesn't make sense that it wouldn't be set unless you had something broken before it *could* be set.
That means backtracing everything all the way back to the first line of code, and stepping your way through everything one line at a time until you find what exactly is broken.
That'll take you months if you're not used to doing it and don't have the tools to make the process even thinkable.

Instead, I recommend you undo whatever changes you made just before the problem started happening, including any edits to your configure.php files or whatever.
And if undoing that stuff doesn't completely solve the problem, then the next logical step is to find out which files are broken by comparing everything on your server against your last known good backup from when the site was working just fine. You can use a tool like WInMerge for the actual file comparisons once you have all the files on your PC. Related article: http://www.zen-cart.com/wiki/index.p...Obscure_Issues

[hamid84]

My hosting company has been looking into this and suggested that if it all fails, fresh installation would be only option.

I am very much happy with new installation provided i do not lose anything. My main concerns are customers, orders, products.. That's all.

I don't want add ons because i can upload them again.

I have backed up whole database from phpmyadmin just to be on very safe side.

Now after reinstallation, would it be just fine to restore the database and have everything up and running?

Thanks

[DrByte]

That all depends on what the real problem is.
Blindly restoring from backup could be a huge waste of time and create unnecessary risk of data loss (ie: all orders placed SINCE that backup was made).

I think your issue is PHP-based, and not database-based, hence the recommendation to verify the contents of all your PHP files by comparing them all against your known good backups.