aow_workflow' doesn't exist SQL Error

loydte3 · 23 August 2016 05:53

Ok, I just went through multiple series of uploads and installs of SuiteCRM 7.7.1 and kept getting a hangup with the database.

To answer anyone response against the “permissions” issue, I used the following to set everything to 777 for directories AND files. If you’re interested here’s the Linux commands:
Files: sudo find . -type f -exec chmod 777 {} ;
Dirs: sudo find . -type d -exec chmod 777 {} ;
Please note this was used in CentOS Linux on command line with Putty. Everything was set to max so there wasn’t a problem with permissions.

HOWEVER, when I downloaded the sugarcrm.log file I had the metric butt-ton (344 times to be exact) of the same error:
Mon Aug 22 22:30:15 2016 [31564][-none-][FATAL] Query 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 : MySQL error 1146: Table ‘wtd_suitecrm.aow_workflow’ doesn’t exist

I then received the following errors:
Mon Aug 22 22:30:24 2016 [31564][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteP/modules is not a file or a dir.
Mon Aug 22 22:30:24 2016 [31564][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/Suite7/modules is not a file or a dir.
Mon Aug 22 22:30:24 2016 [31564][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteR/modules is not a file or a dir.

The problem with all the errors above is that the aow_workflow table DOES exist in the database. AND the bottom SuiteP,7,R modules do exist in the folders. AND all permissions have been set to 777 in Linux before I started the install.

So, my question is where is the database installer failing? I can’t even get to a website because the index.php file won’t allow it.
Thanks for any help!
Thomas

Mijalkovic · 26 August 2016 12:32

I have a similar problem here after upgrading to 7.7.2
When I do a “Quick repair and rebuild” in my log there are 3 errors:
[FATAL] ERROR: rmdir_recursive(): argument cache/themes/Sugar5/modules is not a file or a dir.
[FATAL] ERROR: rmdir_recursive(): argument cache/themes/Suite7/modules is not a file or a dir.
[FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteR/modules is not a file or a dir.

Of course there are those directories and files in them.

Someone mentioned that this problem is related with permissions.
I am on IIS 7.5 and my IUSR and IIS_IUSR both have full access granted.

Any ideas?

Also I used to have error for the forth SuiteP theme but apparently it stopped (I believe when I made it default)

loydte3 · 27 August 2016 04:21

Downloaded SuiteCRM-7.7.3.zip and am still getting the same error. All the above in my post is the same.

loydte3 · 4 September 2016 02:05

Downloaded SuiteCRM-7.7.4.zip and am still getting the same error. All the above in my post is the same.

loydte3 · 4 September 2016 02:09

I’m running on a CentOS system so my problem is completely different. This is one of the reasons why I’m not a fan of PHP and MariaDB. I’m much happier with CFML on Lucee because it is much easier to debug. This stuff is getting painful because no one is responding and I KNOW there are more people out there having the same issues that I am. I’m just going to keep logging it on here until they either fix it or I figure it out. When I do, I will post here what I did. Again, this will be pertinent CentOS and not IIS. Hope you figure out your problem!
Tom

loydte3 · 21 October 2016 06:23

Downloaded SuiteCRM-7.7.5.zip and SuiteCRM-7.7.6.zip and I am still getting the same error. All the above in my post is the same. What gives SuiteCRM? Same errors. Why is it not working?

loydte3 · 22 October 2016 03:08

I think I may have figured it out because my copy is now working.

Here’s a previous post that had a similar issue:
https://www.suitecrm.com/forum/installation-upgrade-help/1534-blank-screen-after-complete-installation

I used it to some extent and had to fiddle around with the folders/files that are mentioned in the above posting.

You may have to load up your files again. The best thing is to mess around with the file permissions to get it working. Why it doesn’t “just work” I don’t know but now I have it working for me and hope it helps someone else on this board. I also found that I was able to make the changes much quicker from command line in linux versus doing it through my FTP program, FileZilla.

Good luck!