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(): )