I tried to install Colorbox and everything went fine but when installing SQL patch I got 1064 syntax error:
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.
Any help would be greatly appreciated.
Bookmarks