[mythtv-users] Avenard repo upgraded to 0.22 Database Schema upgrade failed

[Michael T. Dean]

On 10/21/2009 06:59 PM, Michael T. Dean wrote:
> Those aren't the real error that caused the upgrade to fail.  Those 
> are errors that you get when you repeat the upgrade after the upgrade 
> failed.
>
> Please execute:
>
> mysql -umythtv -p mythconverg \
> -e "DROP TABLE IF EXISTS bad_people; "\
> "DROP TABLE IF EXISTS bad_credits; "
> "DROP TABLE IF EXISTS bad_recordedcredits;"
>
> Then re-run the upgrade and post the output. 

d'oh...  missing \

mysql -umythtv -p mythconverg \
-e "DROP TABLE IF EXISTS bad_people; "\
"DROP TABLE IF EXISTS bad_credits; "\
"DROP TABLE IF EXISTS bad_recordedcredits;"

(and it seems my client may be putting end of line spaces on there which 
would break it).

Mike