Hi,
Having a problem when running the install.sql.
I get this error:
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 '(NULL, 'Show \'Add additional image link\' link', 'IM_SHOW_ADD_IMAGE_LINK', 'no'' at line 1
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Maximum large image width', 'IM_MAX_LARGE_WIDTH', 800, 'The maximum sizes of the small and medium size images can be set through the admin interface (Configuration->Images).
You can set the maximum width of the large files here.
', @configuration_group_id, 10, NOW(), NULL, NULL), (NULL, 'Maximum large image height', 'IM_MAX_LARGE_HEIGHT', 600, 'The maximum sizes of the small and medium size images can be set through the admin interface (Configuration->Images).
You can set the maximum height of the large files here.
', @configuration_group_id, 20, NOW(), NULL, NULL), (NULL, 'Maximum rows per page', 'IM_PAGE_LENGTH', 30, 'This is the number of rows per page that will be displayed in Image Manager.
', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Enable/disable medium size images', 'IM_USE_MEDIUM_IMAGES', 'enable', 'If set to \'disable\', Image Manager will ignore medium size product images and treat them as unattached images.
Also all other functions, like generate or delete an image from a product, will only apply to small and large size images.
', @configuration_group_id, 40, NOW(), NULL, 'zen_cfg_select_option(array(\'enable\', \'disable\'),'), (NULL, 'Show popup image or link', 'IM_SHOW_POPUP_IMAGE', 'image', 'With this option set to \'image\', no separate links to images will be displayed anymore. Instead, hovering over the filename with the mouse causes the image to display underneath the filename.
With this option set to \'link\' an additional column will be displayed with a link to the image. Clicking this link will open a new window with the image.
', @configuration_group_id, 50, NOW(), NULL, 'zen_cfg_select_option(array(\'image\', \'link\'),'), (NULL, 'Folders to exclude from Image Manager', 'IM_EXCLUDE_FOLDERS_EXTRA', '', 'This option allows you to add folders which Image Manager will not display, specifically in the \'unattached\' list.
Image manager already excludes the following subfolders of the images folder:
attributes/
banners/
categories/
gift_certificates/
icons/
manufacturers/
samples/
testimonials/
uploads/
The additional folders must be entered with a trailing slash and comma separated.
', @configuration_group_id, 60, NOW(), NULL, NULL), (NULL, 'Files to include in Image Manager', 'IM_FILETYPES', 'all', 'This option allows you to choose what types of files Image Manager will handle.
If you select \'media\', only file types with media type extensions will be handled and visible in IM.
', @configuration_group_id, 70, NOW(), NULL, 'zen_cfg_select_option(array(\'media\', \'all\'),'), (NULL, 'Initial action at startup', 'IM_STARTUP_ACTION', 'show_menu', 'This option determines what Image Manager will do once started from the administrative interface. Either do nothing and just show the menu, display the unattached files, or display the attached files, the latter two according to the default options set in the Image Manager configuration.
', @configuration_group_id, 80, NOW(), NULL, 'zen_cfg_select_option(array(\'show_menu\', \'show_unattached\', \'show_attached\'),'), (NULL, 'Default value for \'Show Images\"', 'IM_IMAGE_DEFAULT', 'link', 'This option sets the default value for the \'Show Image\' option.
', @configuration_group_id, 90, NOW(), NULL, 'zen_cfg_select_option(array(\'link\', \'small_image\', \'all_images\'),'), (NULL, 'Default value for \'Product Status\'', 'IM_PRODUCT_STATUS_DEFAULT', 'on', 'This option sets the default for the \'Product Status\' option.
', @configuration_group_id, 100, NOW(), NULL, 'zen_cfg_select_option(array(\'on\', \'off\', \'all\'),'), (NULL, 'Default value for \'Show Files\'', 'IM_SHOW_FILES_DEFAULT', 'with_errors', 'This option sets the default for the \'Show Files\' option.
', @configuration_group_id, 110, NOW(), NULL, 'zen_cfg_select_option(array(\'with_errors\', \'without_errors\', \'all_files\'),'), (NULL, 'Default value for \'Sort order\'', 'IM_SORT_ORDER_DEFAULT', 'folder_filename', 'This option sets the default for the \'Sort order\' option.
', @configuration_group_id, 120, NOW(), NULL, 'zen_cfg_select_option(array(\'folder_filename\', \'product_id\', \'large_image_size\'),'), (NULL, 'Show \'Add watermark\' link', 'IM_SHOW_WATERMARK_LINK', 'no', 'When set to \'yes\', Image Manager will display a link to additionally add a watermark to images. This option will only show up in \'attached\' mode, if all image sizes have the right size, and a watermark is present in the appropriate folder.
This option has no impact on the automatic watermarking that takes place during the copying/shrinking of images.
', @configuration_group_id, 130, NOW(), NULL, 'zen_cfg_select_option(array(\'yes\', \'no\'),'), (NULL, 'Show \'Re-upload image\' link', 'IM_SHOW_REUPLOAD_LINK', 'no', 'When set to \'yes\', Image Manager will display a link to re-upload a small size image, replacing an already existing one. You can upload an image with any name; IM will store the image under the name already known. Only the image type must be the same: if the existing image is a jpg-file, the re-uploaded one must also be a jpg file.
This option will only show up in \'attached\' mode.
If the re-uploaded image is large enough, it can be used to also recreate the medium and large size images.
', @configuration_group_id, 140, NOW(), NULL, 'zen_cfg_select_option(array(\'yes\', \'no\'),') (NULL, 'Show \'Add additional image link\' link', 'IM_SHOW_ADD_IMAGE_LINK', 'no', 'When set to \'yes\', Image Manager will display a link to upload a new additional image for a product.
You can upload an image with any name; IM will store the image under the name already known, with the specified suffix added.
This option will only show up in \'attached\' mode, after first selecting a specific products-ID in the right upper box.
If the uploaded image is large enough, it can be used to also recreate the medium and large size images.
', @configuration_group_id, 150, NOW(), NULL, 'zen_cfg_select_option(array(\'yes\', \'no\'),');]
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.
Im using version 1.3.9f, php version 5.2.13 and mySQL version 5.0.90.
Can anyone help?
