Zen Lightbox addon [Support Thread]

fdisk42:

I guess that would help, wouldn't it? lol.

http://dominionleatherwerks.com

I use the Dragon template. I did run the install sql script. And it does show up in admin.

I'm sure Ive just missed something, just can't figure out what.

well looking at your source code there is not the .css file showing.

When you uploaded it you took the files from the zips folder and put them in the exact same fodlers on your server, right?

Did you upload the admin folder files too?

When you click the lightbox link in admin do you get the options?

I think maybe your files went into a different spot than they are supposed to go or got corrupted on the way up.

fdisk42:

I guess that would help, wouldn't it? lol.

http://dominionleatherwerks.com

I use the Dragon template. I did run the install sql script. And it does show up in admin.

I'm sure Ive just missed something, just can't figure out what.
Short answer is that you have NOT installed this incorrectly. Viewing your page source I can see that none of the template overwrites that are needed for this add-on to work are in place.. Please re-read the readme file.. Pay close attention to the handling of the files that are in the YOUR_TEMPLATE folders.. It doesn't look like you have any of these files in the proper locations.

Thanks guys, I'll dfouble check my install and try installing again just to make sure. I'll let you know if I get it working or not.

Ok, I figured it out. I had copied over all of the files to the correct folders but I forgot to rename the TEMPLATE folder. I copied the ZL stuff into my Dragon template folder and now it works. Thanks again for the help folks. I knew it was something easy that I was missing.

Hi there, I had lightbox working but sometime ago it must have stopped working. When you clicked to enlarge an image the white box appeared on my site and the screen darkened but no image or even the next/previous/exit buttons appeared. There was no way to exit out of this except to reload the homepage.

When I searched for the lightbox item in the admin>configuration file it wasn't there so I reinstalled the install.sql file which gave me the following error:

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

so I used the uninstall.sql file which ran successfully and the normal browser popup appears when the enlarge image option is selected.

Any ideas on what the error message means?

I'm using lightbox v1.5 because I'm running Zen Cart 1.3.8a Patch: 1::Database Patch Level: 1.3.8 on PHP Version 5.2.17

Thanks for any help provided.

Trying to install Zen Lightbox 1.6.4. onto zc 1.5.1. Original site 1.3.9h. I upgraded database to zc 1.5.1, then clean install of the file set and started adding updated versions of the mods. So far, Canada Post, Column Grid, Product Attribute Grid, IH4, each tested and running. And now Lightbox. This is a test site only, WAMP, Windows 7. Apache 2.2.11. Php 5.3. MySql 5.1.36

I wasn't able to load the sql either by cut and paste or via PhpMyAdmin paster or import. Running uninstall didn't help before or after. So I deleted all the lightbox statements from the database config and config groups.

Then, I was able to get the first part of the sql in via phpMyAdmin, but not the last statement:

INSERT INTO `admin_pages` (`page_key` ,`language_key` ,`main_page` ,`page_params` ,`menu_key` ,`display_on_menu` ,`sort_order`)VALUES 
('configZenLightbox', 'BOX_CONFIGURATION_ZEN_LIGHTBOX', 'FILENAME_CONFIGURATION', CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);

I tried with and without zen_ prefix on 'admin pages'. I get an error message:

#1048 - Column 'page_params' cannot be null

The lightbox actually works, but there is a blank configuration page in the admin.

Seached forum and googled to no avail. I see one fellow with similar prob solved by reinstalling but I've tried this several times. Any thoughts?

soxophoneplayer:

Trying to install Zen Lightbox 1.6.4. onto zc 1.5.1. Original site 1.3.9h. I upgraded database to zc 1.5.1, then clean install of the file set and started adding updated versions of the mods. So far, Canada Post, Column Grid, Product Attribute Grid, IH4, each tested and running. And now Lightbox. This is a test site only, WAMP, Windows 7. Apache 2.2.11. Php 5.3. MySql 5.1.36

I wasn't able to load the sql either by cut and paste or via PhpMyAdmin paster or import. Running uninstall didn't help before or after. So I deleted all the lightbox statements from the database config and config groups.

Then, I was able to get the first part of the sql in via phpMyAdmin, but not the last statement:

INSERT INTO admin_pages (page_key ,language_key ,main_page ,page_params ,menu_key ,display_on_menu ,sort_order)VALUES
('configZenLightbox', 'BOX_CONFIGURATION_ZEN_LIGHTBOX', 'FILENAME_CONFIGURATION', CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);

> 
> I tried with and without zen_ prefix on 'admin pages'.   I get an error message:
> 
> 
> 
> The lightbox actually works, but there is a blank configuration page in the admin.
> 
> Seached forum and googled to no avail.  I see one fellow with similar prob solved by reinstalling but I've tried this several times. Any thoughts?

You upgraded to 1.5.1 and while you were in the database did you check to see if admin pages table was created

Thanks for your reply.

while you were in the database did you check to see if admin pages table was created

It was created but there was nothing in the two columns :'page params', and 'sort', both of which has @cgi in the query. I went thru the individual config lines as well and found that the Lightbox status was missing the column with @cgi in the query.

I tried crude hack by editing in numbers in place of the @cgi values to match or sequence what looked like a pattern in the tables to my untrained eye. My edited queries were accepted without error message, but the config page is still blank in the store.

So all the queries are present in the admin pages, configuration and group configuration, but with the 3 hacks as mentioned above, AND the only way I could get them accepted was to split the total sql file into 3 segements.

I have no clue what @cgi means - just happened to notice that it was a common thing to the errors I was getting.

in my test store with zen lightbox the database shows as this:

in the part where you actually see all the info mine has the glD= with a number after it.

see if yours has the same numbers as mine in your database, that last one should say No at the end of page_params

was this a new update or an upgrade?

if upgrade did you make sure to remove all the files from the previous version of lightbox

I show the same as your chart. For the gID I put =31, and the other numbers in the table went from 1 - 30; and I put the sort as 26 because the other sort numbers in the table went to 25.

I did an upgrade to the database but with a clean set of zc 1.5.1 files. I added my override folders, which had assorted customizations of my own template and also from other mods. I went thru the over ride files and removed mod files, and merged my custom template files; then started adding back in some mods that have have been cleared for 1.5.

On the database I went through and deleted old IH3 and Lightbox lines. However, I missed the admin pages query as I didn't know it was there. I tried a a few unsuccessful installs, then uninstalled. Then when I discovered the admin pages, there were 4 Lightbox queries in there - one for each of my failed attempts. So I deleted those and tried to install that last section of the sql file dealing with admin pages. It went in but with the errors as described earlier.

My data base is the same one I've had since zen 1.3.7; I've updated the db with each update of the files. I wonder if there's too much residual crud in there and maybe I should be starting from (ugh) scratch. This is the first time I've actually dared poke around in the phpMyAdmin and I may be in over my head ;o( The data base I'm playing with hasn't been live for a few years, but I've duplicated my actions when moving to live site from test site each time. ie. I can ditch the test db and just make a few products to test with, but I'll still have to update the live db eventually so I'm hoping to solve this as I pick away at it.

i accidently install mine about 4 times in the beginning and found I had to do an uninstall sql for each one to get rid of them. I really can't tell you what may be the problem, cause it should show in admin section if all the files have been uploaded, check to see if the one in admin folder is living in includes/languages/english/extra_definitions/zen_lightbox.php

that one may be there so upload it again, overwriting the one there, might have gotten corrupt somehow.

I've been able to get it sorted. I have no idea why, as I tried this a few times early on unsuccessfully.

I ran another uninstall and reinstall, cutting and pasting into the myPhpAdmin sql box. In the uninstall I added zen_ prefix in 3 places, and in install I added the prefix in 4 places.

I did the install in one complete piece and this time it worked, where it failed on previous attempts. When earlier attempts to insert the entire file I was able to insert it in 3 sections without error message, but with the result of the config page refusing to appear in my store.

It seems the install sql doesn't like to be broken into sections, so I conclude I should have just kept uninstalling and installing the complete thing until it played nice.

Thanks for encouraging me along Dark Angel!

soxophoneplayer:

I've been able to get it sorted. I have no idea why, as I tried this a few times early on unsuccessfully.

I ran another uninstall and reinstall, cutting and pasting into the myPhpAdmin sql box. In the uninstall I added zen_ prefix in 3 places, and in install I added the prefix in 4 places.

I did the install in one complete piece and this time it worked, where it failed on previous attempts. When earlier attempts to insert the entire file I was able to insert it in 3 sections without error message, but with the result of the config page refusing to appear in my store.

It seems the install sql doesn't like to be broken into sections, so I conclude I should have just kept uninstalling and installing the complete thing until it played nice.

Thanks for encouraging me along Dark Angel!
A few things..

If you run the install SQL as written from myPhpAdmin (as opposed to the SQL installer in the Zen Cart admin as suggested in the installation instructions), you will add these database entries incorrectly. The script as written is meant to be run from the Zen Cart admin SQL installer which will correctly add the proper table prefixes as needed. If you choose to run it from myPhpAdmin you will need to edit the SQL file to insert the table prefixes where required.

If you broke the install SQL into sections and ran it like that (versus running the entire install.sql file) that would be why it didn't correctly create the database entries. Breaking up the install file could have possibly removed the variable declaration in the early part of the install SQL. That variable declaration is used in later parts of the install SQL. The install SQL should be run in it's ENTIRETY not in segments.

soxophoneplayer:

I've been able to get it sorted. I have no idea why, as I tried this a few times early on unsuccessfully.

I ran another uninstall and reinstall, cutting and pasting into the myPhpAdmin sql box. In the uninstall I added zen_ prefix in 3 places, and in install I added the prefix in 4 places.

I did the install in one complete piece and this time it worked, where it failed on previous attempts. When earlier attempts to insert the entire file I was able to insert it in 3 sections without error message, but with the result of the config page refusing to appear in my store.

It seems the install sql doesn't like to be broken into sections, so I conclude I should have just kept uninstalling and installing the complete thing until it played nice.

Thanks for encouraging me along Dark Angel!

No problem at all. I am like a dog with a bone chipping away until it behaves....but still sometimes it wins...lol

Like Diva said it should be run from admin section, with that said I always had problems running scripts from admin and this one did the same thing to me when I first installed it with 1.3.7 or 1.3.8, can't remember which. I had to add the "zen_" prefix and then had to run the uninstaller several times and manually remove files then do it all again from database until it finally behaved.

Occasionally still I get a stubborn install, but it behaves later on. I have even had to wait a few days before trying it again..

DarkAngel:

No problem at all. I am like a dog with a bone chipping away until it behaves....but still sometimes it wins...lol

Like Diva said it should be run from admin section, with that said I always had problems running scripts from admin and this one did the same thing to me when I first installed it with 1.3.7 or 1.3.8, can't remember which. I had to add the "zen_" prefix and then had to run the uninstaller several times and manually remove files then do it all again from database until it finally behaved.

Occasionally still I get a stubborn install, but it behaves later on. I have even had to wait a few days before trying it again..Since v1.3.9 installing scripts from the admin should not be an issue.. It is the right way to install this add-ons script and it needs to be run all at once not in bite sized chunks..

I am using Zen Cart 1.5.1 and I have just installed Zen Cart. I am using a template with some other modules and this is the first install of Light Box I cannot show my website as I am just building it and is only on localhost.

The problem I have is that I can only show one image via the light box. All other images are opened in a new window. How to open multiple images in the light box?

I have named them as such:

widget.jpg
widget_1.jpg

Did you try re-uploading the additional images file.

Yes and they're all in the images folder.

I don't mean the images themselves, I mean the file [includes/modules/your_template/additional_images.php]

Wow, that worked. It seems fine now. Thanks!