DOOL Posted September 8, 2010 Posted September 8, 2010 I am having a weird error with this contribution, but only on once certain scenerio. The contribution is working great, its sorting the products and displaying them accordingly with no problems at all. The problem occurs only when displaying page 2+ of products. Meaning for instance I have 24 products under one catagory. The max value to display is 15 per page. So the first page of products is displaying great, all in order and life is good, but when you click on page 2 to see the rest of the products I am getting this error message: 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 'p.products_sort_order , pd.products_name asc' at line 1 select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c 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 = '21'p.products_sort_order , pd.products_name asc [TEP STOP] Now the instructions for the contrib stated: To implement this mod, follow the instructions in this text file. You will need to make the following database changes (using phpmyadmin or similar tool) ALTER TABLE products ADD products_sort_order INT( 4 ) DEFAULT '0' NOT NULL; INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('', 'PRODUCT_LIST_SORT_ORDER', '6', '', '0', '', now()); Could anybody please guide me on how to repair this issue. Please understand I am a newb and know very little about coding, but i follow instructons very well. Thanks in advance DOOL
Recommended Posts
Archived
This topic is now archived and is closed to further replies.