Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

wishlist problem


Recommended Posts



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




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



any ideas appreciated







Mark A Reynolds

Link to comment
Share on other sites

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


((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...

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...