I ran the repair as you suggested and it went without errors. There were no SQL statements at the bottom to execute.
I did a clean install of V7.8.5 and before doing do I have modified the /etc/php/7.0/apache/php.ini file to use “memory_size = 256” and “max_execution_time = 60”. The sugarcrm.log file contained the same issue as previously mentioned.
I checked that the suitecrm database had the table aow_workflow:
mysql> desc aow_workflow;
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| id | char(36) | NO | PRI | NULL | |
| name | varchar(255) | YES | | NULL | |
| date_entered | datetime | YES | | NULL | |
| date_modified | datetime | YES | | NULL | |
| modified_user_id | char(36) | YES | | NULL | |
| created_by | char(36) | YES | | NULL | |
| description | text | YES | | NULL | |
| deleted | tinyint(1) | YES | | 0 | |
| assigned_user_id | char(36) | YES | | NULL | |
| flow_module | varchar(100) | YES | | NULL | |
| flow_run_on | varchar(100) | YES | | 0 | |
| status | varchar(100) | YES | MUL | Active | |
| run_when | varchar(100) | YES | | Always | |
| multiple_runs | tinyint(1) | YES | | 0 | |
+------------------+--------------+------+-----+---------+-------+
14 rows in set (0.00 sec)
and then executed the statement that failed:
SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = 'ACLActions' AND aow_workflow.status = 'Active' AND (aow_workflow.run_when = 'Always' OR aow_workflow.run_when = 'On_Save' OR aow_workflow.run_when = 'Create') AND aow_workflow.deleted = 0;
Empty set (0.00 sec)
All seems OK there albeit returning an empty result set.
the output of ls -al is:
total 1420
drwxr-xr-x 17 www-data www-data 4096 Jun 16 16:39 .
drwxrwxr-x 10 root www-data 4096 Jun 16 16:32 ..
drwxrwxr-x 15 www-data www-data 4096 Jun 16 16:40 cache
-rwxr-xr-x 1 www-data www-data 3590 Jun 15 11:44 campaign_tracker.php
-rwxr-xr-x 1 www-data www-data 462 Jun 15 11:44 composer.json
-rwxr-xr-x 1 www-data www-data 17908 Jun 15 11:44 composer.lock
-rwxrwxr-x 1 www-data www-data 573 Jun 16 16:41 config_override.php
-rwxr-xr-x 1 www-data www-data 10126 Jun 16 16:39 config.php
-rwxr-xr-x 1 www-data www-data 5052 Jun 15 11:44 cron.php
-rwxr-xr-x 1 www-data www-data 2446 Jun 15 11:44 crossdomain.xml
drwxrwxr-x 8 www-data www-data 4096 Jun 16 16:39 custom
drwxrwxr-x 3 www-data www-data 4096 Jun 15 11:44 data
-rwxr-xr-x 1 www-data www-data 2388 Jun 15 11:44 dictionary.php
-rwxr-xr-x 1 www-data www-data 12541 Jun 15 11:44 download.php
-rwxr-xr-x 1 www-data www-data 2392 Jun 15 11:44 emailmandelivery.php
-rwxr-xr-x 1 www-data www-data 4912 Jun 15 11:44 export.php
-rwxr-xr-x 1 www-data www-data 967627 Jun 15 11:44 files.md5
-rwxr-xr-x 1 www-data www-data 2811 Jun 15 11:44 HandleAjaxCall.php
-rw-r--r-- 1 www-data www-data 1373 Jun 16 16:39 .htaccess
-rwxr-xr-x 1 www-data www-data 2371 Jun 15 11:44 ical_server.php
drwxr-xr-x 56 www-data www-data 4096 Jun 15 11:44 include
-rwxr-xr-x 1 www-data www-data 2374 Jun 15 11:44 index.php
drwxr-xr-x 6 www-data www-data 4096 Jun 16 16:39 install
-rw-r--r-- 1 www-data www-data 17922 Jun 16 16:39 install.log
-rwxr-xr-x 1 www-data www-data 32077 Jun 15 11:44 install.php
-rwxr-xr-x 1 www-data www-data 13373 Jun 15 11:44 json_server.php
drwxr-xr-x 3 www-data www-data 4096 Jun 15 11:44 jssource
-rwxr-xr-x 1 www-data www-data 34539 Jun 15 11:44 LICENSE.txt
-rwxr-xr-x 1 www-data www-data 2313 Jun 15 11:44 log_file_restricted.html
-rwxr-xr-x 1 www-data www-data 2376 Jun 15 11:44 maintenance.php
drwxr-xr-x 2 www-data www-data 4096 Jun 15 11:44 metadata
drwxr-xr-x 3 www-data www-data 4096 Jun 15 11:44 ModuleInstall
drwxrwxr-x 112 www-data www-data 4096 Jun 15 11:44 modules
-rwxr-xr-x 1 www-data www-data 2890 Jun 15 11:44 pdf.php
-rwxr-xr-x 1 www-data www-data 306 Jun 15 11:44 php_version.php
-rwxr-xr-x 1 www-data www-data 2659 Jun 15 11:44 README.md
-rwxr-xr-x 1 www-data www-data 73 Jun 15 11:44 robots.txt
-rwxr-xr-x 1 www-data www-data 3588 Jun 15 11:44 run_job.php
drwxr-xr-x 11 www-data www-data 4096 Jun 15 11:44 service
drwxr-xr-x 2 www-data www-data 4096 Jun 15 11:44 soap
-rwxr-xr-x 1 www-data www-data 4091 Jun 15 11:44 soap.php
-rw-r--r-- 1 www-data www-data 124046 Jun 16 16:39 sugarcrm.log
-rwxr-xr-x 1 www-data www-data 5327 Jun 15 11:44 SugarSecurity.php
-rwxr-xr-x 1 www-data www-data 154 Jun 15 11:44 sugar_version.json
-rwxr-xr-x 1 www-data www-data 2263 Jun 15 11:44 sugar_version.php
-rw-r--r-- 1 www-data www-data 705 Jun 16 16:49 suitecrm.log
-rwxr-xr-x 1 www-data www-data 168 Jun 15 11:44 suitecrm_version.php
drwxrwxr-x 6 www-data www-data 4096 Jun 15 11:44 themes
-rwxr-xr-x 1 www-data www-data 5843 Jun 15 11:44 TreeData.php
drwxrwxr-x 2 www-data www-data 4096 Jun 16 16:39 upload
-rwxr-xr-x 1 www-data www-data 2707 Jun 15 11:44 vcal_server.php
-rwxr-xr-x 1 www-data www-data 2980 Jun 15 11:44 vCard.php
drwxr-xr-x 2 www-data www-data 4096 Jun 15 11:44 XTemplate
drwxr-xr-x 8 www-data www-data 4096 Jun 15 11:44 Zend
I did the Quick Repair & Rebuild as you suggested but it didn’t help.
The only addition to the suitecrm.log is:
Fri Jun 16 16:49:44 2017 [17937][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteR/modules is not a file or a dir.
The issue still persists and so I would welcome any further suggestions…