1064 You have an error in your SQL syntax when using product list Price Sort

[missesbeehaven]

When I view any category of my store and click on the price link to sort the items by price I get this error:


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 7
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '316' order by ]


What is needed to correct this?

The forum posts I have found regarding this error have been about emails from the admin module of zen cart or initial installation of zen cart. My store seems to be functioning okay besides this error when I try to sort product lists by price.

[bunyip]

a link to your site would be helpful

[missesbeehaven]

Opps yes that would help so sorry

it is www.missesbeehaven.com/shop/

[bunyip]

It looks to me like you have a problem in the file includes/index_filters/default_filter.php

Have you edited that file at all? If not, try uploading a fresh copy from your install package.

If you do have a modified copy of that file, please attach it as a zip file here and I'll take a look at it for you.

For info - it's not just the price sort that has the problem - it also happens with product name sort. I'm thinking that there's a whole section of code missing from that filter file.

[missesbeehaven]

Thanks for the info.

I had a few weeks ago added the product filter mod, maybe that is why?

This is the mod link
https://www.zen-cart.com/forum/showt...107#post752107

I would be most appreciative if you could look at this for me, I really want to get rid of this horrible error

[missesbeehaven]

PS.. So glad I came across your mod shop, I have sent you an email from your site link that you have in your signature

[missesbeehaven]

Thanks heaps that fixed it