Zen Lightbox addon [Support Thread]

[DarkAngel]

DarkAngel,

Perfect!!!!
It was such an easy fix.
I appreciate your help.

Happy holidays to you also..

PB

happy to help when I can

[kernheimer]

well... i'm also in the dark on the /**
* Zen Lightbox mod.
also with a configuration_key error.

4 statements processed.
<strong>Foutmelding</strong> ERROR: Toevoegen "configuration_key" "" niet mogelijk omdat deze al bestaat. ( not possible, because already exist)
<strong>Waarschuwing</strong> Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

i did everything here is mentioned. and i'm in the dark.
my template is a zencart template, my php is good, i'm lost...
i am not a php person, so the mysql things are lost on me..
pretty please help...

[DarkAngel]

What is the prefix you are adding to the beginning of your tables?

Is this the first time installing or have you run the installer more than once?

are you using the current version of zencart and the lightbox?

does it show up in your admin section under configuration?

well... i'm also in the dark on the /**
* Zen Lightbox mod.
also with a configuration_key error.

4 statements processed.
<strong>Foutmelding</strong> ERROR: Toevoegen "configuration_key" "" niet mogelijk omdat deze al bestaat. ( not possible, because already exist)
<strong>Waarschuwing</strong> Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

i did everything here is mentioned. and i'm in the dark.
my template is a zencart template, my php is good, i'm lost...
i am not a php person, so the mysql things are lost on me..
pretty please help...

[abs007]

Hi
I have added the module but I get an error when I try and install the install.sql patch.

I copied the text and entered it into install sql patches - this is the error i am getting

1146 Table 'abs007_zc4.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.

any help will be appreciated

thanks

[micstock]

good contribution,i have used ,it`s so cool,thanks for your sharing

[Houtanzhang]

Hi DarkAngel

As I read through the thread and tried few times. I still have problems in install the light box.

1. zencart 1.3.8a
2. lightbox 1.5

I installled light box few times, all the way works fine.


Then later i install another new one,

1) Insalled, works, no configuration menu....

2) Then i tried to remove all the database file and install the database again---Got the data base does not exit issue!

Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Warning Note: 2 statements ignored. See "upgrade_exceptions" table for additional details.



3) I checked the path to the data base should be correct.

4) I tried removed all from database like "zen_configuration_group" "zen_configuration" then install again. Still does not work.

and i got the below results when try installing again:

Query Results:
/** * Zen Lightbox * * @author Alex Clarke ([email protected]) * @copyright Copyright 2003-2005 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: install.sql 2008-12-17 aclarke $ */ INSERT INTO zen_configuration_group VALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1');
UPDATE zen_configuration_group SET sort_order = LAST_INSERT_ID() WHERE configuration_group_id = LAST_INSERT_ID();
SELECT @cgi := configuration_group_id FROM zen_configuration_group WHERE configuration_group_title = 'Zen Lightbox';
INSERT INTO zen_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, '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
- page (EZ-Pages)
- product_free_shipping_info
- product_info
- product_music_info
- product_reviews
- product_reviews_info
- product_reviews_write

Default: true', @cgi, 100, 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', @cgi, 101, 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_FADE_DURATION', '400', '
Controls the fade duration of the overlay.

Note: This value is measured in milliseconds.

Default: 400
', @cgi, 102, NOW(), NOW(), NULL, NULL), (NULL, 'Resize Duration', 'ZEN_LIGHTBOX_RESIZE_DURATION', '400', '
Controls the speed of the image resizing.

Note: This value is measured in milliseconds.

Default: 400
', @cgi, 103, NOW(), NOW(), NULL, NULL), (NULL, 'Resize Transition', 'ZEN_LIGHTBOX_RESIZE_TRANSITION', 'false', '
Allows for custom control over the transition effect used to animate the lightbox.

Default: false
', @cgi, 104, NOW(), NOW(), NULL, NULL), (NULL, 'Initial Width', 'ZEN_LIGHTBOX_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, 105, NOW(), NOW(), NULL, NULL), (NULL, 'Initial Height', 'ZEN_LIGHTBOX_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, 106, NOW(), NOW(), NULL, NULL), (NULL, 'Image Fade Duration', 'ZEN_LIGHTBOX_IMAGE_FADE_DURATION', '400', '
Controls the fade duration of images.

Note: This value is measured in milliseconds.

Default: 400
', @cgi, 107, NOW(), NOW(), NULL, NULL), (NULL, 'Caption Animation Duration', 'ZEN_LIGHTBOX_CAPTION_ANIMATION_DURATION', '400', '
Controls the animation duration of the caption.

Note: This value is measured in milliseconds.

Default: 400
', @cgi, 108, NOW(), NOW(), NULL, NULL), (NULL, 'Display Image Counter', 'ZEN_LIGHTBOX_COUNTER', 'true', '
If true, the image counter will be displayed (below the caption of each image) within the lightbox.

Default: true', @cgi, 109, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'Close on Image Click', 'ZEN_LIGHTBOX_CLOSE_IMAGE', 'false', '
If true, the lightbox will close when the image being displaying is clicked.

Default: false', @cgi, 110, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Close on Overlay Click', 'ZEN_LIGHTBOX_CLOSE_OVERLAY', 'false', '
If true, the lightbox will close when the overlay is clicked.

Default: false', @cgi, 111, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Keyboard Navigation', 'ZEN_LIGHTBOX_KEYBOARD_NAVIGATION', 'true', '
If true, keyboard inputs will also be used to control the lightbox.

Default: true', @cgi, 200, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Close Lightbox', 'ZEN_LIGHTBOX_ESCAPE_KEYS', '27,88,67', '
The lightbox will close when any of these keys are pressed.

Note: Only ASCII decimal values should be entered and separated with a comma (if listing multiple values).

Default: 27,88,67
', @cgi, 201, NOW(), NOW(), NULL, NULL), (NULL, 'Previous Image', 'ZEN_LIGHTBOX_PREVIOUS_KEYS', '37,80', '
The lightbox will display the previous image (if available) when any of these keys are pressed.

Note: Only ASCII decimal values should be entered and separated with a comma (if listing multiple values).

Default: 37,80
', @cgi, 202, NOW(), NOW(), NULL, NULL), (NULL, 'Next Image', 'ZEN_LIGHTBOX_NEXT_KEYS', '39,78', '
The lightbox will display the next image (if available) when any of these keys are pressed.

Note: Only ASCII decimal values should be entered and separated with a comma (if listing multiple values).

Default: 39,78
', @cgi, 203, NOW(), NOW(), NULL, NULL), (NULL, 'Gallery Mode', 'ZEN_LIGHTBOX_GALLERY_MODE', 'true', '
If true, the lightbox will allow additional images to quickly be displayed using previous and next buttons.

Default: true', @cgi, 300, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'Include Main Image in Gallery', 'ZEN_LIGHTBOX_GALLERY_MAIN_IMAGE', 'true', '
If true, the main product image will be included in the lightbox gallery.

Default: true', @cgi, 301, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'EZ-Pages Support', 'ZEN_LIGHTBOX_EZPAGES', 'true', '
If true, the lightbox effect will be used for linked images on all EZ-Pages.

Default: true', @cgi, 400, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'File Types', 'ZEN_LIGHTBOX_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, 401, NOW(), NOW(), NULL, NULL);

It is too strange! Really mad, dun know how!!!!
Can you help on this?

Regarding the scripts: 1) just try to insert some table for zenlightbox right? 2) So i can remove all the things with words like "lightbox" right? Cause i modified the uninstall scripts try to clean up my data base by change the database table in the scripts. Like "zen_configuration_group" "configuration_group"....

[DarkAngel]

Make sure your prefix is added correctly, add your prefis to the tables where the red zen is shown.

Check to see if it shows in the admin/configuration and if it does then run the uninstaller first before trying to install again.

Aslo if it does not work from admin section (mine did not) then go directly to the database and copy/paste the sql installer there:

INSERT INTO `zen_configuration_group` VALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1');
UPDATE `zen_configuration_group` SET `sort_order` = LAST_INSERT_ID() WHERE `configuration_group_id` = LAST_INSERT_ID();

SELECT @cgi := `configuration_group_id` FROM `zen_configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';

INSERT INTO `zen_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

Hi
I have added the module but I get an error when I try and install the install.sql patch.

I copied the text and entered it into install sql patches - this is the error i am getting

1146 Table 'abs007_zc4.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.

any help will be appreciated

thanks

[DarkAngel]

Hi DarkAngel

As I read through the thread and tried few times. I still have problems in install the light box.

1. zencart 1.3.8a
2. lightbox 1.5

I installled light box few times, all the way works fine.

I am confused, which is not a hard thing to do...lol

If it was working and it is the current version, why install it again?

In order for the lightbox to work right you need to copy/paste the installer information (sql) into either the admin section of the store or the actual database.

removing thins will essentially"confuse" the installer and it will not install correctly.

So please unconfuse me.

[Houtanzhang]

Cause, i set up two zencart account....

the First one works fine.

The second one got problems!


For the second one:

I install got the administration issue, no lightbox configuration menu.

and also got the database does not exist issue...

Then tried to uninstall and install a few time by following the steps in the thread.... in the end.... still can not make it.

[Houtanzhang]

DarkAngel

Really thanks a lot for your help!

It works now. 2 things noticed:

1) Install and uninstall few times will get some strange problem

2) need to install through my phpadmin

3) need to take note the file format. Otherwise will get syntax error.

Thanks a lot for your help. Can move to next step now!!

happy! Haha, learn a lot of things for last week! HTML + CSS + PHP + SQL --> zen cart!