2012-02-27, 22:17
tsp42 Wrote:KeithLM: I think I can fix it if you can dump the content of the mythconverg-record table from the MySQL database when you have scheduled the recording from both xbmc and mythfrontend.
That'd be helpful. My mysql skills are limited though. I know how to poke around in the database and view the tables from the command line, but that's about it. Can you help me with the command I need?
I've logged in from work and took a look, what I can see is this, I tried to record Robot Chicken, episode name is Anne Marie's Pride. What I see in the database is that it put the following in title:
"Robot Chicken: Anne Marie\'s Pride"
and nothing is in subtitle. Here's a cut and paste of the data. Record 48 is valid, 47 is the one that doesn't match a rule or whatever that error was.
Code:
47 | 1 | 1257 | 04:00:00 | 2012-02-27 | 04:15:00 | 2012-02-27 | Robot Chicken: Anne Marie\'s Pride | | Mr. T and the Foo Fighters allign; Stretch Armstrong transplant; Atlantis; GPS date; Alvin and the Chipmunks\' origin; Roger Ebert and M. Night Shyamalan review movies. | | Default | 0 | 1 | 0 |0 | 2 | 2 | Default | 6 | 15 | Cartoon Network | | | 5 | 1 | 1| 1 | 0 | 0 | 0 | 0 | 04:00:00 | 734925 | 0 | 0 | 27 | Default | 0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | Default | 100 |
48 | 1 | 1257 | 04:15:00 | 2012-02-27 | 04:30:00 | 2012-02-27 | Robot Chicken | Terms of Endaredevil| The origin of Mo-Larr, Eternian Dentist is revealed; King of Eternia stays over, much to He-Man's dismay; Gargamel puts himself in a Smurf body to gain the trust of the village. | Comedy | Default | 0 | 1 | 0 |0 | 0 | 0 | Default | 6 | 15 | TOON | EP00725962 | EP007259620088 | 0 | 1 | 1| 1 | 0 | 0 | 0 | 2 | 04:15:00 | 734925 | 0 | 0 | 27 | Default | 0 | 0000-00-00 00:00:00 | 2012-02-27 04:15:02 | 0000-00-00 00:00:00 | Default | 100 |
I don't know anything about the API that is used, I haven't looked at any source or Myth's documents on that yet, but I'm guessing the wrong delimiter is being used between title and subtitle.