-
Wishlist Not Working
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
-
Re: Wishlist Not Working
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
-
Re: Wishlist Not Working
Before attempting anything under your SQL Patches page, make a backup of your mySQL Database first - for security issues.
-
Re: Wishlist Not Working
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:
PHP 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.
-
Re: Wishlist Not Working
-
Re: Wishlist Not Working
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!
-
Re: Wishlist Not Working
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
-
Re: Wishlist Not Working
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.
-
Re: Wishlist Not Working
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.
-
Re: Wishlist Not Working