Zen Lightbox addon [Support Thread]

[DarkAngel]

glad you got it straightened out and got me not confused too...yay

Happy Holidays

[Robert_nz]

Hi

Posted to tvzen_jellyfish but no replies yet. I have this theme on one web site but when I install Zen Lightbox and when I do I stop geting product pages.


I guess they are over writing something they shouldn't. Does anyone have any suggestions?

Thanks
Rob

[Dimascus]

Hey DarkAngel,

First, thanks for making this!

Ok, now...

I get this when I try to install:

4 statements processed.
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Warning Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

Query Results:
/** * 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 zen_configuration_group VALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1');
UPDATE zen_configuration_group SET sort_order = LAST_INSERT_ID() WHERE configuration_group_id = LAST_INSERT_ID();
SELECT @cgi := configuration_group_id FROM zen_configuration_group WHERE configuration_group_title = 'Zen Lightbox';
INSERT INTO zen_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, 'Zen Lightbox', 'ZEN_LIGHTBOX_STATUS', 'true', '
If true, all product images on the following pages will be displayed within a lightbox:

- document_general_info
- document_product_info
- page (EZ-Pages)
- product_free_shipping_info
- product_info
- product_music_info
- product_reviews
- product_reviews_info
- product_reviews_write

Default: true', @cgi, 100, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Overlay Opacity', 'ZEN_LIGHTBOX_OVERLAY_OPACITY', '0.8', '
Controls the transparency of the overlay.

Default: 0.8', @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', '
Controls the fade duration of the overlay.

Note: This value is measured in milliseconds.

Default: 400
', @cgi, 102, NOW(), NOW(), NULL, NULL), (NULL, 'Resize Duration', 'ZEN_LIGHTBOX_RESIZE_DURATION', '400', '
Controls the speed of the image resizing.

Note: This value is measured in milliseconds.

Default: 400
', @cgi, 103, NOW(), NOW(), NULL, NULL), (NULL, 'Resize Transition', 'ZEN_LIGHTBOX_RESIZE_TRANSITION', 'false', '
Allows for custom control over the transition effect used to animate the lightbox.

Default: false
', @cgi, 104, NOW(), NOW(), NULL, NULL), (NULL, 'Initial Width', 'ZEN_LIGHTBOX_INITIAL_WIDTH', '250', '
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.

Note: This value is measured in pixels.

Default: 250
', @cgi, 105, NOW(), NOW(), NULL, NULL), (NULL, 'Initial Height', 'ZEN_LIGHTBOX_INITIAL_HEIGHT', '250', '
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.

Note: This value is measured in pixels.

Default: 250
', @cgi, 106, NOW(), NOW(), NULL, NULL), (NULL, 'Image Fade Duration', 'ZEN_LIGHTBOX_IMAGE_FADE_DURATION', '400', '
Controls the fade duration of images.

Note: This value is measured in milliseconds.

Default: 400
', @cgi, 107, NOW(), NOW(), NULL, NULL), (NULL, 'Caption Animation Duration', 'ZEN_LIGHTBOX_CAPTION_ANIMATION_DURATION', '400', '
Controls the animation duration of the caption.

Note: This value is measured in milliseconds.

Default: 400
', @cgi, 108, NOW(), NOW(), NULL, NULL), (NULL, 'Display Image Counter', 'ZEN_LIGHTBOX_COUNTER', 'true', '
If true, the image counter will be displayed (below the caption of each image) within the lightbox.

Default: true', @cgi, 109, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'Close on Image Click', 'ZEN_LIGHTBOX_CLOSE_IMAGE', 'false', '
If true, the lightbox will close when the image being displaying is clicked.

Default: false', @cgi, 110, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Close on Overlay Click', 'ZEN_LIGHTBOX_CLOSE_OVERLAY', 'false', '
If true, the lightbox will close when the overlay is clicked.

Default: false', @cgi, 111, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Keyboard Navigation', 'ZEN_LIGHTBOX_KEYBOARD_NAVIGATION', 'true', '
If true, keyboard inputs will also be used to control the lightbox.

Default: true', @cgi, 200, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Close Lightbox', 'ZEN_LIGHTBOX_ESCAPE_KEYS', '27,88,67', '
The lightbox will close when any of these keys are pressed.

Note: Only ASCII decimal values should be entered and separated with a comma (if listing multiple values).

Default: 27,88,67
', @cgi, 201, NOW(), NOW(), NULL, NULL), (NULL, 'Previous Image', 'ZEN_LIGHTBOX_PREVIOUS_KEYS', '37,80', '
The lightbox will display the previous image (if available) when any of these keys are pressed.

Note: Only ASCII decimal values should be entered and separated with a comma (if listing multiple values).

Default: 37,80
', @cgi, 202, NOW(), NOW(), NULL, NULL), (NULL, 'Next Image', 'ZEN_LIGHTBOX_NEXT_KEYS', '39,78', '
The lightbox will display the next image (if available) when any of these keys are pressed.

Note: Only ASCII decimal values should be entered and separated with a comma (if listing multiple values).

Default: 39,78
', @cgi, 203, NOW(), NOW(), NULL, NULL), (NULL, 'Gallery Mode', 'ZEN_LIGHTBOX_GALLERY_MODE', 'true', '
If true, the lightbox will allow additional images to quickly be displayed using previous and next buttons.

Default: true', @cgi, 300, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'Include Main Image in Gallery', 'ZEN_LIGHTBOX_GALLERY_MAIN_IMAGE', 'true', '
If true, the main product image will be included in the lightbox gallery.

Default: true', @cgi, 301, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'EZ-Pages Support', 'ZEN_LIGHTBOX_EZPAGES', 'true', '
If true, the lightbox effect will be used for linked images on all EZ-Pages.

Default: true', @cgi, 400, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'File Types', 'ZEN_LIGHTBOX_FILE_TYPES', 'jpg,png,gif', '
On EZ-Pages, the lightbox effect will be applied to all images with one of the following file types.

Default: jpg,png,gif
', @cgi, 401, NOW(), NOW(), NULL, NULL);



I have already tried what you suggested as well: (below)

Anything else that might be wrong? My database is stable and running smooth. Everything that is suppose to be there is there...

Zen Cart = 1.3.8a
Lightbox= 1.5

Thanks.

Make sure your prefix is added correctly, add your prefis to the tables where the red zen is shown.

Check to see if it shows in the admin/configuration and if it does then run the uninstaller first before trying to install again.

Aslo if it does not work from admin section (mine did not) then go directly to the database and copy/paste the sql installer there:

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

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

INSERT INTO `zen_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

[DarkAngel]

@dimascus:

go to your database and take a screenshot of your tables...nothing else is needed just the actual tables. post it here and then we can take it from there.

@Robert_nz:

this doesn't touch your pages it just adds a few files.

did you install it or someone else
is it showing in admin/configuration
any error messages when installed
what themplate is used in store

link to store would be helpful for the ones with even more experience

PS: guys, I did not create this little mod, I love it and even though I do not have the additional images like all others do I just give advice for the same things I have gone thru with the installation and making it behave. I wish I had created it....but tips to my paypal are still accepted...lol <---just kidding

Happy Holidays <---that part is serious.

[Dimascus]

Thanks for your help and time DarkAngel and sorry, I read it wrong. I meant to say thanks to the original creator... :\

@dimascus:

go to your database and take a screenshot of your tables...nothing else is needed just the actual tables. post it here and then we can take it from there.


PS: guys, I did not create this little mod, I love it and even though I do not have the additional images like all others do I just give advice for the same things I have gone thru with the installation and making it behave. I wish I had created it....but tips to my paypal are still accepted...lol <---just kidding


Happy Holidays <---that part is serious.

[DarkAngel]

well the prefix is right so next question...

are you attempting to install from the store admin section or the database

[abs007]

Hi Darkangel
Thanks for the reply - Im still a little confused as to what I need to change. I understand that I need to change the red areas which you highlighted however what should I be changing them to.

Im sorry if this is a kind of dumb question but am kind of lost

thanks

[anshii]

I too have problems installing the install SQL patch on via both Admin and Database.

Error message from admin: 1146 Table 'anshii80_IC_20091104_062332.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 have also tried using the patch given below directly into the DB, this was what I got:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Make sure your prefix is added correctly, add your prefis to the tables where the red zen is shown.

Check to see if it shows in the admin/configuration and if it does then run the uninstaller first before trying to install again.

Aslo if it does not work from admin section (mine did not) then go directly to the database and copy/paste the sql installer there:

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

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

INSERT INTO `zen_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

[abs007]

ummm
It looks like a common problem - Maybe the developer can be kind enough to paste a working sql patch which will help many of us on here

thanks

[Dimascus]

Right from the admin. I havent wanted to try the database yet as many people still have the same problem. How would even put it in the DB myself?



Thanks again.

well the prefix is right so next question...

are you attempting to install from the store admin section or the database