Zen Lightbox addon [Support Thread]

[kobra8]

End get message:

1146 Table 'kavanali_zencart.configuration_group' doesn't exist
in:
[SELECT @cgi := configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Zen Lightbox';]


What to do?
Please help!

[niestudio]

End get message:

1146 Table 'kavanali_zencart.configuration_group' doesn't exist
in:
[SELECT @cgi := configuration_group_id FROM configuration_group WHERE configuration_group_title = 'Zen Lightbox';]


What to do?
Please help!

We've discussed this quite a bit recently, see if this post helps you

[kobra8]

We've discussed this quite a bit recently, see if this post helps you

Hi, I do everiting what write in thet post end I get message in my ZC admin, see picture. What is thet?

[niestudio]

Hi, I do everiting what write in thet post end I get message in my ZC admin, see picture. What is thet?

Did you follow the part to open [includes/configure.php] and look for the line

define('DB_PREFIX', 'yourPrefixHere_');

if so what did the part in red say?

daniel

[kobra8]

Did you follow the part to open [includes/configure.php] and look for the line

define('DB_PREFIX', 'yourPrefixHere_');

if so what did the part in red say?

daniel

The part in red is:
define('DB_PREFIX', 'zen_');

[elaineben]

do i have to change the configure.php to the one noted...like zen instead of znc? i am confused.

i will check again the stylesheets and the installation i made if i forgot something. thanks for all your help.

[DarkAngel]

do i have to change the configure.php to the one noted...like zen instead of znc? i am confused.

i will check again the stylesheets and the installation i made if i forgot something. thanks for all your help.

you need to change the sql installation file to have that as part of the coding for it to work or go to myphpadmin for installing directly into the database if you can't get it to work in admin of store

there are 4 places to change---see in red

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

[niestudio]

The part in red is:
define('DB_PREFIX', 'zen_');

Did you copy and paste the install script into zc admin or use the upload button?

Other users have had better luck with copy/paste.

[DivaVocals]

Did you copy and paste the install script into zc admin or use the upload button?

Other users have had better luck with copy/paste.

I NEVER use upload.. Only copy/paste.. Works every time..

you need to change the sql installation file to have that as part of the coding for it to work or go to myphpadmin for installing directly into the database if you can't get it to work in admin of store

Should be NO reason why anyone would need to manually modify this script and run it in phpAdmin.. That said making the changes you suggest will only work if you run if you are running the script in phpAdmin.. If you add the prefix as you suggest and run the script in the store admin, the script will fail or cause errors.

[kobra8]

Did you copy and paste the install script into zc admin or use the upload button?

Other users have had better luck with copy/paste.

I have copy and paste the install script into zc admin.