Known System Issues: Difference between revisions

From Zymonic
Content added Content deleted
(Populated)
No edit summary
Line 6: Line 6:
</li><li>
</li><li>
Table 'alex_paf.zz_materialized_view_list' doesn't exist (manually creating it fixes the issue: SR: 74666
Table 'alex_paf.zz_materialized_view_list' doesn't exist (manually creating it fixes the issue: SR: 74666
CREATE TABLE `zz_materialized_view_list` (
`mv_sequence_number` int(11) NOT NULL AUTO_INCREMENT,
`flattened_query` varchar(255) DEFAULT NULL,
`datetime_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`being_created` char(1) DEFAULT NULL,
PRIMARY KEY (`mv_sequence_number`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
</li><li>
</li><li>
Role_permissions doesn't get populated initially – had to do: sudo zymonic_toolkit.pl System add_defaults --system paf --full yes : also SR: 74666
Role_permissions doesn't get populated initially – had to do: sudo zymonic_toolkit.pl System add_defaults --system paf --full yes : also SR: 74666

Revision as of 10:37, 12 October 2018

  • Can only add one page at a time (need to do delete from zz_pages where zname is null;) then re-run config build with full – being triaged but apparently only in development at the moment.
  • Needs update_fap then full config build then apache reload to get the security on the fap table correct. SR: 74878
  • Table 'alex_paf.zz_materialized_view_list' doesn't exist (manually creating it fixes the issue: SR: 74666 CREATE TABLE `zz_materialized_view_list` ( `mv_sequence_number` int(11) NOT NULL AUTO_INCREMENT, `flattened_query` varchar(255) DEFAULT NULL, `datetime_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `being_created` char(1) DEFAULT NULL, PRIMARY KEY (`mv_sequence_number`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8;
  • Role_permissions doesn't get populated initially – had to do: sudo zymonic_toolkit.pl System add_defaults --system paf --full yes : also SR: 74666
  • Group didn’t set properly for the newly created superuser - update zz_user_groups set groupid = [ID OF ADMINS GROUP]; - being triaged
  • Pages where the only block is a filter with no records in the DB do not show in the pages list (Transfer Management) - SR: 83904