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

Michael T. Dean mtdean at thirdcontact.com
Thu Sep 15 22:15:49 UTC 2011

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.


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


More information about the mythtv-dev mailing list