[TYPO3-calendar] repair cal tx_cal_fe_user_event_monitor_mm

[Mario Matzulla]

Hi Heinz,

Am 11.05.11 15:22, schrieb Heinz Schilling:
>
> 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?

May I point you to chapter "Known Issues" of the manual ;)

Regards,
Mario

>
> Thanks for helping.
>
> Kind regards, Heinz