I was adding an employee to the payroll and when I click on submit, this is what I got.
I did some search in here and all I could find was someone saying something about mysql database having issues when IP address changes.TimeTrex is currently undergoing maintenance. We're sorry for any inconvenience this may cause. Please try back later
http://forums.timetrex.com/viewtopic.ph ... e9bba0b8d8
I set the server to have a static IP address but that DIDN"T help.
I then realized that whenever I select a pay period to add the new employee to, that is when I got the above error. I omitted the pay period and I was ABLE to add my employee.
I've tried that with a second employee and the scenario repeats itself. What could be the problem?
PS:_____________
After adding the employee, I had to add him to my pay period schedule. But when I add him to that pay period, I get the error above Again. So its clearly a pay period issue. Be it when adding a new employee, or later on when adding that employee to a pay period:
I set verbose = 11 and this is what I get:
Code: Select all
(mysqlt): SET SESSION sql_mode='ansi' (mysqlt): SET SESSION time_zone='GMT' (mysqlt): select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = '8ce2bd24fb249e9556fba13bc70ba76b' AND ip_address = '192.168.1.100' AND updated_date >= 1196441134 (mysqlt): update authentication set updated_date = 1196455534 where session_id = '8ce2bd24fb249e9556fba13bc70ba76b' (mysqlt): SET SESSION time_zone='Africa/Nairobi' (mysqlt): select * from station where company_id = '1' AND station_id = 'f454aa8d339a2c69504a2e310951e11b' AND deleted = 0 (mysqlt): select * from cron WHERE deleted = 0 ORDER BY last_run_date DESC LIMIT 1 (mysqlt): select d.severity_id as severity_id, count(*) as count from exception as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN exception_policy as d ON a.exception_policy_id = d.id LEFT JOIN pay_period as e ON b.pay_period_id = e.id where b.user_id = '1' AND b.date_stamp < '2007-11-30' AND e.status_id = 10 AND NOT EXISTS ( select z.id from request as z where z.user_date_id = a.user_date_id AND z.status_id = 30 ) AND ( a.deleted = 0 AND b.deleted = 0 AND e.deleted=0) GROUP BY d.severity_id ORDER BY d.severity_id desc (mysqlt): SET AUTOCOMMIT=0 (mysqlt): BEGIN (mysqlt): select id from pay_period_schedule where company_id = '1' AND name = 'My Monthly Pay' AND deleted=0 LIMIT 1 /payroll/proll/tmp///28/adodb_288700cf3e64d69e38418ac2de8a6323.cache reloaded, ttl=11666 [ select * from pay_period_schedule_user where id = -1 ]
(mysqlt): select a.* from pay_period_schedule_user as a, pay_period_schedule as b where b.id = a.pay_period_schedule_id AND pay_period_schedule_id = '3' order by a.user_id asc (mysqlt): select * from users where id = '36' AND deleted = 0 (mysqlt): select a.id from pay_period_schedule_user as a, pay_period_schedule as b where a.pay_period_schedule_id = b.id AND a.user_id = '36' AND b.deleted=0 LIMIT 1 (mysqlt): update pay_period_schedule_user_id_seq set id=LAST_INSERT_ID(id+1); /payroll/proll/tmp///bf/adodb_bf8569bfd4bdc03f5a1e6507e6229e61.cache cache failure: Timeout 0 (see sql below)
(mysqlt): select pay_period_schedule_id,user_id,id from pay_period_schedule_user where id = -1 FailTrans was called
ADOConnection.FailTrans() % line 32, file: Exception.class.php
DBError.__construct(Object:ADODB_Exception) % line 628, file: Factory.class.php
Factory.getEmptyRecordSet() % line 709, file: Factory.class.php
Factory.getInsertQuery() % line 803, file: Factory.class.php
Factory.Save() % line 569, file: PayPeriodScheduleFactory.class.php
PayPeriodScheduleFactory.setUser(Array[10]) % line 115, file: EditPayPeriodSchedule.phpThanks
I cleared the cache, attempted to add the employee to a pay period as I had mentioned above and it worked.