Zen Lightbox addon [Support Thread]

badger64:

Hi All
I'm new to zen and I have installed the lastest ver 1.3.8a..
I have uploaded this mod and checked that all files had tranfered properly also changed the relevent folder names But when I come to do the sql install I get this error message...

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

I copyed and pasted it in the sql section in admin and sent it and got the above error back, I also tried the other way by browsing for the file and uploading it but I still get the same error. Has anybody got any ideas wot the problem might be. many thx in advance.

Rgds
Badger

when you are in the database (phpmyadmin) and click on the page to see all the tables of your database is this what is listed just before the table:

maz786_zc1 or is it just a zc1

Hi DarkAngel

Its maz786_zc1 and there are (97) tables in total.

Thx for the reply. :smile:

Rgds
Badger

could you please post a screenshot of the database tables --- no other info just the first few tables is fine and hopefully it won't be too small and let us see it well.

There u go hope this helps thx.

badger64:

There u go hope this helps thx.

yes it did sweety,

as I suspected the name of your database is the part that ends with zc1 but the tables are not that prefix...they should be the zen_

that is what is directly in front of the name of each individual table.

try your code with the zen_ as the prefix. post back with results...try in admin and if it doesn't work then try database sql tab

thanks

Hi DarkAngel

Sorry took so long lost the thread don't come up in my user cp for some unknown reason. anyway..

I'm confused now because all the tables are already showing the zen_ prefix at the front in screenshot so I'm not sure wot you mean ?? sorry

Rgds

what i mean is in the code you copy/pasted to install the SQL you must enter zen_ prefix in 4 different areas prior to pasting it into either admin or phpmyadmin for installation.

that is why it was telling you that you did not have that table...you were using the database name NOT the prefix to the tables.

these are the first 8 lines of the sql installer and in read is where you must insert the zen_ prefix:

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

Hi DarkAngel

Thx very much for that, I understand now you put it that way. The reason for the zen prefix was because it was one of the free scripts offered but my hosting company and if you chose it it gets installed automatically for you. so what I did was download the package myself and uploaded it via ftp and now it works great thankyou very much for your help. loving this script more and more each day. excellent job done by all thankyou. :hug:

Best Regards
Badger64

badger64:

Hi DarkAngel

Thx very much for that, I understand now you put it that way. The reason for the zen prefix was because it was one of the free scripts offered but my hosting company and if you chose it it gets installed automatically for you. so what I did was download the package myself and uploaded it via ftp and now it works great thankyou very much for your help. loving this script more and more each day. excellent job done by all thankyou. :hug:

Best Regards
Badger64

huggies are always welcome...lol

sometimes it just takes explaining something in plain simple english..sometimes I tend to get too simple with an explanation but it helps.

glad you got it to work, i love lightbox totally and coupled with image handler2 is wonderful.

I'm getting this error message when installing the sql (into the zen sql input box).

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 configuration_group SET sort_order = LAST_INSERT_ID() WHERE configuration' at line 11
in:

I'm using zen 1.3.8a

php 5.2.13

MySQL client version: 5.1.30

I've used this same script on other carts on this same server I don't understand why the problem now. Any ideas?

thanks
BB

when you copy paste the coding into the sql installer make sure you get everything.

make sure you have the right prefix--if any

if it doen't work in admin then use phpmyadmin

Thanks DarkAngel

That did the trick. I was a little squeamish about entering directly into phpmyadmin input box, but I'm over it now. LOL

Your examples showed where to add the prefix, but how does one know where a pre-fix is needed if an sql file doesn't have them and I need to do that through phpmyadmin again?

LOL, good question

usually if you are the one that installed it to begin with then you will know what, if any, prefix you added to the database you created.

If another persone installs it then chances are they have access to your database or server files via c-panel?? and you can get the information from them otherwise just take a peek at the configuration file (includes/configuration.php) for the store and it will be listed towards the bottom.

That is why any software you install you want to do all possible to also install the security updates for a hacker can get to this file, and get access to your stuff..

I'm having some issues with getting light box working. The images show up but no light box.

outeredge2:

I'm having some issues with getting light box working. The images show up but no light box.

1. first open the zip
2. go to your server files
3. double check to see that all files are uploaded to the correct placed---remember the best way is to reupload them to overwrite the ones you first did, just in case one or two got corrupted when you did it the first time.

make sure the folders that are marked as your_template --- those items in there need to go into the same sub folders in the template you are using. If you do not have that folder in any area it says then create one, using the exact same name as your template you are using.

does the settings show in the configuration/lightbox area?

sis you have any errors when you installed the sql?

DarkAngel:

1. first open the zip
2. go to your server files
3. double check to see that all files are uploaded to the correct placed---remember the best way is to reupload them to overwrite the ones you first did, just in case one or two got corrupted when you did it the first time.

make sure the folders that are marked as your_template --- those items in there need to go into the same sub folders in the template you are using. If you do not have that folder in any area it says then create one, using the exact same name as your template you are using.

does the settings show in the configuration/lightbox area?

sis you have any errors when you installed the sql?
can you clarify something for me.

When it says:
Rename the following folders to match your template folder name.

includes\languages\english\extra_definitions\YOUR-TEMPLATE-FOLDER
includes\modules\YOUR-TEMPLATE-FOLDER
includes\templates\YOUR-TEMPLATE-FOLDER

Does that mean to change it to:
includes\templates\templates
OR
includes\templates\ri007 ri007(being to folder that is my template and holds my template)

The setting do show up in the Configuration/lightbox area and i can edit them.

There were also no errors when I ran the sql.

outeredge2:

can you clarify something for me.

When it says:
Rename the following folders to match your template folder name.

includes\languages\english\extra_definitions\YOUR-TEMPLATE-FOLDER
includes\modules\YOUR-TEMPLATE-FOLDER
includes\templates\YOUR-TEMPLATE-FOLDER

Does that mean to change it to:
includes\templates\templates
OR
includes\templates\ri007 ri007(being to folder that is my template and holds my template)

The setting do show up in the Configuration/lightbox area and i can edit them.

There were also no errors when I ran the sql.

yes includes\templates\ri007 is what i mean. anytime you find either your_template or custom then that is what you do...drop the items into the folder that houses your template you are using for the store.

and make additional ri007 folders in anyother spot that the zips indicate there should be one.

DarkAngel:

yes includes\templates\ri007 is what i mean. anytime you find either your_template or custom then that is what you do...drop the items into the folder that houses your template you are using for the store.

and make additional ri007 folders in anyother spot that the zips indicate there should be one.
Thanks
I'm trying it now! Fingers crossed!!

Arlette:

Hi. I am having problems with my lightbox not working within Opera. No problems in FF or IE. I have a new shop. ZenCart 1.3.8a
Cherry Zen Template. Zen Lightbox v1.5. Any suggestions what is keeping this from working in Opera? Below is a link to a product with multiple images.

http://www.asembroidery.com/catalog/index.php?main_page=product_info&cPath=7&products_id=11

TIA
Arlette

Same here. Lightbox isnt working in Gallery mode in Opera. The "Next" button doesnt appear in the top right of the lightbox. :censored:

Any help?

Update: Its only the "Next" button in gallery mode in Opera that doesnt work. The keyboard arrow keys cycle through the images in Lightbox, and the "Prev" button works. Its just the Next button that is broken. Please help.