Zen Lightbox addon [Support Thread]

[DarkAngel]

Ok, I made the install.sql into a text file by renaming it to install.txt and then ran it in the query and it worked!!

I just hope that it hasn't messed anything up with soemthing else.

Do you know if it should affect anything else in the database?

Thanks again!

Sincerely,

Jes...

glad it worked. it should only add the function to the datbase and show the controls in configuration ---it shouldn't mess with anything else...just be careful when adding another add-on...keep the lightbox unzipped on your hard drive or in a cd/external hard drive...somewher for safe kepping. So you can check to make sure that the new add-on does not overwrite a file that lightbox installed.

the easy way to have installed it would have been open the sql installer in a text editor like notepad++ then copy the contents go to the SQL tab and paste it into the window then click ok to install it.

It should work how you did it too especialy if it shows in configuration now.

[DarkAngel]

Hi all
I am just puzzled with why i cannot use the lightbox contribution after installing seo urls. I wan't both the contributions to work together. My site is located at lustrejewel.
Any suggestions would be appreciated

I don't have that add-on installed so check both installer folders and see if there are any files that are exactly the same name...it might be one overwrote the other.

if there are you may need to merge the two files to create a new one to upload..

[ginamiller40]

If anyone out there could help me...that would be great. I have tried to install zen lightbox and uploaded everything I was supposed to with my template name, etc. Then copy/pasted the install into admin / install sql patches and hit send...then I get the following message:

des1005809423242.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 I go to admin zen light box....there is no choices there...it's empty..ugh


Am I doing something wrong? Can't quite figure out what the problem is....everything was uploaded.

Thanks,
Gina

[DarkAngel]

If anyone out there could help me...that would be great. I have tried to install zen lightbox and uploaded everything I was supposed to with my template name, etc. Then copy/pasted the install into admin / install sql patches and hit send...then I get the following message:

des1005809423242.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 I go to admin zen light box....there is no choices there...it's empty..ugh


Am I doing something wrong? Can't quite figure out what the problem is....everything was uploaded.

Thanks,
Gina

run the uninstaller the same way you did the installer then make sure it does not show in the configuration again.

then go to your myphpadmin and to the database...copy/paste the installer into the SQL tab window...hit go and it should install from there

some of us could not install from the admin section either and got it to work only from myphpadmin

[ginamiller40]

run the uninstaller the same way you did the installer then make sure it does not show in the configuration again.

then go to your myphpadmin and to the database...copy/paste the installer into the SQL tab window...hit go and it should install from there

some of us could not install from the admin section either and got it to work only from myphpadmin

Thanks DarkAngel...I'll give it a go. :) Hopefully it will work for me.

[ginamiller40]

well It won't work that way either...I'm confused now. I just went into myphpadmin area and tried to install there in the SQL area but now I'm getting this error message:

SQL query:

/** * 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 said:

#1146 - Table 'des1005809423242.configuration_group' doesn't exist


anyone know what this means?
Thanks,
Gina

[ginamiller40]

well It won't work that way either...I'm confused now. I just went into myphpadmin area and tried to install there in the SQL area but now I'm getting this error message:

SQL query:

/** * 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 said:

#1146 - Table 'des1005809423242.configuration_group' doesn't exist


anyone know what this means?
Thanks,
Gina

Well now I've just completely screwed up my shop...ugh. Not even there anymore....i'm so ticked I must have deleted something I shouldn't have. Thats what I'm thinking now. I'm ready to pull my hair out now. What a day.

[DarkAngel]

Well now I've just completely screwed up my shop...ugh. Not even there anymore....i'm so ticked I must have deleted something I shouldn't have. Thats what I'm thinking now. I'm ready to pull my hair out now. What a day.

step away from the store...it will only aggravate you more.

take a deep breath....and if you please:

go to myphpadmin and take a screenshot of the tables for your store and post here

you said you must have removed something...did you delete files?, if not then there is just a glitch and hopefully this is not a live store.

can you still get into admin section

[Eyecube-Art]

I installed Zen Lightbox 1.5, but it does not work ..and it's there in "categories" tab (admin area), but is just blank when I click on it!?. I tried several times to uninstall and reinstall the sql but fails the same again. I use ZC 1.3.8a and IH2 to upload my images..plz help!


4 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

[DarkAngel]

I installed Zen Lightbox 1.5, but it does not work ..and it's there in "categories" tab (admin area), but is just blank when I click on it!?. I tried several times to uninstall and reinstall the sql but fails the same again. I use ZC 1.3.8a and IH2 to upload my images..plz help!


4 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

Make sure your tables do not have a prefix or if the do then add it to the installer sql code.

1. open both your server files and the lightbox zip then compare to make sure each file is in its proper place

2. if you have not done it again, run the uninstaller from admin again to uninstall it from the database

3. open myphpadmin from your sites/server control panel and try running the installer through the SQL tab

see if that helps