Wishlist Not Working

Hello,

I added a wishlist to https://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

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

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

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.

This link should help:

http://www.zen-cart.com/forum/showthread.php?t=35842&highlight=wishlist

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!

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

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.

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.

Wishlist files in thread below
http://www.zen-cart.com/forum/showthread.php?t=26709&highlight=wishlist

Hi I had this exact same problem and I kept using the Install SQL patches from my admin section. So Instead I went to the cpanel of my hosting account, then to phpMyAdmin and imported it from there and VOILA! It worked and now I don't get the "1146 Table 'MYDATABASENAME.un_wishlists' doesn't exist" error anymore. And my wishlist works. Hope this helps someone else out. Thanks for all the great tips and advice in these forums. I am a TOTAL newbie and have found so much help here. Thanks again!!!!

God Bless,
Crystal