Error adding process case to ticket

[unvsual]

When adding a process case to a ticket in GLPI, I get an error about a USER UID or TASK UID.

To reproduce the behavior:

1. Go to Assistance > Tickets
2. Select a ticket, then select process case
3. Select the process to attribute
4. See error

System info:

• OS: CentOS 7
• Browser: Google Chrome
• Version: 3.3.0-community-RE-1.6

Process diagram:

In GLPI:

Thanks in advance.

[tomolimo]

Hello @unvsual Did you set assignment rule to the first task? See Tutorial 1: https://github.com/tomolimo/processmaker/wiki/Tutorial-1 Regards, Tomolimo

[unvsual]

Hello @tomolimo, thank you for the quick reply. I have managed to test it with assignment rules and was able to surpass the problem, but now when I enter the process case I get the following error:

Any idea what it could be? Thanks again.

[tomolimo]

Hello, Which version of mysql are you using? Typically, this error message is due to the strict mode taht is not supported by ProcessMaker server. See: https://wiki.processmaker.com/3.3/ProcessMaker_Installation_Requirements

[unvsual]

I was able to find out the problem, it was SQL related, I had to add the following lines to /config/database.php

'modes' => [ 'ONLY_FULL_GROUP_BY', 'STRICT_TRANS_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ERROR_FOR_DIVISION_BY_ZERO', 'NO_ENGINE_SUBSTITUTION', ]

I will be doing some tests after this to better understand if the resolution, I'm not sure but doesn't there need to be some sort of content when entering this step? As per the documentation.

[tomolimo]

If so, I think you are not using the right version of MySQL. Are you using the version 8?

[unvsual]

Yes, I am using version 8.0.15.

[tomolimo]

Hello @unvsual That's the problem, currently ProcessMaker server doesn't support this version, see: https://wiki.processmaker.com/3.3/ProcessMaker_Installation_Requirements I already made some tests, and I saw that some modifications have to be done in several locations in the code (apart of the one you've found)... Could you respect the recommandations mentioned in the link above? Thank you, Regards, Tomolimo

[sofiammm]

Hello @tomolimo ,

Is it necessary to remove version 8.0.15 and install another one? Is it enough to follow the instructions of the link?

thnks a lot, S.

[tomolimo]

Depending on your OS, you may need to uninstall version 8, and to install version 5.7 (this version is ok I'm using it).

[sofiammm]

OS: CentOS 7

[tomolimo]

Hello @sofiammm,

I'm sorry, but I don't know this OS...

Anyway and moreover, you have to follow the wiki to install and configure PM server and PM plugin. At the end you'll find two tutorials that you MUST follow to be sure that the server and the plugin are correctly installed and configured.

Thank you Regards, Tomolimo

[tomolimo]

I close this issue as there is no feedback, Feel free to re-open if you want to add something.