Zen Lightbox addon [Support Thread]

Hi Countrycharm -
I am using BlueHost, log onto phpMyAdmin
you say click on the link to the right configuration_group.
I just dont see this.Am I missing a step?
Rufus

Hi Countrycharm
Further comment when I sign onto phpMyAdmin the screen with the tabs flashes on/off and goes to the next screen local host on left hand side; phpMyAdmin - 2.11.9.4 on right hand side
something missing?
help
Rufus

rufusclc:

Hi Countrycharm -
I am using BlueHost, log onto phpMyAdmin
you say click on the link to the right configuration_group.
I just dont see this.Am I missing a step?
Rufus

When you log on you have to choose your database name on the left. Sorry I did tell you that. Next configuration_group will be on your left under your database name a long with all your tables.

rufusclc:

Hi Countrycharm
Further comment when I sign onto phpMyAdmin the screen with the tabs flashes on/off and goes to the next screen local host on left hand side; phpMyAdmin - 2.11.9.4 on right hand side
something missing?
help
Rufus

I don't know whats going on with your database flashing on and off. Sorry

I have been toying with ZC v 1.3.8 locally on the xampp set up as recommended in the manual....v win32-1.4.16. I have everything looking and working pretty well as a prelude to making the site live.<p>

I have one little problem in the lightbox install that is giving me a hard time in trying to work it out. I have not found anything (yet) in the forums that helps me to a solution.<p>

I have the Japanese language pack installed and have the site set up with Japanese as the default. This may be the culprit though from everything I've read, doesn't seem it should be an issue. Anyhow, the problem is this.......<p>

The lightbox comes up fine and works with the multiple product images, but when Japanese is the selected language the CLOSE / PREV /NEXT text does not show. The link is there and clicks through the images okay, but no text. Also, the alt shows when moused over...I think this is probably a big clue staring me in the face. In English, everything is perfect, no problems at all.<p>

I haven't messed with it too much beyond copying the languages>English>extra_definitions >my_custom_folder>Lightbox php file to the same string on the Japanese side. I have looked at the script in all the files and the sql config script, but I am no programmer and didn't get any clues from it.<p>

Thanks in Advance....

In regard to my post above, if it is difficult to get the NEXT/PREVIOUS/CLOSE buttons to show in both EN and JP language pages, is there a way for me to direct the buttons instead to the JP version?<P>

I use the EN for admin purpose only and JP is the default site.

OKAY!.....never mind. All it took was a good night's sleep. Figured it out....as simple as moving the images themselves to a Japanese folder (duh).

Not to put this great add on down or anything like that. Alex Clarke is a great coder on everything he does. I have use this Module myself for a long time But if some of you are having so much trouble installing this Module try something else like jqlightbox or the jqzoom it is fairly simple to install. Hope this will help some of you who can not seem to get this to work.

Thanks Countrycharm for the reply. I had no other problem with this mod other than my trying to figure out what turned out to be a very simple fix (most are) for the JP language situation. The multiple images work fine, interface with IH2 is fine and now the Japanese has Japanese buttons for N/P/X.<p>

I think Alex's mod is perfect, was extremely easy to install and I like the admin interface. Everything is almost done, adding some categories and products to test all checkout functions with... then on to live launch. The new ZenCart will be replacing an existing store, https://www.misasfashioncafe.com with JP front/EN admin sometime in the next week.<p>

Actually, after a few false starts (dues to pay), I have found the whole ZenCart experience pretty rewarding. The mods are for the most part well thought out and instructions reasonably clear. It does take paying close attention to details.<p>

Some of the great mods, I've used, IH2, Zen_Lightbox, Japanese Language pack, Multi-lingual PullDowns, additional images relocated w/ CSS, Language Currency links in header, swf object. Have bought coffee for some, others coffee is on the way.<p>

Guess I've been Zenned....

Hello, I'm having a problem. I've copied all the files onto my server but when I try to install the install.sql in the zen cart admin I get:

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

I've tried copy and pasting the text along with uploading the file and I get this error both times. Anyone know how to fix this?

Thanks

dekerf:

Hello, I'm having a problem. I've copied all the files onto my server but when I try to install the install.sql in the zen cart admin I get:

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

I've tried copy and pasting the text along with uploading the file and I get this error both times. Anyone know how to fix this?

Thanks

Same for me. It worked fine on MAMP but the live server gave the error , tried by admin and php myadmin. Earlier in the thread it says if you use a prefix to edit accordingly, but what part do you edit?

Found what to edit but still get a syntax error

Hello

I just recently updated a page on my site & I added some screen shot pictures.. I thought that light box would have worked on the pictures, however it does not appear to work..

the page is
http://www.bigmoneyparttime.com/ecover-creators-p-9.html

Im new to lightbox, so im not sure if this is suppose to work the same way as the product image versus a link to an image on the page?

I also get the same error as "the_doomsayer" and "dekerf". Has anyone worked out a fix for this?

grandpa_shea:

I also get the same error as "the_doomsayer" and "dekerf". Has anyone worked out a fix for this?

Scrap that... I tried some of the other sql codes in this thread and it seems to be working fine for now... Sorry, I just needed to read all of the 100 plus pages.

grandpa_shea:

Scrap that... I tried some of the other sql codes in this thread and it seems to be working fine for now... Sorry, I just needed to read all of the 100 plus pages.

Which ones? Ive tried one I found and it gave the same error.

the_doomsayer:

Which ones? Ive tried one I found and it gave the same error.

I used this one:

need_help:

Ok i had to uninstall with the mysql file twice and then paste this code into the browser to get Zen Lightbox to work

/**

• Zen Lightbox
• @author Alex Clarke (aclarke AT ansellandclarke DOT co DOT uk)
• @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 2009-01-13 aclarke $
  */
  INSERT INTO configuration_group VALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1');
  UPDATE configuration_group SET sort_order = LAST_INSERT_ID() WHERE configuration_group_id = LAST_INSERT_ID();
  SELECT (@cgi := configuration_group_id) 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, '<b>Zen Lightbox</b>', '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 />-
  page (EZ-Pages)<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 /><b>Default: true</b>', @cgi,
  100, 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>', @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', '<br />Controls the fade duration of
  the overlay.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi,
  102, NOW(), NOW(), NULL, NULL),
  (NULL, 'Resize Duration', 'ZEN_LIGHTBOX_RESIZE_DURATION', '400', '<br />Controls the speed of the image resizing.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi, 103, NOW(),
  NOW(), NULL, NULL),
  (NULL, 'Resize Transition', 'ZEN_LIGHTBOX_RESIZE_TRANSITION', 'false', '<br />Allows for custom control over the
  transition effect used to animate the lightbox.<br /><br /><b>Default: false</b><br />', @cgi, 104, NOW(), NOW(),
  NULL, NULL),
  (NULL, 'Initial Width', 'ZEN_LIGHTBOX_INITIAL_WIDTH', '250', '<br />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.<br /><br />Note:
  This value is measured in pixels.<br /><br /><b>Default: 250</b><br />', @cgi, 105, NOW(), NOW(), NULL, NULL),
  (NULL, 'Initial Height', 'ZEN_LIGHTBOX_INITIAL_HEIGHT', '250', '<br />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.<br /><br />Note: This value is measured in pixels.<br /><br /><b>Default: 250</b><br />', @cgi, 106, NOW(), NOW(), NULL,
  NULL),
  (NULL, 'Image Fade Duration', 'ZEN_LIGHTBOX_IMAGE_FADE_DURATION', '400', '<br />Controls the fade duration of
  images.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi, 107,
  NOW(), NOW(), NULL, NULL),
  (NULL, 'Caption Animation Duration', 'ZEN_LIGHTBOX_CAPTION_ANIMATION_DURATION', '400', '<br />Controls the animation
  duration of the caption.<br /><br />Note: This value is measured in milliseconds.<br /><br /><b>Default: 400</b><br />', @cgi, 108, NOW(), NOW(), NULL, NULL),
  (NULL, 'Display Image Counter', 'ZEN_LIGHTBOX_COUNTER', 'true', '<br />If true, the image counter will be displayed
  (below the caption of each image) within the lightbox.<br /><br /><b>Default: true</b>', @cgi, 109, NOW(), NOW(),
  NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
  (NULL, 'Close on Image Click', 'ZEN_LIGHTBOX_CLOSE_IMAGE', 'false', '<br />If true, the lightbox will close when the
  image being displaying is clicked.<br /><br /><b>Default: false</b>', @cgi, 110, NOW(), NOW(), NULL,
  'zen_cfg_select_option(array(''true'', ''false''), '),
  (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>', @cgi, 111, NOW(), NOW(), NULL,
  'zen_cfg_select_option(array(''true'', ''false''), '),
  (NULL, '<b>Keyboard Navigation</b>', 'ZEN_LIGHTBOX_KEYBOARD_NAVIGATION', 'true', '<br />If true, keyboard inputs
  will also be used to control the lightbox.<br /><br /><b>Default: true</b>', @cgi, 200, NOW(), NOW(), NULL,
  'zen_cfg_select_option(array(''true'', ''false''), '),
  (NULL, 'Close Lightbox', 'ZEN_LIGHTBOX_ESCAPE_KEYS', '27,88,67', '<br />The lightbox will close when any of these
  keys are pressed.<br /><br />Note: Only <a href="http://en.wikipedia.org/wiki/ASCII" target="_blank">ASCII</a>
  decimal values should be entered and separated with a comma (if listing multiple values).<br /><br /><b>Default:
  27,88,67</b><br />', @cgi, 201, NOW(), NOW(), NULL, NULL),
  (NULL, 'Previous Image', 'ZEN_LIGHTBOX_PREVIOUS_KEYS', '37,80', '<br />The lightbox will display the previous image
  (if available) when any of these keys are pressed.<br /><br />Note: Only <a href="http://en.wikipedia.org/wiki/ASCII" target="_blank">ASCII</a> decimal values should be entered and separated
  with a comma (if listing multiple values).<br /><br /><b>Default: 37,80</b><br />', @cgi, 202, NOW(), NOW(), NULL,
  NULL),
  (NULL, 'Next Image', 'ZEN_LIGHTBOX_NEXT_KEYS', '39,78', '<br />The lightbox will display the next image (if
  available) when any of these keys are pressed.<br /><br />Note: Only <a href="http://en.wikipedia.org/wiki/ASCII" target="_blank">ASCII</a> decimal values should be entered and separated with a comma (if listing multiple
  values).<br /><br /><b>Default: 39,78</b><br />', @cgi, 203, NOW(), NOW(), NULL, NULL),
  (NULL, '<b>Gallery Mode</b>', 'ZEN_LIGHTBOX_GALLERY_MODE', 'true', '<br />If true, the lightbox will allow
  additional images to quickly be displayed using previous and next buttons.<br /><br /><b>Default: true</b>', @cgi,
  300, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
  (NULL, 'Include Main Image in Gallery', 'ZEN_LIGHTBOX_GALLERY_MAIN_IMAGE', 'true', '<br />If true, the main product
  image will be included in the lightbox gallery.<br /><br /><b>Default: true</b>', @cgi, 301, NOW(), NOW(), NULL,
  'zen_cfg_select_option(array(''true'', ''false''),'),
  (NULL, '<b>EZ-Pages Support</b>', 'ZEN_LIGHTBOX_EZPAGES', 'true', '<br />If true, the lightbox effect will be used
  for linked images on all EZ-Pages.<br /><br /><b>Default: true</b>', @cgi, 400, NOW(), NOW(), NULL,
  'zen_cfg_select_option(array(''true'', ''false''),'),
  (NULL, 'File Types', 'ZEN_LIGHTBOX_FILE_TYPES', 'jpg,png,gif', '<br />On EZ-Pages, the lightbox effect will be
  applied to all images with one of the following file types.<br /><br /><b>Default: jpg,png,gif</b><br />', @cgi,
  401, NOW(), NOW(), NULL, NULL);

Baffles me why though it now works.

My large images are still down though even when i uninstall Image Handler 2 and disable Lightbox....Thats a mystery and it happened yesterday.

Good luck!

I forgot to mention I get a syntax error when I run the uninstall patch as well.
Would the install patch have been applied in any way?

Do I need to run the uninstall patch?

Thanks Grandpa_shea worked for me as well. No idea what I did different but I'll take it.

bmpt:

Hello

I just recently updated a page on my site & I added some screen shot pictures.. I thought that light box would have worked on the pictures, however it does not appear to work..

the page is
http://www.bigmoneyparttime.com/ecover-creators-p-9.html

Im new to lightbox, so im not sure if this is suppose to work the same way as the product image versus a link to an image on the page?

Check out this post: https://www.zen-cart.com/forum/showthread.php?t=45314&page=108

Look for the second post by snowkrash with instructions for making lightbox work with additional images.