Confirmed bugs and workarounds in v1.3.5

[DrByte]

Following is a list of reported bugs and their workarounds for v1.3.5.

A patch will be released in about a week including these fixes.

[DrByte]

On local Windows PC, using 09032006.zip

Logged into admin
Footer shows "PROJECT_VERSION_NAME vPROJECT_VERSION_MAJOR.PROJECT_VERSION_MINOR/v1.3.5"

Tools > Server/Version Info shows:
PROJECT_VERSION_NAME PROJECT_VERSION_MAJOR.PROJECT_VERSION_MINOR
Patch: PROJECT_VERSION_PATCH1:ROJECT_VERSION_PATCH1_SOU RCE
Patch: PROJECT_VERSION_PATCH2:ROJECT_VERSION_PATCH2_SOU RCE
Database Patch Level: 1.3.5
v1.3.5 [2006-09-04 07:25:57] (Fresh Installation)

SOLUTION:
Obtain the 09042006.zip or newer and re-install.

[DrByte]

Problem:

Fatal error: main(): Failed opening required '../includes/classes/db/DB_TYPE/query_factory.php' (include_path='.;c:\php4\pear') in d:\usr\www\html\zen\zc_install\includes\modules\pages\database_upgrade\header_ph p.php on line 53

SOLUTION:
Obtain the 09042006.zip or newer and re-install.
Upgrader was deleting the configure.php due to mistakenly assuming it was doing fresh install.
Updated zip fixes it.

[DrByte]

Problem:

Fatal error: Cannot instantiate non-existent class: phpbb in /home/username/public_html/store/includes/autoload_func.php on line 79

Solution:
From the release announcements and the whatsnew docs:

phpBB file rename. The file /includes/classes/class.phpBB.php was renamed to lowercase for consistency across webserver platforms. If you fail to rename yours during the upgrade, you will encounter error messages saying that the file cannot be found.

[DrByte]

Problem while updating currencies:

Fatal error: Call to undefined function curl_init() in ....\admin\includes\functions\localization.php on line 71

SOLUTION:
Obtain the 09042006.zip or newer and re-install.

[DrByte]

Problem -- affecting UPGRADERS ONLY

Warning: constant(): Couldn't find constant in myroot/includes/init_includes/init_add_crumbs.php on line 45
1064 You have an error in your SQL syntax near 'from where manufacturers_id = 0' at line 2
in:
[select from where manufacturers_id = 0]

SOLUTION:
Apply the following SQL to your database using SQLPatch or phpMyAdmin:

#
# Updating table `get_terms_to_filter`
#
ALTER TABLE get_terms_to_filter ADD get_term_table varchar(64) NOT NULL;
ALTER TABLE get_terms_to_filter ADD get_term_name_field varchar(64) NOT NULL;
UPDATE get_terms_to_filter SET get_term_table = 'TABLE_MANUFACTURERS', get_term_name_field = 'manufacturers_name' where get_term_name = 'manufacturers_id';
UPDATE get_terms_to_filter SET get_term_table = 'TABLE_MUSIC_GENRE', get_term_name_field = 'music_genre_name' where get_term_name = 'music_genre_id';
UPDATE get_terms_to_filter SET get_term_table = 'TABLE_RECORD_COMPANY', get_term_name_field = 'record_company_name' where get_term_name = 'record_company_id';

[DrByte]

Problem:
Unable to send SMTP mail using v1.3.5

Solution: (upgrading to v1.3.6 is the BETTER fix !! )
/includes/functions/functions_email.php
line 137
change from

        if (EMAIL_SMTPAUTH_MAIL_PORT != '25' & EMAIL_SMTPAUTH_MAIL_PORT != '') $mail->Port = EMAIL_SMTPAUTH_MAIL_PORT;

to:

        if (EMAIL_SMTPAUTH_MAIL_SERVER_PORT != '25' && EMAIL_SMTPAUTH_MAIL_SERVER_PORT != '') $mail->Port = EMAIL_SMTPAUTH_MAIL_SERVER_PORT;

[Ajeh]

PROBLEM: New Products show ALL products regardless of settings

This happens in all places where New Products are addressed ...

SOLUTION: Edit the file:
/includes/functions/functions_lookups.php

Down near the bottom change the whole function for zen_get_new_date_range

NOTE: NEW CODE 9-10-2006
Change the code to read:

// build date range for new products
  function zen_get_new_date_range($time_limit = false) {
    if ($time_limit == false) {
      $time_limit = SHOW_NEW_PRODUCTS_LIMIT;
    }

    // 120 days; 24 hours; 60 mins; 60secs
    $date_range = time() - ($time_limit * 24 * 60 * 60);
// echo 'Now:      '. date('Y-m-d') ."<br />";
// echo $time_limit . ' Days: '. date('Ymd', $date_range) ."<br />";
    $zc_new_date = date('Ymd', $date_range);
    switch (true) {
    case (SHOW_NEW_PRODUCTS_LIMIT == 0):
      $new_range = '';
      break;
    case (SHOW_NEW_PRODUCTS_LIMIT == 1):
      $zc_new_date = date('Ym', time()) . '01';
      $new_range = ' and p.products_date_added >=' . $zc_new_date;
      break;
    default:
      $new_range = ' and p.products_date_added >=' . $zc_new_date;
    }
    return $new_range;
  } 

Don't even ask how that got left in there ... it was late ... the coffee ran out ... the candle was flickering ...

WARNING: When fixing this function ... there is another function below that for:

// build date range for upcoming products
  function zen_get_upcoming_date_range() { 

Do NOT delete that function ... ONLY replace the function zen_get_new_date_range with the new code ...

[Ajeh]

PROBLEM: Banners are displaying when set to status 0 when multiple Banner Groups are used in a single Banner Position

SOLUTION: Edit the file:
/includes/functions/banner.php

Change line 229 from:

      $new_banner_search = ' and ' . $new_banner_search; 

To read:

      $new_banner_search = ' and (' . $new_banner_search . ')'; 

[Ajeh]

PROBLEM: Downloads when expired in the Customers ... ... Orders ... does not prevent the customer from obtaining the download when changing the Download status via the green/yellow icon on a per Download basis

Both Max days and Download Count are adjust, and this conflicts with unlimited

SOLUTION: Edit the file:
/admin/orders.php

Change line 52 from:

          $update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays='0', download_count='0' where orders_id='" . $_GET['oID'] . "' and orders_products_download_id='" . $_GET['download_reset_off'] . "'"; 

To read:

          $update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_count='0' where orders_id='" . $_GET['oID'] . "' and orders_products_download_id='" . $_GET['download_reset_off'] . "'"; 

Now only the download count is adjust and not the max days ...