Getting this error on a site [edit] (fresh install of 7.1.3) that installed all modules except the "Sites"
get this error:
Installation of: SitesFailed
-- -- There are errors in the following MySQL queries:
-- -- Error:
INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES('bx_sites_permalinks', 'on', 26, 'Enable friendly permalinks in sites', 'checkbox', '', '', 0, ''),('bx_sites_autoapproval', 'on', @iCategId, 'Activate all sites after creation automatically', 'checkbox', '', '', 1, ''),('bx_sites_comments', 'on', @iCategId, 'Allow comments for sites', 'checkbox', '', '', 2, ''),('bx_sites_votes', 'on', @iCategId, 'Allow votes for sites', 'checkbox', '', '', 3, ''),('bx_sites_per_page', '10', @iCategId, 'The number of items shown on the page', 'digit', '', '', 4, ''),('bx_sites_max_rss_num', '10', @iCategId, 'Max number of rss items to provide', 'digit', '', '', 5, ''),('category_auto_app_bx_sites', 'on', @iCategId, 'Activate all categories for all sites after creation automatically', 'checkbox', '', '', 6, ''),('bx_sites_key_id', '', @iCategId, 'ShrinkTheWeb Access Key', 'digit', '', '', '7', ''),('bx_sites_secret_key', '', @iCategId, 'ShrinkTheWeb Secret Key', 'digit', '', '', '8', ''),('bx_sites_account_type', 'No Automated Screenshots', @iCategId, 'ShrinkTheWeb Account Type', 'select', 'return strlen($arg0) > 0;', 'cannot be empty.', '9', 'No Automated Screenshots,Enabled'),('bx_sites_cache_days', '7', @iCategId, 'Cache days
(how many days the images are valid in your cache,
Enter 0 (zero) to never update screenshots once cached or
-1 to disable caching and always use embedded method instead)', 'digit', '', '', '10', ''),('bx_sites_debug', 'off', @iCategId, 'Debug
(store debug info in database)', 'checkbox', '', '', '11', ''),('bx_sites_inside_pages', 'off', @iCategId, 'Inside Page Captures
(i.e. not just homepages and sub-domains,
select if you have purchased this pro package)', 'checkbox', '', '', '12', ''),('bx_sites_custom_msg_url', '', @iCategId, 'Custom Messages URL
(specify the URL where your custom
message images are stored)', 'digit', '', '', '13', ''),('bx_sites_thumb_size', 'lg', @iCategId, 'Default Thumbnail size
(width: mcr 75px, tny 90px, vsm 100px,
sm 120px, lg 200px, xlg 320px)', 'select', 'return strlen($arg0) > 0;', 'cannot be empty.', '14', 'mcr,tny,vsm,sm,lg,xlg'),('bx_sites_thumb_size_custom', '', @iCategId, 'Custom Width
(enter your custom image width,
this will override default size)', 'digit', '', '', '15', ''),('bx_sites_full_size', '', @iCategId, 'Full-Length capture', 'checkbox', '', '', '16', ''),('bx_sites_max_height', '', @iCategId, 'Max height
(use if you want to set maxheight for fullsize capture)', 'digit', '', '', '17', ''),('bx_sites_native_res', '', @iCategId, 'Native resolution
(i.e. 640 for 640x480)', 'digit', '', '', '18', ''),('bx_sites_widescreen_y', '', @iCategId, 'Widescreen resolution Y
(i.e. 900 for 1440x900 if 1440 is
set for Native resolution)', 'digit', '', '', '19', ''),('bx_sites_redo', 'off', @iCategId, 'Refresh On-Demand
(select if you have purchased this pro package
and want to allow your members to use it)', 'checkbox', '', '', '20', ''),('bx_sites_delay', '', @iCategId, 'Flash delay
(max. 45)', 'digit', '', '', '21', ''),('bx_sites_quality', '', @iCategId, 'Quality
(0 .. 100)', 'digit', '', '', '22', '');
Have also run the uninstall.sql on the database manually and get no error.
Manually removed the "sites" entries in the sys_options_cats table.
Each time the install is run, a new entry in entered into the database, there were a total of six entries.
This should not happen right?
I manually removed the entries, run the uninstall manually on the database and still get the above error.
What could I be overlooking?
Each install adds new entry with error.