-RecordedTable -Subtitle Column: 'new lines' added to db, causing issues on streamfile creation.

[Miroslav Pavlovic]

Subtitle data coming from EIT with newines, is added with new lines into the database.

When trying to download the ASX Stream file from Mythweb, it is generating the Browser Error:

---

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@localhost to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log. Apache/2.4.29 (Ubuntu) Server at mythbox Port 80

---

Issue is, that the new lines are added to the table, see below snippet:

mysql> select title, subtitle from recorded; +----------------------------------------------------+-----------------------------------------------------------------------------+ | title | subtitle | +----------------------------------------------------+-----------------------------------------------------------------------------+ | Fast N' Loud | Chevrolet Apache |

ooo

| Star Wars: Die Abenteuer der Freemaker | Das Schicksalsduell | | Star Wars: Die Abenteuer der Freemaker | Die Rückkehr des Kyberschwertes | | Fresh Off the Boat | Der Cha-Cha-King wird 40 Sitcom, USA 2019 Altersfreigabe: ab 6 | | Star Wars: Die Abenteuer der Freemaker | Der Kristall von Hoth | +----------------------------------------------------+-----------------------------------------------------------------------------+ 161 rows in set (0.00 sec)

mysql>

In the last entry you can see the added new line, which is causing the issue.

---

Log snippets:

Dec 6 14:47:00 mythbox mythbackend: mythbackend[10789]: I Scheduler scheduler.cpp:2356 (HandleReschedule?) Reschedule requested for MATCH 0 1 14 2019-12-12T23:59:55Z EITScanner Dec 6 14:47:00 mythbox mythbackend: mythbackend[10789]: I Scheduler scheduler.cpp:2472 (HandleReschedule?) Scheduled 7 items in 0.1 = 0.08 match + 0.00 check + 0.00 place Dec 6 14:47:01 mythbox mythbackend: mythbackend[10789]: I TVRecEvent tv_rec.cpp:3682 (TuningFrequency?) TVRec[5]: TuningFrequency? Dec 6 14:47:10 mythbox mythbackend: mythbackend[10789]: I ProcessRequest? mainserver.cpp:1780 (HandleAnnounce?) MainServer?: MainServer::ANN Monitor Dec 6 14:47:10 mythbox mythbackend: mythbackend[10789]: I ProcessRequest? mainserver.cpp:1785 (HandleAnnounce?) MainServer?: adding: mythbox(564aa43064c0) as a client (events: 0) Dec 6 14:47:10 mythbox mythbackend: mythbackend[10789]: E ProcessRequest? programinfo.cpp:2781 (GetPlaybackURL) ProgramInfo?(18505_20190610181400.ts): GetPlaybackURL: '18505_20190610181400.ts' should be local, but it can not be found. Dec 6 14:47:10 mythbox mythbackend: mythbackend[10789]: I MythSocketThread?(67) mainserver.cpp:7928 (connectionClosed) Monitor sock(564aa43064c0) 'mythbox' disconnected Dec 6 14:47:10 mythbox mythbackend: mythbackend[10789]: E HttpServer67 programinfo.cpp:2781 (GetPlaybackURL) ProgramInfo?(18505_20190610181400.ts): GetPlaybackURL: '18505_20190610181400.ts' should be local, but it can not be found. ^{C kingmiro@mythbox:~$}

access.log

192.168.1.4 - - [09/Dec/2019:10:57:02 +0100] "GET mythweb/pl/stream/18501/1575885420.asx HTTP/1.1" 500 797 "​http://mythbox/mythweb/tv/recorded" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:70.0) Gecko/20100101 Firefox/70.0"

---

After updating the subtitle column in the recorded table to have only one line, all is working fine.

mysql> update recorded set subtitle ='Der Cha-Cha-King wird 40' where subtitle like 'Der Cha-Cha-King wird 40%'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0

mysql>

====

Solution:

Make the function more robust to change all taken values into one line, before adding to the Database tables.

[Miroslav Pavlovic]

miro@mythbox:/var/log$ mythbackend --version Please attach all output as a file in bug reports. MythTV Version : v30.0 MythTV Branch : Network Protocol : 91 Library API : 30.20181231-1 QT Version : 5.9.5 Options compiled in:

[Stuart Auchterlonie]

We have moved all bug tracking to github [1]

If you continue to have this issue, please open a new issue at github, referencing this ticket.

[1] - ​https://github.com/MythTV/mythtv/issues