Zen Lightbox addon [Support Thread]

How did you do it?

Quote:

---

Originally Posted by 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.

---

Finally got the SQL correct, thanks for the great contribution :smile:

I have tested on both FireFox 3.5.6 and Chrome - both only showed white page without image. Hence I would assume this is not universally applicable or is there anything to be changed in the coding?

Quote:

---

Originally Posted by DarkAngel

my guess is that since chrome is so "new" still it is like opera started out...dicey...lol

I have a customer also that just emailed me as to why she could not see the lightbox and that all she got is a white page.

found out she is using chrome so informed her of the problem.

it is something coded into chrome I would assume...has anyone tried using it at other sites that may use some sort of lightbox?

the creator has not been in for a long time so not sure if they are working on it or have quit working on their add on.

---

Hello,

I seen some posts already with this issue but cannot seem to find a solution for mine. I am running 1.3.8a, lightbox 1.5, my own created theme (i didnt make any modifications to it yet, just set it up from scratch), no addons yet besides this, new install.

When I click on the image, it does not come up in a light box, it just opens in a new page (same window).

All folders are named properly... not sure what it is. Please PM me and I will give you my development address.

Thanks,
-A

Quote:

---

Originally Posted by 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

---

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

Quote:

---

Originally Posted by abs007

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

Quote:

---

Originally Posted by anshii

Finally got the SQL correct, thanks for the great contribution :smile:

I have tested on both FireFox 3.5.6 and Chrome - both only showed white page without image. Hence I would assume this is not universally applicable or is there anything to be changed in the coding?

---

there is a known issue with it not working in chrome but in firefox you should see the lightbox in action.

I would suggest:

1. you ensure the folder items are in their proper place on your server...by manually viewing/comparing the zip to the server

2. all Your_template folders actually are in the server where indicated and renamed to your template name you are using....example mostlygrey template used...name of folder should be mostlygrey, this is to override the default to yours.

3. while verifying...actually upload the files into proper places again...sometimes the internet hiccups and they can get corrupted.

If it is in the admin/configuration section allowing you to set the controls then it may just be a corrupt file.

also--go to the site here>upper navigation panel>addons

find the dibugging tool and install that file into includes/extra_configures

make cache folder permissions set to 777

then try the naughty page, check the cache folder for the error file then post results here AFTER you remove the debug tool file.

Hi Thanks alot Dark Angel

Well I checked the prefix from my phpmyadmin area - I should have copied you - the prefix is zen_

Anyway I changed the code to match your initial one and I got a different error. The screenshots of both phpmyadmin and the error are below. It processed a few statements but not others.

http://directlcdtv.com/prefix.gif
http://directlcdtv.com/sql_error.gif

ok next question...does it show in the admin/configuration section allowing you to change the settings--or is it listed but empty page?

and you are using the default classic theme right?

this is strange
yesterday it showed it in the admin configuration area twice and now that ive taken a look it isnt there.

Yes the classic template - a brand new instalation just to test the modules before adding them to my main site. I have only changed the includes>templates to point to includes>templates>MYTEMPLATE

Your gonna tell me i havnt added the files correctly arnt you? Im just going through them again now

yup
checked all the files and they all look sound - the template is set to MYTEMPLATE and I have added all the files as they were meant to be added