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="noDataMessage" value="
Aucun élément Raison fin de contrat de travail sélectionné." /> 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)
LEAVE SYSTEM ERASING ABORTED. Error on resource's update
I work on a CentOs Server with a mariaDB Database.
Can you help me fix this, please?
Thank you
MCanuto
Issue recorded as Ticket #4081
Hello,
is this Ticket #4081 fixed by the version 8.0.6?
I've installed the latest stable version, but I still have de same trouble.
What can I do, please?
thank you for your help.
MCanuto
Hello,
did you clean your browser cache ?
Yes issue you reported
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
is fixed on V8.0.6
If you still have issue, please report error loggued in log file