Zen Lightbox addon [Support Thread]

[PUREchocolatetruffle]

I think its the same problem as chrome and FF4, your ZLB site is not working in those browsers either.
try backing up and update to ZLB 1.6

Hi Dark Angel and Niestudio.

Many thanks for your help and advice. I've done what you said. ran the uninstall sql file and uninstalled my old ZLB.
However, neither the ZLB 1.6 install or upgrade sgl will work.
I get the error messages:

SQL-forespørgsel:

/** * 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 `configuration_group`
VALUES (

NULL , 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1'
);



MySQL returnerede:

#1046 - No database selected

OR

1146 Table 'purechocolate_IC_XXXXXXXXXXXXX.configuration_group' doesn't exist
in:
[/** * Zen Lightbox * * @author Daniel Hopkins (daniel [dot] niestudio [at] gmail [dot] com) * @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: upgrade.sql 2011-01-21 aclarke $ */ 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've looked into my zen_configuration and found that the error might be there. I just don't know how to correct it. Have a look at the attached file. Thanks in advance.

Kim

[DivaVocals]

We were just talking about this a few posts back yesterday..

DON'T run this script using phpMyAdmin.. Here's what I posted yesterday about installing this script.

[FONT=Verdana]The best way to avoid this error is to NOT run the install script via phpMyAdmin, but to open the install.sql file and copy/paste it into the form on the Tools > Install SQL Patches from the shop admin.. This will properly add the table pre-fixes to the script as it runs.[/FONT]

Hi Dark Angel and Niestudio.

Many thanks for your help and advice. I've done what you said. ran the uninstall sql file and uninstalled my old ZLB.
However, neither the ZLB 1.6 install or upgrade sgl will work.
I get the error messages:

SQL-forespørgsel:

/** * 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 `configuration_group`
VALUES (

NULL , 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1'
);



MySQL returnerede:

#1046 - No database selected

OR

1146 Table 'purechocolate_IC_XXXXXXXXXXXXX.configuration_group' doesn't exist
in:
[/** * Zen Lightbox * * @author Daniel Hopkins (daniel [dot] niestudio [at] gmail [dot] com) * @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: upgrade.sql 2011-01-21 aclarke $ */ 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've looked into my zen_configuration and found that the error might be there. I just don't know how to correct it. Have a look at the attached file. Thanks in advance.

Kim

[PUREchocolatetruffle]

DivaVocals, I do listen and that's what I did first. Only when it didn't work I went to PhPMyAdmin.
The only sql patch that works at the moment is the uninstall. There I don't get any error messages.

Kim

[DivaVocals]

DivaVocals, I do listen and that's what I did first. Only when it didn't work I went to PhPMyAdmin.
The only sql patch that works at the moment is the uninstall. There I don't get any error messages.

Kim

What error messages do you get when you run the install.sql?? (unmodified as it comes with ZLB)

[PUREchocolatetruffle]

What error messages do you get when you run the install.sql?? (unmodified as it comes with ZLB)

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


Does it give any sense to you ? Not me :-(

Kim

[DivaVocals]

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


Does it give any sense to you ? Not me :-(

Kim

It actually does.. you are missing a table according to the error message

[niestudio]

It actually does.. you are missing a table according to the error message

Hi PUREchocolatetruffle,
following up on DivaVocals earlier suggestion.
If you still have the original ZLB zip file you downloaded (if not then re-download it) unzip again it so you know you have a totally fresh install.sql file.
open install.sql in a text editor:
mac - TextEdit
windows - notepad

highlight all of the text in the file and then copy it.
go to the zen cart admin > tools > install sql patches

paste the contents of the install.sql file you copied here.
click send and cross your fingers

hopefully this will work for you.