Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

UltraPics v1.0 - Addition Image Pack! MS2


blaircampbell

Recommended Posts

I am getting the following sql error:

 

MySQL said:

 

 

#1064 - You have an error in your SQL syntax near '');

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `co' at line 1

 

With this sql provided in UltraPics v1.0 - Addition Image Pack! MS2

 

INSERT INTO `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 ('', 'PRODUCT DESCRIPTIONS use JPSY-PHP ULTRA-IMAGES MANAGER?', 'HTML_AREA_WYSIWYG_DISABLE_JPSY', 'Enable', 'Enable/Disable JPSY PHP/WYSIWYG ULTRA-IMAGE MANAGER box', 112, 5, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');

INSERT INTO `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 ('', 'Enable Additional Images?', 'ULTIMATE_ADDITIONAL_IMAGES', 'enable', 'Display Additional Images below Product Description?', 4, 10, now(), now(), NULL, 'tep_cfg_select_option(array(\'enable\', \'disable\'),');

INSERT INTO `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 ('', 'Additional Thumb Width', 'ULT_THUMB_IMAGE_WIDTH', '140', 'The pixel width of additional thumb images', 4, 11, now(), now(), NULL, NULL);

INSERT INTO `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 ('', 'Additional Thumb Height', 'ULT_THUMB_IMAGE_HEIGHT', '120', 'The pixel height of additional thumb images', 4, 12, now(), now(), NULL, NULL);

INSERT INTO `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 ('', 'Medium Image Width', 'MEDIUM_IMAGE_WIDTH', '200', 'The pixel width of medium images', 4, 13, now(), now(), NULL, NULL);

INSERT INTO `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 ('', 'Medium Image Height', 'MEDIUM_IMAGE_HEIGHT', '200', 'The pixel height of medium images', 4, 14, now(), now(), NULL, NULL);

INSERT INTO `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 ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', '0', 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 15, now(), now(), NULL, NULL);

INSERT INTO `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 ('', 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', '0', 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 16, now(), now(), NULL, NULL);

 

ALTER TABLE `products` ADD `products_image_med` VARCHAR(64) AFTER `products_image`;

ALTER TABLE `products` ADD `products_image_lrg` VARCHAR(64) AFTER `products_image_med`;

ALTER TABLE `products` ADD `products_image_sm_1` VARCHAR(64) AFTER `products_image_lrg`;

ALTER TABLE `products` ADD `products_image_xl_1` VARCHAR(64) AFTER `products_image_sm_1`;

ALTER TABLE `products` ADD `products_image_sm_2` VARCHAR(64) AFTER `products_image_xl_1`;

ALTER TABLE `products` ADD `products_image_xl_2` VARCHAR(64) AFTER `products_image_sm_2`;

ALTER TABLE `products` ADD `products_image_sm_3` VARCHAR(64) AFTER `products_image_xl_2`;

ALTER TABLE `products` ADD `products_image_xl_3` VARCHAR(64) AFTER `products_image_sm_3`;

ALTER TABLE `products` ADD `products_image_sm_4` VARCHAR(64) AFTER `products_image_xl_3`;

ALTER TABLE `products` ADD `products_image_xl_4` VARCHAR(64) AFTER `products_image_sm_4`;

ALTER TABLE `products` ADD `products_image_sm_5` VARCHAR(64) AFTER `products_image_xl_4`;

ALTER TABLE `products` ADD `products_image_xl_5` VARCHAR(64) AFTER `products_image_sm_5`;

ALTER TABLE `products` ADD `products_image_sm_6` VARCHAR(64) AFTER `products_image_xl_5`;

ALTER TABLE `products` ADD `products_image_xl_6` VARCHAR(64) AFTER `products_image_sm_6`;

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...