tomolimo / processmaker

GLPI plugin that provides an interface with ProcessMaker (http://www.processmaker.com/)
30 stars 11 forks source link

Error on creating new case #51

Closed orouet closed 6 years ago

orouet commented 6 years ago

I've got an error message when creating a new case : Erreur à la création du cas ! Column "DEL_INDEX" cannot be null. (100) My configuration : GLPI 9.1.6 ProcessMaker Server 3.0.1.8-RE-1.8 ProcessMaker plugin 3.2.5

tomolimo commented 6 years ago

Hello, Could post the logs from the files/_log folder of GLPI? The php-errors.log and the sql-errors.log Could you also post the PHP error log file for Processmaker server? See location of this file here: https://github.com/tomolimo/processmaker/issues/39#issuecomment-354281483 Thank you, Regards, Tomolimo

orouet commented 6 years ago

No GLPI log files are produced. In PHP error log we can see :

[13-Feb-2018 13:48:50 Europe/Paris] PHP Notice:  Trying to get property of non-object in /opt/processmaker-3.0.1.8-RE-1.8/workflow/engine/methods/services/soap2.php on line 756
[13-Feb-2018 13:48:50 Europe/Paris] Unable to execute INSERT statement. [wrapped: Could not execute update [Native Error: Column 'APP_PRO_TITLE' cannot be null] [User Info: INSERT INTO APP_DELEGATION (`APP_UID`,`DEL_INDEX`,`DEL_PREVIOUS`,`DEL_LAST_INDEX`,`PRO_UID`,`TAS_UID`,`USR_UID`,`DEL_TYPE`,`DEL_THREAD`,`DEL_THREAD_STATUS`,`DEL_PRIORITY`,`DEL_DELEGATE_DATE`,`DEL_INIT_DATE`,`DEL_TASK_DUE_DATE`,`DEL_RISK_DATE`,`DEL_DATA`) VALUES ('4268818675a82deb22c3ea7080511761',1,0,1,'2030511805a82bfd9b72dc7068690666','6665680065a82bfd9c56454035542183','4794469455a81a9910e4b88000815024','NORMAL',1,'OPEN','3','2018-02-13 13:48:50','2018-02-13 13:48:50','2018-02-14 13:48:50','2018-02-14 12:12:50','')]]
[13-Feb-2018 13:48:50 Europe/Paris] PHP Notice:  Undefined property: wsResponse::$caseId in /opt/processmaker-3.0.1.8-RE-1.8/workflow/engine/methods/services/soap2.php on line 780
tomolimo commented 6 years ago

Hello @orouet Could you also post screen copies of the configuration of PM server, of PM plugin and of GLPI? Thank you, Regards, Tomolimo

orouet commented 6 years ago

I'm forced to disable the plugin due to escaped strings probs. I will send screen copy as soon as possible (out of working hours)

tomolimo commented 6 years ago

Don't you use a test system?

tomolimo commented 6 years ago

Hello, A new release is out that fixes the trouble of the quotes. Could you test it? Thank you Regards, Tomolimo

tomolimo commented 6 years ago

Hello, Closed as I got no news, feel free to reopen if you need. Thank you, Regards, Tomolimo