[mythtvnz] Blank characters at start of titles in EPG

[Stephen Worthington]

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)=' ';