Added javascript functionality
Added javascript functionality
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.
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",,"",""
"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",,"",""
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]: <b>[Function]()</b>: Production: 1<br>
DEBUG [56]: <b>[Function]()</b>: 0. User: jefferya<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5682<br>
DEBUG [56]: <b>[Function]()</b>: 1. User: davida<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5683<br>
DEBUG [56]: <b>[Function]()</b>: 2. User: janeta<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5684<br>
DEBUG [56]: <b>[Function]()</b>: 3. User: jasonbaker<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5685<br>
DEBUG [56]: <b>[Function]()</b>: 4. User: jasonb<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5686<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 5. User: amyb<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5688<br>
DEBUG [56]: <b>[Function]()</b>: 6. User: jennyb<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5689<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 7. User: courtneyb<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 3538<br>
DEBUG [56]: <b>[Function]()</b>: 8. User: richardb<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5690<br>
DEBUG [56]: <b>[Function]()</b>: 9. User: michael<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5691<br>
DEBUG [56]: <b>[Function]()</b>: 10. User: alanab<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5692<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 11. User: bruceb<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5693<br>
DEBUG [56]: <b>[Function]()</b>: 12. User: sandrab<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5694<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 13. User: patriciab<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5695<br>
DEBUG [56]: <b>[Function]()</b>: 14. User: byronc<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5697<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 15. User: sherylc<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5699<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 16. User: nancyc<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5701<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 17. User: jenniferc<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
string(4) "5702"
</pre><br>
DEBUG [405]: <b>Validator::Error()</b>: Validation Error: Label: date_stamp Msg: Employee can not have duplicate entries on the same day<br>
DEBUG [384] Array: <b>Validator::isValid()</b>: Errors <pre>
array(1) {
["date_stamp"]=>
array(1) {
[0]=>
string(55) "Employee can not have duplicate entries on the same day"
}
}
</pre><br>
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
DEBUG [155]: <b>[Function]()</b>: Production: 1<br>
DEBUG [56]: <b>[Function]()</b>: 0. User: jefferya<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5682<br>
DEBUG [56]: <b>[Function]()</b>: 1. User: davida<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5683<br>
DEBUG [56]: <b>[Function]()</b>: 2. User: janeta<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5684<br>
DEBUG [56]: <b>[Function]()</b>: 3. User: jasonbaker<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5685<br>
DEBUG [56]: <b>[Function]()</b>: 4. User: jasonb<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5686<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 5. User: amyb<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5688<br>
DEBUG [56]: <b>[Function]()</b>: 6. User: jennyb<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5689<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759303 Converted Value: 1173759303<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 7. User: courtneyb<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 3538<br>
DEBUG [56]: <b>[Function]()</b>: 8. User: richardb<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5690<br>
DEBUG [56]: <b>[Function]()</b>: 9. User: michael<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5691<br>
DEBUG [56]: <b>[Function]()</b>: 10. User: alanab<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5692<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 11. User: bruceb<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5693<br>
DEBUG [56]: <b>[Function]()</b>: 12. User: sandrab<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5694<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 13. User: patriciab<br>
DEBUG [192]: <b>UserDateFactory::findOrInsertUserDate()</b>: Found Already Existing User Date ID: 5695<br>
DEBUG [56]: <b>[Function]()</b>: 14. User: byronc<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5697<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 15. User: sherylc<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5699<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 16. User: nancyc<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [796]: <b>Factory::Save()</b>: Insert ID: 5701<br>
DEBUG [702]: <b>Factory::getInsertQuery()</b>: Insert<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173759304 Converted Value: 1173759304<br>
DEBUG [847]: <b>Factory::Save()</b>: Calling postSave()<br>
DEBUG [730]: <b>Factory::CommitTransaction()</b>: CommitTransaction(): Transaction Count: 1 Trans Off: 1<br>
DEBUG [56]: <b>[Function]()</b>: 17. User: jenniferc<br>
DEBUG [195]: <b>UserDateFactory::findOrInsertUserDate()</b>: Inserting new UserDate row.<br>
DEBUG [256]: <b>Validator::isDate()</b>: Raw Date: 1173844800 Converted Value: 1173844800<br>
DEBUG [93]: <b>UserDateFactory::findPayPeriod()</b>: Attempting to find Pay Period for Start Date: 1173844800<br>
DEBUG [99]: <b>UserDateFactory::findPayPeriod()</b>: Date: 1173844800<br>
DEBUG [104]: <b>UserDateFactory::findPayPeriod()</b>: Pay Period Id: 5<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
bool(false)
</pre><br>
DEBUG [720]: <b>Factory::StartTransaction()</b>: StartTransaction(): Transaction Count: 0 Trans Off: 0<br>
DEBUG [737]: <b>Factory::isValid()</b>: Calling Validate()<br>
DEBUG [243] Array: <b>UserDateFactory::isUnique()</b>: Unique User Date.
<pre>
string(4) "5702"
</pre><br>
DEBUG [405]: <b>Validator::Error()</b>: Validation Error: Label: date_stamp Msg: Employee can not have duplicate entries on the same day<br>
DEBUG [384] Array: <b>Validator::isValid()</b>: Errors <pre>
array(1) {
["date_stamp"]=>
array(1) {
[0]=>
string(55) "Employee can not have duplicate entries on the same day"
}
}
</pre><br>
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
Here is some more information. I ran a query to find duplicates and this is what I came up with.
"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?
Code: Select all
select count(*) as num , user_id, date_stamp from user_date group by date_stamp, user_id having count(*) > 1;
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?
I did the mysql query
and it returned the same results.
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;
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.
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.
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.
Please don't forget to answer the other questions in my previous post.
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.
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.
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?
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?
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.
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.
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.
Any help would be appreciated.