Bug Report on database from 3.2 to 3.3

[payampersa]

Hi, Sergey

First I installed the clean new version 3.3 on my localhost
Then I restored my database from tools > Database Backup . I restored my previous version db 3.2 to the site
Then
1.
I updated the database from 3.2 to 3.3, this way:
http://localhost/ruko/install/ext_autou ... to_3.3.php

Then I received the following bug:

Rukovoditel Extension | Database Auto Update from 3.2 to3.3
Processing...
ALTER TABLE `app_ext_import_templates` ADD `filepath` VARCHAR(255) NOT NULL AFTER `is_active`, ADD `import_action` VARCHAR(16) NOT NULL AFTER `filepath`, ADD `filetype` VARCHAR(8) NOT NULL AFTER `import_action`, ADD `parent_item_id` INT NOT NULL AFTER `filetype`, ADD `text_delimiter` VARCHAR(16) NOT NULL AFTER `parent_item_id`, ADD `update_use_column` VARCHAR(16) NOT NULL AFTER `text_delimiter`
1146
Table 'payampersapcm.app_ext_import_templates' doesn't exist

2. On the Nested entities menu page
I also see the following bug:

Database Error: 1146 - Table 'payampersapcm.app_nested_entities_menu' doesn't exist
Query: select * from app_nested_entities_menu where entities_id='40' order by sort_order, name
Page: /ruko/index.php?module=nested_entities_menu/menu&entities_id=40
#0 includes\functions\database.php(87): mysqli_query(Object(mysqli), 'select * from a...')
#1 modules\nested_entities_menu\views\menu.php(24): db_query('select * from a...')
#2 template\layout.php(155): require('D:\\xampp\\htdocs...')
#3 index.php(32): require('D:\\xampp\\htdocs...')
#4 {main}


NOW I wonder what to do????
please help me ...

[support]

Table "app_ext_import_templates" was added in 2.4 version.

Try to add this table manually. Open phpmyadmin and run next query:

Code: Select all

CREATE TABLE IF NOT EXISTS `app_ext_import_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `import_fields` text NOT NULL,
  `users_groups` text NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `idx_entities_id` (`entities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Once it'd done, then run update script again

Code: Select all

http://localhost/ruko/install/ext_autoupdate/from_3.2_to_3.3.php

Should works.

[payampersa]

I did what you recommended.
Then I updated the database from 3.2 to 3.3, this way:
http://localhost/ruko/install/ext_autou ... to_3.3.php

Now I have his bug:


Rukovoditel Extension | Database Auto Update from 3.2 to3.3
Processing...
ALTER TABLE `app_ext_import_templates` ADD `filepath` VARCHAR(255) NOT NULL AFTER `is_active`, ADD `import_action` VARCHAR(16) NOT NULL AFTER `filepath`, ADD `filetype` VARCHAR(8) NOT NULL AFTER `import_action`, ADD `parent_item_id` INT NOT NULL AFTER `filetype`, ADD `text_delimiter` VARCHAR(16) NOT NULL AFTER `parent_item_id`, ADD `update_use_column` VARCHAR(16) NOT NULL AFTER `text_delimiter`
1146
Table 'payampersapcm.app_ext_import_templates' doesn't exist

RSVP

[support]

Looks like your previous version was not 3.2 because lots of tables missed.
See update instruction https://docs.rukovoditel.net/index.php?p=63

Also pure sql to update database is here install\db_updates\

[payampersa]

thanks