Wishlist

[jar3300]

SBP,
I started over from scratch and this is what I get when I click on wish lists under "extras".
1146 Table 'rustic_zc1.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.

I feel like I'm out in the weeds.
Thanks
Jim

[SnuggleBerryPie]

Jim - take it easy, it looks like an easy fix :)

Although I *thought* I had triple-checked my instructions before posting, it looks like I missed another piece of information (sorry about that!).

You need to also add the DB_PREFIX to your admin un_database_tables.php file:
- in /admin/includes/extra_datafiles/un_database_tables.php, prefix the table names with DB_PREFIX so that it ends up looking like the following:

<?php

// Wishlist
define('UN_TABLE_WISHLISTS', DB_PREFIX . 'un_wishlists');
define('UN_TABLE_PRODUCTS_TO_WISHLISTS', DB_PREFIX . 'un_products_to_wishlists');

?>

[jar3300]

SNB,
Okay. Now I get the wish list, but there are errors at the top and nothing shows up next to the item for a customer to start a wish list. You can see this at http://www.rusticranchfurniture.com. Here's the error.

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/rustic/public_html/cart/rrf_74admin84/includes/extra_datafiles/un_database_tables.php:7) in /home/rustic/public_html/cart/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/rustic/public_html/cart/rrf_74admin84/includes/extra_datafiles/un_database_tables.php:7) in /home/rustic/public_html/cart/rrf_74admin84/includes/init_includes/init_templates.php on line 36

BTW, I've not seen whether using the renamed admin folder affects any of this.

Thanks,
Jim

[nagelkruid]

I don't have a button to be able to edit my original post (since it was only my 2nd post on the forum) but it looks like I have incorrect information there. You do not need to modify the tpl_product_info_display.php file as it is already doing the check correctly. Instead, just edit /includes/templates/template_default/un_wishlist_find/tpl_un_wishlist_find_default.php

Find:

<li class="price"><?php echo TEXT_BASE_PRICE . $products_price; ?></li>

Replace with:

<li class="price"><?php echo ((zen_has_product_attributes_values((int)$products->fields['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . $products_price; ?></li>

Sorry for the confusion. I copied the checking code from the tpl_product_info_display.php file and must have confused the two files when I posted the instructions.

thanks for posting your fixes Snuggle, i have replaced this line in the file but it still shows starting at while it shouldn't.
crazy, i am clueless why...

[SnuggleBerryPie]

Jim, my admin folder is renamed so that shouldn't be the problem.

Regarding seeing the WishList in the page details, I noticed that you are using a custom/modified template for your page (with an 'Ask us about this item' button). Since this is the case, modify your custom tpl_product_info_display.php file to include the following code wherever you want the wishlist button to appear

<!--bof Wishlist button -->
<div id="productWishlistLink" class="buttonRow back"><?php 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_submit(UN_BUTTON_IMAGE_WISHLIST_ADD, UN_BUTTON_WISHLIST_ADD_ALT) . '</a>'); ?></div>
<!--eof Wishlist button -->

Alternatively, you can enable the Wish List sidebox through the admin (but I guess your admin doesn't look too happy at the moment).

Regarding the admin, my suggestion is to check for any typos (or incorrect quotes) in the un_database_tables.php file. The only change should have been to add DB_PREFIX . before the current filename. As a temporary test, you could even put in the exact database name instead e.g. define('UN_TABLE_WISHLISTS', 'zen_un_wishlists'); and see if that made any difference.

Side Issue - I created a user on your site so that I could confirm that the wishlist wasn't being shown when logged in. When I submitted the page, it came back with a message about having to enter a state so I did that and re-submitted and ended up at a blank page. I clicked back twice and found that I was logged in.

[SnuggleBerryPie]

nagelkruid - Hmm... perhaps you have a custom template or an additional file that needs to be modified. My suggestion is to do a search to see whether there are any other files that contain TEXT_BASE_PRICE. If so, check each one to ensure that it has something like (various conditions) ? TEXT_BASE_PRICE : '' around it rather than just TEXT_BASE_PRICE on it's own. Alternatively, I've found in the past that when I have used the "My Network Places" option for connecting to my server and copying files back and forth from my PC, that the web server hasn't recognised them as being modified so still serves the cached version. If I then open the same file on the server (eg using the 'Edit Code' option from the 'File Manager' through cPanel) and save it again, it all works fine. Rather odd but perhaps the files need to be "touched".

[nagelkruid]

thanks for posting your fixes Snuggle, i have replaced this line in the file but it still shows starting at while it shouldn't.
crazy, i am clueless why...

think i figured it out, in your previous posts, where you said to edit /includes/templates/template_default/templates/tpl_product_info_display.php incorrectly, i think you may wanted to refer to the file
includes\templates\template_default\un_wishlist\tpl_un_wishlist_default.php

[SnuggleBerryPie]

ooohh You are correct! Good find! So the corrected information should be...

'Starting At' Text
The supplied pages are hard-coded to show the "Starting At" prefix to the price regardless of whether it is needed. To fix this:
- in /includes/templates/template_default/un_wishlist/tpl_unwishlist_default.php search for TEXT_BASE_PRICE
- replace the entire line with the following:

<li class="price"><?php echo ((zen_has_product_attributes_values((int)$products->fields['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . $products_price; ?></li>

- repeat for /includes/templates/template_default/un_wishlist_find/tpl_un_wishlist_find_default.php

[jar3300]

Regarding the admin, my suggestion is to check for any typos (or incorrect quotes) in the un_database_tables.php file. The only change should have been to add DB_PREFIX . before the current filename. As a temporary test, you could even put in the exact database name instead e.g. define('UN_TABLE_WISHLISTS', 'zen_un_wishlists'); and see if that made any difference.

Side Issue - I created a user on your site so that I could confirm that the wishlist wasn't being shown when logged in. When I submitted the page, it came back with a message about having to enter a state so I did that and re-submitted and ended up at a blank page. I clicked back twice and found that I was logged in.[/QUOTE]

I used WinMerge and looked at both the current file and both lines of code in this thread and they are identical. It appears that this is good if it is working for you and others so the error is coming from somewhere else???
<?php

// Wishlist
define('UN_TABLE_WISHLISTS', DB_PREFIX . 'un_wishlists');
define('UN_TABLE_PRODUCTS_TO_WISHLISTS', DB_PREFIX . 'un_products_to_wishlists');

?>

Thanks for the sidebar, I'll look into that as well.
Jim

[SnuggleBerryPie]

Jim, my suggestion would be to first get the wish list button added to your product info page (and/or activate the sidebox) so that you can create a wish list in case the error is being caused by a message being echoed (for example) when the page is being created but there are no entries in the wish list tables.

nagelkruid - are you able to access your Wishlist admin page (under Extras -> Wishlists) or do you also get an error similar to Jim's?

Actually, I have one more suggestion... do you have the Admin Profiles mod installed? If so, go to Tools -> Admin Settings and click the P next to your admin user and ensure that both "un wishlist" and "un wishlists" are both ticked in the bottom section of the page before clicking "Save Changes".