[mythtv-users] 0.27 Front end Profile Issues
Michael T. Dean
mtdean at thirdcontact.com
Sun Oct 27 23:43:48 UTC 2013
On 10/27/2013 03:42 PM, Philip Nourse wrote:
> On 2013-10-27 2:06 PM, Philip Nourse wrote:
>> I just upgraded to 0.27, and I have an issue with the playback
>> profiles. Every time I start the front end, it adds another 10
>> profiles to the initial group as if it didn't have any profiles to
>> start with. Even worse, if I try to add another frontend, it trys to
>> do the same, but faults for trying to add a duplicate key. It's like
>> it doesn't realize that the profiles are already there. Anybody else
>> experience this, and how did you resolve it?
>
> I just figured it out. When I migrated the database to the new server
> (or when it upgraded - Devs may want to look into it to be sure) ,
> the auto increment for the ids was removed for the two tables. I put
> it back in, wiped the tables, and all is corrected.
This is just one of the problems that occurs when you use mysqldump to
create a database backup and do not pass the right arguments. Thus our
recommendation to use the official mythconverg_backup.pl and
mythconverg_restore.pl scripts for database backups and restore.
http://www.mythtv.org/wiki/Database_Backup_and_Restore
Oh, and the same thing that caused this problem will cause other
problems with MythTV, you should consider your schema corrupt and do a
partial restore to throw away the bad schema and import the
non-recreatable data (recordings, recording history, and such) in your
database--otherwise, expect problems down the line.
http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup
Mike
More information about the mythtv-users
mailing list