Zen Lightbox addon [Support Thread]

[soxophoneplayer]

Trying to install Zen Lightbox 1.6.4. onto zc 1.5.1. Original site 1.3.9h. I upgraded database to zc 1.5.1, then clean install of the file set and started adding updated versions of the mods. So far, Canada Post, Column Grid, Product Attribute Grid, IH4, each tested and running. And now Lightbox. This is a test site only, WAMP, Windows 7. Apache 2.2.11. Php 5.3. MySql 5.1.36

I wasn't able to load the sql either by cut and paste or via PhpMyAdmin paster or import. Running uninstall didn't help before or after. So I deleted all the lightbox statements from the database config and config groups.

Then, I was able to get the first part of the sql in via phpMyAdmin, but not the last statement:

INSERT INTO `admin_pages` (`page_key` ,`language_key` ,`main_page` ,`page_params` ,`menu_key` ,`display_on_menu` ,`sort_order`)VALUES 
('configZenLightbox', 'BOX_CONFIGURATION_ZEN_LIGHTBOX', 'FILENAME_CONFIGURATION', CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);

I tried with and without zen_ prefix on 'admin pages'. I get an error message:

#1048 - Column 'page_params' cannot be null

The lightbox actually works, but there is a blank configuration page in the admin.

Seached forum and googled to no avail. I see one fellow with similar prob solved by reinstalling but I've tried this several times. Any thoughts?

[DarkAngel]

Trying to install Zen Lightbox 1.6.4. onto zc 1.5.1. Original site 1.3.9h. I upgraded database to zc 1.5.1, then clean install of the file set and started adding updated versions of the mods. So far, Canada Post, Column Grid, Product Attribute Grid, IH4, each tested and running. And now Lightbox. This is a test site only, WAMP, Windows 7. Apache 2.2.11. Php 5.3. MySql 5.1.36

I wasn't able to load the sql either by cut and paste or via PhpMyAdmin paster or import. Running uninstall didn't help before or after. So I deleted all the lightbox statements from the database config and config groups.

Then, I was able to get the first part of the sql in via phpMyAdmin, but not the last statement:

INSERT INTO `admin_pages` (`page_key` ,`language_key` ,`main_page` ,`page_params` ,`menu_key` ,`display_on_menu` ,`sort_order`)VALUES 
('configZenLightbox', 'BOX_CONFIGURATION_ZEN_LIGHTBOX', 'FILENAME_CONFIGURATION', CONCAT('gID=',@cgi), 'configuration', 'Y', @cgi);

I tried with and without zen_ prefix on 'admin pages'. I get an error message:



The lightbox actually works, but there is a blank configuration page in the admin.

Seached forum and googled to no avail. I see one fellow with similar prob solved by reinstalling but I've tried this several times. Any thoughts?

You upgraded to 1.5.1 and while you were in the database did you check to see if admin pages table was created

[soxophoneplayer]

Thanks for your reply.

while you were in the database did you check to see if admin pages table was created

It was created but there was nothing in the two columns :'page params', and 'sort', both of which has @cgi in the query. I went thru the individual config lines as well and found that the Lightbox status was missing the column with @cgi in the query.

I tried crude hack by editing in numbers in place of the @cgi values to match or sequence what looked like a pattern in the tables to my untrained eye. My edited queries were accepted without error message, but the config page is still blank in the store.

So all the queries are present in the admin pages, configuration and group configuration, but with the 3 hacks as mentioned above, AND the only way I could get them accepted was to split the total sql file into 3 segements.

I have no clue what @cgi means - just happened to notice that it was a common thing to the errors I was getting.

[DarkAngel]

in my test store with zen lightbox the database shows as this:

1	page_key	varchar(32)	utf8_general_ci		No
2	language_key	varchar(255)	utf8_general_ci		No
3	main_page	varchar(64)	utf8_general_ci		No
4	page_params	varchar(64)	utf8_general_ci		No
5	menu_key	varchar(32)	utf8_general_ci		No
6	display_on_menu	char(1)	utf8_general_ci		No
7	sort_order	int(11)		No

in the part where you actually see all the info mine has the glD= with a number after it.

see if yours has the same numbers as mine in your database, that last one should say No at the end of page_params

was this a new update or an upgrade?

if upgrade did you make sure to remove all the files from the previous version of lightbox

[soxophoneplayer]

I show the same as your chart. For the gID I put =31, and the other numbers in the table went from 1 - 30; and I put the sort as 26 because the other sort numbers in the table went to 25.

I did an upgrade to the database but with a clean set of zc 1.5.1 files. I added my override folders, which had assorted customizations of my own template and also from other mods. I went thru the over ride files and removed mod files, and merged my custom template files; then started adding back in some mods that have have been cleared for 1.5.

On the database I went through and deleted old IH3 and Lightbox lines. However, I missed the admin pages query as I didn't know it was there. I tried a a few unsuccessful installs, then uninstalled. Then when I discovered the admin pages, there were 4 Lightbox queries in there - one for each of my failed attempts. So I deleted those and tried to install that last section of the sql file dealing with admin pages. It went in but with the errors as described earlier.

My data base is the same one I've had since zen 1.3.7; I've updated the db with each update of the files. I wonder if there's too much residual crud in there and maybe I should be starting from (ugh) scratch. This is the first time I've actually dared poke around in the phpMyAdmin and I may be in over my head ;o( The data base I'm playing with hasn't been live for a few years, but I've duplicated my actions when moving to live site from test site each time. ie. I can ditch the test db and just make a few products to test with, but I'll still have to update the live db eventually so I'm hoping to solve this as I pick away at it.

[DarkAngel]

i accidently install mine about 4 times in the beginning and found I had to do an uninstall sql for each one to get rid of them. I really can't tell you what may be the problem, cause it should show in admin section if all the files have been uploaded, check to see if the one in admin folder is living in includes/languages/english/extra_definitions/zen_lightbox.php

that one may be there so upload it again, overwriting the one there, might have gotten corrupt somehow.

[soxophoneplayer]

I've been able to get it sorted. I have no idea why, as I tried this a few times early on unsuccessfully.

I ran another uninstall and reinstall, cutting and pasting into the myPhpAdmin sql box. In the uninstall I added zen_ prefix in 3 places, and in install I added the prefix in 4 places.

I did the install in one complete piece and this time it worked, where it failed on previous attempts. When earlier attempts to insert the entire file I was able to insert it in 3 sections without error message, but with the result of the config page refusing to appear in my store.

It seems the install sql doesn't like to be broken into sections, so I conclude I should have just kept uninstalling and installing the complete thing until it played nice.

Thanks for encouraging me along Dark Angel!

[DivaVocals]

I've been able to get it sorted. I have no idea why, as I tried this a few times early on unsuccessfully.

I ran another uninstall and reinstall, cutting and pasting into the myPhpAdmin sql box. In the uninstall I added zen_ prefix in 3 places, and in install I added the prefix in 4 places.

I did the install in one complete piece and this time it worked, where it failed on previous attempts. When earlier attempts to insert the entire file I was able to insert it in 3 sections without error message, but with the result of the config page refusing to appear in my store.

It seems the install sql doesn't like to be broken into sections, so I conclude I should have just kept uninstalling and installing the complete thing until it played nice.

Thanks for encouraging me along Dark Angel!

A few things..

If you run the install SQL as written from myPhpAdmin (as opposed to the SQL installer in the Zen Cart admin as suggested in the installation instructions), you will add these database entries incorrectly. The script as written is meant to be run from the Zen Cart admin SQL installer which will correctly add the proper table prefixes as needed. If you choose to run it from myPhpAdmin you will need to edit the SQL file to insert the table prefixes where required.

If you broke the install SQL into sections and ran it like that (versus running the entire install.sql file) that would be why it didn't correctly create the database entries. Breaking up the install file could have possibly removed the variable declaration in the early part of the install SQL. That variable declaration is used in later parts of the install SQL. The install SQL should be run in it's ENTIRETY not in segments.

[DarkAngel]

I've been able to get it sorted. I have no idea why, as I tried this a few times early on unsuccessfully.

I ran another uninstall and reinstall, cutting and pasting into the myPhpAdmin sql box. In the uninstall I added zen_ prefix in 3 places, and in install I added the prefix in 4 places.

I did the install in one complete piece and this time it worked, where it failed on previous attempts. When earlier attempts to insert the entire file I was able to insert it in 3 sections without error message, but with the result of the config page refusing to appear in my store.

It seems the install sql doesn't like to be broken into sections, so I conclude I should have just kept uninstalling and installing the complete thing until it played nice.

Thanks for encouraging me along Dark Angel!

No problem at all. I am like a dog with a bone chipping away until it behaves....but still sometimes it wins...lol

Like Diva said it should be run from admin section, with that said I always had problems running scripts from admin and this one did the same thing to me when I first installed it with 1.3.7 or 1.3.8, can't remember which. I had to add the "zen_" prefix and then had to run the uninstaller several times and manually remove files then do it all again from database until it finally behaved.

Occasionally still I get a stubborn install, but it behaves later on. I have even had to wait a few days before trying it again..

[DivaVocals]

No problem at all. I am like a dog with a bone chipping away until it behaves....but still sometimes it wins...lol

Like Diva said it should be run from admin section, with that said I always had problems running scripts from admin and this one did the same thing to me when I first installed it with 1.3.7 or 1.3.8, can't remember which. I had to add the "zen_" prefix and then had to run the uninstaller several times and manually remove files then do it all again from database until it finally behaved.

Occasionally still I get a stubborn install, but it behaves later on. I have even had to wait a few days before trying it again..

Since v1.3.9 installing scripts from the admin should not be an issue.. It is the right way to install this add-ons script and it needs to be run all at once not in bite sized chunks..