Tweet
In the MySQL database associated with Espocrm, we have setup views for various reporting purposes. This is posing a problem in the following Espocrm functions:
(1) Upgrades hang. We had to drop the views, upgrade and reinstall these views.
(2) The workflow rules fail. We tested the rules without the views and they work fine.
This seems mostly likely due to a serious bug in MySQL databases systems as we also found that we were unable to perform MySQLdump of the database with views. We had to use the ignore parameter to complete the dump.
I posting this as a bug so that the developers of Espocrm can investigate and overcome the upgrades and workflow issues.
(1) Upgrades hang. We had to drop the views, upgrade and reinstall these views.
(2) The workflow rules fail. We tested the rules without the views and they work fine.
This seems mostly likely due to a serious bug in MySQL databases systems as we also found that we were unable to perform MySQLdump of the database with views. We had to use the ignore parameter to complete the dump.
I posting this as a bug so that the developers of Espocrm can investigate and overcome the upgrades and workflow issues.