Errors while updating from 3.3.1 to 3.4.2 such errors appeared:

[payampersa]

Updating from 3.3.1 to 3.4.2 such errors appeared:


Database Error: 1146 - Table 'r342.app_ext_report_page' doesn't exist
Query: select * from app_ext_report_page where id=''
Page: /r342/index.php?module=dashboard/
#0 includes\functions\database.php(87): mysqli_query(Object(mysqli), 'select * from a...')
#1 modules\dashboard\components\sections_reports.php(123): db_query('select * from a...')
#2 modules\dashboard\components\sections.php(37): require('D:\\xampp\\htdocs...')
#3 modules\dashboard\views\dashboard.php(26): require('D:\\xampp\\htdocs...')
#4 template\layout.php(154): require('D:\\xampp\\htdocs...')
#5 index.php(38): require('D:\\xampp\\htdocs...')
#6 {main}


I also used:
https://docs.rukovoditel.net/index.php?p=63
to update database and ext, but it still did not work.
Please help, How can I solve the problem?

[support]

You have to update database for main version and extension also.
The error "Table 'r342.app_ext_report_page' doesn't exist" means the database was not updated and required table was not created.

Also table app_ext_report_page was added 3.2 version. Are you sure your previous version was 3.3.1?
you can find sql to add this table here install\db_updates\ext\ext_3.2.sql
and you can run it in phpmyadmin

[payampersa]

Hi Sergey
I used the instructions on: https://docs.rukovoditel.net/index.php?p=63
from the Top of the list to the bottom of the list one by one, and I Ran the update for both database and the Ex.
It still has the bug I Mentioned at the 1st post.

What do you mean by main Version, what do you mean I should update database for main version and extension also? This part IS NOT clear, please elaborate.
And I AM sure the previous version was 3.3.1?
Because Tools > Check Version > You are using Rukovoditel 3.3.1, approves this.

[Didou12]

Sergey meant you need to replace folders about main version AND the extension (from your account on Rukovoditel website).

After, you need to run this :

Code: Select all

/install/autoupdate/from_3.3_to_3.4.php
/install/ext_autoupdate/from_3.3_to_3.4.php

You have to be sure all previous version (main and extension) are 3.3, or you need to update 3.1 to 3.2, 3.2 to 3.3 and 3.3 to 3.4.

If you are sure all is okay with previous statement, you can run SQL in your phpMyAdmin for the required table, in your case :

Code: Select all

CREATE TABLE IF NOT EXISTS `app_ext_report_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `type` varchar(64) NOT NULL,
  `use_editor` tinyint(1) NOT NULL,
  `save_filename` varchar(255) NOT NULL,
  `save_as` varchar(16) 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` varchar(255) NOT NULL,
  `assigned_to` varchar(255) NOT NULL,
  `page_orientation` varchar(16) NOT NULL,
  `settings` text NOT NULL,
  `css` longtext NOT NULL,
  `sort_order` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;