Added javascript functionality

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Locked
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Added javascript functionality

Post by lstoumbos »

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.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

Is there any particular page that they are pressing submit multiple times?
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

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.
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

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?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

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?
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

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",,"",""
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

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

Can you please post the rows that you feel are duplicate?
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

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
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

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?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

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.
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

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.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

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.
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

Do you want a mysqldump of the whole table? I could do that.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

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.
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

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.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

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?
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

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.
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

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.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

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.
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

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.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

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.
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

Thanx for the help. I will look into it.
Locked