[mythtv] [mythtv-commits] Ticket #10040: menu added commflag jobs has NULL hostname

[Michael T. Dean]

On 09/15/2011 02:10 PM, MythTV wrote:
> #10040: menu added commflag jobs has NULL hostname
>
>
> Comment (by warpme@…):
>
>   Hi,
>   'DESC jobqueue;' attached. Thx for quick commit !
>

warpme, as Raymond alluded to, your DESC jobqueue; confirms that your 
jobqueue table definition is wrong.

You can fix it by executing:

ALTER TABLE jobqueue MODIFY hostname varchar(64) NOT NULL default '';

in a mysql client.

However, if that table is improperly defined--and you can't say for sure 
how it got that way--there's a good chance other parts of your schema 
are also broken/corrupted by whatever broke this.  If that's the case, 
you may want to consider doing a partial restore--i.e. allow MythTV to 
create a brand-new, empty schema, then restore only the 
critical/not-recreatable data, then reconfigure everything (on all 
hosts).  It's a lot of work, but it will ensure your schema is correct.

http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup

where your database falls under the "primarily useful as a last-resort 
when ... the database schema itself is corrupt" category.

Mike