WishList v0.4 -- v1.3.7 compatible

I checked my sql database and trendsde_zc2 does exist!

james739:

... I am getting the same error:

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

How can I create a trendsde_zc2 table?

This error is of format DATABASE.TABLE.

First, mysql is saying it's looking for a database named "trendsde_zc2". Do you have a database named "trendsde_zc2"?

Second, mysql is saying it's looking for a table named "un_wishlists". Do you have a table named "un_wishlists"?

I'm guessing the error stems from step number 1 in the readme entitled "Create tables". It reads:

Create tables 'un_wishlists' and 'un_products_to_wishlists' using 'un_wishlist.sql'. Important: If in your implementation of ZenCart you defined a database table prefix (see file "includes/configure.php", line 52), add that prefix to the table names in the sql file ("un_wishlist.sql", lines 9, 10, 28 and 29).

ok, the DB prefix on line 52 is Zen_. I placed this prefix in front of line 9 (zen_un_wishlists), line 10 (zen_un_wishlists), line 28 (zen_un_products_to_wishlists) and line 29 (zen_un_products_to_wishlists).

trendsde_zc2 exists in mysql, there is table named un_wishlists in database_tables.php.

I am still getting the same error when I click on Add to wishlist on the products page.

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

untitled:

Sounds like you want a "form button", as is used in the sidebox. That would require a little more effort. I'd recommend simply "styling" the link as desired. For example:

> 
> Notice I added some CSS to the <a> element via the "style" attribute. You can use inline style definitions like this or external style sheets to control the appearance of any link. You might want to check out the following site for more info: <http://www.w3schools.com/css/css_intro.asp>
> 
> Another option is to create an image. Replace "UN_TEXT_ADD_WISHLIST" with your image tag and you have complete control over the appearance of the "link".

good,Your very good example ah helpful! :clap:

james739:

ok, the DB prefix on line 52 is Zen_. I placed this prefix in front of line 9 (zen_un_wishlists), line 10 (zen_un_wishlists), line 28 (zen_un_products_to_wishlists) and line 29 (zen_un_products_to_wishlists).

trendsde_zc2 exists in mysql, there is table named un_wishlists in database_tables.php.

I am still getting the same error when I click on Add to wishlist on the products page.

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

do you realize that just changing those lines is not enough -- you must actually use the altered sql file to recreate the tables afterwards? what version of the contribution are you using? if it's not the newest, i'd recommend you start from scratch. delete the old tables. download the newest version. then go through all the steps again.

nb: is your implementation of mysql case-sensitive? your message mixes cases...

Hi untitled, i finally got the mod to work! I forgot to change the db prefix in the includes/data_field sections!

Thanks again for your help

How can I edit my product info page so that the "wishlist" button is aligned with tell a "friend button?"

My other question is:
In my wishlist in extended view, the images are way too large, how can I make the images smaller?

my site:

http://trendsdepot.com/index.php?main_page=product_info&cPath=1_2_7&products_id=1

ok, i fixed it by playing with product_info display. I still need help making the images in wishlist product list smaller.

Thanks!

untitled: I have tried different ways on replacing a link with an image tag and I keep getting an error. Here is what I have:

Can you please let me know what I did wrong. I am not a programmer and this is driving me nuts.

Thanks.

I'm sure I'll be yelled at for this but I followed the installation instructions but like the problem someone else was having , when I click the add to wishlist button I get an error

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

I have no clue where or how to fix this. Can someone please help a pathetic noob?

Just a quick note:

I have posted a question regarding this contrib here:
http://www.zen-cart.com/forum/showthread.php?t=72234

It has given birth to a new contrib.

StampsVille

We have installed the WishList and it is running without issue EXCEPT for one thing. It seems that when someone adds their products from the wishlist they do not actually get their downloads. (Our store is full of downloadable products only). We think it may have something to do with the product attribute but are not sure how to test it or fix it.

If the customer adds the product manually all products are received as downloads.

Anyone have any ideas?

Thanks

Rick

I have added the wishlist module and for some reason, when I click add to wishlist, it takes you to the wishlist, but doesn't add the item. Here is a link: www.tehome.net To try it out, use login:[email protected] and password: demo.

Oops, sorry the password is demo1

How would I go about creating new database tables? Do I just import the .sql file into my zen database and it will create them for me? Please forgive my ignorance.

Thanks in advance

Okay, sorry, nevermind. I fixed the problem by re-installing all the wishlist files.

Nevermind my post too! I just exported one of my other database tables and then saw what I had to do, Thanks anyway :)

gabenn2:

How would I go about creating new database tables? Do I just import the .sql file into my zen database and it will create them for me? Please forgive my ignorance.

Thanks in advance

Go to your admin, under tools click on "install sql patch". Then under browse, find the sql file on your computer and select it. Then click upload.

See thread http://www.zen-cart.com/forum/showthread.php?t=44607&highlight=wishlist+patch

Now that I have figured out the databases this mod functions perfectly :) :clap:

I am trying to get an image to show up rather than a text link for my wishlist on the product page. I have changed the code to

<?php 
// (un): start wishlist link
echo '<a href="' . zen_href_link(UN_FILENAME_WISHLIST, zen_get_all_get_params(array('action', 'products_id')) . 'products_id='.(int)$_GET['products_id'].'&action=un_add_wishlist') . '">' . zen_image_button(BUTTON_IMAGE_ADD_WISHLIST, BUTTON_ADD_WISHLIST_ALT) . '</a>'; 
// (un): end wishlist link
?>

and added an image named button_add_wishlist.gif to my cart. The image isn't showing up only the alt text is. Any ideas?

Thanks in advance :)

***Nevermind, I figured it out.

For anyone else who may need this, the file is includes/languages/english/button_names.php***

Hi!

I've seen how I can add an "add to wishlist" button to a product page template, but my client wants an "add selected products to wishlist" button on the category listing page. Then the customer would be able to go down the list of products, type in quantities and add to wishlist all at once, like they'd be able to add multiple products at once to the cart.

Is that possible?

thanks!
tray :blink: