lorax Posted January 6, 2005 Share Posted January 6, 2005 Contrib: http://www.oscommerce.com/community/contributions,2541 Installed and working for the 1st page of any product listing within the catalog. As soon as I click to view the next page, the sorting falls to pieces. Click << previous and the 1st page no longer sorts correctly. Quote Apathy is a dominant gene - mutate. Link to comment Share on other sites More sharing options...
lorax Posted January 6, 2005 Author Share Posted January 6, 2005 Ah ha. Locate at about line 205 in catalog/index.php case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); and change to case 'PRODUCT_LIST_NAME': $listing_sql .= "p.products_sort_order, pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); Quote Apathy is a dominant gene - mutate. Link to comment Share on other sites More sharing options...
Simmy Posted January 7, 2005 Share Posted January 7, 2005 The contribution has been updated with this fix! My humble appologies for this bug, don't be put off though, it is an excellent contribution :D B Quote Link to comment Share on other sites More sharing options...
gwolz Posted January 8, 2005 Share Posted January 8, 2005 Hi I installed the contrib. but it does not run without error. I have this error if I open a product (in the area where the select options normaly are) 1146 - Table 'testshop.TABLE_PRODUCTS_STOCK' doesn't exist select products_stock_quantity from TABLE_PRODUCTS_STOCK where products_id = '2' AND products_stock_attributes REGEXP '(^|,)3-6(,|$)' AND products_stock_quantity > 0 I looked for any wrong thinks I made but I did not find any. What can I do? Quote Link to comment Share on other sites More sharing options...
Simmy Posted January 8, 2005 Share Posted January 8, 2005 Table products stock is not a default osc table and it's not from my contribution so it must be from another contribution! If the error says the table doesn't exist then it probably doesn't exist. Have you just installed another contri too???? Quote Link to comment Share on other sites More sharing options...
gwolz Posted January 8, 2005 Share Posted January 8, 2005 Sorry I wrote in the wrong list!!! Quote Link to comment Share on other sites More sharing options...
sheepiedog Posted July 28, 2005 Share Posted July 28, 2005 I must be missing something. It installed without errors. everything looks right, I put numbers in to sort the products, but it just doesnt change the order of the products in my store.....any ideas ? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.