[prev in list] [next in list] [prev in thread] [next in thread] 

List:       amarok-bugs-dist
Subject:    [amarok] [Bug 462268] New: Error storing podcast episode description in external MySQL database
From:       Stephan Schöttl <bugzilla_noreply () kde ! org>
Date:       2022-11-26 13:36:22
Message-ID: bug-462268-71684 () http ! bugs ! kde ! org/
[Download RAW message or body]

https://bugs.kde.org/show_bug.cgi?id=462268

            Bug ID: 462268
           Summary: Error storing podcast episode description in external
                    MySQL database
    Classification: Applications
           Product: amarok
           Version: unspecified
          Platform: OpenSUSE
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: Podcast
          Assignee: amarok-bugs-dist@kde.org
          Reporter: stschoettl@web.de
                CC: bart.cerneels@kde.org
  Target Milestone: kf5

Certain podcast episodes are not saved to the database. A dialog with a MySQL
appears with an error message. The error hast been seen with the podcast
https://zoo-podcast.podigee.io/feed/mp3 and an external mysql database

STEPS TO REPRODUCE
1. Subscribe podcast https://zoo-podcast.podigee.io/feed/mp3
2. Update podcast episodes
3. wait

OBSERVED RESULT
***
MySQL-server query failed! (1366) Incorrect string value: '\xF0\x9F\x8E\xA4
T...' for column `amarok26db`.`podcastepisodes`.`description` at row 1 on
INSERT INTO podcastepisodes
(url,channel,localurl,guid,title,subtitle,sequencenumber,description,mimetype,pubdate,duration,filesize,isnew,iskeep)
 VALUES (
'https://cdn.podigee.com/media/podcast_18387_mia_san_tier_der_zoo_pdcst_aus_hellabrunn \
_episode_417392_laut_und_verspielt_mahnenrobben_in_hellabrunn.mp3?v=1617282197&source=feed',
 10, '', 'ed19282cc9dad42e0b89167f1263e9f2', 'Laut und verspielt - Mähnenrobben
in Hellabrunn', 'Folge 32', 0, 'Mit verbundenen Augen würde Tierpfleger Helmut
jede seiner Robben am "Röhren" erkennen. MiaSanTier, der Zoo-Podcast aus
Hellabrunn, ist zu Gast bei den Mähnenrobben - die haben erstaunlich kleine
Ohren. Ihr lernt die Robben-Gruppe näher kennen und erfahrt, wer gerade in wen
verliebt ist. Diesmal wird es auf jeden Fall laut und verspielt! 
\n
\nPodcast-Redakteurin 🎤 Tina Gentner hat diesmal Zoologin Lena Bockreiß befragt
und war mit Tierpfleger Helmut bei der Robben-Fütterung dabei.', 'audio/mpeg',
'2021-04-02T05:00:00Z', 0, 19784629, 0, 0);
***

EXPECTED RESULT
no error dialog

SOFTWARE/OS VERSIONS
Linux/KDE Plasma: OpenSuse 15.4
Amarok version: amarok-2.9.75git.20220614T014846~dc55a00143-bp154.2.3.1.x86_64
from Opensuse repository

ADDITIONAL INFORMATION
using an external mysql database (not sure if that makes any difference)

-- 
You are receiving this mail because:
You are the assignee for the bug.=


[prev in list] [next in list] [prev in thread] [next in thread]