WebBasser Posted December 20, 2008 Share Posted December 20, 2008 (edited) Hello Everyone, I am trying to install the contrib 6429 in which you can define the 'Product Listing Order", and I am really close to having it ready to go. However, I am receiving an SQL error. I have the changes made to the files, have the products order working, and I can also change the listing order with no problem. However, on the publis side, when I attempt to go to the second page of product listings, I am receiving 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 '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 = '29'p.products_sort_order , pd.products_name asc [TEP STOP] Can someone tell me what this could be, and how to fix it? Thanks in advance - GREAT CONTRIB from the OSC Community - exactly what I was looking for! In friendship and peace, Erich, aka WebBasser Edited December 20, 2008 by WebBasser Quote "When one door closes another door opens; but we do often look so long and so regretfully upon the closed door, that we do not see the ones which open for us." ~~~ Alexander Graham Bell, inventor Link to comment Share on other sites More sharing options...
rescuestat Posted December 20, 2008 Share Posted December 20, 2008 Hello Everyone,I am trying to install the contrib 6429 in which you can define the 'Product Listing Order", and I am really close to having it ready to go. However, I am receiving an SQL error. I have the changes made to the files, have the products order working, and I can also change the listing order with no problem. However, on the publis side, when I attempt to go to the second page of product listings, I am receiving 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 '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 = '29'p.products_sort_order , pd.products_name asc [TEP STOP] Looks as though you missed the ORDER BY, try ... p2c.categories_id = '29' ORDER BY p.products_sort_order, pd.products_name asc Frank Can someone tell me what this could be, and how to fix it? Thanks in advance - GREAT CONTRIB from the OSC Community - exactly what I was looking for! In friendship and peace, Erich, aka WebBasser Quote Link to comment Share on other sites More sharing options...
WebBasser Posted December 20, 2008 Author Share Posted December 20, 2008 Hi Frank, Is this something that I can fix in the database via MySQL, or will I need to re-install the original database and run the correct SQL query? Thanks for the quick reply, Erich Quote "When one door closes another door opens; but we do often look so long and so regretfully upon the closed door, that we do not see the ones which open for us." ~~~ Alexander Graham Bell, inventor Link to comment Share on other sites More sharing options...
New 
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.