TimeTrex Time and Attendance

Posted: **Fri Mar 09, 2007 12:48 pm**

I have noticed that it seems people are hitting the submit button multiple times. I was wondering if you could add some javascript to disable submit buttons after a submit has been clicked.

Posted: **Fri Mar 09, 2007 2:32 pm**

Is there any particular page that they are pressing submit multiple times?

Posted: **Fri Mar 09, 2007 2:38 pm**

It appears as though maybe the punch tables is what caused the problem on my machine. Thats where I would really like to see it.

Posted: **Sat Mar 10, 2007 6:48 am**

Its now user_date table that is getting duplicat entries. I looked to confirm and there is a duplicate entry and I have taken care of several other duplicate entries. Any idea as to why this might be happening?

Posted: **Sat Mar 10, 2007 11:52 am**

Are you running MySQL by chance? If so, at your mysql console try running:

show table status from timetrex;

What storage engine are your tables using?

Posted: **Mon Mar 12, 2007 6:19 am**

Here is the status list. Its in Comma Delimited Format.

"Name","Engine","Version","Row_format","Rows","Avg_row_length","Data_length","Max_data_length","Index_length","Data_free","Auto_increment","Create_time","Update_time","Check_time","Collation","Checksum","Create_options","Comment"
"absence_policy","InnoDB",10,"Compact",2,8192,16384,0,16384,0,3,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"absence_policy_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 13:17:46","2007-01-16 13:18:04","","latin1_swedish_ci",,"",""
"accrual","InnoDB",10,"Compact",90,182,16384,0,32768,0,96,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"accrual_balance","InnoDB",10,"Compact",87,188,16384,0,16384,0,107,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"accrual_balance_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 15:08:26","2007-03-01 10:15:23","","latin1_swedish_ci",,"",""
"accrual_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 15:08:26","2007-03-01 10:15:23","","latin1_swedish_ci",,"",""
"accrual_policy","InnoDB",10,"Compact",4,4096,16384,0,16384,0,5,"2007-02-07 15:11:24","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"accrual_policy_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 13:11:07","2007-01-16 13:58:32","","latin1_swedish_ci",,"",""
"accrual_policy_milestone","MyISAM",10,"Fixed",0,0,0,18014398509481983,1024,0,1,"2007-02-07 15:11:24","2007-02-07 15:11:24","","latin1_swedish_ci",,"",""
"authentication","InnoDB",10,"Compact",0,0,16384,0,16384,0,426,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"authorizations","InnoDB",10,"Compact",2,8192,16384,0,16384,0,3,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"authorizations_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-02-26 13:46:23","2007-03-08 06:55:30","","latin1_swedish_ci",,"",""
"bank_account","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"branch","InnoDB",10,"Compact",4,4096,16384,0,16384,0,5,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"branch_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 15:02:14","2007-01-17 15:16:02","","latin1_swedish_ci",,"",""
"bread_crumb","InnoDB",10,"Compact",21,780,16384,0,32768,0,968,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"company","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:43","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"company_deduction","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"company_deduction_pay_stub_entry_account","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"company_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:44:33","2007-01-16 11:44:33","","latin1_swedish_ci",,"",""
"company_user_count","InnoDB",10,"Compact",66,248,16384,0,16384,0,67,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"company_user_count_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 04:15:02","2007-03-12 00:15:03","","latin1_swedish_ci",,"",""
"cron","InnoDB",10,"Compact",9,1820,16384,0,16384,0,10,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"cron_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:43:42","2007-02-07 15:11:24","","latin1_swedish_ci",,"",""
"department","InnoDB",10,"Compact",7,2340,16384,0,16384,0,8,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"department_branch","InnoDB",10,"Compact",9,1820,16384,0,16384,0,10,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"department_branch_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 15:17:06","2007-01-22 15:53:51","","latin1_swedish_ci",,"",""
"department_branch_user","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"department_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 15:17:06","2007-01-22 15:53:51","","latin1_swedish_ci",,"",""
"exception","InnoDB",10,"Compact",43,381,16384,0,32768,0,330,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"exception_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 09:33:59","2007-03-11 00:30:05","","latin1_swedish_ci",,"",""
"exception_policy","InnoDB",10,"Compact",12,1365,16384,0,16384,0,13,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"exception_policy_control","InnoDB",10,"Compact",1,16384,16384,0,16384,0,11,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"exception_policy_control_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 13:23:32","2007-01-16 13:50:11","","latin1_swedish_ci",,"",""
"exception_policy_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 13:50:11","2007-01-16 13:50:11","","latin1_swedish_ci",,"",""
"help","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"help_group","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"help_group_control","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"hierarchy_control","InnoDB",10,"Compact",2,8192,16384,0,16384,0,3,"2007-01-16 11:43:40","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"hierarchy_control_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 16:17:18","2007-01-17 16:17:39","","latin1_swedish_ci",,"",""
"hierarchy_object_type","InnoDB",10,"Compact",2,8192,16384,0,16384,0,4,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"hierarchy_object_type_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 16:17:18","2007-01-17 16:20:29","","latin1_swedish_ci",,"",""
"hierarchy_share","InnoDB",10,"Compact",4,4096,16384,0,16384,0,15,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"hierarchy_share_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 16:22:00","2007-01-22 16:28:42","","latin1_swedish_ci",,"",""
"hierarchy_tree","InnoDB",10,"Compact",95,172,16384,0,49152,0,,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"holiday_policy","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"holiday_policy_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:51:20","2007-01-16 11:51:20","","latin1_swedish_ci",,"",""
"holiday_policy_recurring_holiday","InnoDB",10,"Compact",5,3276,16384,0,16384,0,6,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"holiday_policy_recurring_holiday_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:51:20","2007-01-16 11:51:20","","latin1_swedish_ci",,"",""
"holidays","InnoDB",10,"Compact",0,0,16384,0,49152,0,1,"2007-01-16 11:43:43","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"income_tax_rate","InnoDB",10,"Compact",118,138,16384,0,16384,0,129,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"income_tax_rate_us","InnoDB",10,"Compact",367,178,65536,0,16384,0,702,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"meal_policy","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"meal_policy_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 13:15:42","2007-01-16 13:15:42","","latin1_swedish_ci",,"",""
"message","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"message_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-02-26 13:46:09","2007-02-26 13:46:09","","latin1_swedish_ci",,"",""
"other_field","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"over_time_policy","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"over_time_policy_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:49:40","2007-01-16 11:49:40","","latin1_swedish_ci",,"",""
"pay_period","InnoDB",10,"Compact",5,3276,16384,0,16384,0,6,"2007-02-07 15:11:25","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"pay_period_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 14:06:23","2007-03-03 00:00:03","","latin1_swedish_ci",,"",""
"pay_period_schedule","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:43","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"pay_period_schedule_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 14:06:23","2007-01-16 14:06:23","","latin1_swedish_ci",,"",""
"pay_period_schedule_user","InnoDB",10,"Compact",107,153,16384,0,32768,0,110,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"pay_period_schedule_user_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 14:36:50","2007-03-08 11:25:29","","latin1_swedish_ci",,"",""
"pay_period_time_sheet_verify","InnoDB",10,"Compact",9,1820,16384,0,16384,0,10,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"pay_period_time_sheet_verify_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-22 15:48:34","2007-03-05 10:55:10","","latin1_swedish_ci",,"",""
"pay_stub","InnoDB",10,"Compact",0,0,16384,0,32768,0,1,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"pay_stub_amendment","InnoDB",10,"Compact",0,0,16384,0,32768,0,1,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"pay_stub_entry","InnoDB",10,"Compact",0,0,16384,0,32768,0,1,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"pay_stub_entry_account","InnoDB",10,"Compact",28,585,16384,0,16384,0,29,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"pay_stub_entry_account_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:44:34","2007-01-16 11:44:34","","latin1_swedish_ci",,"",""
"pay_stub_entry_account_link","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"pay_stub_entry_account_link_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:44:34","2007-01-16 11:44:34","","latin1_swedish_ci",,"",""
"permission","InnoDB",10,"Compact",2507,98,245760,0,147456,0,3736,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"permission_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:45:57","2007-03-07 09:06:55","","latin1_swedish_ci",,"",""
"policy_group","InnoDB",10,"Compact",2,8192,16384,0,16384,0,3,"2007-02-07 15:11:24","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"policy_group_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 14:10:06","2007-01-16 14:10:26","","latin1_swedish_ci",,"",""
"policy_group_over_time_policy","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"policy_group_premium_policy","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"policy_group_round_interval_policy","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"policy_group_user","InnoDB",10,"Compact",106,154,16384,0,32768,0,108,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"policy_group_user_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 14:36:50","2007-03-07 15:25:55","","latin1_swedish_ci",,"",""
"premium_policy","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"punch","InnoDB",10,"Compact",340,192,65536,0,32768,0,352,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"punch_control","InnoDB",10,"Compact",191,257,49152,0,32768,0,191,"2007-01-16 11:43:43","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"punch_control_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 09:33:59","2007-03-12 09:06:19","","latin1_swedish_ci",,"",""
"punch_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 09:33:59","2007-03-12 09:06:20","","latin1_swedish_ci",,"",""
"recurring_holiday","InnoDB",10,"Compact",11,1489,16384,0,16384,0,12,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"recurring_holiday_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:44:34","2007-01-16 11:44:35","","latin1_swedish_ci",,"",""
"recurring_ps_amendment","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"recurring_ps_amendment_user","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"recurring_schedule_control","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"recurring_schedule_control_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-02-20 07:42:35","2007-02-20 07:42:35","","latin1_swedish_ci",,"",""
"recurring_schedule_template","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"recurring_schedule_template_control","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"recurring_schedule_template_control_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-02-20 07:42:00","2007-02-20 07:42:00","","latin1_swedish_ci",,"",""
"recurring_schedule_template_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-02-20 07:42:00","2007-02-20 07:42:00","","latin1_swedish_ci",,"",""
"recurring_schedule_user","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"request","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"request_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-02-26 13:46:08","2007-02-26 13:46:08","","latin1_swedish_ci",,"",""
"roe","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"round_interval_policy","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"round_interval_policy_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:51:56","2007-01-16 11:51:56","","latin1_swedish_ci",,"",""
"schedule","InnoDB",10,"Compact",52,315,16384,0,32768,0,53,"2007-01-16 11:43:43","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"schedule_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-30 12:43:36","2007-02-20 09:57:52","","latin1_swedish_ci",,"",""
"schedule_policy","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"schedule_policy_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-02-23 09:44:11","2007-02-23 09:44:11","","latin1_swedish_ci",,"",""
"station","InnoDB",10,"Compact",114,574,65536,0,32768,0,155,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"station_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:45:59","2007-03-12 09:06:06","","latin1_swedish_ci",,"",""
"station_user","InnoDB",10,"Compact",2,8192,16384,0,16384,0,21,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"station_user_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:45:59","2007-01-30 16:49:26","","latin1_swedish_ci",,"",""
"system_log","InnoDB",10,"Compact",6261,253,1589248,0,409600,0,7268,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"system_log_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:43:42","2007-03-12 09:06:23","","latin1_swedish_ci",,"",""
"system_setting","InnoDB",10,"Compact",9,1820,16384,0,16384,0,10,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"system_setting_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:43:42","2007-01-17 08:47:03","","latin1_swedish_ci",,"",""
"user_date","InnoDB",10,"Compact",5753,51,294912,0,475136,0,5682,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_date_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 03:15:03","2007-03-11 23:15:14","","latin1_swedish_ci",,"",""
"user_date_total","InnoDB",10,"Compact",5620,279,1572864,0,245760,0,14966,"2007-01-16 11:43:42","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_date_total_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 09:33:59","2007-03-12 09:06:20","","latin1_swedish_ci",,"",""
"user_deduction","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_default","InnoDB",10,"Compact",1,16384,16384,0,16384,0,2,"2007-01-16 11:43:43","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_default_company_deduction","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_default_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 14:05:16","2007-01-16 14:05:16","","latin1_swedish_ci",,"",""
"user_generic_data","InnoDB",10,"Compact",88,744,65536,0,16384,0,77,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_generic_data_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-17 09:33:15","2007-03-09 12:47:04","","latin1_swedish_ci",,"",""
"user_generic_status","InnoDB",10,"Compact",0,0,16384,0,32768,0,1,"2007-01-16 11:43:43","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_group","InnoDB",10,"Compact",12,1365,16384,0,0,0,13,"2007-01-16 11:43:43","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_group_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 14:41:03","2007-01-22 16:11:17","","latin1_swedish_ci",,"",""
"user_group_tree","InnoDB",10,"Compact",13,1260,16384,0,0,0,,"2007-01-16 11:43:43","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_pay_period_total","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_preference","InnoDB",10,"Compact",107,153,16384,0,16384,0,108,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_preference_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:48:49","2007-03-07 09:06:31","","latin1_swedish_ci",,"",""
"user_tax","InnoDB",10,"Compact",0,0,16384,0,16384,0,1,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_title","InnoDB",10,"Compact",14,1170,16384,0,16384,0,17,"2007-01-16 11:43:41","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"user_title_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 13:37:15","2007-01-22 16:11:46","","latin1_swedish_ci",,"",""
"user_wage","InnoDB",10,"Compact",0,0,16384,0,32768,0,1,"2007-02-07 15:11:24","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"users","InnoDB",10,"Compact",25,2621,65536,0,16384,0,108,"2007-01-16 11:43:43","","","latin1_swedish_ci",,"","InnoDB free: 19456 kB"
"users_id_seq","MyISAM",10,"Fixed",1,7,7,1970324836974591,1024,0,,"2007-01-16 11:45:57","2007-03-07 09:06:31","","latin1_swedish_ci",,"",""

Posted: **Mon Mar 12, 2007 1:11 pm**

That all looks fine, the tables that should be InnoDB are.

Can you please post the rows that you feel are duplicate?

Posted: **Tue Mar 13, 2007 6:18 am**

I am gonna try to get you as much information as I can. Here is the error log I recieved this morning and I am sure more will come.

DEBUG [155]: [Function](): Production: 1 
DEBUG [56]: [Function](): 0. User: jefferya 
DEBUG [192]: UserDateFactory::findOrInsertUserDate(): Found Already Existing User Date ID: 5682 
DEBUG [56]: [Function](): 1. User: davida 
DEBUG [192]: UserDateFactory::findOrInsertUserDate(): Found Already Existing User Date ID: 5683 
DEBUG [56]: [Function](): 2. User: janeta 
DEBUG [192]: UserDateFactory::findOrInsertUserDate(): Found Already Existing User Date ID: 5684 
DEBUG [56]: [Function](): 3. User: jasonbaker 
DEBUG [192]: UserDateFactory::findOrInsertUserDate(): Found Already Existing User Date ID: 5685 
DEBUG [56]: [Function](): 4. User: jasonb 
DEBUG [195]: UserDateFactory::findOrInsertUserDate(): Inserting new UserDate row. 
DEBUG [256]: Validator::isDate(): Raw Date: 1173844800 Converted Value: 1173844800 
DEBUG [93]: UserDateFactory::findPayPeriod(): Attempting to find Pay Period for Start Date: 1173844800 
DEBUG [99]: UserDateFactory::findPayPeriod(): Date: 1173844800 
DEBUG [104]: UserDateFactory::findPayPeriod(): Pay Period Id: 5 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [720]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759303 Converted Value: 1173759303 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759303 Converted Value: 1173759303 
DEBUG [796]: Factory::Save(): Insert ID: 5686 
DEBUG [702]: Factory::getInsertQuery(): Insert 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759303 Converted Value: 1173759303 
DEBUG [847]: Factory::Save(): Calling postSave() 
DEBUG [730]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1 
DEBUG [56]: [Function](): 5. User: amyb 
DEBUG [192]: UserDateFactory::findOrInsertUserDate(): Found Already Existing User Date ID: 5688 
DEBUG [56]: [Function](): 6. User: jennyb 
DEBUG [195]: UserDateFactory::findOrInsertUserDate(): Inserting new UserDate row. 
DEBUG [256]: Validator::isDate(): Raw Date: 1173844800 Converted Value: 1173844800 
DEBUG [93]: UserDateFactory::findPayPeriod(): Attempting to find Pay Period for Start Date: 1173844800 
DEBUG [99]: UserDateFactory::findPayPeriod(): Date: 1173844800 
DEBUG [104]: UserDateFactory::findPayPeriod(): Pay Period Id: 5 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [720]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759303 Converted Value: 1173759303 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759303 Converted Value: 1173759303 
DEBUG [796]: Factory::Save(): Insert ID: 5689 
DEBUG [702]: Factory::getInsertQuery(): Insert 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759303 Converted Value: 1173759303 
DEBUG [847]: Factory::Save(): Calling postSave() 
DEBUG [730]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1 
DEBUG [56]: [Function](): 7. User: courtneyb 
DEBUG [192]: UserDateFactory::findOrInsertUserDate(): Found Already Existing User Date ID: 3538 
DEBUG [56]: [Function](): 8. User: richardb 
DEBUG [192]: UserDateFactory::findOrInsertUserDate(): Found Already Existing User Date ID: 5690 
DEBUG [56]: [Function](): 9. User: michael 
DEBUG [192]: UserDateFactory::findOrInsertUserDate(): Found Already Existing User Date ID: 5691 
DEBUG [56]: [Function](): 10. User: alanab 
DEBUG [195]: UserDateFactory::findOrInsertUserDate(): Inserting new UserDate row. 
DEBUG [256]: Validator::isDate(): Raw Date: 1173844800 Converted Value: 1173844800 
DEBUG [93]: UserDateFactory::findPayPeriod(): Attempting to find Pay Period for Start Date: 1173844800 
DEBUG [99]: UserDateFactory::findPayPeriod(): Date: 1173844800 
DEBUG [104]: UserDateFactory::findPayPeriod(): Pay Period Id: 5 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [720]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [796]: Factory::Save(): Insert ID: 5692 
DEBUG [702]: Factory::getInsertQuery(): Insert 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [847]: Factory::Save(): Calling postSave() 
DEBUG [730]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1 
DEBUG [56]: [Function](): 11. User: bruceb 
DEBUG [192]: UserDateFactory::findOrInsertUserDate(): Found Already Existing User Date ID: 5693 
DEBUG [56]: [Function](): 12. User: sandrab 
DEBUG [195]: UserDateFactory::findOrInsertUserDate(): Inserting new UserDate row. 
DEBUG [256]: Validator::isDate(): Raw Date: 1173844800 Converted Value: 1173844800 
DEBUG [93]: UserDateFactory::findPayPeriod(): Attempting to find Pay Period for Start Date: 1173844800 
DEBUG [99]: UserDateFactory::findPayPeriod(): Date: 1173844800 
DEBUG [104]: UserDateFactory::findPayPeriod(): Pay Period Id: 5 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [720]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [796]: Factory::Save(): Insert ID: 5694 
DEBUG [702]: Factory::getInsertQuery(): Insert 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [847]: Factory::Save(): Calling postSave() 
DEBUG [730]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1 
DEBUG [56]: [Function](): 13. User: patriciab 
DEBUG [192]: UserDateFactory::findOrInsertUserDate(): Found Already Existing User Date ID: 5695 
DEBUG [56]: [Function](): 14. User: byronc 
DEBUG [195]: UserDateFactory::findOrInsertUserDate(): Inserting new UserDate row. 
DEBUG [256]: Validator::isDate(): Raw Date: 1173844800 Converted Value: 1173844800 
DEBUG [93]: UserDateFactory::findPayPeriod(): Attempting to find Pay Period for Start Date: 1173844800 
DEBUG [99]: UserDateFactory::findPayPeriod(): Date: 1173844800 
DEBUG [104]: UserDateFactory::findPayPeriod(): Pay Period Id: 5 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [720]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [796]: Factory::Save(): Insert ID: 5697 
DEBUG [702]: Factory::getInsertQuery(): Insert 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [847]: Factory::Save(): Calling postSave() 
DEBUG [730]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1 
DEBUG [56]: [Function](): 15. User: sherylc 
DEBUG [195]: UserDateFactory::findOrInsertUserDate(): Inserting new UserDate row. 
DEBUG [256]: Validator::isDate(): Raw Date: 1173844800 Converted Value: 1173844800 
DEBUG [93]: UserDateFactory::findPayPeriod(): Attempting to find Pay Period for Start Date: 1173844800 
DEBUG [99]: UserDateFactory::findPayPeriod(): Date: 1173844800 
DEBUG [104]: UserDateFactory::findPayPeriod(): Pay Period Id: 5 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [720]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [796]: Factory::Save(): Insert ID: 5699 
DEBUG [702]: Factory::getInsertQuery(): Insert 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [847]: Factory::Save(): Calling postSave() 
DEBUG [730]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1 
DEBUG [56]: [Function](): 16. User: nancyc 
DEBUG [195]: UserDateFactory::findOrInsertUserDate(): Inserting new UserDate row. 
DEBUG [256]: Validator::isDate(): Raw Date: 1173844800 Converted Value: 1173844800 
DEBUG [93]: UserDateFactory::findPayPeriod(): Attempting to find Pay Period for Start Date: 1173844800 
DEBUG [99]: UserDateFactory::findPayPeriod(): Date: 1173844800 
DEBUG [104]: UserDateFactory::findPayPeriod(): Pay Period Id: 5 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [720]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [796]: Factory::Save(): Insert ID: 5701 
DEBUG [702]: Factory::getInsertQuery(): Insert 
DEBUG [256]: Validator::isDate(): Raw Date: 1173759304 Converted Value: 1173759304 
DEBUG [847]: Factory::Save(): Calling postSave() 
DEBUG [730]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1 
DEBUG [56]: [Function](): 17. User: jenniferc 
DEBUG [195]: UserDateFactory::findOrInsertUserDate(): Inserting new UserDate row. 
DEBUG [256]: Validator::isDate(): Raw Date: 1173844800 Converted Value: 1173844800 
DEBUG [93]: UserDateFactory::findPayPeriod(): Attempting to find Pay Period for Start Date: 1173844800 
DEBUG [99]: UserDateFactory::findPayPeriod(): Date: 1173844800 
DEBUG [104]: UserDateFactory::findPayPeriod(): Pay Period Id: 5 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
bool(false)
</pre> 
DEBUG [720]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0 
DEBUG [737]: Factory::isValid(): Calling Validate() 
DEBUG [243] Array: UserDateFactory::isUnique(): Unique User Date.
<pre>
string(4) "5702"
</pre> 
DEBUG [405]: Validator::Error(): Validation Error: Label: date_stamp Msg: Employee can not have duplicate entries on the same day 
DEBUG [384] Array: Validator::isValid(): Errors <pre>
array(1) {
["date_stamp"]=>
array(1) {
[0]=>
string(55) "Employee can not have duplicate entries on the same day"
}
}
</pre> 

Now here is a couple of examples where the rows seens to be duplicated.
------------------------------------------------------------------------------------
Its in comma delimited format again

"id","user_id","pay_period_id","date_stamp","created_date","created_by","updated_date","updated_by","deleted_date","deleted_by","deleted"
5576,12,5,"2007-03-13",1173672903,,1173672903,,,,0
5577,12,5,"2007-03-13",1173672903,,1173672903,,,,0
5578,13,5,"2007-03-13",1173672903,,1173672903,,,,0
5579,14,5,"2007-03-13",1173672903,,1173672903,,,,0
5580,15,5,"2007-03-13",1173672903,,1173672903,,,,0
5581,16,5,"2007-03-13",1173672903,,1173672903,,,,0
5582,17,5,"2007-03-13",1173672903,,1173672903,,,,0
5583,18,5,"2007-03-13",1173672903,,1173672903,,,,0
5584,18,5,"2007-03-13",1173672903,,1173672903,,,,0
5585,19,5,"2007-03-13",1173672903,,1173672903,,,,0
5586,19,5,"2007-03-13",1173672903,,1173672903,,,,0
5587,20,5,"2007-03-13",1173672903,,1173672903,,,,0
5588,20,5,"2007-03-13",1173672903,,1173672903,,,,0
5589,21,5,"2007-03-13",1173672904,,1173672904,,,,0
5590,21,5,"2007-03-13",1173672904,,1173672904,,,,0
5591,22,5,"2007-03-13",1173672904,,1173672904,,,,0
5592,23,5,"2007-03-13",1173672904,,1173672904,,,,0
5593,23,5,"2007-03-13",1173672904,,1173672904,,,,0
5594,24,5,"2007-03-13",1173672904,,1173672904,,,,0
5595,24,5,"2007-03-13",1173672904,,1173672904,,,,0
5596,25,5,"2007-03-13",1173672904,,1173672904,,,,0
5597,25,5,"2007-03-13",1173672904,,1173672904,,,,0
5598,106,5,"2007-03-13",1173672904,,1173672904,,,,0
5599,106,5,"2007-03-13",1173672904,,1173672904,,,,0
5600,26,5,"2007-03-13",1173672904,,1173672904,,,,0

Posted: **Tue Mar 13, 2007 7:44 am**

Here is some more information. I ran a query to find duplicates and this is what I came up with.

Code: Select all

select count(*) as num , user_id, date_stamp from user_date group by date_stamp, user_id having count(*) > 1;

"num","user_id","date_stamp"
2,2,"2007-03-03"
2,3,"2007-03-03"
2,11,"2007-03-03"
2,13,"2007-03-03"
2,14,"2007-03-03"
2,15,"2007-03-03"
2,16,"2007-03-03"
2,17,"2007-03-03"
2,18,"2007-03-03"
2,19,"2007-03-03"
2,20,"2007-03-03"
2,21,"2007-03-03"
2,2,"2007-03-04"
2,12,"2007-03-04"
2,13,"2007-03-04"
2,16,"2007-03-05"
2,17,"2007-03-05"
2,18,"2007-03-05"
2,19,"2007-03-05"
2,20,"2007-03-05"
2,21,"2007-03-05"
2,22,"2007-03-05"
2,14,"2007-03-06"
2,105,"2007-03-06"
2,13,"2007-03-07"
2,15,"2007-03-07"
2,16,"2007-03-07"
2,17,"2007-03-07"
2,18,"2007-03-07"
2,19,"2007-03-07"
2,20,"2007-03-07"
2,21,"2007-03-07"
2,2,"2007-03-08"
2,2,"2007-03-09"
2,15,"2007-03-09"
2,16,"2007-03-09"
2,17,"2007-03-09"
2,16,"2007-03-11"
2,17,"2007-03-11"
2,18,"2007-03-11"
2,2,"2007-03-12"
2,3,"2007-03-12"
2,5,"2007-03-12"
2,18,"2007-03-13"
2,19,"2007-03-13"
2,20,"2007-03-13"
2,21,"2007-03-13"
2,24,"2007-03-13"
2,25,"2007-03-13"
2,5,"2007-03-14"
2,17,"2007-03-14"
2,19,"2007-03-14"

Any idea why these duplicates would be showing up?

Posted: **Tue Mar 13, 2007 9:39 am**

Please add: "where deleted = 0" to your query. TimeTrex rarely deletes rows, it just marks them as deleted to be purged later on, so that may be what you are seeing.

Posted: **Tue Mar 13, 2007 10:22 am**

I did the mysql query

Code: Select all

select count(*) as num , user_id, date_stamp from user_date where deletec='0' group by date_stamp, user_id having count(*) > 1;

and it returned the same results.

Posted: **Tue Mar 13, 2007 11:39 am**

This is the first of such report that we have seen. We aren't seeing this issue on any of our On-Demand servers either.

Is there a way you can narrow it down to a specific operation? For instance do the duplicate rows appear when submitting a punch on a day that doesn't have any punches? Do they appear when the first punch is entered, or the second punch, ... ?

Can you also send us all columns of one or two pairs of the duplicate rows, so we can see exactly which columns match and which ones don't. It might also help narrow down what is going on.

Also, have you made any modifications whatsoever to the TimeTrex source code? What version of TimeTrex are you running.

Posted: **Tue Mar 13, 2007 12:04 pm**

Do you want a mysqldump of the whole table? I could do that.

Posted: **Tue Mar 13, 2007 2:58 pm**

Your whole database would be even better. Please email the compressed dump to support@timetrex.com.

Please don't forget to answer the other questions in my previous post.

Posted: **Wed Mar 14, 2007 6:53 am**

I don't know if I could narrow it down but the error reports come in the morning. So my guess is that when everyone is punching in the morning. I am not sure how the user_date table is used so I can't give you much further detail.
I have changed only 1 line in the source code and that was for getting the next free employee id number available.
http://forums.timetrex.com/viewtopic.php?t=149
I will compress the database and send it over.

Posted: **Wed Mar 14, 2007 11:57 am**

When you say "error reports" what do you mean exactly? Reports from your employees of issues, or error reports from TimeTrex itself?

A couple things we noticed with the duplicate rows. They always have consecutive row id's. ie: 5000,5001, 5401,5402, and the created times are either identical or one second apart. The other thing we noticed is that no punches are associated with any of the duplicate row dates.

Which I assume means this issue makes it so your employees can't punch in/out at all on these days?

The other thing we noticed is that these rows were all created two days (at 21:15) before the date_stamp value. Which leads us to believe that you may have two cron jobs firing at the same time, causing a race condition, and duplicating the rows.

Can you look into this and let us know if that is indeed the case?

Posted: **Wed Mar 14, 2007 12:19 pm**

You might be right on that. I did have 2 cron jobs working. I created a separate virtual host in apache so that I could modify TimeTrex without disturbing the original. I created a separate database and cron job. I did disable the cron job yesterday as a test and it did keep me from getting any errors from TimeTrex today or any complaints from employees.

The errors I am refering to are those sent to the administrator through email. I have been getting the errors in the email for awhile now ever since I installed TimeTrex.

Thank you for looking into the problem.

Posted: **Thu Mar 15, 2007 6:17 am**

I guess now I am wondering why TimeTrex cron jobs don't notice the different database. I have go through and completely changed the settings for the 2nd Timetrex installation I have and yet when I disabled the cron job that seemed to take care of the problem. The 2nd timetrex installation is in a completely different directory and database. Why would one affect the other? The cron.php is also in a different directory.

Any help would be appreciated.

Posted: **Thu Mar 15, 2007 8:58 am**

It all depends on your database settings in your timetrex.ini.php file. If both cron.php files are loading the same timetrex.ini.php file, then you will have problems.

Posted: **Thu Mar 15, 2007 9:03 am**

But thats just it. I have changed the settings in timetrex.ini.php file. Thats why I am having trouble understanding why this might have been happening.

Posted: **Thu Mar 15, 2007 2:07 pm**

I would have to see your directory structure and cron entries to know for sure. But the basic idea is that:

maint/cron.php

loads:

../timetrex.ini.php

To get its settings. Unless of course you've hard coded the timetrex.ini.php to a path outside your webroot.

Posted: **Thu Mar 15, 2007 5:38 pm**

Thanx for the help. I will look into it.

TimeTrex Time and Attendance

Added javascript functionality

Added javascript functionality