Hi,
Just some helpful feedback here..
With a strict version of MySQL 5 the installation SQL script for AIS fails. This is because of the use of double single quotes for the configuration ID setting.
The last block in the AIS_fresh_sql_installer.sql file could/should be changed from
Code:
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()),
etc.
to
Code:
INSERT INTO configuration
(configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added)
VALUES
(NULL, '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()),
I.e. NULL instead of ''
Or, the first field should be removed altogether:
Code:
INSERT INTO configuration
(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()),
Hope that helps!
Thanks as always for all the time and effort you put in John! :)
All the best..
Conor
ceon