[TYPO3-calendar] repair cal tx_cal_fe_user_event_monitor_mm

Heinz Schilling typo3 at webtekk.ch
Wed May 11 15:22:28 CEST 2011


Hi to the list

I updated a TYPO3 from 4.4 to 4.5 and found the following bug by 
comparing the database:

ALTER TABLE tx_cal_fe_user_event_monitor_mm ADD PRIMARY KEY (uid);
	Duplicate entry '0' for key 1

The table contains data like
uid_local	uid_foreign	tablenames	sorting	uid	pid	offset	schedulerId
23	0	fe_groups	1	0	0	0	0
23	0	fe_users	1	0	0	0	0
28	2	fe_users	1	0	0	0	0
30	2	fe_users	1	0	0	0	0
31	2	fe_users	1	0	0	0	0
32	11	fe_users	1	0	0	0	0
33	2	fe_users	1	0	0	0	0

I think the uid should be auto_increment. What is the best practice to 
solve this problem?

Thanks for helping.

Kind regards, Heinz


More information about the TYPO3-project-calendar mailing list