Zen Lightbox addon [Support Thread]

[timmyneal]

Success...but only after a lot of experimentation. I wont go into all the details, but what you suggested did not work for me. After running several modified install attempts based on the errors I was getting, I finally figured out the only thing I needed to change in the script was the SELECT command line to insert the zen_ prefix. The script was run directly from the SQL Query Executor box.

SELECT @cgi := `configuration_group_id` FROM `configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';
was changed to:

SELECT @cgi := `configuration_group_id` FROM `zen_configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';

I think I could safely say that if someone runs the unmodified script, and gets the following error, then the fix above should work...but I'll leave that to those more experienced to confirm.

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

[DarkAngel]

thanks for the info, many have had trouble and many have been aided with the info I and others have given and it is my realization that no two places will have the same mistake all the time...I know I have since installed this on several stores now with no trouble what so ever, yet on my own it pitched a fit.

[timmyneal]

Yes...I appreciate all the help folks from this forum have given me while getting my site configured. There is no way I could have gotten as far as I have without folks like you. You're a great bunch. I thank you all.

Tim