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.
