Zen Lightbox addon [Support Thread]

Hi,

I gave it a go a still the same error 1146.

MyPhP Admin is the area where the databases are located..like if your server has C-Panel for access to your databases...myphpadmin is the actual place you insert the sql code into. I forget others may not have this in their controls.

IS this the "Tools/Install SQL Patches area" in my zencart admin?

Dreamhost is my host.

Thanks for your help
Andrew

try this one then: and remember to uninstall the sql qith the uninstaller too to get rid of unwanted ones

/**
 * Zen Lightbox
 *
 * @author Alex Clarke ([email protected])
 * @copyright Copyright 2003-2005 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: install.sql 2008-12-17 aclarke $
 */

INSERT INTO `zc1_configuration_group` VALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1');
UPDATE `zc1_configuration_group` SET `sort_order` = LAST_INSERT_ID() WHERE `configuration_group_id` = LAST_INSERT_ID();

SELECT @cgi := `configuration_group_id` FROM `configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';

INSERT INTO `zc1_configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES
(NULL, '<b>Zen Lightbox</b>', 'ZEN_LIGHTBOX_STATUS', 'true', '<br />If true, all product images on the following pages will be displayed within a lightbox:<br /><br />- document_general_info<br />- document_product_info<br />- page (EZ-Pages)<br />- product_free_shipping_info<br />- product_info<br />- product_music_info<br />- product_reviews<br />- product_reviews_info<br />- product_reviews_write<br /><br /><b>Default: true</b>', @cgi, 100, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, 'Overlay Opacity', 'ZEN_LIGHTBOX_OVERLAY_OPACITY', '0.8', '<br />Controls the transparency of the overlay.<br /><br /><b>Default: 0.8</b>', @cgi, 101, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''0'', ''0.1'', ''0.2'', ''0.3'', ''0.4'', ''0.5'', ''0.6'', ''0.7'', ''0.8'', ''0.9'', ''1''), '),
(NULL, 'Overlay Fade Duration', 'ZEN_LIGHTBOX_OVERLAY_FADE_DURATION', '400', '<br />Controls the fade duration of the overlay.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi, 102, NOW(), NOW(), NULL, NULL),
(NULL, 'Resize Duration', 'ZEN_LIGHTBOX_RESIZE_DURATION', '400', '<br />Controls the speed of the image resizing.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi, 103, NOW(), NOW(), NULL, NULL),
(NULL, 'Resize Transition', 'ZEN_LIGHTBOX_RESIZE_TRANSITION', 'false', '<br />Allows for custom control over the transition effect used to animate the lightbox.<br /><br /><b>Default: false</b><br />', @cgi, 104, NOW(), NOW(), NULL, NULL),
(NULL, 'Initial Width', 'ZEN_LIGHTBOX_INITIAL_WIDTH', '250', '<br />If Enable Resize Animations is set to true, the lightbox will resize its width from this value to the current image width, when first displayed.<br /><br />Note: This value is measured in pixels.<br /><br /><b>Default: 250</b><br />', @cgi, 105, NOW(), NOW(), NULL, NULL),
(NULL, 'Initial Height', 'ZEN_LIGHTBOX_INITIAL_HEIGHT', '250', '<br />If Enable Resize Animations is set to true, the lightbox will resize its height from this value to the current image height, when first displayed.<br /><br />Note: This value is measured in pixels.<br /><br /><b>Default: 250</b><br />', @cgi, 106, NOW(), NOW(), NULL, NULL),
(NULL, 'Image Fade Duration', 'ZEN_LIGHTBOX_IMAGE_FADE_DURATION', '400', '<br />Controls the fade duration of images.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi, 107, NOW(), NOW(), NULL, NULL),
(NULL, 'Caption Animation Duration', 'ZEN_LIGHTBOX_CAPTION_ANIMATION_DURATION', '400', '<br />Controls the animation duration of the caption.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi, 108, NOW(), NOW(), NULL, NULL),
(NULL, 'Display Image Counter', 'ZEN_LIGHTBOX_COUNTER', 'true', '<br />If true, the image counter will be displayed (below the caption of each image) within the lightbox.<br /><br /><b>Default: true</b>', @cgi, 109, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
(NULL, 'Close on Image Click', 'ZEN_LIGHTBOX_CLOSE_IMAGE', 'false', '<br />If true, the lightbox will close when the image being displaying is clicked.<br /><br /><b>Default: false</b>', @cgi, 110, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, 'Close on Overlay Click', 'ZEN_LIGHTBOX_CLOSE_OVERLAY', 'false', '<br />If true, the lightbox will close when the overlay is clicked.<br /><br /><b>Default: false</b>', @cgi, 111, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, '<b>Keyboard Navigation</b>', 'ZEN_LIGHTBOX_KEYBOARD_NAVIGATION', 'true', '<br />If true, keyboard inputs will also be used to control the lightbox.<br /><br /><b>Default: true</b>', @cgi, 200, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, 'Close Lightbox', 'ZEN_LIGHTBOX_ESCAPE_KEYS', '27,88,67', '<br />The lightbox will close when any of these keys are pressed.<br /><br />Note: Only <a href="http://en.wikipedia.org/wiki/ASCII" target="_blank">ASCII</a> decimal values should be entered and separated with a comma (if listing multiple values).<br /><br /><b>Default: 27,88,67</b><br />', @cgi, 201, NOW(), NOW(), NULL, NULL),
(NULL, 'Previous Image', 'ZEN_LIGHTBOX_PREVIOUS_KEYS', '37,80', '<br />The lightbox will display the previous image (if available) when any of these keys are pressed.<br /><br />Note: Only <a href="http://en.wikipedia.org/wiki/ASCII" target="_blank">ASCII</a> decimal values should be entered and separated with a comma (if listing multiple values).<br /><br /><b>Default: 37,80</b><br />', @cgi, 202, NOW(), NOW(), NULL, NULL),
(NULL, 'Next Image', 'ZEN_LIGHTBOX_NEXT_KEYS', '39,78', '<br />The lightbox will display the next image (if available) when any of these keys are pressed.<br /><br />Note: Only <a href="http://en.wikipedia.org/wiki/ASCII" target="_blank">ASCII</a> decimal values should be entered and separated with a comma (if listing multiple values).<br /><br /><b>Default: 39,78</b><br />', @cgi, 203, NOW(), NOW(), NULL, NULL),
(NULL, '<b>Gallery Mode</b>', 'ZEN_LIGHTBOX_GALLERY_MODE', 'true', '<br />If true, the lightbox will allow additional images to quickly be displayed using previous and next buttons.<br /><br /><b>Default: true</b>', @cgi, 300, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
(NULL, 'Include Main Image in Gallery', 'ZEN_LIGHTBOX_GALLERY_MAIN_IMAGE', 'true', '<br />If true, the main product image will be included in the lightbox gallery.<br /><br /><b>Default: true</b>', @cgi, 301, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
(NULL, '<b>EZ-Pages Support</b>', 'ZEN_LIGHTBOX_EZPAGES', 'true', '<br />If true, the lightbox effect will be used for linked images on all EZ-Pages.<br /><br /><b>Default: true</b>', @cgi, 400, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
(NULL, 'File Types', 'ZEN_LIGHTBOX_FILE_TYPES', 'jpg,png,gif', '<br />On EZ-Pages, the lightbox effect will be applied to all images with one of the following file types.<br /><br /><b>Default: jpg,png,gif</b><br />', @cgi, 401, NOW(), NOW(), NULL, NULL);

DarkAngel:

try this one then: and remember to uninstall the sql qith the uninstaller too to get rid of unwanted ones

I'm Sorry Dark Angel, I Don't know how to uninstall the SQL code.:cry::(:no:

I don't know if it is the light box code or the time offset code however i can't list anything. I can't create new categories or anything.

ADE Cyber Emporium:

I'm Sorry Dark Angel, I Don't know how to uninstall the SQL code.:cry::(:no:

I don't know if it is the light box code or the time offset code however i can't list anything. I can't create new categories or anything.

in the zip you opened to get the lightbox fiels to upload is the uninstall.sql

just copy-paste it into the sql part of your database...click go and that will remove the table info

then do the sql again for the lightbox that i inserted in my post above and keep our fingers crossed.

have you been able to do anything in your store since you created it?

OK, Thank you.

Yes i have done some stuff in the site.
Turned some products off, made some new products.
I also changed the background and logo.

Thanks for your time.:blush:

Sorry to say, NO Luck!

this is all i got.

1146 Table 'shopperzencart.configuration_group' doesn't exist
in:
[SELECT @cgi := configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Zen Lightbox';]
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'll have to reload the backup of my site and start again.
I'll let you know how i went later this arvo.

Thank
Andrew

alright cause there seems to be something wrong if you have suddenly started with not being able to do things, that was why I was asking if it was recent that it happened or previous.

keep us posted

Hello,

Does anyone know how to fix this Lightbox problem?

When the product image is clicked the browser moves to a new page which is white, with just the image on it. No lightbox?

I've put a link to the example page here

Thanks in advance.

Treasuresbycaz:

Hello,

Does anyone know how to fix this Lightbox problem?

When the product image is clicked the browser moves to a new page which is white, with just the image on it. No lightbox?

I've put a link to the example page here

Thanks in advance.

Have you gone into admin section/configuration and set the preferences for this?

Have you made sure you got all the files uploaded to the right spot?

Tried just reuploding the files and overwriting the ones on the server?

Hello,

I have one layout issue that I believe is related to the Zen lightbox mod. I thought I installed Zen lightbox successfully. All images were showing up beautifully with the mod. It was when I needed to fix the layout of tpl_products_review_default.php that I came across an unwanted text link that displays the product name and is hyperlinked to the enlarged image using the lightbox mod. I have attached a .jpg of this problem. It sits on the bottom left corner of the product image.

I've tried copying the original tpl_products_review_default.php from the default template, but really this was useless because this problem was already there before I even started tweaking this page. I've tried deleting everything else on tpl_products_review_default.php except for the image to determine which part of the page this extra text link is coming from, and it's definitely linked to the product image somehow. This is the only page that this problem shows up in. All the other product image pages are perfect.

When I view the source code of the page, this section is written as follows:

.
.
.

<div id="productReviewsDefaultProductImage" class="centeredContent back"> <div id="productMainImage" class="centeredContent back"> <script language="javascript" type="text/javascript"><!-- document.write('<a href="images/large/carmen_designerhandbag_palema_LRG.jpg" rel="lightbox-g" title="Carmen<br /><span class=\"smallText\">[Carmen]</span>"><img src="images/medium/carmen_designerhandbag_palema_MED.jpg" alt="Carmen [Carmen]" title=" Carmen [Carmen] " width="230" height="210" /><br /><span class="imgLink">larger image</span></a>'); //--></script> <noscript> <a href="http://wickedmango.com.au/palema/index.php?main_page=popup_image&pID=51" target="_blank"><img src="images/medium/carmen_designerhandbag_palema_MED.jpg" alt="Carmen [Carmen]" title=" Carmen [Carmen] " width="230" height="210" /><br /><span class="imgLink">larger image</span></a></noscript> </div> <div class="buttonRow"> <a href="http://wickedmango.com.au/palema/index.php?main_page=product_reviews&products_id=51&action=buy_now"><img src="includes/templates/palema/buttons/english/button_in_cart.gif" alt="Add To Shopping My Bag" title=" Add To Shopping My Bag " width="178" height="30" /></a><br /></div> </div> . . .

I thought that there was a closing html tag omitted after title="Carmen ... (in red) so I looked at tpl_modules_main_product_image.php, but I really can't see anything out of place. The source code of tpl_modules_main_product_image.php is:

<?php /** * Module Template * * @package templateSystem * @copyright Copyright 2003-2005 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * @version $Id: tpl_modules_main_product_image.php 3208 2006-03-19 16:48:57Z birdbrain $ */ ?> <?php require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_MAIN_PRODUCT_IMAGE)); ?> <div id="productMainImage" class="centeredContent back"> <?php // bof Zen Lightbox 2008-12-15 aclarke ?> <?php if (ZEN_LIGHTBOX_STATUS == 'true') { if (ZEN_LIGHTBOX_GALLERY_MODE == 'true' && ZEN_LIGHTBOX_GALLERY_MAIN_IMAGE == 'true') { $rel = 'lightbox-g'; } else { $rel = 'lightbox'; } ?> <script language="javascript" type="text/javascript"><!-- document.write('<?php echo '<a href="' . zen_lightbox($products_image_large, addslashes($products_name), LARGE_IMAGE_WIDTH, LARGE_IMAGE_HEIGHT) . '" rel="' . $rel . '" title="' . addslashes($products_name) . '">' . zen_image($products_image_medium, addslashes($products_name), MEDIUM_IMAGE_WIDTH, MEDIUM_IMAGE_HEIGHT) . '<br /><span class="imgLink">' . TEXT_CLICK_TO_ENLARGE . '</span></a>'; ?>'); //--></script> <?php } else { ?> <?php // eof Zen Lightbox 2008-12-15 aclarke ?> <script language="javascript" type="text/javascript"><!-- document.write('<?php echo '<a href="javascript: popupWindow(\\\'' . zen_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $_GET['products_id']) . '\\\')">' . zen_image($products_image_medium, addslashes($products_name), MEDIUM_IMAGE_WIDTH, MEDIUM_IMAGE_HEIGHT) . '<br /><span class="imgLink">' . TEXT_CLICK_TO_ENLARGE . '</span></a>'; ?>'); //--></script> <?php // bof Zen Lightbox 2008-12-15 aclarke ?> <?php } ?> <?php // eof Zen Lightbox 2008-12-15 aclarke ?> <noscript> <?php echo '<a href="' . zen_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $_GET['products_id']) . '" target="_blank">' . zen_image($products_image_medium, $products_name, MEDIUM_IMAGE_WIDTH, MEDIUM_IMAGE_HEIGHT) . '<br /><span class="imgLink">' . TEXT_CLICK_TO_ENLARGE . '</span></a>'; ?> </noscript> </div>

(NB. I've added an extra space between : and p in the javascript call above to prevent the smily from appearing in this post)

I'm using Zencart v1.38a. Other addons that were previously installed include: About Us Page, Column Divider Pro, Column Layout Grid, CSS Menu, Flash Hacks, Newsletter Subscribe, Time Zone Offset and RFQ.

I'm sure it's something really simple but for the life of me I can't see it and it's slowly driving me insane. :wacko: Can anyone help me?

Sorry, I forgot to add the php code for tpl_product_reviews_default.php

<?php
/**
 * Page Template
 *
 * @package templateSystem
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: tpl_product_reviews_default.php 4852 2006-10-28 06:47:45Z drbyte $
 */
?>
<div class="centerColumn" id="reviewsDefault">

<div id="productReviewsDefaultProductImage" class="centeredContent back">
<?php
  if (zen_not_null($products_image)) {
  /**
   * require the image display code
   */
?>
<?php require($template->get_template_dir('/tpl_modules_main_product_image.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_main_product_image.php'); ?>
<?php
  }
?>
<!--bof Add to Cart Box -->
<div class="buttonRow">
<?php
        // more info in place of buy now
        if (zen_has_product_attributes($review->fields['products_id'] )) {
          //   $link = '<p>' . '<a href="' . zen_href_link(zen_get_info_page($review->fields['products_id']), 'products_id=' . $review->fields['products_id'] ) . '">' . MORE_INFO_TEXT . '</a>' . '</p>';
          $link = '';
        } else {
          $link= '<a href="' . zen_href_link($_GET['main_page'], zen_get_all_get_params(array('action', 'reviews_id')) . 'action=buy_now') . '">' . zen_image_button(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT) . '</a>';
        }
        $the_button = $link;
        $products_link = '';
        echo zen_get_buy_now_button($review->fields['products_id'], $the_button, $products_link) . '<br />' . zen_get_products_quantity_min_units_display($review->fields['products_id']);
      ?>
</div>
<!--eof Add to Cart Box -->

</div>



<!-- bof align right column-->
<div id="productReviewsRightColumn">

<h3 id="productReviewsDefaultHeading"><?php echo $products_name . $products_model; ?></h3>

<h2 id="productReviewsDefaultPrice" class=""><?php echo $products_price; ?></h2>
<div id="productReviewsDefaultProductPageLink" class="buttonRow"><?php echo '<a href="' . zen_href_link(zen_get_info_page($_GET['products_id']), zen_get_all_get_params(array('reviews_id'))) . '">' . zen_image_button(BUTTON_IMAGE_GOTO_PROD_DETAILS , BUTTON_GOTO_PROD_DETAILS_ALT) . '</a>'; ?></div>

<div class="buttonRow"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, zen_get_all_get_params(array('reviews_id'))) . '">' . zen_image_button(BUTTON_IMAGE_WRITE_REVIEW, BUTTON_WRITE_REVIEW_ALT) . '</a>'; ?></div>
</div>

<!-- eof align right column-->

<br class="clearBoth" />

<?php
  if ($reviews_split->number_of_rows > 0) {
    if ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3')) {
?>

<div id="productReviewsDefaultListingTopNumber" class="navSplitPagesResult"><?php echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS); ?></div>

<div id="productReviewsDefaultListingTopLinks" class="navSplitPagesLinks"><?php echo TEXT_RESULT_PAGE . ' ' . $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, zen_get_all_get_params(array('page', 'info', 'main_page'))); ?></div>

<?php
    }
    foreach ($reviewsArray as $reviews) {
?>
<hr />

<div class="buttonRow forward"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . (int)$_GET['products_id'] . '&reviews_id=' . $reviews['id']) . '">' . zen_image_button(BUTTON_IMAGE_READ_REVIEWS , BUTTON_READ_REVIEWS_ALT) . '</a>'; ?></div>

<div class="productReviewsDefaultReviewer bold"><?php echo sprintf(TEXT_REVIEW_DATE_ADDED, zen_date_short($reviews['dateAdded'])); ?> <?php echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($reviews['customersName'])); ?></div>

<div class="rating"><?php echo zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $reviews['reviewsRating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviewsRating'])), sprintf(TEXT_OF_5_STARS, $reviews['reviewsRating']); ?></div>

<div class="productReviewsDefaultProductMainContent content"><?php echo zen_break_string(zen_output_string_protected(stripslashes($reviews['reviewsText'])), 60, '-<br />') . ((strlen($reviews['reviewsText']) >= 100) ? '...' : ''); ?></div>


<br class="clearBoth" />
<?php
    }
?>
<?php
  } else {
?>
<hr />
<div id="productReviewsDefaultNoReviews" class="content"><?php echo TEXT_NO_REVIEWS . (REVIEWS_APPROVAL == '1' ? '<br />' . TEXT_APPROVAL_REQUIRED: ''); ?></div>
<br class="clearBoth" />
<?php
  }

  if (($reviews_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) {
?>
<hr />
<div id="productReviewsDefaultListingBottomNumber" class="navSplitPagesResult"><?php echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS); ?></div>
<div id="productReviewsDefaultListingBottomLinks" class="navSplitPagesLinks"><?php echo TEXT_RESULT_PAGE . ' ' . $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, zen_get_all_get_params(array('page', 'info', 'main_page'))); ?></div>

<?php
  }
?>



</div>

And here is the jpg attachment ...

Whew! Finally found the answer I was looking for thanks to Nick's solution (http://www.zen-cart.com/forum/showthread.php?t=45314&highlight=reviews&page=126). Turns out I was using the wrong search term (initially 'product reviews page' ... changed it to just 'reviews') which was why I overlooked this post. Got rid of the extra text link next to the product image. Thanks so much Nick. And thank you Alex for creating such a classy contribution! :clap:

I am getting lightbox to work great in Firefox but in IE8 the box is HUGE with a smaller picture in it. Also the attributes are not clickable anymore ( I have attribute popup installed).

I have looked through these forums and did not find any answer. If they are out there or you can help me I would be much obliged.

Very good, thank you very much!:smile:

Hi Again,

Well i gave it another go and endded up with this message

1146 Table 'shopperzencart.configuration_group' doesn't exist
in:
[SELECT @cgi := configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Zen Lightbox';]
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 guess i'm just not up to installing this mod.
:no::lamo:

Anything i can try to fix this?

A great addon in fact. Thanks for this mode. My question is this how can i change or remove the WATERMARK (ZenCart unleashed) from images????

Hi all, sorry for my previous post about WATERMARK problem. I just figured it out that this is not LIGHTBOX but IMAGEHANDLER which is showing watermark on images :) . btw this is a great addon

I keep trying however i just can't get it to work.

Can ANYONE help me?
:cry:

ADE Cyber Emporium:

I keep trying however i just can't get it to work.

Can ANYONE help me?
:cry:

Seems to me that you may not have run the sql installation code?? It is the only reason why the configuration would not exist in your database.