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