Quote Originally Posted by OopsIbrickedIT View Post
Zen zart 1.5.x Mariadb 10.4

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.
BR,
Oops
Please forgive me for looking at the current github fileset. I don't see the above sql exactly as required to be executed. By that I mean there is a fileset that is expected to perform the install/upgrade. It has similar statements, but not exactly as it executes each query rather than one giant one. The Readme file shows something similar, but doesn't appear to have the problem that the above has.

So the problem with the above query is that this portion:
Code:
 'ZEN_COLORBOX_PLUGIN_CHECK', , 'Allow
Has that comma followed by a space followed by a comma.

The Readme shows a text value of 'true' in that space, but the above shows nothing.

So why does the Readme show the query? Too many have questioned what happens, or they come across an issue and want to know what was expected, etc. Lastly to that though, because a previous author took a lot of trouble to incorporate it and I didn't see the benefit of removing it. After all navigation of the site after file incorporation causes the install, so running the sql again really does nothing other than waste time and in this case energy.

So, if the version being installed doesn't look like what is in Github, perhaps could offer some more info to be able to track down the issue.