WishList v0.4 -- v1.3.7 compatible

[james739]

I checked my sql database and trendsde_zc2 does exist!

[untitled]

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

[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 ]

[jordan9527]

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:

<?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') . '" style="background:#ccc; padding: 5px;">' . UN_TEXT_ADD_WISHLIST . '</a>'; 
// (un): end wishlist link
?>

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!

[untitled]

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

[james739]

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

[james739]

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?mai...&products_id=1

[james739]

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

Thanks!

[Linux]

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:

<?php
// (un): start wishlist link
echo '<a href="' . zen_href_link(UN_FILENAME_WISHLIST, 'products_id=' . YOUR_PRODUCTS_ID . '&action=un_add_wishlist') . '">' . zen_image_button(BUTTON_IMAGE_WISHLIST, BUTTON_WISHLIST_ALT) . '</a>' : ''); ?></div>
<?php
// (un): end wishlist link
?>

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

Thanks.

[Chris10]

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?