Error after version 2.6 - 1054

[J2X9]

This is the error that pops up.

Database Error: 1054 - Unknown column 'r.assigned_to' in 'where clause'
Query: select r.* from app_reports r, app_entities e, app_entities_access ea where r.entities_id = e.id and e.id=ea.entities_id and length(ea.access_schema)>0 and ea.access_groups_id='0' and (find_in_set(0,r.users_groups) or find_in_set(1,r.assigned_to)) and r.in_header=1 and r.reports_type = 'common' order by r.dashboard_sort_order, r.name
Page: /index.php?module=dashboard/

I tried to use the instructions from the other similar blog post even though his error is slightly different and it didn't work.

[support]

Looks like not all sql query was run during update.
Try to run this query manually in phpmyadmin

Code: Select all

ALTER TABLE `app_reports` ADD `assigned_to` TEXT NOT NULL AFTER `users_groups`;

Let me know if it works ok now.

[J2X9]

Thanks for the help! It worked.

[J2X9]

Actually, I thought it worked. It did up to a point. Now the web page is loading and I am able to login but some things are not populating. Please see the screenshot below:

[J2X9]

I removed the install folder and that alert went away but the error message in red still populates.

[support]

Did you update your database during update? Or you just rewrite files?

Since you already run one script manually you can't run automatically update.Run next script:

Code: Select all

ALTER TABLE `app_filters_panels` ADD `type` VARCHAR(64) NOT NULL AFTER `entities_id`;
ALTER TABLE `app_filters_panels_fields` ADD `search_type_match` TINYINT(1) NOT NULL AFTER `display_type`;
ALTER TABLE `app_global_lists_choices` ADD `is_active` TINYINT(1) NOT NULL DEFAULT '1' AFTER `lists_id`;
ALTER TABLE `app_fields_choices` ADD `is_active` TINYINT(1) NOT NULL DEFAULT '1' AFTER `fields_id`;

ALTER TABLE `app_global_lists` ADD `notes` TEXT NOT NULL AFTER `name`;
ALTER TABLE `app_global_lists_choices` ADD `notes` TEXT NOT NULL AFTER `users`;
ALTER TABLE `app_reports` ADD `dashboard_counter_hide_zero_count` TINYINT(1) NOT NULL AFTER `dashboard_counter_hide_count`;

CREATE TABLE IF NOT EXISTS `app_records_visibility_rules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `users_groups` text NOT NULL,
  `merged_fields` text NOT NULL,
  `notes` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_entities_id` (`entities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[J2X9]

No I let it update on its own. With the feature in softaculous. I did not rewrite anything.

[J2X9]

Do I just run this like I did the other query?

[support]

Yes, run queries above. It should fix issue.

[J2X9]

Thank you! That fixed it.