Zen Lightbox addon [Support Thread]

[DarkAngel]

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.

[DBB1]

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

[FONT="Courier New"]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.[/FONT]

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.

[DBB1]

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!

[DarkAngel]

....
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

[Alex Clarke]

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

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.

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.

[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?

[cowboyfred]

FOUI= For Other Users Info.

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. Thanks for the info and help. now to test it out on the site.

[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!

[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.

[Alex Clarke]

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/showpo...postcount=1240

It may prove helpful.

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