[mythtv-users] "Internal Server Error" for specific recordings only from specific channels

[Miroslav Pavlovic]

ok, me again...

Is this a Bug ?
I mean, that mythweb is adding the newlines into the table ?
I do not have an account for raising Bugs.

Any idea?

Thanks!
Cheers,
Miro


Am Fr., 29. Nov. 2019 um 12:37 Uhr schrieb Miroslav Pavlovic <
mail.pavlovic at gmail.com>:

>
> Yeah, this is the problem.... It is generating a line break and mythweb
> does not like it.
>
> No idea how to fix it, but I tried the below updates and this fixed it.
> I removed the tick in the recording, not to use meta data and will see, if
> this will change anything.
> The stuff added in the next line is the data like "allowed from age 16" or
> "Drama" etc..
>
> Will monitor and update you.
>
> BR./Miro
>
> mysql> update recorded set subtitle ='Ave Chemicals' where subtitle like
> 'Ace Chem%';
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1  Changed: 1  Warnings: 0
>
> mysql>
> mysql> update recorded set subtitle ='13 Stiche' where subtitle like '13
> Stiche%';
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1  Changed: 1  Warnings: 0
>
> mysql>
>
>
> Am Fr., 29. Nov. 2019 um 12:25 Uhr schrieb Miroslav Pavlovic <
> mail.pavlovic at gmail.com>:
>
>>
>> Hi Paul,
>>
>> I am getting this :
>>
>> mysql> select title, subtitle from recorded where title like 'Gotham%';
>> +--------+-----------------------------------------------------+
>> | title  | subtitle                                            |
>> +--------+-----------------------------------------------------+
>> | Gotham | Eindringlinge                                       |
>> | Gotham | Pena Dura
>> Drama, USA 2019
>> Altersfreigabe: ab 16     |
>> | Gotham | 13 Stiche
>> Drama, USA 2019
>> Altersfreigabe: ab 16     |
>> | Gotham | Pinguin, unser Held                                 |
>> | Gotham | Jahr Null                                           |
>> | Gotham | Ace Chemicals
>> Drama, USA 2019
>> Altersfreigabe: ab 16 |
>> +--------+-----------------------------------------------------+
>> 6 rows in set (0.00 sec)
>>
>> mysql>
>>
>> or a bit different:
>>
>> | Yps - Die Sendung                                  | Yps und die
>> Roboter - Freund oder Feind?                                    |
>> | Yps - Die Sendung                                  | Yps rettet die
>> Welt                                                         |
>> | The Flash                                          | In Gedanken
>> gefangen                                                        |
>> | The Flash                                          | Willkommen auf
>> Erde Zwei
>> Action, USA 2016
>> Altersfreigabe: ab 12             |
>> | Gotham                                             | Ace Chemicals
>> Drama, USA 2019
>> Altersfreigabe: ab 16                         |
>> | The Flash                                          | Die Rückkehr des
>> Tricksters                                                 |
>> | The Flash                                          | Ein Held sieht rot
>>                                                          |
>> | The Flash                                          | Familie der
>> Schurken                                                        |
>> | Yps - Die Sendung                                  | Yps und die 90er
>> Jahre - Kult und Revolution                                |
>> | Yps - Die Sendung                                  | Yps und die Jäger
>> der verlorenen Schätze                                    |
>>
>>
>> It looks like it is adding the Information on the Episode to the title
>> name. :-o
>> And it is only doing it for these few channels.
>>
>> Is there a setting for this?
>>
>>
>> Thanks!
>> Cheers,
>> Miro
>>
>>
>>
>> ====
>> Am Mi., 27. Nov. 2019 um 19:37 Uhr schrieb Douglas Paul <doug at bogon.ca>:
>>
>>> Hello,
>>>
>>> On Wed, Nov 27, 2019 at 02:19:27PM +0100, Miroslav Pavlovic wrote:
>>> > Where should I look in the database?
>>> > Any suggestion for tables ?
>>>
>>> I would recommend something like this:
>>>
>>> select title, subtitle from recorded where title like 'Gotham%';
>>>
>>> But you might even be able to see this directly in mythweb before you
>>> click on the link that breaks (or in the HTML source for the page). I'm
>>> not sure as I don't use mythweb.
>>>
>>> > > > >>> [Wed Nov 13 13:04:18.129915 2019] [cgi:error] [pid 30203]
>>> [client
>>> > > > >>> 192.168.178.45:1448] AH01215: Invalid header value contains a
>>> > > newline
>>> > > > >>> not followed by whitespace: content-disposition=" attachment;
>>> > > > >>> filename="Gotham-13 Stiche: /var/www/html/mythweb/
>>> mythweb.pl,
>>> > > > >>> referer: http://mythbox/mythweb/tv/recorded
>>>
>>> --
>>> Douglas Paul
>>>
>>>
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>>> http://wiki.mythtv.org/Mailing_List_etiquette
>>> MythTV Forums: https://forum.mythtv.org
>>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20191202/1ab64808/attachment.htm>