rdch:
I tried to run the SQL patch and I get the following error:
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?
How did you paste the SQL statements? It looks like some formatting has been applied.
Try opening the file with Notepad (or another simple text editor) and then copying the data from there.