Zen Lightbox addon [Support Thread]

[Crunch]

I'm desperatly wanting to install this mod to my site, but I'm just worried about running into problems. I can see that people are getting errors when they run the SQL script (with cut and paste) because they need to add something somewhere. So my question is what needs to be put into the SQL script, and where?

The prefix for my tables is 'zen_'

Backup your Zen Cart database before running this SQL patch.

Your database prefix should only have to be added to SQL statements when installing contribution SQL patches from phpMyAdmin. This isn't the preferred method.

It's recommended to run the SQL from the Zen Cart admin "Install SQL patches" as you do not need to use your database prefix (Zen Cart already knows about it - if your configure.php files are setup correctly).

Open the install.sql file in a plain text editor, highlight and copy all the text inside the file. Go into your Zen Cart admin > Tools > Install SQL Patches and paste what you copied into the query box and click Send.

NOTE: I believe many problems encountered are due to attempting to upload the actual install.sql file instead of copying and pasting the text inside.