2012-03-16, 01:44
(2012-03-12, 23:38)Jimmer Wrote: Hey tsp,
Have a new problem....
My missus recorded One Tree Hill and the title of the show has a / in it: "know this, we/'ve noticed"
Not sure if this is the backend trying to escape the ' in the title, or the frontend trying to deal with it
Debug log snippit:
http://pastebin.com/7ffBP0Qc
All other recordings (including other episodes of One Tree Hill) play just fine, so must be something specific to this title
Regards,
Jim
Edit:
Just to compare, the mysql entries for the two One Tree Hill recordings:
http://pastebin.com/KnNN2MHr
The unsuccessful recording has the title+subtitle in the title field and the date in the subtitle field. Not sure what caused this really (may be an error in the xml grabber data?). Will try to edit the tables with a mysql query and see if the addon can play it. I'll report back......
Edit2:
Used a mysql query to change the title to "One Tree Hill", dropping the problematic / and now the addon plays it just fine. Interestingly, I could not construct a query matching the show's title entry in the database
Code:mysql> select * from recorded where title = "One Tree Hill: Know This, We\'ve Noticed";
Empty set (0.00 sec)
so had to use the following to change the title based on the starttime instead:
Code:mysql> UPDATE recorded set title = "One Tree Hill" where starttime = "2012-03-05 20:58:00";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
guess if the recording can't be accessed via title during a mysql query, then the addon would have no chance either?
Just wanted to add that I had this issue as well. Mine was a different show but when it was scheduled via the cmyth addon it inserted a '\' to escape the apostrophe and this showed in the title from that point on. The show recorded just fine but would not play until I changed the show name manually on the mysql cli.