SQL Error

[Butta]

Recently installed the latest version of Zen Cart on the following setup:

FreeBSD 6.1
PHP 5.1.2
MySQL 5.1.2

Install went as expected, but the product page shows nothing but a SQL error:

1054 - Unknown column 'p.products_id' in 'on clause'

I did a little research on the web and found this thread regarding the same error in osCommerce:

http//www.oscommerce.com/community/bugs,3171/category,Installation+&+Configuration

where I learned about the new, stricter JOIN syntax. I then made the following changes to includes/modules/meta_tags.php :

> diff -Nu meta_tags.php.old meta_tags.php
--- meta_tags.php.old   Mon Jun 12 03:19:12 2006
+++ meta_tags.php       Mon Jun 12 03:17:59 2006
@@ -161,7 +161,7 @@
                                       p.products_id, p.metatags_price_status, p.metatags_title_tagline_status,
                                       pd.products_description,
                                       mtpd.metatags_title, mtpd.metatags_keywords, mtpd.metatags_description
-                              from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " mtpd on mtpd.products_id = p.products_id and mtpd.language_id = '" . (int)$_SESSION['languages_id'] . "'
+                              from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . " mtpd on mtpd.products_id = p.products_id and mtpd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                               where p.products_id = '" . (int)$_GET['products_id'] . "'
                               and p.products_id = pd.products_id
                               and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";

And the product page now displays correctly without the error. I assume this JOIN syntax bug exists elsewhere in the code base and will show itself in MySQL 5 installations. However, my Zen Cart experience has lasted about 30 minutes thus far.

[DrByte]

Thanks for the feedback.

I'm not sure where you got your "latest" code for Zen Cart, because the suggestion you posted was fixed in the v1.3.0 release. In the code you'll notice it starting on line 180.

You are looking at v1.2.7 code. A number of MySQL5-compatibility fixes were implemented in v1.3.x. The latest version can be obtained by clicking the "Get Zen Cart" link at the top of this page.

[Butta]

Ahhh... the Zen Cart project on FreshMeat needs to be updated.