Zen Lightbox addon [Support Thread]

[DarkAngel]

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

[badger64]

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

[DarkAngel]

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

[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.

Best Regards
Badger64

[DarkAngel]

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.

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.

[buildingblocks]

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

[DarkAngel]

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

[buildingblocks]

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?

[DarkAngel]

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..

[outeredge2]

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