Opened 4 years ago

Closed 2 years ago

#13535 closed Bug Report - General (Trac EOL)

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

Reported by: Miroslav Pavlovic Owned by:
Priority: minor Milestone: needs_triage
Component: MythTV - General Version: Unspecified
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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.

Change History (2)

comment:1 Changed 4 years ago by 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:

comment:2 Changed 2 years ago by Stuart Auchterlonie

Resolution: Trac EOL
Status: newclosed

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

Note: See TracTickets for help on using tickets.