Zen Lightbox addon [Support Thread]

my info is a couple of pages back and like many others when doing the sql I got the same error that the others did when inserting it in the ZenCart Admin section.

I did however insert it into the database via MySQL by adding the prefix for my tables but I still have nothing in the admin section for settings.

What can I do, oh I did recheck for the millionth time (it feels that way...lol) to make sure all the files are in the correct place and all former version should not still be hiding either.

What else is there for me to do...as I said the lightbox feature works but no settings to be found on the page in admin section...and yes have verified the tables are in the database.

disregard my post I got it to show in the admin panel.

1. went into server and deleted everything again from the uploading of files and made sure all old version was gone too.

2. ran the uninstaller from MyphpAdmin

3. uploaded new files once more to proper places

4. Ran the sql installer from MyphpAdmin by adding the prefix_ infront of the main parts and it said it installed successfully

went into admin for my store and lo and behold there are the admin setting to change if need be.

hope that helps someone else...I forgot to mention that no matter what I did the admin section would not let me insert the sql coding at all.

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

I got this problem too....

yup, this is probably the case of some path invalid or smth.

TS, may want to relook at the code

• i query into the mysql via the Zencart DB interface, but still doesnt work.
  let me know again once your are done, for now, i will uninstalled it.

it shoudl be zen. NOT netkompa_zc4

Alex Clarke:

Hi Ameet,

You've got a few errors on your site. I recommend that you fix these. Try installing Firefox and using the FireBug addon to locate the problems.

An existing contribution that's installed may be causing a conflict with Zen Lightbox here.

Can you list all the contributions you have installed please?

Thanks,

Alex

Hi Alex

Thanks for getting back to me. We actually had a company do the site for us. So i am a bit clueless on what errors I am looking for .. Are these related to Zen Lightbox you have encountered? Or otherwise. Can you point in a direction that i can check on firebug. I just installed it and was trying to figure out what to look for.

I have installed personally the following contributions. I am not sure if they had installed any previously as well. I know we have he Testimonial manager, Banner Manager and wish list as some of the features on the site.

Google Analytics
Advanced Cross Sell
Zen Cart Lightbox

Any pointers would be great.

Ameet

knobbery:

Hi Alex

Thanks for getting back to me. We actually had a company do the site for us. So i am a bit clueless on what errors I am looking for .. Are these related to Zen Lightbox you have encountered? Or otherwise. Can you point in a direction that i can check on firebug. I just installed it and was trying to figure out what to look for.

I have installed personally the following contributions. I am not sure if they had installed any previously as well. I know we have he Testimonial manager, Banner Manager and wish list as some of the features on the site.

Google Analytics
Advanced Cross Sell
Zen Cart Lightbox

Any pointers would be great.

Ameet

Alex, Also looks like I see some mention of Slim Lightbox in some of the scripts when i use the Firebug, But i cannot see it in the Config Menu's

Ameet

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

Is netkompa_zc4 the name of the table?

or is zc4 the prefix to the tables through the entire netkompa database? If yes then leave that part off

I will write here the first part of the sql so that I can color code what I did via the myphpadmin and sql section there. If at all possible do the changes to your sql installation doc that came with the lightbox then install the sql info thru myphpadmin by copy --paste into the window it provides.

that is how I got it to work. if you removed the files then return them to the server...check your store admin section to make sure you do not have the lightbox shown in the admin section cause each time we try to add the sql thru the zen admin it creates a link in there that is useless.

If you have those then you will need to find them in the database and delete those.

This is the main first section of the sql installer file:

[b]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[b]

Change yours to be the table prefix where the words are red. then "save as" your file as "install2.sql" without the quotation marks so that you know it is the doctored file.

The go to myphpadmin and click the sql tab for your table and paste the info into it and tell it to install.

It should work now...I say should because sometimes things still wont behave themselves.

Like several others, I had errors running the SQL script from within the ZCart admin panel. The error that was returned was:

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

When reviewing the SQL script, I noticed that the table prefixes were not included, so I edited it to include mine ('gf_,' not 'zen_'). I ran the script again and got further along, but when it returned me to the admin panel, there were additional errors listed at the top of the screen indicating that some insertions were successful, but others were not. It referred me to the 'upgrade_exception' table for details, but it was empty.

Having run the script twice, it left me with two instances of "Zen Lightbox" entries in the Configuration drop-down, both of which - when selected - only showed the column headings of Title, Value, and Action. Like DarkAngel's post a few pages back, nothing else was present (I was able to remove the second entry by editing the tables directly, but again, Lightbox is not working; my ZC demo images still display in a pop-up window).

I also have ImageHandler2 installed, and am current with ZC v1.3.8.

My question is twofold:

-Firstly, how does one go about undoing changes made by running this SQL script? I saw a post that said that you use the same script, but do you use a "remove from" instead of an "insert into," or what? It wasn't overly apparent if one had not performed this action before...

-Does anyone have a working script that has been edited to include table prefixes? I would like to alter it to match my prefixes, and hopefully get this thing running. I did see a post of a working script to use, but it was posted at the first of the year, and most likely for Lightbox 1.4, so I was hesitant to try it.

Thanks for any assistance anyone can provide me.

DarkAngel:

Is netkompa_zc4 the name of the table?

or is zc4 the prefix to the tables through the entire netkompa database? If yes then leave that part off

I will write here the first part of the sql so that I can color code what I did via the myphpadmin and sql section there. If at all possible do the changes to your sql installation doc that came with the lightbox then install the sql info thru myphpadmin by copy --paste into the window it provides.

that is how I got it to work. if you removed the files then return them to the server...check your store admin section to make sure you do not have the lightbox shown in the admin section cause each time we try to add the sql thru the zen admin it creates a link in there that is useless.

If you have those then you will need to find them in the database and delete those.

This is the main first section of the sql installer file:

[b]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[b]

Change yours to be the table prefix where the words are red. then "save as" your file as "install2.sql" without the quotation marks so that you know it is the doctored file.

The go to myphpadmin and click the sql tab for your table and paste the info into it and tell it to install.

It should work now...I say should because sometimes things still wont behave themselves.

Thank you, DarkAngel!

You must have just posted while I was creating mine...

I used your edited script and changed it to match mine. Thing is, your table prefixes were in the same places where I had made my edits. The only difference for me this time, was that I used the phpMyAdmin to execute the query on the database, and not from the ZC admin panel.

At any rate, Lightbox seems to be working, and I have configuration options now!

Thanks, again!

DBB1:

....
My question is twofold:

-Firstly, how does one go about undoing changes made by running this SQL script? I saw a post that said that you use the same script, but do you use a "remove from" instead of an "insert into," or what? It wasn't overly apparent if one had not performed this action before...

look at the database and delete the parts there--via myphpadmin

-Does anyone have a working script that has been edited to include table prefixes? I would like to alter it to match my prefixes, and hopefully get this thing running.

again look above your post, I wrote down the first section of the script, just change what is in red and upload the saved file ( change the sections on your file), save and upload thru myphpadmin for it to work

Thanks for any assistance anyone can provide me.

you are welcome and I am on yahoo right now if you want to reach me for the little help I can be: dragonheart612

Could the following 2 users post their MySQL version information here please?

DarkAngel:

disregard my post I got it to show in the admin panel.

1. went into server and deleted everything again from the uploading of files and made sure all old version was gone too.

2. ran the uninstaller from MyphpAdmin

3. uploaded new files once more to proper places

4. Ran the sql installer from MyphpAdmin by adding the prefix_ infront of the main parts and it said it installed successfully

went into admin for my store and lo and behold there are the admin setting to change if need be.

hope that helps someone else...I forgot to mention that no matter what I did the admin section would not let me insert the sql coding at all.

newfu:

I got this problem too....

yup, this is probably the case of some path invalid or smth.

TS, may want to relook at the code

• i query into the mysql via the Zencart DB interface, but still doesnt work.
  let me know again once your are done, for now, i will uninstalled it.

Alex my info is:

i am running zencart 1.3.8a
mysql is 5.051a community
php version 4.4.8(zend:1.3.0)
php on server is 5.2.6

is that what you wanted to know?

FOUI= For Other Users Info.

DarkAngel:

Is netkompa_zc4 the name of the table?

or is zc4 the prefix to the tables through the entire netkompa database? If yes then leave that part off

I will write here the first part of the sql so that I can color code what I did via the myphpadmin and sql section there. If at all possible do the changes to your sql installation doc that came with the lightbox then install the sql info thru myphpadmin by copy --paste into the window it provides.

that is how I got it to work. if you removed the files then return them to the server...check your store admin section to make sure you do not have the lightbox shown in the admin section cause each time we try to add the sql thru the zen admin it creates a link in there that is useless.

If you have those then you will need to find them in the database and delete those.

This is the main first section of the sql installer file:

[b]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[b]

Change yours to be the table prefix where the words are red. then "save as" your file as "install2.sql" without the quotation marks so that you know it is the doctored file.

The go to myphpadmin and click the sql tab for your table and paste the info into it and tell it to install.

It should work now...I say should because sometimes things still wont behave themselves.

i had the same install problem and followed the above steps and it worked. :clap: Thanks for the info and help. now to test it out on the site.

Well, I was a bit quick to state that Lightbox was working (see previous posts).

When using the demo DVD images that came with the ZenCart install, I get varying results, depending on the browser being used.

Yesterday when I originally posted, I was using the latest version of Firefox. The Lightboxed image was a small one (ZenCart demo images), but the "CLOSE" and "NEXT/PREVIOUS" tags were overlaying and obscuring the actual image, and the product description was word-wrapped vertically. I thought that Lightbox would auto-size depending on the image size or description length, but this doesn't appear to be the case. I played with all the settings, but with no luck.

Today, I tried using InternetExplorer, v7.0.x. Mostly, I get the lightbox with no image, but sometimes I'll get just a white box in the middle of the screen, with no darkening of the background. A mouse click to the screen will then cause the background to darken, but again, no image.

Anyone else see these types of behaviors, or found a way to address them?

This seems to be a very slick contribution, but it's looking like it may not play well with other add-ons and/or environments.

Thanks!

DBB1:

Well, I was a bit quick to state that Lightbox was working (see previous posts).

When using the demo DVD images that came with the ZenCart install, I get varying results, depending on the browser being used.

Yesterday when I originally posted, I was using the latest version of Firefox. The Lightboxed image was a small one (ZenCart demo images), but the "CLOSE" and "NEXT/PREVIOUS" tags were overlaying and obscuring the actual image, and the product description was word-wrapped vertically. I thought that Lightbox would auto-size depending on the image size or description length, but this doesn't appear to be the case. I played with all the settings, but with no luck.

Today, I tried using InternetExplorer, v7.0.x. Mostly, I get the lightbox with no image, but sometimes I'll get just a white box in the middle of the screen, with no darkening of the background. A mouse click to the screen will then cause the background to darken, but again, no image.

Anyone else see these types of behaviors, or found a way to address them?

This seems to be a very slick contribution, but it's looking like it may not play well with other add-ons and/or environments.

Thanks!

I grabbed some screen shots to illustrate my last post:

Firefox:

IE:

As mentioned with IE, I occasionally have to click on the screen somewhere after the empty lightbox appears, in order for the background shading to take effect.

DarkAngel:

Alex my info is:

i am running zencart 1.3.8a
mysql is 5.051a community
php version 4.4.8(zend:1.3.0)
php on server is 5.2.6

is that what you wanted to know?

That's the stuff. :)

I'll be testing the install.sql code soon to find out it works for some people, but not others.

In the meantime, anyone having trouble running the install.sql code should review the following post.

http://www.zen-cart.com/forum/showpost.php?p=662273&postcount=1240

It may prove helpful.

DBB1:

Well, I was a bit quick to state that Lightbox was working (see previous posts).

When using the demo DVD images that came with the ZenCart install, I get varying results, depending on the browser being used.

Yesterday when I originally posted, I was using the latest version of Firefox. The Lightboxed image was a small one (ZenCart demo images), but the "CLOSE" and "NEXT/PREVIOUS" tags were overlaying and obscuring the actual image, and the product description was word-wrapped vertically. I thought that Lightbox would auto-size depending on the image size or description length, but this doesn't appear to be the case. I played with all the settings, but with no luck.

Today, I tried using InternetExplorer, v7.0.x. Mostly, I get the lightbox with no image, but sometimes I'll get just a white box in the middle of the screen, with no darkening of the background. A mouse click to the screen will then cause the background to darken, but again, no image.

Anyone else see these types of behaviors, or found a way to address them?

This seems to be a very slick contribution, but it's looking like it may not play well with other add-ons and/or environments.

Thanks!

Thanks for your feedback.

In my opinion, the button overlay behaviour isn't really an issue. Most people display larger images in the lightbox, not ones of the same size.

However, the caption behaviour isn't really ideal. I'll see if this can be improved in a later release.

As for the blank lightbox issue, do you have link to this test site? If so, please PM it to me and I'll take a closer look.

Regards,

Alex

Hello,

First off, this is a great addon!

I'm trying to find out if there is a way to not show the next / prev buttons on the image, until you mouse over that particular area.

I've tried overriding the CSS and created a #lbPrevLink:hover to change the background image, but that doesn't work. Been searching all over the forums and haven't found anything.

I am on ZenCart 1.3.8 and using Zen Lightbox 1.5.

Thanks!

I'm having a problem. I have 1.3.8a and IH2, I installed 1.5 light box and my hover over image disappeared. IH2 pop up box is now a new window. No light box pop up. Sql installed. Anyone else have this problem?

i tried everything below and ended up with this set of errors:

4 statements processed.

ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!

ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!

ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!

ERROR: Cannot execute because table zen_configuration does not exist. CHECK PREFIXES!

Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

DarkAngel:

disregard my post I got it to show in the admin panel.

1. went into server and deleted everything again from the uploading of files and made sure all old version was gone too.

2. ran the uninstaller from MyphpAdmin

3. uploaded new files once more to proper places

4. Ran the sql installer from MyphpAdmin by adding the prefix_ infront of the main parts and it said it installed successfully

went into admin for my store and lo and behold there are the admin setting to change if need be.

hope that helps someone else...I forgot to mention that no matter what I did the admin section would not let me insert the sql coding at all.

GOT IT!
made this slight change and ran it through again...

SELECT @cgi := `configuration_group_id` FROM `[B]zen[/B]_configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';
```> **dni:**
>
> i tried everything below and ended up with this set of errors:
> 
> 4 statements processed.           
> 
> ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES! 
> 
> ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
> 
> ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES! 
> 
> ERROR: Cannot execute because table zen_configuration does not exist. CHECK PREFIXES! 
> 
> Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.