Zen Lightbox addon [Support Thread]

[anshii]

I too have problems installing the install SQL patch on via both Admin and Database.

Error message from admin: 1146 Table 'anshii80_IC_20091104_062332.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.

I have also tried using the patch given below directly into the DB, this was what I got:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Make sure your prefix is added correctly, add your prefis to the tables where the red zen is shown.

Check to see if it shows in the admin/configuration and if it does then run the uninstaller first before trying to install again.

Aslo if it does not work from admin section (mine did not) then go directly to the database and copy/paste the sql installer there:

INSERT INTO `zen_configuration_group` VALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1');
UPDATE `zen_configuration_group` SET `sort_order` = LAST_INSERT_ID() WHERE `configuration_group_id` = LAST_INSERT_ID();

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

INSERT INTO `zen_configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES