Code:
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 '; SELECT (@t4:=configuration_group_id) as t4 FROM configuration_group WHERE ' at line 1
in:
[SET @t4=0; SELECT (@t4:=configuration_group_id) as t4 FROM configuration_group WHERE configuration_group_title= 'Zen Lightbox'; DELETE FROM configuration WHERE configuration_group_id = @t4; DELETE FROM configuration_group WHERE configuration_group_id = @t4; INSERT INTO configuration_group VALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox options', '1', '1'); UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id(); SET @t4=0; SELECT (@t4:=configuration_group_id) as t4 FROM 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, 'Enable 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
- product_free_shipping_info
- product_info
- product_music_info
- product_reviews
- product_reviews_info
- product_reviews_write
Please note: To completely remove Zen Lightbox you will need to manually delete the installation files.
Default: true', @t4, 1, 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', @t4, 2, 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_DURATION', '0.2', '
Controls the fade duration of the overlay.
Default: 0.2', @t4, 3, 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, 'Enable Resize Animations?', 'ZEN_LIGHTBOX_RESIZE_ANIMATIONS', 'true', '
If true, the lightbox will be animated as it appears on the screen.
Default: true', @t4, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Resize Speed', 'ZEN_LIGHTBOX_RESIZE_SPEED', '7', '
Controls the speed of the image resizing.
(1 = slowest and 10 = fastest)
Default: 7', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3'', ''4'', ''5'', ''6'', ''7'', ''8'', ''9'', ''10''), '), (NULL, 'Border Size', 'ZEN_LIGHTBOX_BORDER_SIZE', '10', '
If you adjust the padding in the CSS file, you will need to update this variable.
Please note: This value is measured in pixels.
Default: 10
', @t4, 6, NOW(), NOW(), NULL, NULL), (NULL, 'Close on Overlay Click?', 'ZEN_LIGHTBOX_CLOSE_OVERLAY', 'false', '
If true, the lightbox will close when the overlay is clicked.
Default: false', @t4, 7, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Hide Flash Objects?', 'ZEN_LIGHTBOX_HIDE_FLASH', 'true', '
If true, all Flash objects will be hidden when the lightbox is displayed.
Default: true', @t4, 8, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'DIV Class to Hide', 'ZEN_LIGHTBOX_HIDE_ME', 'zenLightboxHideMe', '
Any content wrapped in a DIV tag with this class will be hidden when the lightbox is displayed.
Default: zenLightboxHideMe
', @t4, 9, NOW(), NOW(), NULL, NULL);]
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.
any ideas?
Bookmarks