Zen Lightbox addon [Support Thread]

[niestudio]

Hi,

I am trying to isnatll Lightbox 1.62 onto my Zen cart site at www.womanlycharm.co.uk. The site is using Zen 1.3.9h.
When i try and run the database update either through PhpMyAdmin, or manually through Zen Cart, I get an SQL error Here:

Can anybody help?

SQL query:

/** * 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 `configuration_group`
VALUES (
NULL , 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1'
);

Thanks in advance.

Was there an actual error that came with it?
something similar to : "MySQL said: Documentation
#1146 - Table '[table_prefix].configuration_group' doesn't exist "

if so, check out this post:
http://www.zen-cart.com/forum/showpo...postcount=2583
try following this for instructions on modifying the install.sql file.

If that is not the error you are getting, please post the error too.

daniel

[bugster]

Hi, thanks for your help.

I had a look at the link you gave and checked that I did indeed have a prefix defined (zen_) as per the link.
So I made the changes suggested and applied the patch through the Admin which partly worked. However I got 4 errors and the following text:

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, 'Always show Prev / Next', 'ZEN_LIGHTBOX_PREV_NEXT', 'false', '
If true, the lightbox will always show Previous & Next buttons when using additional images. NOTE: This setting will be overwritten automatically when Close on Image Click is set to TRUE.

Default: false', @cgi, 112, 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); 

The errors I got at the top of the csreen were:

ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration does not exist. CHECK PREFIXES!

I also now have 4 entries for Zen Lightbox on the Admin configuration menu! None of which appear to do anything!!!

This is now starting to get messy and I am worried about breaking something. I have backups so can recover if required but would rather not have to if it can be avoided. Any further help much appreciated.

[bugster]

Just tried it again, but this time applying it via phpMyAdmin, and it has worked!

However, i now have FIVE 'Zen Lightbox' entries on the Admin Config Menu, of which the 1st 4 are non functional!

Is there an easy way to remove these, or should I just live with them?

[DivaVocals]

The best way to avoid this error is to NOT run the install script via phpMyAdmin, but to open the install.sql file and copy/paste it into the form on the Tools > Install SQL Patches from the shop admin.. This will properly add the table pre-fixes to the script as it runs.

Was there an actual error that came with it?
something similar to : "MySQL said: Documentation
#1146 - Table '[table_prefix].configuration_group' doesn't exist "

if so, check out this post:
http://www.zen-cart.com/forum/showpo...postcount=2583
try following this for instructions on modifying the install.sql file.

If that is not the error you are getting, please post the error too.

daniel

[niestudio]

Just tried it again, but this time applying it via phpMyAdmin, and it has worked!

However, i now have FIVE 'Zen Lightbox' entries on the Admin Config Menu, of which the 1st 4 are non functional!

Is there an easy way to remove these, or should I just live with them?

you can try to run the uninstall.sql file and it should delete everything zen lightbox related and then run your updated install.sql file and i think you'll be in business.

daniel

[bugster]

you can try to run the uninstall.sql file and it should delete everything zen lightbox related and then run your updated install.sql file and i think you'll be in business.

daniel

Thanks, I will try that.

[niestudio]

The best way to avoid this error is to NOT run the install script via phpMyAdmin, but to open the install.sql file and copy/paste it into the form on the Tools > Install SQL Patches from the shop admin.. This will properly add the table pre-fixes to the script as it runs.

Hi DivaVocals,
I know you have posted this advice before, but it seems many people who try to run it in ZC admin run into problems. Do you think there is something missing from this install.sql file that makes it not play nice with ZC admin?

daniel

[willy12]

before you upgraded...did you remember to run the uninstall script and remove the files form your server and then upload the new ones?

Hi Dark Angel,

Just wanted to ask if you had any updates on the "Lightbox EZ Pages" issue.

Please let me know.


Thank you.

[DivaVocals]

Hi DivaVocals,
I know you have posted this advice before, but it seems many people who try to run it in ZC admin run into problems. Do you think there is something missing from this install.sql file that makes it not play nice with ZC admin?

daniel

Yes.. If you try to UPLOAD the file you may experience errors.. But if you open the file and copy and paste the contents instead it will run with no problems..

[DarkAngel]

Yes I did....I didn't skip one step, in fact it took some time to remove all the old files.....


Please feel free to visit my website and check it out www.aquafinatic.com. Once you are on the main page scroll down to the bottom where it says "Finatic Tailnews" on the big tab and click on it. You will see that there is a Compatability Chart and when you try to view the larger image the lightbox does not jump into effect.

Any ideas?......Thank you.

question about the chart

is it located within the body of the description and not as the main image like any other product should be?

if so then you have to add the bit of code for it when you post it in the description:

<a href="http://aquafinatic.com/images/Compatibility Chart Mini.jpg" rel="lightbox"><<img width="375" vspace="10" height="164" border="0" align="left" src="http://aquafinatic.com/images/Compatibility Chart Mini.jpg" ></a>

you of course change the size shown and alignment to your liking but this will give it thelightbox when clicked. You will also have to add the line to click image to view larger but doing it this way you just need the full grouwn image, thecoding will resize it to view prior to clicking for larger view.

I would also get into the habit of NOT using caps and spaces in the image names...like conpatibility_chart.jpg would be just right too