upgrade 3.2 to 3.3 error

[vesb]

Hi

After upgrade 3.2 to 3.3 the autoupdate stop at ;

Processing...
ALTER TABLE `app_reports` ADD `description` TEXT NOT NULL AFTER `name`
1060
Duplicate column name 'description

and when run the database - the error came out like this -

Database Error: 1146 - Table 'infrmmy1_ruko30.app_nested_entities_menu' doesn't exist
Query: select e.*, (select count(*) from app_nested_entities_menu m where find_in_set(e.id,m.entities) and is_active=1) is_used from app_entities e where parent_id='167' having is_used=0 order by e.sort_order, e.name
Page: /veds/index.php?module=items/info&path=166-1/167-2&gotopage[3238549]=1

[support]

Strange. Go to instsll/dbupdates folder where you can find pure sql. Open phpmyadmin and run missed sql.

[vesb]

Hi Sergey,

i got no idea how to run phpmyadmin missed sql in install/dbupdates folder.

attached is the dbupdates file

br

Razli

[support]

phpmyadmin you can open under your control panel on server. Run next query:

Code: Select all

CREATE TABLE IF NOT EXISTS `app_nested_entities_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL,
  `is_active` tinyint(4) NOT NULL,
  `name` varchar(64) NOT NULL,
  `entities` varchar(255) NOT NULL,
  `icon` varchar(64) NOT NULL,
  `icon_color` varchar(10) NOT NULL,
  `sort_order` smallint(6) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_entities_id` (`entities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

table app_nested_entities_menu is not auto created during update. Hard to say way. Just run update sql manually in phpmyadmin.

[vesb]

Hi Sergey,

Problem solve. Thank you very much

Happy New Year

Br

Razli

[M1S1L]

Thanks Sergey. This helped me too.