Thread: LightBox

Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2012
    Posts
    25
    Plugin Contributions
    0

    Default LightBox

    Hello,

    i have installed light box and i have follow all instruction in readme file but after i execute sql i get this error,

    5 statements processed.
    ERROR: Cannot insert configuration_key "" because it already exists
    ERROR: Cannot insert configuration_key "" because it already exists
    Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

    if i go to configuration - Zin LightBox Configuration is empty.

    Here is what i get after execute sql:

    (You are presently using: v1.5.0)
    Sat, 09 Jun 2012 04:42:50 -0500GMT [81.81.225.78 ] Admin Home | Online Catalog | Support Site | Version | Account | Logoff
    Configuration
    Catalog
    Modules
    Customers
    Locations / Taxes
    Localization
    Reports
    Tools
    Gift Certificate/Coupons
    Admin Access Management
    Extras
    SQL Query Executor
    BE SURE TO DO A FULL DATABASE BACKUP BEFORE RUNNING SCRIPTS HERE
    If you are installing 3rd-party contributions, note that you do so at your own risk.
    Zen Cart® makes no warranty as to the safety of scripts supplied by 3rd-party contributors. Test before using on your live database!
    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 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);
    /* zencart 1.5 mods */ INSERT INTO zen_admin_pages (page_key ,language_key ,main_page ,page_params ,menu_key ,display_on_menu ,sort_order)VALUES ('configZenLightbox', 'BOX_CONFIGURATION_ZEN_LIGHTBOX', 'FILENAME_CONFIGURATION', CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);

    Wbr, Carmelo.
    Last edited by inteltronics; 9 Jun 2012 at 10:51 AM. Reason: Forget to specify problems on title

  2. #2
    Join Date
    Apr 2012
    Posts
    25
    Plugin Contributions
    0

    Default Re: LightBox

    i still to have problems with this addon, i can't update database sql i get error, if uninstall can remove only 2 key or if i install iti get this error what will be the problem, here is a log from database install:

    5 statements processed.
    ERROR: Cannot insert configuration_key "" because it already exists
    ERROR: Cannot insert configuration_key "" because it already exists
    Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

    if i go to configuration from my admin the ZEN LightBox Configuration is empty.

    Wbr, Carmelo.

  3. #3
    Join Date
    Apr 2012
    Posts
    25
    Plugin Contributions
    0

    Default Re: LightBox

    i have uninstalled all files and database sql, installed again, my site is Italian and English, maybe conflict with image handler? here is the log:

    Success 5 statements processed.
    Error ERROR: Cannot insert configuration_key "" because it already exists
    Error ERROR: Cannot insert configuration_key "" because it already exists
    Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

    BE SURE TO DO A FULL DATABASE BACKUP BEFORE RUNNING SCRIPTS HERE
    If you are installing 3rd-party contributions, note that you do so at your own risk.
    Zen Cart® makes no warranty as to the safety of scripts supplied by 3rd-party contributors. Test before using on your live database!
    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 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);
    /* zencart 1.5 mods */ INSERT INTO zen_admin_pages (page_key ,language_key ,main_page ,page_params ,menu_key ,display_on_menu ,sort_order)VALUES ('configZenLightbox', 'BOX_CONFIGURATION_ZEN_LIGHTBOX', 'FILENAME_CONFIGURATION', CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);

  4. #4
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,846
    Plugin Contributions
    25

  5. #5
    Join Date
    Apr 2012
    Posts
    25
    Plugin Contributions
    0

    Default Re: LightBox

    if i try upgrade SQL i get: ARNING: An Error occurred, please refresh the page and try again.

 

 

Similar Threads

  1. v139h lightbox and IH2 - additional image not working in the lightbox
    By kitcorsa in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 2 Aug 2013, 10:45 AM
  2. Zen Lightbox
    By ttmb33 in forum All Other Contributions/Addons
    Replies: 14
    Last Post: 17 May 2012, 04:00 PM
  3. Lightbox
    By rbarbour in forum General Questions
    Replies: 2
    Last Post: 17 Aug 2011, 04:15 PM
  4. Lightbox problem on IE
    By manton in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 27 Dec 2008, 04:31 PM
  5. Zen Lightbox
    By surrealcurly in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 26 Jan 2007, 11:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR