id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked 13535 -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. " Bug Report - General closed minor needs_triage MythTV - General Unspecified medium Trac EOL 0