Zen Lightbox addon [Support Thread]

[shahram]

Hi i just install zen light box and i m getting error on SQL when i install sql file i ghet this error


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

[DarkAngel]

is sneakerf_testing the prefix to your store's tables in the database?

[shahram]

yes sneakerf_testing prefix

[shahram]

is sneakerf_testing the prefix to your store's tables in the database?

yes sneakerf_testing prefix

[DarkAngel]

sneakerf is the name of the site
testing is the name of the database

I think but the tables within the testing database is more than likly either zc, zen or nothing at all but just table names.

I suggest you go to your database manager (MyPHPadmin from your c-panel), and take a screenshot of the actual tables in the database.

that way we can see which one of us is confused...thanks

[shahram]

sneakerf is the name of the site
testing is the name of the database

I think but the tables within the testing database is more than likly either zc, zen or nothing at all but just table names.

I suggest you go to your database manager (MyPHPadmin from your c-panel), and take a screenshot of the actual tables in the database.

that way we can see which one of us is confused...thanks

sneakerf_testing is my database name
testing_ is my prefix name

[DarkAngel]

then maybe you need to run the sql installer with the prefix where indicated in red...but remember to run the uninstaller first... if tester is the word just before the table name...like it should look like this tester_admin

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

[phiblack]

Hopefully this will be an easy one to answer.
I have just had installed Light Box and it appears to work fine - apart from the fact that when I click an image it brings up the box but the image is the same size as the image I clicked to open the box.

Do I need to resize all my existing images, and add _LRG.jpg and place them all in the LARGE folder for light box to open a larger image of my products?

Or do I need to do something else so that the customer if they click on my existing image (say 100 x 100 pixels) they get to see a light box image that is say 600 x 600 pixels in size.

I am going around in circles trying to rectify this.

Phil
www.colourpatch.com/shop

[DarkAngel]

@philblack:

hi there and happy holiday!

about the thumbnail images...depending on what size you have them set in admin is the size you initially see...however what I do is upload the image full size via the description page---at the bottom and then the software resizes it to fit your constraints and when clicked on the customer is given the larger size.

hope that made sense

example mine are set at width=175 I think...lol I do not enter a height so the software fits to size...then I go enter all the info I need for the product and under the place to enter model you click the browse button to locate the image on your computer...select where you want it uploaded...click preview when doen then update to finalize...go to your store and click the thumbnail and it should open to the original size you uploaded.

see my store (link in signature for Fantasies Realm) rightclick the thumbnail and choose view image to see the actual size of the image...they are all uploaded full size, named as I want them to be.

the_LRG is more if you actually get the counter to go thru more than one image on your product page...mine never behaved, so i did it this way

[phiblack]

DarkAngel,

Perfect!!!!
It was such an easy fix.
I appreciate your help.

Happy holidays to you also..

PB