Zen Lightbox addon [Support Thread]

[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?

[Alex Clarke]

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.

[rdch]

it was straight from notepad

[Alex Clarke]

it was straight from notepad

And where did you paste it?

[rdch]

into the large box in admin>tools>Install SQL Patches

/admin/sqlpatch.php

[rdch]

any other ideas?

[dbltoe]

You're generally better off to use phpMyAdmin in your control panel for running sql from this source.

[rdch]

i can just run this exact script in phpmyadmin? i'm not a sql expert i'm afraid.