WishList v0.4 -- v1.3.7 compatible

[novastar]

I dropped the tables zen_zen_un_wishlists and zen_zen_un_products_to_wishlists in phpmyadmin and reran the sql file. This time zen_un_wishlists and zen_un_products_to_wishlists were created. So I thought it would be working but it's not. I turned on the sidebox in the admin but it doesn't show up on my shop. And in my admin > Extras > Wishlists, I still get the following error. Please help.

1146 Table 'dealbyet_zc4.un_wishlists' doesn't exist
in:
[SELECT w.id, w.customers_id, w.created, w.modified, w.name, w.comment, w.default_status, w.public_status, count(p.products_id) as items_count, c.customers_email_address, c.customers_firstname, c.customers_lastname FROM un_wishlists w LEFT JOIN un_products_to_wishlists p2w ON w.id=p2w.un_wishlists_id LEFT JOIN zen_products p ON p2w.products_id=p.products_id LEFT JOIN zen_customers c ON w.customers_id=c.customers_id GROUP BY w.id ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

deal by ethan how did you solve this problem

[balihr]

Hey Manojlo, did you manage to solve this issue?

Pozdrav

[MrSpiffy]

Okay, I fixed a problem with the compact view on version .05 in firefox.

If your compact view table has a big gap in it under the table heading and before the product listing, do the following.

edit

./includes/templates/template_default/un_wishlist/tpl_un_wishlist_s.php


and move the hidden inputs out of the table.

So look for this:

<!-- product listing -->
<table border="0" cellspacing="0" class="productlist">

        <tr class="heading">

        <?php echo $oWishlist->getTableHeader(); ?>
        </tr>

<?php
if ($listing_split->number_of_rows > 0) {
        $rows = 0;
        $products = $db->Execute($listing_split->sql_query);
        while (!$products->EOF) {
                if ( $rows & 1 ) {
                        $tdclass = 'even';
                } else {
                        $tdclass = 'odd';
                }
?>

        <tr>
<input type="hidden" name="products_id[]" value="<?php echo $products->fields['products_id']; ?>" />
<input type="hidden" name="wishlist_quantity[]" value="<?php echo $products->fields['quantity']; ?>" />
<input type="hidden" name="comment[]" value="<?php echo $products->fields['comment']; ?>" />

        <?php echo $oWishlist->getTableRow($tdclass, $products); ?>

        </tr>
                <?php $rows++; ?>
                <?php $products->MoveNext(); ?>
        <?php } // end while products ?>

<?php } else { ?>
        <tr><td colspan="99"><?php echo UN_TEXT_NO_PRODUCTS; ?></td></tr>

<?php } ?>
</table>
<!-- end product listing -->

and set it like this:

<!-- product listing -->
<table border="0" cellspacing="0" class="productlist">

        <tr class="heading">

        <?php echo $oWishlist->getTableHeader(); ?>
        </tr>

<?php
if ($listing_split->number_of_rows > 0) {
        $rows = 0;
        $products = $db->Execute($listing_split->sql_query);
        while (!$products->EOF) {
                if ( $rows & 1 ) {
                        $tdclass = 'even';
                } else {
                        $tdclass = 'odd';
                }
?>

        <tr>

        <?php echo $oWishlist->getTableRow($tdclass, $products); ?>

        </tr>
                <?php $rows++; ?>
                <?php $products->MoveNext(); ?>
        <?php } // end while products ?>

<?php } else { ?>
        <tr><td colspan="99"><?php echo UN_TEXT_NO_PRODUCTS; ?></td></tr>

<?php } ?>
</table>
<input type="hidden" name="products_id[]" value="<?php echo $products->fields['products_id']; ?>" />
<input type="hidden" name="wishlist_quantity[]" value="<?php echo $products->fields['quantity']; ?>" />
<input type="hidden" name="comment[]" value="<?php echo $products->fields['comment']; ?>" />
<!-- end product listing -->

[MrSpiffy]

deal by ethan how did you solve this problem

edit the table names in /Admin/includes/extra_datafiles/un_database_tables.php in include the table prefix. In my case it was "zen_".

[MrSpiffy]

edit the table names in /Admin/includes/extra_datafiles/un_database_tables.php in include the table prefix. In my case it was "zen_".

You're also going to need to do the same thing to ./includes/extra_datafiles/un_database_tables.php

[kappy1]

The problem I am having with wish list is if a product is out of stock add to cart button does not appear, which is correct, but the add to wish list still appears and the item can be added to the wish list then the customer can go to their wish list and add to product to the cart even if it is not in stock.

[MrSpiffy]

The problem I am having with wish list is if a product is out of stock add to cart button does not appear, which is correct, but the add to wish list still appears and the item can be added to the wish list then the customer can go to their wish list and add to product to the cart even if it is not in stock.

Does this happen if the items are disabled?

The quick solution then is to have your items disabled when they reach 0 qty. Config -> Stock -> Product status...

[kappy1]

Works ok if I disable but I also use the addon back to stock so it defeats the purpose of this addon. I have a number of customers that use the back to stock so my only alternative is to put wish list on the back burner until I or someone can figure out a fix...

[motoccnl]

Would it be possible to make a guest wish list, just like the zen cart shopping cart? So that the guest don't need to login for the use of the default wish list.

I've been looking around and tried to change the $_session['customers_id'] to a variable witch is $_session['customers_id'] when logged in, and zenid when not logged in. That didn't brake anything, but it didn't add anything either.

Is there somebody how can help me or point me in the right direction.