Zen Lightbox addon [Support Thread]

[uncharted]

Thank you

[leon76]

Hi guys.

I'm installing lightbox in 1.5.0.

I followed the readme.html, changed what was asked to change and uploaded the folders.
Now, when I try to execute the SQL patch, the error appears:

"WARNING: An Error occurred, please refresh the page and try again."

What can be wrong?

[leon76]

Hi guys.

I'm installing lightbox in 1.5.0.

I followed the readme.html, changed what was asked to change and uploaded the folders.
Now, when I try to execute the SQL patch, the error appears:

"WARNING: An Error occurred, please refresh the page and try again."

What can be wrong?

SOLVED

There was an error in install.sql.

I ran the script in phpmyadmin and the error was clear, there wasn't a table "configuration_group". Neither the rest of the tables in that script.
They were all missing the "zen_" prefix.
Changed it and ran it and it worked.

[DivaVocals]

SOLVED

There was an error in install.sql.

I ran the script in phpmyadmin and the error was clear, there wasn't a table "configuration_group". Neither the rest of the tables in that script.
They were all missing the "zen_" prefix.
Changed it and ran it and it worked.

Not an error in the install.sql file.. This issue was where you ran it..

If you had used the SQL installer in your store's admin (Admin > Tools > Install SQL Patches) to run the install.sql file (and NOT phpMyAdmin) you would not have had this issue..

(plus if this was an issue in the install.sql file, a LOT MORE folks would be reporting the problem..)

[leon76]

Not an error in the install.sql file.. This issue was where you ran it..

If you had used the SQL installer in your store's admin (Admin > Tools > Install SQL Patches) to run the install.sql file (and NOT phpMyAdmin) you would not have had this issue..

(plus if this was an issue in the install.sql file, a LOT MORE folks would be reporting the problem..)

I did ran it first in the store's admin, but the error returned didn't help, as I told earlier.

phpMyAdmin was my second choice, but provided more info about the error. At least this time I knew what was wrong and changed whatever was needed.

[DivaVocals]

I did ran it first in the store's admin, but the error returned didn't help, as I told earlier.

phpMyAdmin was my second choice, but provided more info about the error. At least this time I knew what was wrong and changed whatever was needed.

And if you are running the install in phpMyAdmin, you WOULD need to add the table prefix..

The Zen Cart log file would have told you EXACTLY what went wrong in your SQL install.. (along with the error message an error log is created)

Bottomline is that for a normal install (running hte SQL from the store admin) adding the table prefix is not necessary..

[Fehfeh]

I just installed this after upgrading to 1.50 but the next/prev buttons would not work, and the config panel was missing quite a few options. I have a fresh zen-cart, but using my old DB. My solution was to run the uninstall SQL and then rund the install (instead of just the upgrade, as my previous lightbox settings was still in the old db). Could be worth mentioning in the readme!