crash3903 Posted October 8, 2003 Share Posted October 8, 2003 Morning I have installed the wishlist into the new package of osCommerce. When I go to the products that i want to view it does not show up the button to add to wishlist? when i go to the checkout it shows the wishlist link so when i go to view my wish list it throws up this error in ...catalog/wishlist.php 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 'select * from customers_wishlist WHERE customers_id=2 order by select count(select * from customers_wishlist WHERE customers_id=2 order by products_name) as total [TEP STOP] This is the sql that is included with the contribution CREATE TABLE customers_wishlist ( products_id int(13) NOT NULL default '0', customers_id int(13) NOT NULL default '0', products_model varchar(13) default NULL, products_name varchar(64) NOT NULL default '', products_price decimal(8,2) NOT NULL default '0.00', final_price decimal(8,2) NOT NULL default '0.00', products_quantity int(2) NOT NULL default '0', wishlist_name varchar(64) default NULL ) TYPE=MyISAM; any ideas appreciated thanks mark Quote Regards Mark A Reynolds Link to comment Share on other sites More sharing options...
Lena Posted October 8, 2003 Share Posted October 8, 2003 HI! welcome as another one working on the wishlist-contrib! you can have a look here: http://www.oscommerce.com/forums/index.php?showtopic=50005 obviously wishlist is for ms1 and not for ms2. Seems to me that the errormessage you mention will disappear when you change that splitPageResults-call like mentioned. But don't forget to define define('MAX_DISPLAY_WISHLIST_PRODUCTS', 1); ((or maybe something else than 1)) because otherwise the next errormessage will be 'division by zero'... I'm never through with the whole thing, but hope that this might help you... Quote Link to comment Share on other sites More sharing options...
Lena Posted October 8, 2003 Share Posted October 8, 2003 sorry, what i wrote will refer to the sql-error (which you will see when you say 'view wishlist') but not to the button which will not appear these are 2 different topics but both rooted in the differences ms1 to ms2 (correct me if i'm wrong) 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.