product filter module addon

[dropbop]

The solution is to (probably) remove the "zs_" prefix on the table "zs_products_attributes" in the SQL statement. If you know how to view your SQL tables, view them and look for the correct table name. My tables do not have a "zs_" prefix, but your tables may have another prefix.

Go to:
"includes/modules/pages/product_filter_result/header_php.php"

Change the line:
<code>$where_str .= " AND ((pa.products_id In (SELECT pa.products_id FROM zs_products_attributes pa WHERE ("; </code>

To:
<code>$where_str .= " AND ((pa.products_id In (SELECT pa.products_id FROM products_attributes pa WHERE ("; </code>

OR change it to the product_attribute table name in your system.

Hope it works and you understand what I'm talking about...

Perfect - cheers for that, Worked perfectly!

Such a simple thing to miss.

And for people who installed Zen using fantastico.. you may have to change the table prefix to 'zen_' as fantastico can add it automaticly to your tables.

To find out what the table prefix is.. open cpanel

http://www.yourdomain.com/cpanel

scroll down to phpMyAdmin and click it.

Find the database your zencart is using.

you will see at the start of each table a prefex ie: 'zen_'


copy the prefix and change the prefix in the header_php.php supplied with this addon

Find this line

$where_str .= " AND ((pa.products_id In (SELECT pa.products_id FROM zs_products_attributes pa WHERE (";

and change zs_products_attributes to zen_products_attributes (or what ever your database prefix is)


Hope this is of some help....

DB