Zen Lightbox addon [Support Thread]

[countrycharm]

Try un-installing it from your data base with the code that came with zen lightbox. If you have two copies of zen lightbox showing in admin you will have to go to your data base and manully remove one of them.

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;

[dni]

Try un-installing it from your data base with the code that came with zen lightbox. If you have two copies of zen lightbox showing in admin you will have to go to your data base and manully remove one of them.

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;

do you mean i should run this bit of code to remove it , or i should go into phpmyadmin and remove tables?

many thanks

[countrycharm]

You should run the code to remove it. If you still have zen lightbox showing in admin after you run the code you will have to go to your data base and remove the extra copy there. If you do and you need help I will try to help you in doing that. Your sql should have told you that it was already installed before it took the code. I don't understand why it didn't tell you that. Anyway

[dni]

You should run the code to remove it. If you still have zen lightbox showing in admin after you run the code you will have to go to your data base and remove the extra copy there. If you do and you need help I will try to help you in doing that. Your sql should have told you that it was already installed before it took the code. I don't understand why it didn't tell you that. Anyway

many thanks!

i actually had to run it through twice to get rid of both of them.
i will try to re-install and see if that will solve the missing bottom of the page problem.

[countrycharm]

Glade to be of help.

[carilivia]

For everyone that is getting this error when trying to add the installation SQL patch into their Zen Cart. What the problem is, is an extra table in your configuration_group from working with a website that is in multiple languages. You have to modify your SQL to work. I used the code below and it worked great!


INSERT INTO configuration_group
VALUES (

NULL , 'Zen Lightbox', 'Configure Zen Lightbox options', '1', '1'
);



MySQL meldet:

#1136 - Column count doesn't match value count at row 1


***********************Use the code below instead************

INSERT INTO configuration_group VALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox options', '1', '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', '<br />If true, all product images on the following pages will be displayed within a lightbox:<br /><br />- document_general_info<br />- document_product_info<br />- product_free_shipping_info<br />- product_info<br />- product_music_info<br />- product_reviews<br />- product_reviews_info<br />- product_reviews_write<br /><br />Please note: To completely remove Zen Lightbox you will need to manually delete the installation files.<br /><br /><b>Default: true</b>', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, 'Overlay Opacity', 'ZEN_LIGHTBOX_OVERLAY_OPACITY', '0.8', '<br />Controls the transparency of the overlay.<br /><br /><b>Default: 0.8</b>', @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', '<br />Controls the fade duration of the overlay.<br /><br /><b>Default: 0.2</b>', @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', '<br />If true, the lightbox will be animated as it appears on the screen.<br /><br /><b>Default: true</b>', @t4, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, 'Resize Speed', 'ZEN_LIGHTBOX_RESIZE_SPEED', '7', '<br />Controls the speed of the image resizing.<br /><br />(1 = slowest and 10 = fastest)<br /><br /><b>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', '<br />If you adjust the padding in the CSS file, you will need to update this variable.<br /><br />Please note: This value is measured in pixels.<br /><br /><b>Default: 10</b><br />', @t4, 6, NOW(), NOW(), NULL, NULL),
(NULL, 'Close on Overlay Click?', 'ZEN_LIGHTBOX_CLOSE_OVERLAY', 'false', '<br />If true, the lightbox will close when the overlay is clicked.<br /><br /><b>Default: false</b>', @t4, 7, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, 'Hide Flash Objects?', 'ZEN_LIGHTBOX_HIDE_FLASH', 'true', '<br />If true, all Flash objects will be hidden when the lightbox is displayed.<br /><br /><b>Default: true</b>', @t4, 8, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '),
(NULL, 'DIV Class to Hide', 'ZEN_LIGHTBOX_HIDE_ME', 'zenLightboxHideMe', '<br />Any content wrapped in a DIV tag with this class will be hidden when the lightbox is displayed.<br /><br /><b>Default: zenLightboxHideMe</b><br />', @t4, 9, NOW(), NOW(), NULL, NULL);

[kimsonvu]

Dear all,

My website have some little problem with Zencart Light box + You tuble video code.

When i click into image of product which have video from you tuble. The image behind the video ! How to configure for image show in the first ?

This is image:




KIM SON

Thanks you !!

[kimsonvu]

I found this bug when tried to upgrade into new version ! Please help me :

1146 Table 'handicra_shop.configuration_group' doesn't exist
in:
[SELECT @cgi := configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Zen Lightbox';]
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.

[Alex Clarke]

I'm sure this has been gone over before but I wasn't finding much in my search of the thread. Great mod with an easy install. My question is.. Is there a way to make the lightbox load the image on mouse over? It is cool but right now they have to click the image to open the product page and then click the image from the product page to load it. I understand this would be bandwith intensive, but I'd like to try it if possible.

This sounds like a good feature that I'll have to add. It should be fairly easy to implement.

I'll add this to the additions/features for v1.6, which I'm currently working on at the moment.

PM me if you would like me to work on this straight away for you (for a small fee/donation), or you can wait for the v1.6 release.

May I say hot dog!! and here is how I got it working...

I went to the cherry zen support thread and found this: http://www.zen-cart.com/forum/showpo...postcount=1080
Put in fix since that is the template my cart is based on
I uninstalled the SQL again
I reinstalled the SQL using phpMyAdmin - changing instances of configuration_group to zen_configuration_group

Now I need to figure out how to size my large pics

Thanks for the update.

Did you get any error messages when installing the SQL this time?

Also, I'll make sure that a fix for the Cherry Zen template is included in the v1.6 release. Thanks for pointing this out.

I found this bug when tried to upgrade into new version ! Please help me :

Just to confirm, you were running the install.sql by copying the text from the file and pasting it into the text area (Install SQL Patches) in the Zen Cart Admin, right?

It appears that a number of people are running into SQL errors during the installation.

I'm fairly sure that this is owing to the MySQL version (being 4).

My developement environment is based on the following:

• IIS 5.2 build 3790
• PHP 5.2.5 (Zend: 2.2.0)
• MySQL 5.0.51a-community-nt

I'll look into this installation issue and see if MySQL is unhappy with the script.

[selcyis]

How do I uninstall it from my sql and take the tap off the categories?
I have like 6 of them on there. please help.
Thanks