php warning and SQL syntax error [1.3.5]

[helmetman]

Whenever I try to view the products by manufacturers ("index.php?main_page=index&manufacturers_id=X") I get the following:

Warning: constant() [function.constant]: Couldn't find constant in <MY_STORE>/includes/init_includes/init_add_crumbs.php on line 45
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from where manufacturers_id = 1' at line 2
in:
[select from where manufacturers_id = 1]

Lines 35 through 48 of that file:

/**
 * split to add manufacturers_name to the display
 */
if (isset($_GET['manufacturers_id'])) {
  $manufacturers_query = "select manufacturers_name
                            from " . TABLE_MANUFACTURERS . "
                            where manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "'";

  $manufacturers = $db->Execute($manufacturers_query);

  if ($manufacturers->RecordCount() > 0) {
    $breadcrumb->add($manufacturers->fields['manufacturers_name'], zen_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $_GET['manufacturers_id']));
  }
} 

Heres is some info about my server and stuff.

Database: MySQL 5.0.18-standard-log

HTTP Server: Apache/2.0.54 (Unix) PHP/4.4.2 mod_ssl/2.0.54 OpenSSL/0.9.7e mod_fastcgi/2.4.2 DAV/2 SVN/1.1.4

PHP Version: 5.1.2 (Zend: 2.1.0)

Zen Cart 1.3.5
Database Patch Level: 1.3.5

Ask if you need more. I really want to fix this problem.

[helmetman]

Until a fix is found I'm just going to change the query to

$sql = "select manufacturers_name
                from zen_manufacturers
                where manufacturers_name =  " . (int)$_GET[$get_terms->fields['get_term_name']]; 

Also, the advanced search does not work.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10
in:
[select count(distinct p.products_id) as total FROM zen_products p LEFT JOIN zen_manufacturers m USING(manufacturers_id), zen_products_description pd, zen_categories c, zen_products_to_categories p2c LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND m.manufacturers_id = 2]

[a_berezin]

Also, the advanced search does not work.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10
in:
[select count(distinct p.products_id) as total FROM zen_products p LEFT JOIN zen_manufacturers m USING(manufacturers_id), zen_products_description pd, zen_categories c, zen_products_to_categories p2c LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND m.manufacturers_id = 2]

split_page_results class error

[helmetman]

split_page_results class error

This did not work.

[Ajeh]

You might wish to look at the bug fixes for v1.3.5 that are posted on this bugfix thread:

http://www.zen-cart.com/forum/showthread.php?t=45377