Zen Lightbox addon [Support Thread]

[raspberryjamcloth]

Hi. I am having trouble running the SQL file to install this addon. This is the error I receive when I try to execute the script:

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

"cwyshop" is the name of my database and the prefix for my Zen Cart tables is "zen_"

I've tried adding "zen_" to the front of of the table names but still get an error and in the end only 4 statements get executed.

Does anyone know what's wrong?

-------------------------

Er, nevermind. I found a code oin one of the previous pages, tried it, and it worked. Weird because I had copied and pasted the sql file exactly.

Anyway, now I have 3 "Zen Lightbox"s under Configuration. The only one that works is the third one. How do I remove the first two?

I am getting the same error. May I ask what code you entered to make it work?

[crosswithyou]

I am getting the same error. May I ask what code you entered to make it work?

Hi. This is what I used:
http://www.zen-cart.com/forum/showth...198#post512198

Unfortunately the mod still doesn't seem to be working.

HELP SOMEONE!

Lightbox is turned on but my images still load in a new window. Also, if I turn it off, my additional images get messed up. Like, if you click on an additional image, it just loads the base image. If it's on then the correct image loads but it's not in a lightbox. This seems to be some kind of conflict with Image Handler 2.

Anyone know what's up with this?

[crosswithyou]

Was able to remove those extra two "Zen Lightbox" options from my Configuration menu by deleting the entries in the database, btw. Just need Lightbox to actually work now...

[Alex Clarke]

Was able to remove those extra two "Zen Lightbox" options from my Configuration menu by deleting the entries in the database, btw. Just need Lightbox to actually work now...

I've just read your last few posts.

The SQL code that you ran (which someone else linked to from an old post) was code only to be used with v1.4 and not the latest release.

You will need to successfully install the new SQL code in order to get Zen Lightbox to work.

First run the uninstall.sql code (via Zen Cart Admin). Then, run the install.sql code.

Please post back any errors you received here. I'll then be able to troubleshoot this further for you.

[crosswithyou]

I've just read your last few posts.

The SQL code that you ran (which someone else linked to from an old post) was code only to be used with v1.4 and not the latest release.

You will need to successfully install the new SQL code in order to get Zen Lightbox to work.

First run the uninstall.sql code (via Zen Cart Admin). Then, run the install.sql code.

Please post back any errors you received here. I'll then be able to troubleshoot this further for you.

Hi. I successfully uninstalled Lightbox. This is the error I get when I copy and paste the install.sql stuff and execute it:

1146 Table 'cwyshop.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'm running ZenCart 1.3.8a on PHP 5.2.6 and MySQL client version 5.0.16.


Now with Lightbox uninstalled, my additional images are only loading the base image when clicked on. Is this a problem created by Lightbox or Image Handler 2?

[raspberryjamcloth]

is the table name zen_configuration_group ?? If so I can post what I put in.

[raspberryjamcloth]

Hi. This is what I used:
http://www.zen-cart.com/forum/showth...198#post512198

Unfortunately the mod still doesn't seem to be working.

HELP SOMEONE!

Lightbox is turned on but my images still load in a new window. Also, if I turn it off, my additional images get messed up. Like, if you click on an additional image, it just loads the base image. If it's on then the correct image loads but it's not in a lightbox. This seems to be some kind of conflict with Image Handler 2.

Anyone know what's up with this?

I got it to take the code thank you!! Now I am off to see if it is working.

[Anna718]

I am also running Image Handler 2 and the lightbox worked fine first time. Not really possible for there to be any conflict.

[raspberryjamcloth]

I am still getting pop ups. I am not running Image Handler.

www.raspberryjamcloth.com


Where do I put jscript_zen_lightbox.php ?

[Alex Clarke]

I am still getting pop ups. I am not running Image Handler.

www.raspberryjamcloth.com


Where do I put jscript_zen_lightbox.php ?

Is this the file that was in the root of the v1.5 release? If so, that's only to be used if you want to enable Zen Lightbox on extra pages of your website (i.e. the contact_us page).

I've checked your wesite and it appears that you have not run the install.sql code.

Please run the uninstall.sql code followed by the install.sql code.

Let me know how you get on!