Code:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ', 'Allow version checking if Zen ...' at line 1
in:
[INSERT IGNORE INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Zen Colorbox', 'ZEN_COLORBOX_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, 10, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), ('Zen Colorbox (Update Check)', 'ZEN_COLORBOX_PLUGIN_CHECK', , 'Allow version checking if Zen Cart version checking enabled
If false, no version checking performed.
If true, then only if Zen Cart version checking is on:', @cgi, 20, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), ('Overlay Opacity', 'ZEN_COLORBOX_OVERLAY_OPACITY', '0.6', '
Controls the transparency of the overlay.
Default: 0.6', @cgi, 30, 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''), '), ('Resize Duration', 'ZEN_COLORBOX_RESIZE_DURATION', '400', '
Controls the speed of the image resizing.
Note: This value is measured in milliseconds.
Default: 400
', @cgi, 40, NOW(), NULL, NULL), ('Initial Width', 'ZEN_COLORBOX_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, 50, NOW(), NULL, NULL), ('Initial Height', 'ZEN_COLORBOX_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, 60, NOW(), NULL, NULL), ('Display Image Counter', 'ZEN_COLORBOX_COUNTER', 'true', '
If true, the image counter will be displayed (below the caption of each image) within the lightbox.
Default: true', @cgi, 70, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), ('Close on Overlay Click', 'ZEN_COLORBOX_CLOSE_OVERLAY', 'false', '
If true, the lightbox will close when the overlay is clicked.
Default: false', @cgi, 80, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), ('Loop', 'ZEN_COLORBOX_LOOP', 'true', '
If true, Images will loop in both directions.
Default: true', @cgi, 90, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), ('Slideshow', 'ZEN_COLORBOX_SLIDESHOW', 'false', '
If true, Images will display as a slideshow.
Default: false', @cgi, 100, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (' Slideshow Auto Start', 'ZEN_COLORBOX_SLIDESHOW_AUTO', 'true', '
If true, your slideshow will auto start.
Default: true', @cgi, 110, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (' Slideshow Speed', 'ZEN_COLORBOX_SLIDESHOW_SPEED', '2500', '
Sets the speed of the slideshow
Note: This value is measured in milliseconds.
Default: 2500', @cgi, 120, NOW(), NULL, NULL), (' Slideshow Start Text', 'ZEN_COLORBOX_SLIDESHOW_START_TEXT', 'start slideshow', '
Link text to start the slideshow.
Default: start slideshow', @cgi, 130, NOW(), NULL, NULL), (' Slideshow Stop Text', 'ZEN_COLORBOX_SLIDESHOW_STOP_TEXT', 'stop slideshow', '
Link text to stop the slideshow.
Default: stop slideshow', @cgi, 140, NOW(), NULL, NULL), ('Gallery Mode', 'ZEN_COLORBOX_GALLERY_MODE', 'true', '
If true, the lightbox will allow additional images to quickly be displayed using previous and next buttons.
Default: true', @cgi, 150, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (' Include Main Image in Gallery', 'ZEN_COLORBOX_GALLERY_MAIN_IMAGE', 'true', '
If true, the main product image will be included in the lightbox gallery.
Default: true', @cgi, 160, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), ('EZ-Pages Support', 'ZEN_COLORBOX_EZPAGES', 'true', '
If true, the lightbox effect will be used for linked images on all EZ-Pages.
Default: true', @cgi, 170, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (' File Types', 'ZEN_COLORBOX_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, 180, 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.
I am stuck with this. Seems there has been Colorbox earlier or at least it works on the site but no admin options are visible thanks to this error.
Bookmarks