Just did it thru PhpMyadmin and now its working !!
But I dont see anything in admin/configuration.
Andre
Printable View
at least you got it to install without errors
in admin at the bottom of configuration there is no lightbox listed?
am lost on that one unless your theme lightbox files are not in their designated theme folder
check to make sure that you put the:
includes/languages/english/extra_definitions/make a folder for your theme here and place that file in it
same for the modules/your theme folder
and the templates/your theme folder
put those files from the zip into the folders and then check admin again either in a new page or refreshing the page you have open
let us know
Hello, For some reason lightbox does not display the image in Chrome 3.0.195.33, and Opera 10.10. The light box appears, just with no image. Works fine in IE 8.0.7600.
@serovectra:
make sure everything is uploaded right and that you installed the sql without any errors
@dre:
the files are for the software to be able to use the lightbox but the install sql is for it to be seen/set in admin section.
I am at a loss as to why unless it has to do with your template you are using...which is it and you are using zencart 1.38 yes?
my turn to ask a question...lol
when you click the image and get the lightbox view at the bottom of the image---there should be the title of the image with the counter info like image 1 0f 3
on this site we got it to work but it does not show that...
where do i fix that to read out right.
see image
https://www.pennylanebridal.com.au
well i originaly tok off the setting to show the counter and it did not work but now suddenly it is so the gremlins did it.
it fixed itself
Hi i just install zen light box and i m getting error on SQL when i install sql file i ghet this error
1146 Table 'sneakerf_testing.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.
is sneakerf_testing the prefix to your store's tables in the database?
yes sneakerf_testing prefix
sneakerf is the name of the site
testing is the name of the database
I think but the tables within the testing database is more than likly either zc, zen or nothing at all but just table names.
I suggest you go to your database manager (MyPHPadmin from your c-panel), and take a screenshot of the actual tables in the database.
that way we can see which one of us is confused...thanks
then maybe you need to run the sql installer with the prefix where indicated in red...but remember to run the uninstaller first... if tester is the word just before the table name...like it should look like this tester_admin
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
Hopefully this will be an easy one to answer.
I have just had installed Light Box and it appears to work fine - apart from the fact that when I click an image it brings up the box but the image is the same size as the image I clicked to open the box.
Do I need to resize all my existing images, and add _LRG.jpg and place them all in the LARGE folder for light box to open a larger image of my products?
Or do I need to do something else so that the customer if they click on my existing image (say 100 x 100 pixels) they get to see a light box image that is say 600 x 600 pixels in size.
I am going around in circles trying to rectify this.
Phil
www.colourpatch.com/shop
@philblack:
hi there and happy holiday!
about the thumbnail images...depending on what size you have them set in admin is the size you initially see...however what I do is upload the image full size via the description page---at the bottom and then the software resizes it to fit your constraints and when clicked on the customer is given the larger size.
hope that made sense
example mine are set at width=175 I think...lol I do not enter a height so the software fits to size...then I go enter all the info I need for the product and under the place to enter model you click the browse button to locate the image on your computer...select where you want it uploaded...click preview when doen then update to finalize...go to your store and click the thumbnail and it should open to the original size you uploaded.
see my store (link in signature for Fantasies Realm) rightclick the thumbnail and choose view image to see the actual size of the image...they are all uploaded full size, named as I want them to be.
the_LRG is more if you actually get the counter to go thru more than one image on your product page...mine never behaved, so i did it this way
DarkAngel,
Perfect!!!!
It was such an easy fix.
I appreciate your help.
Happy holidays to you also..
PB
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..
:oops: pretty please help...
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?
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
good contribution,i have used ,it`s so cool,thanks for your sharing:laugh:
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"....
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
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.:cry:
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.
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!!:clap:
happy! Haha, learn a lot of things for last week! HTML + CSS + PHP + SQL --> zen cart!
glad you got it straightened out and got me not confused too...yay:clap:
Happy Holidays
Hi
Posted to tvzen_jellyfish but no replies yet. I have this theme on one web site but when I install Zen Lightbox and when I do I stop geting product pages.
I guess they are over writing something they shouldn't. Does anyone have any suggestions?
Thanks
Rob
Hey DarkAngel,
First, thanks for making this! :D
Ok, now...
I get this when I try to install:
4 statements processed.
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!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Warning Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.
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);
I have already tried what you suggested as well: (below)
Anything else that might be wrong? My database is stable and running smooth. Everything that is suppose to be there is there...
Zen Cart = 1.3.8a
Lightbox= 1.5
Thanks.
@dimascus:
go to your database and take a screenshot of your tables...nothing else is needed just the actual tables. post it here and then we can take it from there.
@Robert_nz:
this doesn't touch your pages it just adds a few files.
did you install it or someone else
is it showing in admin/configuration
any error messages when installed
what themplate is used in store
link to store would be helpful for the ones with even more experience
PS: guys, I did not create this little mod, I love it and even though I do not have the additional images like all others do I just give advice for the same things I have gone thru with the installation and making it behave. I wish I had created it....but tips to my paypal are still accepted...lol <---just kidding
Happy Holidays <---that part is serious.
http://www.nightmaresls.com/tables11.jpg
Thanks for your help and time DarkAngel and sorry, I read it wrong. I meant to say thanks to the original creator... :\
well the prefix is right so next question...
are you attempting to install from the store admin section or the database
Hi Darkangel
Thanks for the reply - Im still a little confused as to what I need to change. I understand that I need to change the red areas which you highlighted however what should I be changing them to.
Im sorry if this is a kind of dumb question but am kind of lost
thanks
I too have problems installing the install SQL patch on via both Admin and Database.
Error message from admin: 1146 Table 'anshii80_IC_20091104_062332.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 have also tried using the patch given below directly into the DB, this was what I got:
#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 '' at line 1
ummm
It looks like a common problem - Maybe the developer can be kind enough to paste a working sql patch which will help many of us on here
thanks
Got it working finally... 1 thing was missing for some reason in my sql code. It works now... what a headache... lol
Thanks for all your time DarkAngel.
Hi DarkAngel
Yes I installed it. It showed in the admin fine and I don't recall any error messages. The template is tvzen_jellyfish which I have modded a little. It is currently uninstalled but I will reinstall it and so you can see what happens. I will post a link when it is up :)
Thanks
@abs007:
there is no such thing as a dumb question except the one you keep to yourself. If we all knew exactly what to do then we would not be here helping each other...lol
1. you need to look at your database (see the one that is pictured in the above post) to see what your prefix (the part in red of my post) to your tables is.
2. that is what you replace my red words with.
Then after you fix your install file you upload it either through the database or through store admin section.
@Dimascus:
yay you got it done!!!
@abs007:
the only problem is that not everyone has the same prefix to their database tables. Which seems to be the main part of the problems found here. plus like me, I could not get it to install from the store admin section, I had to install it via the database
Hi DarkAngel
I have re installed (no errors). The settings are available from the zen admin. When turned on I get blank screens when viewing products, when turned off it all works fine.
http://v p s 3 2 0.win.vps.isx.net.nz/Oasis/
Test web server not always available.
TIA
Rob
even removing the spaces I get nothing but a login page to the host...lol
I would suggest you go to the server--check all the folders to ensure you uploaded everything right. do this by opening the zip on your destop and checking visually especially the ones that you need to rename with your templates name.
is it on the default template or a different one.
then if all is well then go to the addons page here --click the main nav bar link...search for debugging tool and grab it...
open the zip, upload it to the includes/extra_configures folder set the cache folder permissions to either 775 or 777 then try one of the pages that is blank.
once you do that go to the cache folder and see what it plops in there...plop the error message in here for all to see and get an idea? then remove the debugging tool file.
did you change the installation sql in any way, except for the usual prefix change? same for the actual files you uploaded, did they get changed in any way?
Hi Try the path again it definitely should bring up a web homepage. I have just tested it again (removing spaces) and it works fine for me and others around the country.
It is not the default theme and I have installed with another theme and it worked great. It is definitely some sort of conflict between the theme and light box.
I will get the tool you recommended and see what I can see. When I look at the source in the browser it is only partly there with light box turned on, so i guess something is crashing PHP.
Cheers
Hi DarkAngel
Thanks so much for your help!! The debugging tool showed me the issue. my configure.php was pointing to the wrong path (DIR_FS_CATALOG was set to another web sites directory. This must have happended when I copied it previously).
Its working great.
A side question but is it possible to show the products description in the 'light box' as well as the name ?
Thanks
Rob
well it did work this time...lol
um are you using IE or Firefox...cause I got the lightbox to come up
I would not enter the info in the lightbox...leaving it as it is is best I know that the lightbox has given me problems if the image is too big in width by not letting it scroll or even close.
Was there ever any consensus regarding the images being blank in browsers other the IE 8? I was looking forever for problems using Google Chrome, then finally tried IE8 and presto...it worked. Google Chrome just comes up with a blank white image, but IE 8 works correctly.
my guess is that since chrome is so "new" still it is like opera started out...dicey...lol
I have a customer also that just emailed me as to why she could not see the lightbox and that all she got is a white page.
found out she is using chrome so informed her of the problem.
it is something coded into chrome I would assume...has anyone tried using it at other sites that may use some sort of lightbox?
the creator has not been in for a long time so not sure if they are working on it or have quit working on their add on.
Finally got the SQL correct, thanks for the great contribution :smile:
I have tested on both FireFox 3.5.6 and Chrome - both only showed white page without image. Hence I would assume this is not universally applicable or is there anything to be changed in the coding?
Hello,
I seen some posts already with this issue but cannot seem to find a solution for mine. I am running 1.3.8a, lightbox 1.5, my own created theme (i didnt make any modifications to it yet, just set it up from scratch), no addons yet besides this, new install.
When I click on the image, it does not come up in a light box, it just opens in a new page (same window).
All folders are named properly... not sure what it is. Please PM me and I will give you my development address.
Thanks,
-A
Hi dark angel
thank you ever so much for your help. I still can not manage to get it to work. Heres wht I did
I replaced all the red coding in your previous post to my database so it reads
INSERT INTO `abs007_zc4_configuration_group` VALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1');
UPDATE `abs007_zc4_configuration_group` SET `sort_order` = LAST_INSERT_ID() WHERE `configuration_group_id` = LAST_INSERT_ID();
SELECT @cgi := `configuration_group_id` FROM `abs007_zc4_configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';
INSERT INTO `abs007_zc4_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
This is the error that I am getting
1146 Table 'abs007_zc4.abs007_zc4_configuration_group' doesn't exist
in:
[SELECT @cgi := configuration_group_id FROM abs007_zc4_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.
not too sure what im doing wrong. I got the database name from my configure.php file
thanks
That may be the trouble...
you wrote:abs007_zc4_configuration_group
I think that it should read: zc4_configuration_group
what you entered is the database name but not the table prefix, this is why I ask everyone to take a screen shot of the database tables.
when you go to your mysql manager (myPhpadmin for some) you will see the name of the database in the list (if you have more than one database), clicking the name will show you all the tables in a list
look at the tables and see what is written immediately in front of them---that is the prefix
take a screen shot of yours---tables only then post it to verify the prefix...
then we can take it from there
there is a known issue with it not working in chrome but in firefox you should see the lightbox in action.
I would suggest:
1. you ensure the folder items are in their proper place on your server...by manually viewing/comparing the zip to the server
2. all Your_template folders actually are in the server where indicated and renamed to your template name you are using....example mostlygrey template used...name of folder should be mostlygrey, this is to override the default to yours.
3. while verifying...actually upload the files into proper places again...sometimes the internet hiccups and they can get corrupted.
If it is in the admin/configuration section allowing you to set the controls then it may just be a corrupt file.
also--go to the site here>upper navigation panel>addons
find the dibugging tool and install that file into includes/extra_configures
make cache folder permissions set to 777
then try the naughty page, check the cache folder for the error file then post results here AFTER you remove the debug tool file.
Hi Thanks alot Dark Angel
Well I checked the prefix from my phpmyadmin area - I should have copied you - the prefix is zen_
Anyway I changed the code to match your initial one and I got a different error. The screenshots of both phpmyadmin and the error are below. It processed a few statements but not others.
http://directlcdtv.com/prefix.gif
http://directlcdtv.com/sql_error.gif
ok next question...does it show in the admin/configuration section allowing you to change the settings--or is it listed but empty page?
and you are using the default classic theme right?
this is strange
yesterday it showed it in the admin configuration area twice and now that ive taken a look it isnt there.
Yes the classic template - a brand new instalation just to test the modules before adding them to my main site. I have only changed the includes>templates to point to includes>templates>MYTEMPLATE
Your gonna tell me i havnt added the files correctly arnt you? Im just going through them again now
yup
checked all the files and they all look sound - the template is set to MYTEMPLATE and I have added all the files as they were meant to be added
ok bear with me here.
when the folders are called your_template,, they need to be renamed to the name of the template you are using for your shop...the template you are using in your store at this moment...
is is the classic one or is it really a template called MYTEMPLATE
I have done all the below steps of re-installing the mod but still FireFox displays only a blank page. It works perfectly on IE8 though.
I have also installed the debugging tool but I guess no errors were found as there wasn't any error file in /cache/ There was errors earlier but it was from my other mod not uninstalled properly. After I clean that up, no more error was logged and still FireFox is displaying blank.
ok, I tried it in Netscape Navigator 9, Firefox 2 on a macintosh and firefox 3.5.5 on the laptop along with IE8
it does work in ie8 but not in the other browsers.
now for starters the one thing I can think of that may be messing about with FF is the length of the file name:
46b5e453034862df49191c85dd2fb2e1.image.57x120.jpg
try calling it just plain testpromo.jpg
why is it in the cache folder and not in the images folder?
http://lilpixies.com/bmz_cache/4/46b...age.57x120.jpg
try shortening the name, moving it to the stores images folder and see if that makes it behave any different. it might be all those periods in the image name that are the problem too
when you go to admin/configuration/lightbox, do the settings show--all of them?
did you have any errors while installing it?
The original image file is in /images/ and it is named correctly. bmz_cache is Image Handler's cache folder and apparently, there is no way to rename the files - IH2 creates the file name automatically. I have tried renaming - but it will generate another with such long names again. I have asked the creator what is the purpose of bmz_cache - it is where IH2 stores its cached images so that they load faster and in different sizes. I have also tried to change permission on the folder after clearing the cache so that it is not writable but still, FireFox displays only a blank white page.
Yes I believe admin is showing all of the settings - I have attached a screenshot.
I had problems with SQL when installing but have had them fixed. It was the prefixes which was giving me problems.
I was told that Zen Lightbox works perfectly well with IH2 so am not sure where this problem this.
many people use it with IH but many also have trouble with it...my store uses the G2 for images and I have nto hade trouble with the images...just me not naming them right for the additional images to show but that is fine cause i use a work around...lol
aside from totally deleting it, uninstalling it again then reupping the files to re install the sql I have no suggestions more.
{offtopic}
sorry DarkAngel, i had a computercrahs, could not answer you befor. thanks for your repl. but i switched to the 'easy' slimbox version.
this all is way... over my head.
i will however follow this thread.
thank you for your input.
everything is fine, but for the last image of additional images, when click the image it bring you to home page...how can we simply close it?
Hi, help!! lightbox not working at all, installed ok... image shows not in original pop-up but own page. i can't workout what's wrong, ive read tonnes of forum help pages and have to resort to asking for help. Sorry if this has already been solved, if so please direct me to the page, but ive spent hours over 2 days.
I have successfully installed lightbox and it shows in admin/configuration/zen lightbox, before you ask yes i have set 'enable zen lightbox?' to TRUE. -- this was a challenge it itself because the install.sql just errored but i found a version in the forums that installed nicely via admin/tools/install SQL patches
So to set up a picture in catalog/categories/products i have setup so far just 1 test product page. There i set 07400_DET_0.gif and uploaded to /main directory and FTP uploaded, to /images two more pictures 07400_DET_1.gif and 07400_DET_2.gif
I've played around with different file names, different directories for the images but still to no avail.
Thanks
Joe :dontgetit
Zen Cart 1.3.8a
zen lightbox v1.5
www.gerbermulti-tools.com.au (new site - setting up product descriptions and pictures first ie lightbox)
anyone has an idea?
the problem i see is from zen cart structure. when you click on the images, the link on it is http://your_catelog/#, as long as i click the last image, it will open home page...of course...how to make it minimize the pop up instead of go to home page?
Hi can someone help me please. I've not heard from anyone and im completely stuck. BTW i have before set up a lightbox for html know the principal but this just doesn't want to know. Also i don't have any other modules or installs it's a fresh template.
thanks
Joe
No reply needed. Fixed this problem by uninstalling it and starting over with a different program. This time i used SlimBox http://www.zenflavor.com/lightbox-for-zen-cart.html -- which is much more compact and very easy to install and setup!!
and Image Handler 2 http://www.zen-cart.com/index.php?ma...roducts_id=117 - this manages the image in admin/tools
this works nicely and easily just wish id found this 3 days ago!!!!!
Joe
I'll second that, I have used Lightbox on a couple of sites and it worked fine, the one I am currently doing I was experiencing many of the problems mentioned in this thread, and believe me I have read almost all of it trying to find a solution until right near the very end I saw joeharradines post and installed it, no problems, no hassle...
so thanks joe for pointing me there, it's not as customisable but it works and thats all I care about at the end of the day rather than waste so much time on trying to find what the problem is/was. All my previous sites are on the same server, same setup and versions, so for the life of me I cannot and could not find where the problem lay
I just wish I'd started reading the ******* thread backwards from the end LOL :censored::censored::censored:
I'm having the same problem here. Admin > Configuration > Zen Lightbox does not show up.
I have checked and rechecked that my template folders have been named correctly (corresponding to the selected template) and that the file structure is intact. I have manually gone through each folder to make sure the files are there.
Anyone got an idea?
Thanks for your excellent contribution Alex!
Absolute cracker!
I also had a problem executing the sql patch in admin - even after adding the prefix. Came across Dark Angel's post at
http://www.zen-cart.com/forum/showth...146#post818893
followed the advice in that post - and BINGO.
See it in action at www.personalnaturals.com
Frank
:hug: Big thanks to DarkAngel for all your help and support!!
glad it behaved, I also had to install via myphpadmin instead of the store admin.
How do I move the product caption next to the close button at the bottom of the large image to to top?
Thank you in advance.
I'm hoping someone can help me. I am using lightbox on a new site and it was working perfectly until I installed Links Partners. Now Lightbox is not working, I click on the image and it brings up a white box and that is it.
I am using all the recent/latest versions of the zencart and mods.
Please help :smile:
Thank you in advance.
I was thinking that, so have just overwritten all the lightbox files and still not working. I can see all the images on the product listing but when I click to view the larger image, it is just the empty lightbox.
I would link but the site I am working is on a private server that only I have access to.
Should also add that I have uninstalled links partner and that has made no difference so possibly not related? No idea.
No sql files have been changed or altered since I first installed lightbox when it was working perfectly.
Actually I just opened it up in IE and it worked perfectly. So perhaps there is something going on with Chrome?
aha, reading thru all these you would have seen Chrome be not playing nice with lightbox...so yes it is chrome and not the other addon.
now there is a tool in the addon section that is really helpful, especially when any browser is giving you a blank page...debug rror logging tool
get it and follow the directions of where to place it and it will let you know what is being naughty...not sure it will help with chrome issue but...
I need help with the initial installation. The Instructions say to upload the entire content of the include folder to the server. However I am not sure where on the server to upload the folder to. Is it going inside the includes folder on the server?
Unfortunately that is the mistake many mod creators do, they tell the person to upload all files to the server BUT they forget the novice that knows not to do that as written...it may overwrite things of not work at all.
what you do is open the zip containing all your files.
using ftp navigate to the exact same folders showing in the zip and putting the file into the exact same folder on the server.
any folder called custom or your_template is actually to be placed into a folder in that location with the name of your template you are using...for instance if you use mostlygrey then [[if there is not one in the folder you need it to be]] create a folder with that name then plop the file into it.
in the templates folder you need to plop those files into you templates folder
then run the SQL if there is one to do after making certain you add the prefix to your database tables to it.
sorry if this confuses you.
Have installed this mod and it all seems to be working ok except...the 'close' button to close the image is not showing at all so is confusing for some customers who have rang me to ask how to close the image ! does anyone know why this button isnt appearing and how to make it show
Thanks
Daisy
Hi Daisy,
did you upload the images to your templates folder?
Dark Angel, thanks for the speedy reply.Let me see if I understand you correctly. Inside the zip are five folders. one for example is called languages. So through FTP, I have gone to my site/includes/languages. And then inside this language folder on the server is where Im putting the new language folder from the zip? Or am I replacing the languages folder on the server with the new one from the zip file?
Also, Im using the template default. So it looks like this: /public_html/mysite/includes/templates/template_default/
So just like the previous question, the new template_default from the zip drive replaces the old one on the server or does it go inside the old template default on the server?
if you are placing the one from the lightbox in there then yes you may be replacing the entire folder
that is why i said to open both server files in ftp and then open the zipp folders on your desktop and drop only the files into the server...but in the corresponding folder.
I never did use the default so I think that they should go into the classic template folder...but like I said only the files into the proper folders already there.
Ok so I believe I have done that. Now I get this error when I try to install the sql file in Admin > Tools > Install SQL Patches
1146 Table 'sac2126_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.
Im sorry this is the first time doing this and I have no clue what Im doing. Im just trying to follow the directions.
Has anyone solved the Chrome problem with Light box? - I'm running 1.3.8a with lightbox 1.5, and getting a white screen instead of the image. I know there's been a few posts on this but I couldn't seem to find any details on what might be causing it.
@megetweh
Is this: sac2126_zc1 the prefix to your tables?
when you look at the tables in myphpadmin...is that what is seen before the table name? like some is zen_ or zc1_
and don't worry, new at this or not we all sometimes have trouble and errors while following the steps....lol
Now if this is your prefix to the tables then installing the SQL through myphpadmin's sql section
comartdw@ cableone.net
without the space feel free to email me if you need further hands on help
I uploaded the images to the 'buttons' folder of my template as that is where it said they go should I put them straight into my images folder?
Hi guys sorry I know this is all over the forum but keep getting stuck.
Okay so I have uploaded all the files for the light box def in the right places, but I cant seem to get the install.sql to upload.
I have uploaded the jscript_zen_lightbox.php to the /public_html and the /public_html/store and then gone to admin install sql patches, select the file upload, but all I get is,
1146 Table 'elfefcom_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.
assuming I need to create a new file, but where and what should it be called.
would really appreciate your guys help on this,
thanks
Owain