Wishlist Not Working

[Xerxes3333]

Hello,

I added a wishlist to www.mudpuddlz.com and whenever someone clicks it. It gives the following error:

1146 Table 'zencart.un_wishlists' doesn't exist
in:
[SELECT id FROM un_wishlists w WHERE w.customers_id=4 and w.default_status=1 ]

In the readme for the wishlist it says to create tables using un_wishlist.sql. How would you go about doing that? Thank you

[TinaS]

Go to your admin area Tools/Install SQL Patches - browse to the file included with the mod for the SQL and import it.

hope that helps

[TheOracle]

Before attempting anything under your SQL Patches page, make a backup of your mySQL Database first - for security issues.

[Xerxes3333]

Alright. I did that, so that is fixed. Thank you. Now, I am having a different problem. I am supposed to change the application_top.php file by finding a peice of code and inserting code after it, however when I look at the php file. There is not anything in there about a wishlist yet. The readme says that I am supposed to find this code:

    // remove item from the wishlist
///// CHANGES TO case 'remove_wishlist' BY DREAMSCAPE /////
      case 'remove_wishlist' :
                             $db->Execute("delete from " . TABLE_WISHLIST . " where products_id = '" . $HTTP_GET_VARS['pid'] . "' and customers_id = '" . $_SESSION['customer_id'] . "'");
                            zen_redirect(zen_href_link(FILENAME_WISHLIST));
                             break; 

but the code is not there.

[yoniyum]

This link should help:

http://www.zen-cart.com/forum/showth...light=wishlist

[yoniyum]

I am having the same problem. I keep getting the message:

1146 Table 'MYDATABASENAME.un_wishlists' doesn't exist
in:
[SELECT id FROM un_wishlists w WHERE w.customers_id=1 and w.default_status=1 ]



I have reinstalled the SQL patch through Admin a few times and this hasn't fixed the problem.

Please help!

[jacopo3001]

sorry i am completely new to ZC, even i know OSC quite well.
could you kindly tell me where to downalod the wishlist contribution from?
i cant find it anywhere
thanks

[yoniyum]

Hey, there is a link at the top of this page called "Downloads" and that's where you can find the modules. Good luck getting it to work.

[jacopo3001]

well , i saw the download page of course, but i dont know which category is the wishlist module under.
also it seems there is no any search tool for the modules.
i find it quite hard to get oriented.

[misty]

Wishlist files in thread below
http://www.zen-cart.com/forum/showth...light=wishlist