[mythtv] SQL Update 1038 Broken By tv_grab_uk_rt

[Simon Kenyon]

thanks for that recipe
it bit me about 10 minutes ago and then i remembered seeing your message
once again thank you

regards
--
simon

On Monday 19 April 2004 15:01, Martin Smith wrote:
> Hi,
>
> When I upgraded from CVS this morning a database schema update failed
> because it was unable to create a unique index on the people table.
>
> On investigation the grabber seems to have been creating entries in the
> people table with a fragment of Javascript instead of their name. This
> broke the index because they're all the same string. After this happens you
> can't start the backend because it tries to reapply all the pieces of the
> update that worked before and complains about them.
>
> If this particular problem happens to anyone else you can back out the
> changes made by this update with the SQL below. Maybe back up the database
> first, just in case.