Possible Bug

[bkpie]

When using quick search and mulitple products come up you are given the option to sort by model ,price or product name. 2 work but price does not and you get the error below. Can someone else test this to see if bug? I am using customer groups for Seperate Price per customer and the only contribution added was Call for Price. Problem exists when logged in and prices show.

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 'left join products_group_prices_cg_1 as tmp_pp using(products_id), products_desc' at line 1

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), left join products_group_prices_cg_1 as tmp_pp using(products_id), products_description pd, categories c, products_to_categories p2c 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 ((pd.products_name like '%turtle%' or p.products_model like '%turtle%' or m.manufacturers_name like '%turtle%' or pd.products_description like '%turtle%') )

[TEP STOP]

[jpf]

Can you produce this error on a STOCK (non-moded) OSCMAX install?

IF NOT: Check what you edited.... You missed something in a SQL statement some where...

Happy New Year!!!

[bkpie]

Got same error on fresh install. Maybe I did something on install?

[timbrrr]

I get this same error on my shop as well. Good catch bkpie - I think this is worthy of submitting as a bug

[bkpie]

Thank you timbrrr I tried finding the problem with no luck yet. Not sure about submitting as a bug , I have never done that and want to make sure its not something I am doing. If anyone else wants to test this let me know.
2 so far if we get 3 I would say we have a problem.