[mythtvnz] Blank characters at start of titles in EPG

[Adam Bennetts]

Hi,

These all have "All New " in front for me (using tv_grab_nz-py),
except possibly repeats which have the normal titles. I don't do any
post processing. Something isn't removing "All New" and not removing
the trailing space on your end?

All New Dr. Ken
All New Mike & Molly
All New The Big Bang Theory
All New 2 Broke Girls
All New The Middle

Duke has "New: " just to be different. And of course "New Girl" is valid.

On Mon, Oct 17, 2016 at 4:19 PM, Stephen Worthington
<stephen_agent at jsw.gen.nz> wrote:
> It looks like TVNZ has invented a new way to create crappy EPG
> listings - adding a blank character at the start of the title for some
> programmes.  This is what I found in my database when I looked at why
> the new series of The Middle was not recording:
>
> select
> chanid,starttime,title,subtitle,left(description,20),season,episode,category,seriesid,programid
> from program where left(title,1)=' '
>
> +--------+---------------------+----------------------+------------+----------------------+--------+---------+----------+-----------+-----------+
> | chanid | starttime           | title                | subtitle   | left(description,20) | season | episode | category | seriesid  | programid |
> +--------+---------------------+----------------------+------------+----------------------+--------+---------+----------+-----------+-----------+
> |   1007 | 2016-10-18 07:30:00 |  The Middle          | New Season | S8 E1 Our favourite  |      0 |       0 |          | 220783125 | 10454729  |
> |   1002 | 2016-10-18 06:30:00 |  The Middle          | New Season | S8 E1 Our favourite  |      0 |       0 |          | 220783125 | 10454729  |
> |   1007 | 2016-10-19 07:30:00 |  Dr. Ken             |            | S2 E2 Allison's firs |      0 |       0 |          | 86298846  | 10447741  |
> |   1007 | 2016-10-19 08:00:00 |  Mike & Molly        |            | S6 E4 Mike turns int |      0 |       0 |          | 262741513 | 10421583  |
> |   1007 | 2016-10-19 08:30:00 |  The Big Bang Theory |            | S10 E5 Shamy navigat |      0 |       0 |          | 139824009 | 10454708  |
> |   1007 | 2016-10-19 09:00:00 |  2 Broke Girls       |            | S5 E20 A law firm th |      0 |       0 |          | 223419955 | 10421612  |
> |   1002 | 2016-10-19 06:30:00 |  Dr. Ken             |            | S2 E2 Allison's firs |      0 |       0 |          | 86298846  | 10447741  |
> |   1002 | 2016-10-19 07:00:00 |  Mike & Molly        |            | S6 E4 Mike turns int |      0 |       0 |          | 262741513 | 10421583  |
> |   1002 | 2016-10-19 07:30:00 |  The Big Bang Theory |            | S10 E5 Shamy navigat |      0 |       0 |          | 139824009 | 10454708  |
> |   1002 | 2016-10-19 08:00:00 |  2 Broke Girls       |            | S5 E20 A law firm th |      0 |       0 |          | 223419955 | 10421612  |
> +--------+---------------------+----------------------+------------+----------------------+--------+---------+----------+-----------+-----------+
> 10 rows in set (0.10 sec)
>
> So it is happening on TVNZ 2 (chanid 1002) and TVNZ 2+1 (chanid 1007).
>
> As a temporary fix, I have added this processing to the SQL I do
> automatically after an EPG update:
>
> update program set title=substr(title,2) where left(title,1)=' ';
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/