Forum

[SOLVED] Error on d...
 
Notifications
Clear all

[SOLVED] Error on disabling REGULATED ABSENCES MODULE

5 Posts
3 Users
0 Reactions
2,518 Views
(@mcanuto)
Posts: 183
Active Member
Topic starter
 
[#6068]

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


 
Posted : 17 Jun 2019 23H21
(@babynus)
Posts: 14952
Member Admin
 

Issue recorded as Ticket #4081


 
Posted : 21 Jun 2019 17H48
(@mcanuto)
Posts: 183
Active Member
Topic starter
 

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


 
Posted : 28 Jun 2019 12H56
Gautier
(@gautier)
Posts: 207
Member Admin Registered
 

Hello,

did you clean your browser cache ?


 
Posted : 28 Jun 2019 18H13
(@babynus)
Posts: 14952
Member Admin
 

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


 
Posted : 29 Jun 2019 15H08
Share:

Scroll to Top