AJAX IMAGE Swapper support thread

[Svanis]

Running a clean install of ZC 1.3.9h.

When trying to install this mod i get the SQL error;

1366 Incorrect integer value: '' for column 'configuration_id' at row 1
in:
[INSERT INTO zen_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()), ('', 'Large Image Height (Max. image height)', 'IMAGE_VIEWER_LARGE_IMAGE_HEIGHT','9999','The height of large images / maximum image height in AJAX Image Swapper.', @last_id, 16, now()), ('', 'Large Image Width (Max. image width)', 'IMAGE_VIEWER_LARGE_IMAGE_WIDTH','9999','The width of large images / maximum image width in AJAX Image Swapper.', @last_id, 17, now()), ('', 'Number of Images Shown', 'IMAGE_VIEWER_IMAGES_NUM','3','Number of images shown in AJAX Image Swapper', @last_id, 20, now()), ('', 'Scroll Size', 'IMAGE_VIEWER_SCROLL_SIZE','3','How many images to be scrolled when pressing left or right arrow', @last_id, 25, now());]
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.

[dbltoe]

two questions come to mind:

1. does you DB have a prefix of zen_?
2. How did you load the .sql file?

[Svanis]

two questions come to mind:

1. does you DB have a prefix of zen_?
2. How did you load the .sql file?

Yes it does. But I can't see that this would cause the problem since the error occurs on the last statement of the included "fresh install" sql file which I copied the text from before pasting it into the install sql feature of ZC.

[dbltoe]

Sometimes copy & paste hiccups.

What happens if you use the upload file versus copy & paste?

[Svanis]

Sometimes copy & paste hiccups.

What happens if you use the upload file versus copy & paste?

Didn't do the trick.
However, I solved it by manually assigning configuration id's and configuration group id's.

Thanks for the help though =)

[Svanis]

And now! On to the next issue;
I've got AIS running fine but now the alignment of the product info display is horrific.

The images ends up OK to the left of the page but the price and product description ends up below the images instead of to the right.

This is probably very simple but I'm stuck.

Any help is appreciated!

[Scarlet]

anyone know where I can get this module? I don't see it in the add-ons and the original link is dead.