Totally Zenned
- Join Date:
- May 2007
- Location:
- SW Florida
- Posts:
- 1,062
- Plugin Contributions:
- 1
Zen Lightbox addon [Support Thread]
DarkAngel:
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_groupVALUES (NULL, 'Zen Lightbox', 'Configure Zen Lightbox settings', '0', '1');
UPDATEzen_configuration_groupSETsort_order= LAST_INSERT_ID() WHEREconfiguration_group_id= LAST_INSERT_ID();SELECT @cgi :=
configuration_group_idFROMzen_configuration_groupWHEREconfiguration_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
HI 'DarkAngel
I have done this a dozen times and have never experienced this much trouble. I checked my db with phpmyadmin and I did truely use the zen_ prefix. I edited the install.sql file as above and I cut n pasted in SQL patch and it tells me at the tables zen_ do not exist.
ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration does not exist. CHECK PREFIXES!
From phpMyadmin I selected the db, went to querry and pasted the contents into the query box and I get:
#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 'UPDATE
zen_configuration_groupSETsort_order= LAST_INSERT_ID() WHERE `conf' at line 12
Not a clue as to why this is not working......
JOhn ><>