Page 1 of 1

Issues with Processmaker 3.0.1.8 Install

Posted: Thu Jun 16, 2016 3:49 pm
by kongmeng
When I click the Reassign on the Home page it gives me the following errors.
Code: Select all
RuntimeException:

 [wrapped: It is not possible to execute the query. Please contact your system administrator]

    At BasePeer::doSelect()
    in /opt/processmaker/workflow/engine/classes/model/om/BaseAppCacheViewPeer.php line 423
    At BaseAppCacheViewPeer::doSelectRS()
    in /opt/processmaker/workflow/engine/methods/cases/casesListExtJs.php line 485
    At getAllUsersArray() in /opt/processmaker/workflow/engine/methods/cases/casesListExtJs.php line 237
    At require_once() in /opt/processmaker/workflow/public_html/sysGeneric.php line 2027
    At include() in /opt/processmaker/workflow/public_html/app.php line 61

When I click the Participated on the Home page I get the following error and after I click ok it logs me out.
Code: Select all
[wrapped: It is not possible to execute the query. Please contact your system administrator]
I am not sure what is causing the issue.

I am running the following:

CentOS 7
Mysql 5.7
PHP 5.6
Apache 2.4

It should be straightforward but the two items listed above is blocking the deployment of this software. I can't see to figure out what the issue maybe since everything else seems to be working just fine. Thank you.

Re: Issues with Processmaker 3.0.1.8 Install

Posted: Thu Jun 16, 2016 4:31 pm
by kongmeng
Hi,

You can close this issue. I just kept installing and uninstalling. Some how it works now. No idea why. Note no errors where present in the install file, httpd file, and mysql file.

Re: Issues with Processmaker 3.0.1.8 Install

Posted: Thu Jun 16, 2016 5:41 pm
by amosbatto
Your errors are caused by database queries. PM 3.0.1.8 has only been tested with MySQL 5.5. See: http://wiki.processmaker.com/3.0/Supported_Stacks

If you see other errors, you might want to install MySQL 5.5.

Re: Issues with Processmaker 3.0.1.8 Install

Posted: Wed Apr 05, 2017 3:20 am
by cdonis
Same happened. Solution that work for me: change the mysql mode

Edit in /etc/mysql/my.cnf
Under [mysqld], add or modify slq_mode
sql_mode = ""

Hope this be usefull,