ProcessMaker Forum | BPM Workflow Simplified

Hi everyone,

I want to create multiple workspaces in my Processmaker I followed this https://wiki.processmaker.com/3.1/Workspaces .
but when I click on test, it keeps on loading and after 1 minute it gives following error It was throwing this error after exactly 1min so I increased mysql_timeout to 240s but still it is throwing this error.

I read this question on forum viewtopic.php?t=709062 but didn't help.

Are you using a Bitnami installation?
If so, then you need to follow these instructions:
https://www.pmusers.com/index.php/Creat ... tallations
(Of course, it is strongly recommended that you switch to a manual installation if you are using ProcessMaker in production.)

No, I'm using manual installation in CentOS.
PM version: 3.0.1.8-community-RE-1.8

rohitambre wrote: ↑Tue Jul 23, 2019 12:25 am No, I'm using manual installation in CentOS.
PM version: 3.0.1.8-community-RE-1.8

Hello rohitambre,
Are you really still using this old version of ProcessMaker?
Don't you plan to switch to 3.3.0-community-RE-1.4?
Thank you,
regards,
Tomolimo

Hi Tomolimo,
Actually this instance is already in use and I can't upgrade this instance at this moment but we need multiple workspaces

Ok,
Then, did you ensure that:
1. This requested php module is installed?
2. Mysql strict mode is off?

By the way, which version of mysql are you using?

If you didn't understand Tomolino's instructions, in the command line, do this:
php -m

Do you see "mysql" in the list?

See: https://wiki.processmaker.com/3.0/Chang ... trict_Mode

Yes, I have mysql php module and I also tried after setting sql_mode="" it is showing same error.

php version : 5.6.40
Mysql Server version: 5.7.22 MySQL Community Server

Hello rohitambre,

Don't you have any errors in the PHP error log?
Thank you,
Regards,
Tomolimo

Hi,
I have enabled php error logs from php.ini But my error file is not getting generated at given location

Hello rohitambre,

Where did you get this screen copy?
Is it in the Admin part of your PM server like shown below?
or somewhere else?
Thank you,
Regards,
Tomolimo

You can also edit your env.ini file and add the line:
debug = 1
This will show you some types of errors in the ProcessMaker interface.

Hi tomolimo and amosbatto,
the screenshot shared in last comment is from processmaker admin menu only.

and tried setting in env.ini but it is not showing any error on screen or in php log file.

But I tried creating workspace on my other server where it got created successfully.

so one of the difference that I noticed is here my mysql is running on custom port and on the other sever it is running on default port i.e. 3306 is that causing a problem?
because this viewtopic.php?t=709062 forum question also had the same problem but I tried his solution it didn't work.

rohitambre,
Under Admin > Case List Cache Builder, did you include the port number in the "Host" field like "localhost:3307"? When you clicked on "Setup Password", did it accept the new configuration?

It shows Completed message but workspace creation still giving the same error.

Are you able to login from the command line?
mysql -u root -P 3307 -p