AJAX IMAGE Swapper support thread

[chuckienorton]

1. New installs are bombing because the first command is to drop a table that might not even exist. Adding "IF EXISTS" stops the mysql error.
2. zen_ is a common prefix that is added to the beginning of database table names when initially loading ZenCart. It was in the one spot and NOT in the others. That caused yet another mysql error.

Is it possible to have two IF EXISTS's ...one that adds to the table only for the databases w/ 'zen_blablabla', and the other that adds to the table for databases labelled 'blablabla'? That way this discussion is never an issue in the future? (not sure if this is even possible, just wondering?)

[jaycode]

Thanks dbltoe,

Or if you install through admin install sql patches, for example if you have xyz_ as your prefix, use this:

			 				DROP TABLE products_attributes_images;

CREATE TABLE products_attributes_images (
	image_id INT NOT NULL AUTO_INCREMENT,
	products_attributes_id INT NOT NULL,
	image_path VARCHAR(255),
	image_title VARCHAR(255),
	image_sort_order INT,
	PRIMARY KEY(`image_id`)
);

INSERT INTO configuration_group
(configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible)
VALUES (NULL, 'AJAX Image Swapper', 'Config options for AJAX Image Swapper', '1', '1');

UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SELECT @last_id :=last_insert_id() FROM xyz_configuration_group;

INSERT INTO configuration 
(configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added)
VALUES 
('', 'Small Image Height', 'IMAGE_VIEWER_SMALL_IMAGE_HEIGHT','75','The height of small images in AJAX Image Swapper, shown as thumbnails. Default 75.', @last_id, 1, now()),
('', 'Small Image Width', 'IMAGE_VIEWER_SMALL_IMAGE_WIDTH','75','The height of small images in AJAX Image Swapper, shown as thumbnails. Default 75.', @last_id, 5, now()),
('', 'Medium Image Height', 'IMAGE_VIEWER_MEDIUM_IMAGE_HEIGHT','300','The height of medium images in AJAX Image Swapper. Default 300.', @last_id, 10, now()),
('', 'Medium Image Width', 'IMAGE_VIEWER_MEDIUM_IMAGE_WIDTH','300','The width of medium images in AJAX Image Swapper. Default 300.', @last_id, 15, now()),
('', 'Number of Images Shown', 'IMAGE_VIEWER_IMAGES_NUM','3','Number of images shown in AJAX Image Swapper', @last_id, 20, now());

Note that I only added xyz_ to this line:

 SELECT @last_id :=last_insert_id() FROM xyz_configuration_group;

You can omit the first DROP query since it doesn't do nothing for fresh installation.

Good luck

[jaycode]

Is it possible to have two IF EXISTS's ...one that adds to the table only for the databases w/ 'zen_blablabla', and the other that adds to the table for databases labelled 'blablabla'? That way this discussion is never an issue in the future? (not sure if this is even possible, just wondering?)

Hold on, I don't think the IF EXISTS is of any issue to this, since even while it generated an error, it doesn't stop the query from running, if you install it from admin page. Just follow the installation steps from readme file, its already working(isn't it?).

[dbltoe]

I'm not the sharpest knife in the drawer when it comes to this and I am not able to come up with a method that will detect the prefix before uploading the sql file.

The admin panel's Install SQL Patches MAY take into consideration the prefix but I haven't found where the configure.php setting is saved in the database. Also, I can't help but think that the mixture of prefix - no prefix could possibly help. Not trying to cast dispersions on anyone's ability. Just letting you know what we've had to do to get this working.

Not done looking but certainly open to those much smarter helping with the problem.

When the sql upload fails under the old method, you often wind up with two listings under Configuration. If you delete the wrong one, the ID will not match the setting in the configuration-group table.

Things only get worse from there.

Things known for sure:

1. This will NOT work without attributes on EVERY product as products without attributes just sit and spin waiting for an image.
2. This will NOT work without PHP 5+
3. The existing file structure does not put some of the files where they are needed. (web images folder is wrong)

The list of things still not known is too long for here but we continue on.

[dbltoe]

chuckienorton,
In reference to the onMouseover versus onclick, I would only change the one at or near line 36 in the script-imageViewer.js.
Changing all of them may frustrate the customer when they hover over the "lightbox effect" close box by mistake.
I would say the two at lines 492 and 493 would be optional.

[chuckienorton]

chuckienorton,
In reference to the onMouseover versus onclick, I would only change the one at or near line 36 in the script-imageViewer.js.
Changing all of them may frustrate the customer when they hover over the "lightbox effect" close box by mistake.
I would say the two at lines 492 and 493 would be optional.

good call! Your right, it would be a bad idea changing all of them. I disabled the larger image part, so I didn't even think about it. Thanks!

[dbltoe]

yep,

Now working on the larger image as a customer wants it. Problem is that the controls resize based on the window size but the image never moves.

Now where did I put those JavaScript books.

[walkerhxg]

How to uninstall AJAX IMAGE Swapper thoroughly? IH2 cannot work with it

[dbltoe]

You may have made an installation mistake OR you are not using php 5.2.

We've found that the two work well together except for the AJAX centering problem with its lightbox feature and that is strictly a JavaScript fix for that area.

It works if the opening browser is not set too small and the customer doesn't resize the browser window during viewing.

Still hoping someone will com up with a fix for that jaycode?

[easy665]

Could you tell me why "Add New Image " Button can't work.
Tks!