[mythtv] [mythtv-commits] Ticket #5442: MythWeb "Scan Collection" does not set inetref
Michael T. Dean
mtdean at thirdcontact.com
Mon Jun 16 22:42:59 UTC 2008
On 06/16/2008 03:31 PM, MythTV wrote:
> #5442: MythWeb "Scan Collection" does not set inetref
>
> I noticed that when scanning for new or changed files via the Video Manger
> new files found are given a default inetref value of '00000000'. Using
> the "Scan Collection" feature of MythWeb leaves this and other values in
> the videometadata table blank.
>
> Performing a select on this table for an inetref='00000000' should return
> recently added and any entries without metadata. However files added via
> MythWeb will not be returned. This has the potential to break some custom
> scripts that may be in use.
If inetref is really supposed to default to '00000000', why isn't it
specified as the column default? In other words, I think your scripts
may be relying on "undocumented" features.
Why not write your scripts to do something like:
SELECT inetref FROM videometadata
WHERE inetref REGEXP '^0+$'
OR inetref NOT REGEXP '^[[:digit:]]{1,8}$';
Mike
More information about the mythtv-dev
mailing list