Update to 2.6 error

[elviseras]

Hi,

To upgrade to v2.6 extension php script returns following error

Processing...
ALTER TABLE `app_ext_calendar` ADD `min_time` VARCHAR(5) NOT NULL AFTER `highlighting_weekends`, ADD `max_time` VARCHAR(5) NOT NULL AFTER `min_time`, ADD `time_slot_duration` VARCHAR(8) NOT NULL AFTER `max_time`
1054
Unknown column 'highlighting_weekends' in 'app_ext_calendar'

Before, upgrade to v2.6 main php script completed witout errors

what can I do now?

[support]

From which version you do update?

highlighting_weekends was added in 2.4 version. Not sure why you don't have it.

Run next script:

Code: Select all

ALTER TABLE `app_ext_calendar` ADD `highlighting_weekends` VARCHAR(64) NOT NULL AFTER `default_view`;

After this run next:

Code: Select all

CREATE TABLE IF NOT EXISTS `app_ext_global_search_entities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL,
  `fields_for_search` text NOT NULL,
  `fields_in_listing` text NOT NULL,
  `sort_order` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_entities_id` (`entities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `app_ext_ipages` ADD `assigned_to` TEXT NOT NULL AFTER `users_groups`;
ALTER TABLE `app_ext_export_templates` ADD `template_header` TEXT NOT NULL AFTER `split_into_pages`, ADD `template_footer` TEXT NOT NULL AFTER `template_header`;
ALTER TABLE `app_ext_pivotreports` ADD `allow_edit` TINYINT(1) NOT NULL AFTER `allowed_groups`;

CREATE TABLE IF NOT EXISTS `app_ext_pivotreports_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reports_id` int(11) NOT NULL,
  `users_id` int(11) NOT NULL,
  `reports_settings` text NOT NULL,
  `view_mode` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_reports_id` (`reports_id`),
  KEY `idx_users_id` (`users_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `app_ext_sms_rules` CHANGE `phone` `phone` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

CREATE TABLE IF NOT EXISTS `app_ext_xml_export_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `button_title` varchar(64) NOT NULL,
  `button_position` varchar(64) NOT NULL,
  `button_color` varchar(7) NOT NULL,
  `button_icon` varchar(64) NOT NULL,
  `users_groups` text NOT NULL,
  `assigned_to` text NOT NULL,
  `is_public` tinyint(1) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `template_header` text NOT NULL,
  `template_body` text NOT NULL,
  `template_footer` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_entities_id` (`entities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `app_ext_email_rules` ADD `attach_attachments` TINYINT(1) NOT NULL AFTER `is_active`;

CREATE TABLE IF NOT EXISTS `app_ext_processes_clone_subitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `actions_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `from_entity_id` int(11) NOT NULL,
  `to_entity_id` int(11) NOT NULL,
  `fields` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_parent_id` (`parent_id`),
  KEY `idx_from_entity_id` (`from_entity_id`),
  KEY `idx_to_entity_id` (`to_entity_id`),
  KEY `idx_actions_id` (`actions_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `app_ext_email_rules` ADD `send_to_email` TEXT NOT NULL AFTER `send_to_assigned_users`, ADD `send_to_assigned_email` TEXT NOT NULL AFTER `send_to_email`;
ALTER TABLE `app_ext_calendar` ADD `view_modes` VARCHAR(255) NOT NULL AFTER `default_view`;
ALTER TABLE `app_ext_pivot_calendars` ADD `view_modes` VARCHAR(255) NOT NULL AFTER `default_view`;
ALTER TABLE `app_ext_import_templates` ADD `multilevel_import` INT NOT NULL AFTER `entities_id`;
ALTER TABLE `app_ext_ganttchart` ADD `default_fields_in_listing` VARCHAR(64) NOT NULL DEFAULT 'start_date,end_date,duration' AFTER `use_background`;
ALTER TABLE `app_ext_ganttchart` ADD `grid_width` SMALLINT NOT NULL AFTER `default_fields_in_listing`;
ALTER TABLE `app_ext_ganttchart` ADD `default_view` VARCHAR(16) NOT NULL DEFAULT 'day' AFTER `grid_width`;

[elviseras]

Thanks Sergey ... Now it works !!!

Theoretically we have updated since v2.5.2 but it is a test platform on a local server, and it is possible that from some previous update or test there is something wrong ... Logically it is not a critical system, but thanks anyway for your help...