Zen Lightbox addon [Support Thread]

[DarkAngel]

@dimascus:

go to your database and take a screenshot of your tables...nothing else is needed just the actual tables. post it here and then we can take it from there.

@Robert_nz:

this doesn't touch your pages it just adds a few files.

did you install it or someone else
is it showing in admin/configuration
any error messages when installed
what themplate is used in store

link to store would be helpful for the ones with even more experience

PS: guys, I did not create this little mod, I love it and even though I do not have the additional images like all others do I just give advice for the same things I have gone thru with the installation and making it behave. I wish I had created it....but tips to my paypal are still accepted...lol <---just kidding

Happy Holidays <---that part is serious.

[Dimascus]

Thanks for your help and time DarkAngel and sorry, I read it wrong. I meant to say thanks to the original creator... :\

@dimascus:

go to your database and take a screenshot of your tables...nothing else is needed just the actual tables. post it here and then we can take it from there.


PS: guys, I did not create this little mod, I love it and even though I do not have the additional images like all others do I just give advice for the same things I have gone thru with the installation and making it behave. I wish I had created it....but tips to my paypal are still accepted...lol <---just kidding


Happy Holidays <---that part is serious.

[DarkAngel]

well the prefix is right so next question...

are you attempting to install from the store admin section or the database

[abs007]

Hi Darkangel
Thanks for the reply - Im still a little confused as to what I need to change. I understand that I need to change the red areas which you highlighted however what should I be changing them to.

Im sorry if this is a kind of dumb question but am kind of lost

thanks

[DarkAngel]

@abs007:

there is no such thing as a dumb question except the one you keep to yourself. If we all knew exactly what to do then we would not be here helping each other...lol

1. you need to look at your database (see the one that is pictured in the above post) to see what your prefix (the part in red of my post) to your tables is.

2. that is what you replace my red words with.

Then after you fix your install file you upload it either through the database or through store admin section.

@Dimascus:

yay you got it done!!!


@abs007:

the only problem is that not everyone has the same prefix to their database tables. Which seems to be the main part of the problems found here. plus like me, I could not get it to install from the store admin section, I had to install it via the database

[abs007]

@abs007:

there is no such thing as a dumb question except the one you keep to yourself. If we all knew exactly what to do then we would not be here helping each other...lol

1. you need to look at your database (see the one that is pictured in the above post) to see what your prefix (the part in red of my post) to your tables is.

2. that is what you replace my red words with.

Then after you fix your install file you upload it either through the database or through store admin section.

@Dimascus:

yay you got it done!!!


@abs007:

the only problem is that not everyone has the same prefix to their database tables. Which seems to be the main part of the problems found here. plus like me, I could not get it to install from the store admin section, I had to install it via the database

Hi dark angel
thank you ever so much for your help. I still can not manage to get it to work. Heres wht I did

I replaced all the red coding in your previous post to my database so it reads

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

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

INSERT INTO `abs007_zc4_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


This is the error that I am getting

1146 Table 'abs007_zc4.abs007_zc4_configuration_group' doesn't exist
in:
[SELECT @cgi := configuration_group_id FROM abs007_zc4_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.

not too sure what im doing wrong. I got the database name from my configure.php file

thanks

[DarkAngel]

not too sure what im doing wrong. I got the database name from my configure.php file

thanks

That may be the trouble...

you wrote:abs007_zc4_configuration_group

I think that it should read: zc4_configuration_group

what you entered is the database name but not the table prefix, this is why I ask everyone to take a screen shot of the database tables.

when you go to your mysql manager (myPhpadmin for some) you will see the name of the database in the list (if you have more than one database), clicking the name will show you all the tables in a list

look at the tables and see what is written immediately in front of them---that is the prefix

take a screen shot of yours---tables only then post it to verify the prefix...

then we can take it from there

[Dimascus]

Right from the admin. I havent wanted to try the database yet as many people still have the same problem. How would even put it in the DB myself?



Thanks again.

well the prefix is right so next question...

are you attempting to install from the store admin section or the database

[Dimascus]

Got it working finally... 1 thing was missing for some reason in my sql code. It works now... what a headache... lol

Thanks for all your time DarkAngel.

[anshii]

How did you do it?

Got it working finally... 1 thing was missing for some reason in my sql code. It works now... what a headache... lol

Thanks for all your time DarkAngel.