Error when change employee's status

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Post Reply
coob
Posts: 2
Joined: Thu Oct 15, 2015 7:11 pm

Error when change employee's status

Post by coob »

hi all,

I met a problem, after I create a new employee information, I cannot change employee's status, TimeTrex will show unable to connect its database.
But if I change other information, it will be successful..........

Anybody can help me ?
(I have tried to re-install, but not fix this)

And I found the error in log file:

Code: Select all

DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): #1.DBError->__construct(Object(ADODB_Exception))
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): #2.Authentication->logoutUser(8)
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): #3.UserFactory->postSave(Array(7))
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): #4.Factory->Save(1, 1)
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): #5.APIUser->setUser(Array(102), , )
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): #6.call_user_func_array(Array(2), Array(3))
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): #7.authenticatedInvokeService(APIUser, setUser, Array(3), a2e9f2f6-1d77-687b-ec22-a40354058680, Object(Authentication), Object(APIAuthentication))
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): "
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): 
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): 
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): DEBUG [L0065] [00441ms]: DBError::__construct(): mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your My
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): SQL server version for the right syntax to use n
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): ear 'as a WHERE a.object_id = 8 AND a.type_id = 8
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): DEBUG [L0065] [00441ms]: DBError::__construct(): 00' at line 1] in adodb_throw(DELETE FROM authentication as a WHERE a.object_id = 8 AND a.type_id = 800
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): , )
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): DEBUG [L0065] [00441ms]: DBError::__construct(): 
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): DEBUG [L0073] [00441ms]: DBError::__construct(): End Exception...
DEBUG [L0153] [00765ms]: Debug::ErrorHandler(): DEBUG [L0153] [00511ms]: Debug::ErrorHandler(): )
Attachments
timetrex.log
this is the log file
(750.7 KiB) Downloaded 219 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Error when change employee's status

Post by shaunw »

Try running the TimeTrex web-based installer again and see if that makes any difference.
coob
Posts: 2
Joined: Thu Oct 15, 2015 7:11 pm

Re: Error when change employee's status

Post by coob »

shaunw wrote:Try running the TimeTrex web-based installer again and see if that makes any difference.
I have modified the code due to mysql not spport table alias in delete command as the other database , and seems no error any more.
for example:
change:
delete from xxxx as a where xxxxx
to:
delete a from xxxx as a where xxxxxx

change:
delete from xxx as a using xxx as b where a.xx=b.xx
to:
delete a from xxx as a left join xxx as b on a.xx=b.xx where
Post Reply