Hello,
We've been exploring and making tests over this new module and at some point we wanted to begin again, so knowing that by disabling the module, it cleans everything attached to it, I thought I could do that to clean up our tests and begin again.
The issue is that when I abled it again, I got twice the status "submit", "accepted" and "rejeted". I didn't see it at once so I kept doing some tests and when I realised it, I said to myself : "Ok, I'm gonna disable the module, delete the status if they're still there (which happened) and then reable it".
But now, I have no more those three status, and when I look at the log file, I realised my problem:
The disabling fonctionality keeps aborting with the following error :
2019-06-17 20:40:22.262 ***** ERROR ***** [V8.0.4] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.Resource' doesn't exist
2019-06-17 20:40:22.262 ***** ERROR ***** [V8.0.4] For query : UPDATE Resource SET isEmployee=0 WHERE isEmployee=1
2019-06-17 20:40:22.262 ***** ERROR ***** [V8.0.4] Strack trace :
2019-06-17 20:40:22.262 ***** ERROR ***** [V8.0.4] #0 Sql->query called at [/var/www/html/projeqtor/tool/projeqtor-hr.php:451]
2019-06-17 20:40:22.263 ***** ERROR ***** [V8.0.4] #1 initPurgeLeaveSystemElements called at [/var/www/html/projeqtor/model/Module.php:79]
2019-06-17 20:40:22.263 ***** ERROR ***** [V8.0.4] #2 Module->save called at [/var/www/html/projeqtor/tool/saveModuleStatus.php:40]
2019-06-17 20:40:22.263 ===== TRACE ===== InitLeaveSystemElement - ERROR on QUERY = UPDATE Resource SET isEmployee=0 WHERE isEmployee=1
2019-06-17 20:40:22.263 ===== TRACE ===== 0 Raison fin de contrat de travail(s) supprimé(s)<input type="hidden" id="lastSaveId" value="" /><input type="hidden" id="lastOperation" value="delete" /><input type="hidden" id="lastOperationStatus" value="OK" /><input type="hidden" id="noDataMessage" value="<br/><i> Aucun élément Raison fin de contrat de travail sélectionné.</i>" />
2019-06-17 20:40:22.263 ===== TRACE ===== Change LeaveSystemActiv to NO :ERROR
2019-06-17 20:40:22.263 ===== TRACE ===== 0 Raison fin de contrat de travail(s) supprimé(s)<input type="hidden" id="lastSaveId" value="" /><input type="hidden" id="lastOperation" value="delete" /><br/>LEAVE SYSTEM ERASING ABORTED. Error on resource's update<input type="hidden" id="lastSaveId" value="" /><input type="hidden" id="lastOperation" value="Resource's update" /><input type="hidden" id="lastOperationStatus" value="ERROR" />
I work on a CentOs Server with a mariaDB Database.
Can you help me fix this, please?
Thank you
MCanuto