Zen Lightbox addon [Support Thread]

[Asdesign]

Can you link me up to your site so I can check it out myself?...

[manage-it]

Lightbox 1.5 installed on v1.38a with Image handler 2.0
Lightbox is not working in internet explorer.
Firefox works fine.

Please help

[DarkAngel]

http://fantasiesrealm.com/market/

lightbox 1.5 running on zencart 1.38a, I am not using image handler but the G2 I think is what it is called

[kobra8]

Hi, I install the contributions Zen Lightbox v1.5 on ZC 1.3.8.
When I install.sql file (Admin > Tools > Install SQL Patches) in your Zen Cart admin end clik SEND, I get mesage:


1146 Table 'C251393_zencart.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.


???????

[kobra8]

More:
I get mesage:
1146 Table 'C251393_zencart.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.
.................
Clik BECK.
now I have in:
Admin > Configuration > Zen Lightbox (triplet Zen Lightbox )!

Zen Lightbox
Zen Lightbox
Zen Lightbox


I have: Image Handler2
!!!!!!!! help !!!!!!!!!!!

[DarkAngel]

what you need to do first is run the uninstall sql to get rid of the tables in your database that it created...they are no good check admin to make sure the duplicates are gone and repeat for each one that remains til they are all gone.

then go to your database and make certain you have written the prefix to your tables correctly...


some start with:
zencart_
zen_
shoppe_
store_
zc_

see what is the first part of the table and that is what you need to write in front of the first few places in the sql before you try to install it.

make certain you have your files in the right spots too

[kobra8]

what you need to do first is run the uninstall sql to get rid of the tables in your database that it created...they are no good check admin to make sure the duplicates are gone and repeat for each one that remains til they are all gone.

then go to your database and make certain you have written the prefix to your tables correctly...


some start with:
zencart_
zen_
shoppe_
store_
zc_

see what is the first part of the table and that is what you need to write in front of the first few places in the sql before you try to install it.

make certain you have your files in the right spots too

Hi, I lnstall meny contributions/addons end I install.SQL with not problem!
Now when I wont to install thet SQL it don't work.
In SQL my Table is: zen_configuration_group
when I change in file from configuration_group in zen_configuration_group still don't work!

Note: when I install 'instal.SQL' from contributions in Admin end clik SEND getting mesage:

1146 Table 'C251393_zencart.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 clik BACK in brouser, in admin panel go in configuration end I see Zen Lightbox, I clik on.
End when I go in Zen Lightbox only see:
Title Value Action
end noting else!

What is wrong

[DarkAngel]

this is the only part of the SQL that you need to change---the red words only:

The key things, are:

INSERT INTO `zen_configuration_group`
UPDATE `zen_configuration_group`
FROM `zen_configuration_group`

The things in red MUST match the wording in your database.

You dont want to rename:

SELECT @cgi := `configuration_group_id`

to:

SELECT @cgi := `zen_configuration_group_id`

Is that the only places you added the prefix to...I do understand your frustration, I too have installed many mods but this one is picky to the max...lol

I had just as much trouble when I did mine too and I had to install the SQL through my database asmin panel NOT the store admin

[kobra8]

this is the only part of the SQL that you need to change---the red words only:

The key things, are:

INSERT INTO `zen_configuration_group`
UPDATE `zen_configuration_group`
FROM `zen_configuration_group`

The things in red MUST match the wording in your database.

You dont want to rename:

SELECT @cgi := `configuration_group_id`

to:

SELECT @cgi := `zen_configuration_group_id`

Is that the only places you added the prefix to...I do understand your frustration, I too have installed many mods but this one is picky to the max...lol

I had just as much trouble when I did mine too and I had to install the SQL through my database asmin panel NOT the store admin

I do thet you write end nothing, geting mesage:

1054 Unknown column 'zen_configuration_group_id' in 'field list'
in:
[INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, zen_configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Zen Lightbox', 'ZEN_LIGHTBOX_STATUS', 'true', '
If true, all product images on the following pages will be displayed within a lightbox:

- document_general_info
- document_product_info
- page (EZ-Pages)
- product_free_shipping_info
- product_info
- product_music_info
- product_reviews
- product_reviews_info
- product_reviews_write

.............................

Can you please tell my hay did you install the SQL through your's database asmin panel NOT the store admin.

[cdnbride]

this is the only part of the SQL that you need to change---the red words only:

The key things, are:

INSERT INTO `zen_configuration_group`
UPDATE `zen_configuration_group`
FROM `zen_configuration_group`

The things in red MUST match the wording in your database.

You dont want to rename:

SELECT @cgi := `configuration_group_id`

to:

SELECT @cgi := `zen_configuration_group_id`

Is that the only places you added the prefix to...I do understand your frustration, I too have installed many mods but this one is picky to the max...lol

I had just as much trouble when I did mine too and I had to install the SQL through my database asmin panel NOT the store admin

Okay hello I am new at this and installed my first mod yesterday with success and to my surprise so I too would love to get my 2nd mod installed without too much confusion.
I have two questions with respect to lightbox ... first, because I'm still learning I followed the install directions very literally which maybe I shouldn't have. Was I supposed to copy the "includes" folder the whole folder to my includes folder or was I supposed to open it and copy over each folder in their prospective folders in my store?? Either way I've done it both ways, I'm just curious as to which is the right way.
Second, I am not sure how to find out what the correct wording is in my database, the one that is being refered to in the last post in red. Is there some where specific that I can look at and know for sure what I should be putting in there? I've tried a few combinations but none have worked. My SQL database is named cdnbridal_zc1, would that be what I put in there?

I would love to get some feedback and hopefully get this working before tomorrow

Cheers!
Cdnbride