Wishlist 2.0

[michael_s]

open "wishlist_public.php"

find:

$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_status, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $wishlist_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");
$products = tep_db_fetch_array($products_query);




replace eith:

$products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_status, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ( " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $wishlist_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");
$products = tep_db_fetch_array($products_query);

More...

[TheGringe]

Have these changes been included in RC4?
I'm getting the following error when trying to add a product to the wishlist:

1054 - Unknown column 'products_name' in 'order clause'

select * from customers_wishlist where customers_id = '' order by products_name limit 0, 12

[TEP STOP]

My Wish List contains:

I've done some reading around, and noticed there are some suggest code changes to the sql query thats generated by a few of the php modules, but the "what to replace" does not match so I am guessing some changes have already been applied.
EDIT: I also checked with a customer logged in and it still generates the above error, but the sql does contain a customer id.
thanks
Gringe