How to make new products show first on categories and sub categories...HELP!

[amandavz]

Hi Linda...I recently installed some modules to my site and it messed up my sort order. Anyway, I went back and did what you say in the post above and I get this 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 'order by p.products_date_added DESC, p.products_sort_order, pd.products_name' at line 7
in:

When I visit the front end of my store. Any idea why i might be getting that? Thanks.

BTW: When I remove the code in red it goes away.

[frank18]

Hi Linda...I recently installed some modules to my site and it messed up my sort order. Anyway, I went back and did what you say in the post above and I get this 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 'order by p.products_date_added DESC, p.products_sort_order, pd.products_name' at line 7
in:

When I visit the front end of my store. Any idea why i might be getting that? Thanks.

BTW: When I remove the code in red it goes away.

Please post the block of code as modified by you (file includes/index_filters/default_filter.php)

[amandavz]

and add the code in RED:

// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER is left blank
// for reverse, descending order use:
// $listing_sql .= " order by p.products_sort_order desc, pd.products_name";
// $listing_sql .= " order by p.products_sort_order, pd.products_name";
$listing_sql .= " order by p.products_date_added DESC, p.products_sort_order, pd.products_name";
break;

[frank18]

What else does the error message say after this

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 'order by p.products_date_added DESC, p.products_sort_order, pd.products_name' at line 7
in:

in: what???

[amandavz]

Sorry...here is the whole 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 'order by p.products_date_added DESC, p.products_sort_order, pd.products_name' at line 7
in:
[select m.manufacturers_name, 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 = '5' and p2c.categories_id = '195' order by p.products_sort_order, pd.products_name order by p.products_date_added DESC, p.products_sort_order, pd.products_name]

Does it help to know that i just installed CEON Uri? It may have something to do with the products now being named link instead of code.

[gilby]

order by p.products_sort_order, pd.products_name order by p.products_date_added DESC, p.products_sort_order, pd.products_name]

It appears you didn't comment out the original "order by" details as you have it in twice.

So your post 7 code probably looks like this

// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER is left blank
// for reverse, descending order use:
// $listing_sql .= " order by p.products_sort_order desc, pd.products_name";
$listing_sql .= " order by p.products_sort_order, pd.products_name";
$listing_sql .= " order by p.products_date_added DESC, p.products_sort_order, pd.products_name";
   break;

[frank18]

It appears you didn't comment out the original "order by" details as you have it in twice.

So your post 7 code probably looks like this

// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER is left blank
// for reverse, descending order use:
// $listing_sql .= " order by p.products_sort_order desc, pd.products_name";
$listing_sql .= " order by p.products_sort_order, pd.products_name";
$listing_sql .= " order by p.products_date_added DESC, p.products_sort_order, pd.products_name";
   break;

Post #2:

Then set the Sort Order in the Configuration ... Product Listing ... to blank for:

[amandavz]

I'm not sure I understand...

here is what I added: $listing_sql .= " order by p.products_date_added DESC, p.products_sort_order, pd.products_name";
according to Linda's instructions in the above post and when I go to my store front end I get the error I posted in the last post.

[amandavz]

Hey...what do you know...that worked. Thanks for your time. :)