Questions and discussion about using ProcessMaker: user interface, running cases & functionality

Moderator: amosbatto

By woxinwuchen
#814693
I got an error when creating a new BPMN project . Error :


Can't create Project with prj_uid: 4709892725b18bc0ed659f2098235346, workflow creation fails. [wrapped: It is not possible to execute the query. Please contact your system administrator]

I am installing processmaker in a virtual server.
Centos 7.5.1804 (core)
PHP : 5.6.36
Mysql : 5.5.60

PHP recommended version 5.6 or higher (7.0 not supported):
5.6.36
MySQL Support:
Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
cURL Version:
cURL 7.60.0
OpenSSL Version (*):
OpenSSL/1.0.2o
DOM/XML Support:
Enabled
GD Support:
bundled (2.1.0 compatible)
Multibyte Strings Support:
Enabled
Soap Support:
Enabled
Mcrypt Support:
Enabled
LDAP Support (*):
Not Enabled
Memory Limit >= 80M:
256M

I have tried to create Categories in Admin tab, it works.
The Mysql user is administrator


But I can't create a new user, it says need to specify a calendar, then I go to add a calendar, it throws out an error too.
"Admin Controller Exception
PropelException: [wrapped: It is not possible to execute the query. Please contact your system administrator]
Controller: Admin
File: /opt/processmaker/gulliver/thirdparty/propel/util/BasePeer.php
Line: 473
At BasePeer::doSelect()
in /opt/processmaker/workflow/engine/classes/model/om/BaseAddonsManagerPeer.php line 353
At BaseAddonsManagerPeer::doSelectRS()
in /opt/processmaker/workflow/engine/classes/model/om/BaseAddonsManagerPeer.php line 321
At BaseAddonsManagerPeer::doSelect()
in /opt/processmaker/workflow/engine/classes/class.licensedFeatures.php line 336
At PMLicensedFeatures->__construct()
in /opt/processmaker/workflow/engine/classes/class.licensedFeatures.php line 353
At PMLicensedFeatures::getSingleton()
in /opt/processmaker/gulliver/system/class.g.php line 5472
At G::auditLog()
in /opt/processmaker/workflow/engine/classes/model/CalendarDefinition.php line 257
At CalendarDefinition->saveCalendarInfo()
in /opt/processmaker/workflow/engine/classes/model/CalendarDefinition.php line 132
At CalendarDefinition->getCalendarInfo()
in /opt/processmaker/workflow/engine/classes/model/CalendarDefinition.php line 378
At CalendarDefinition->getCalendarFor()
in /opt/processmaker/workflow/engine/classes/class.calendar.php line 355
At calendar->setupCalendar()
in /opt/processmaker/workflow/engine/classes/class.calendar.php line 325
At calendar->calendar()
in /opt/processmaker/workflow/engine/controllers/admin.php line 91
At Admin->calendarEdit()
in /opt/processmaker/gulliver/system/class.controller.php line 127
At Controller->call()
in /opt/processmaker/workflow/public_html/sysGeneric.php line 1041
At include() in /opt/processmaker/workflow/public_html/app.php line 61"
By amosbatto
#814702
The error message says that you are having trouble with a database query. Have you disabled ONLY_FULL_GROUP_BY?

If that isn't the problem, then put debug_sql=1 in your env.ini file, and check the SQL query that is causing the error.

Also, list your PHP modules in the command line and post them here:
php -m
php -v
By woxinwuchen
#814707
amosbatto wrote: Thu Jun 07, 2018 5:50 pm The error message says that you are having trouble with a database query. Have you disabled ONLY_FULL_GROUP_BY?

If that isn't the problem, then put debug_sql=1 in your env.ini file, and check the SQL query that is causing the error.

Also, list your PHP modules in the command line and post them here:
php -m
php -v
Hi Amosbatto, Thank you for your reply. Would you pls check following my reply:

1, I have check sql_mode. It was blank . I have tried to set to following. it doesn't work
MySQL [(none)]> SELECT @@sql_mode;
+-------------------------------------+
| @@sql_mode |
+-------------------------------------+
| STRICT_TRANS_TABLES,NO_ZERO_IN_DATE |
+-------------------------------------+
1 row in set (0.00 sec)

2, My env.ini setting is below:
;Setting default_lang - Created by System on Wed 06 Jun, 2018 23:40:01
default_lang = "en"

;Setting default_skin - Created by System on Wed 06 Jun, 2018 23:40:01
default_skin = "neoclassic"

debug_sql = 1

3, php -v
# php -v
PHP 5.6.36 (cli) (built: Jun 6 2018 22:43:04)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies

4,php -m
[PHP Modules]
bcmath
Core
ctype
curl
date
dom
ereg
exif
filter
ftp
gd
gettext
hash
iconv
imagick
intl
json
libxml
mbstring
mcrypt
memcache
memcached
mhash
mysql
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
Reflection
session
shmop
SimpleXML
soap
sockets
SPL
sqlite3
standard
sysvsem
tokenizer
xml
xmlreader
xmlrpc
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache

5, log file
see attached.
Attachments
(99.14 KiB) Downloaded 10 times
By amosbatto
#814728
I don't see the problem in the log file.
When you try the same action in ProcessMaker, do you now see a more detailed error message or does it still tell you to "contact your system administrator"?
If you still see the same error message, then in your env.ini file, change from:
debug_sql = 1
To:
debug = 1
Then, try to create a new process in ProcessMaker and see if it gives you a different error message.

Now, let's go through some basic questions.
What version of PM are you installing?
What OS are you using?
Is this a manual install or a Bitnami install?
Did you disable strict mode in MySQL?
Are you importing an existing process or are you creating a new process?
By woxinwuchen
#814734
amosbatto wrote: Mon Jun 11, 2018 9:06 pm I don't see the problem in the log file.
When you try the same action in ProcessMaker, do you now see a more detailed error message or does it still tell you to "contact your system administrator"?
If you still see the same error message, then in your env.ini file, change from:
debug_sql = 1
To:
debug = 1
Then, try to create a new process in ProcessMaker and see if it gives you a different error message.

Now, let's go through some basic questions.
What version of PM are you installing?
What OS are you using?
Is this a manual install or a Bitnami install?
Did you disable strict mode in MySQL?
Are you importing an existing process or are you creating a new process?
Hi amosbatto, thank you for your help. Would you pls check attached error message screenshot. I couldn't find the log file after enable debug = 1.

What version of PM are you installing?
--3.2.1 community
What OS are you using?
--CentOS-7-x86_64-Minimal-1804
Is this a manual install or a Bitnami install?
-- it is a manual install
Did you disable strict modein MySQL?
-- I definitely did.
Are you importing an existing process or are you creating a new process?
-- creating new process.

I am using this environment installation script. http://soft.vpser.net/lnmp/lnmp1.5.tar.gz && tar zxf lnmp1.5.tar.gz && cd lnmp1.5 && ./install.sh lamp

PHP 5.6.36
Mysql 5.5.60
I am using vmare pro 14.1.1 build-7528167 on windows 7 ultimate sp1 64bit
Attachments
processmaker error debug_sql equal 1.png
processmaker error debug_sql equal 1.png (69.73 KiB) Viewed 888 times
processmaker error debug equal 1.png
processmaker error debug equal 1.png (302.56 KiB) Viewed 888 times
By amosbatto
#814741
From the error message, it looks the installation wizard didn't properly install the database. You are going to have to do a new installation of ProcessMaker.

If you post your /opt/processmaker/shared/log/install.log file, I will look at it to try to figure out what went wrong, but at this point you should delete your /opt/processmaker directory and try again. Use a different name for the database (not "wf_workflow") in Step 5 of the ProcessMaker installation wizard.

If it still doesn't work after that, then I recommend creating a new virtual machine and then do the entire installation manually. Maybe your environment installation script is screwing up something.

Thanks Amos, it kinda of worked. But the API respo[…]

Data table in the panel

Create a hidden field associated with the variab[…]

Timo, that code has been moved to: workflow/engine[…]

routeCase SOAP API error

There is no web service function to get all the va[…]