This is a semi-recent development. After Fedora went to KDe 4.10 when I started Amarok I got some error about podcasts and the database. Not sure if that's relavent, but it's an error I saw that one time. Ever since then, whatever songs are on the playlist when I exit Amarok, when I start it up again it has forgotten they are part of the local collection. Collection: None and all the first/last played stats are never. Deleting the playlist and loading new songs - those are fine - they are correctly listed as part of the local playlist. Starting from commandline: Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated. [0x32ff268] main services discovery error: no suitable services discovery module WARNING: Phonon::createPath: Cannot connect Phonon::MediaObject ( no objectName ) to Phonon::AudioDataOutput ( no objectName ). Object::connect: No such signal Phonon::VLC::MediaObject::angleChanged(int) in /builddir/build/BUILD/phonon-4.6.0/phonon/mediacontroller.cpp:64 Object::connect: No such signal Phonon::VLC::MediaObject::availableAnglesChanged(int) in /builddir/build/BUILD/phonon-4.6.0/phonon/mediacontroller.cpp:65 QColor::setHsvF: HSV parameters out of range QCoreApplication::postEvent: Unexpected null receiver loaded the Generic plugin QWidget::insertAction: Attempt to insert null action ********************************************************************************************** ** AMAROK WAS STARTED IN NORMAL MODE. IF YOU WANT TO SEE DEBUGGING INFORMATION, PLEASE USE: ** ** amarok --debug ** ********************************************************************************************** And diagnostics: Amarok Diagnostics Amarok Version: 2.7.0 KDE Version: 4.10.1 Qt Version: 4.8.4 Phonon Version: 4.6.0 Phonon Backend: VLC (0.6.2) PulseAudio: Yes Amarok Scripts: Music Quiz 1.4 (stopped) Amarok Script Console 1.0 (stopped) Rating Statistics 2.0.1 (stopped) Quick labeler 0.3.2 (stopped) Lyricwiki .2 (stopped) Ultimate Lyrics 2.06 (stopped) Free Music Charts 1.6.0 (stopped) Librivox.org 1.0 (stopped) Cool Streams 1.0 (stopped) Amarok Plugins: AudioCd Collection (enabled) DAAP Collection (disabled) MTP Collection (enabled) MySQLServer Collection (enabled) MySQLe Collection (enabled) Nepomuk Collection (disabled) UPnP Collection (disabled) Universal Mass Storage Collection (enabled) iPod, iPad & iPhone Collection (disabled) Ampache (enabled) Jamendo (enabled) Last.fm (enabled) MP3 Music Store (enabled) MP3tunes (disabled) Magnatune Store (disabled) Podcast Directory (enabled) gpodder.net (disabled) Reproducible: Always Steps to Reproduce: 1.Have songs on a playlist 2.Quit Amarok 3.Start Amarok Actual Results: All songs on the playlist have lost their collection/stats Expected Results: for Amarok to remember where the songs came from
Wasn't there a database change from MySQL to MariaDB? Then maybe something is missing in your installation, happened for Arch users recently.
(In reply to comment #1) > Wasn't there a database change from MySQL to MariaDB? Then maybe something > is missing in your installation, happened for Arch users recently. Ran Amarok in debug mode. Here's something very interesting: amarok: BEGIN: void Playlist::LayoutManager::loadLayouts(const QString&, bool) amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='file:///home/ermesa/Music/Gorillaz/Demon_Days/06_-_feel_good_inc_900_flac_lossless_ex.flac' OR url='file:///home/ermesa/Music/Gorillaz/Demon_Days/06_-_feel_good_inc_900_flac_lossless_ex.flac' OR localurl='file:///home/ermesa/Music/Gorillaz/Demon_Days/06_-_feel_good_inc_900_flac_lossless_ex.flac';" amarok: [MySqlStorage] Initialized thread, count== 3 amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='file:///home/ermesa/Music/Barenaked_Ladies/Stunt/12_Barenaked_Ladies_Stunt_Some_Fantastic.ogg' OR url='file:///home/ermesa/Music/Barenaked_Ladies/Stunt/12_Barenaked_Ladies_Stunt_Some_Fantastic.ogg' OR localurl='file:///home/ermesa/Music/Barenaked_Ladies/Stunt/12_Barenaked_Ladies_Stunt_Some_Fantastic.ogg';" amarok: [MySqlStorage] Initialized thread, count== 4 amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='file:///home/ermesa/Music/The_Gregory_Brothers/Songify_the_News/Muffins%20in%20Congress%20-%20Songify%20the%20News%202.mp3' OR url='file:///home/ermesa/Music/The_Gregory_Brothers/Songify_the_News/Muffins%20in%20Congress%20-%20Songify%20the%20News%202.mp3' OR localurl='file:///home/ermesa/Music/The_Gregory_Brothers/Songify_the_News/Muffins%20in%20Congress%20-%20Songify%20the%20News%202.mp3';" amarok: [MySqlStorage] Initialized thread, count== 5 amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='file:///home/ermesa/Music/The_Beatles/Abbey_Road/09_The_Beatles_Abbey_Road_You_Never_Give_Me_Your_Money.flac' OR url='file:///home/ermesa/Music/The_Beatles/Abbey_Road/09_The_Beatles_Abbey_Road_You_Never_Give_Me_Your_Money.flac' OR localurl='file:///home/ermesa/Music/The_Beatles/Abbey_Road/09_The_Beatles_Abbey_Road_You_Never_Give_Me_Your_Money.flac';" amarok: loading layout "Default" amarok: grouping mode is: "Album" amarok: loading layout "No Grouping" amarok: grouping mode is: "None" amarok: loading layout "No Grouping (Single Line)" amarok: grouping mode is: "None" amarok: loading layout "Verbose" amarok: grouping mode is: "Album" amarok: END__: void Playlist::LayoutManager::loadLayouts(const QString&, bool) [Took: 0.016s] amarok: BEGIN: void Playlist::LayoutManager::loadLayouts(const QString&, bool) amarok: loading layout "copy of Default" amarok: grouping mode is: "Album" amarok: END__: void Playlist::LayoutManager::loadLayouts(const QString&, bool) [Took: 0.057s] amarok: END__: Playlist::LayoutManager::LayoutManager() [Took: 0.13s] amarok: [ActionClasses] setCurrentItem: 1 amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='file:///home/ermesa/Music/Jars_of_Clay/If_I_Left_the_Zoo/07_Jars_of_Clay_If_I_Left_the_Zoo_Hand.ogg' OR url='file:///home/ermesa/Music/Jars_of_Clay/If_I_Left_the_Zoo/07_Jars_of_Clay_If_I_Left_the_Zoo_Hand.ogg' OR localurl='file:///home/ermesa/Music/Jars_of_Clay/If_I_Left_the_Zoo/07_Jars_of_Clay_If_I_Left_the_Zoo_Hand.ogg';" amarok: [ActionClasses] setCurrentItem: 0 amarok: BEGIN: void MainWindow::init() amarok: BEGIN: MainToolbar::MainToolbar(QWidget*) amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='file:///home/ermesa/Music/Thousand_Foot_Krutch/The_Art_Of_Breaking/08_Thousand_Foot_Krutch_The_Art_Of_Breaking_Hit_The_Floor.ogg' OR url='file:///home/ermesa/Music/Thousand_Foot_Krutch/The_Art_Of_Breaking/08_Thousand_Foot_Krutch_The_Art_Of_Breaking_Hit_The_Floor.ogg' OR localurl='file:///home/ermesa/Music/Thousand_Foot_Krutch/The_Art_Of_Breaking/08_Thousand_Foot_Krutch_The_Art_Of_Breaking_Hit_The_Floor.ogg';" amarok: BEGIN: SvgHandler::SvgHandler(QObject*) amarok: END__: SvgHandler::SvgHandler(QObject*) [Took: 0s] amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='file:///home/ermesa/Music/Five_Iron_Frenzy/LiveProof_that_the_Youth_are_Revolting/07_Five_Iron_Frenzy_LiveProof_that_the_Youth_are_Revolting_All_that_is_Good.ogg' OR url='file:///home/ermesa/Music/Five_Iron_Frenzy/LiveProof_that_the_Youth_are_Revolting/07_Five_Iron_Frenzy_LiveProof_that_the_Youth_are_Revolting_All_that_is_Good.ogg' OR localurl='file:///home/ermesa/Music/Five_Iron_Frenzy/LiveProof_that_the_Youth_are_Revolting/07_Five_Iron_Frenzy_LiveProof_that_the_Youth_are_Revolting_All_that_is_Good.ogg';" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='file:///home/ermesa/Music/Various/MP3s_Vol_7/01_Styx_MP3s_Vol_7_Mr_Roboto.flac' OR url='file:///home/ermesa/Music/Various/MP3s_Vol_7/01_Styx_MP3s_Vol_7_Mr_Roboto.flac' OR localurl='file:///home/ermesa/Music/Various/MP3s_Vol_7/01_Styx_MP3s_Vol_7_Mr_Roboto.flac';" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='file:///home/ermesa/Music/Tom_Lehrer/An_Evening_Wasted_with_Tom_Lehrer/01_Tom_Lehrer_An_Evening_Wasted_with_Tom_Lehrer_Poisoning_Pigeons_In_The_Park.ogg' OR url='file:///home/ermesa/Music/Tom_Lehrer/An_Evening_Wasted_with_Tom_Lehrer/01_Tom_Lehrer_An_Evening_Wasted_with_Tom_Lehrer_Poisoning_Pigeons_In_The_Park.ogg' OR localurl='file:///home/ermesa/Music/Tom_Lehrer/An_Evening_Wasted_with_Tom_Lehrer/01_Tom_Lehrer_An_Evening_Wasted_with_Tom_Lehrer_Poisoning_Pigeons_In_The_Park.ogg';" But those are not podcasts - that's what's in my normal music playlist. If it helps - amarok also forgets that I had dynamic playlist mode turned on
So there is a problem in reading the database indeed, thank you for the feedback.
Tried turning off dynamic playlist before quitting - same results.
(In reply to comment #2) > (In reply to comment #1) > > Wasn't there a database change from MySQL to MariaDB? Then maybe something > > is missing in your installation, happened for Arch users recently. You didn't answer this question. > Ran Amarok in debug mode. Here's something very interesting: > > amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! > (130) Incorrect file format 'podcastepisodes' on SELECT id FROM This is most probably error of your installation. Perhaps you downgraded MySQL? Or downgraded from MariaDB to MySQL? Or copied the database from another machine? Or your files are simply corrupted? In either case, please try renaming the ~/.kde/share/apps/amarok/mysqle folder followed by full rescan. If you are not able to reproduce the bug afterwards, it was indeed local error.
(In reply to comment #5) > (In reply to comment #2) > > (In reply to comment #1) > > > Wasn't there a database change from MySQL to MariaDB? Then maybe something > > > is missing in your installation, happened for Arch users recently. > > You didn't answer this question. > > > Ran Amarok in debug mode. Here's something very interesting: > > > > amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! > > (130) Incorrect file format 'podcastepisodes' on SELECT id FROM > > This is most probably error of your installation. Perhaps you downgraded > MySQL? Or downgraded from MariaDB to MySQL? Or copied the database from > another machine? Or your files are simply corrupted? > > In either case, please try renaming the ~/.kde/share/apps/amarok/mysqle > folder followed by full rescan. If you are not able to reproduce the bug > afterwards, it was indeed local error. I haven't done anything. This just happened after the most recent update. How do I check what's going on with mariadb/mysql, etc? I'm using mysqle - the embedded one. I'd prefer not to lose my database - that would make it the fourth time I've lost it and then I lost all my labels and last played and first played. I would prefer to figure this out in a way that doesn't lose the db. After all, the databse appears to be fine - the left side of Amarok is fine. It's the right side, the playlist that seems to be having some issue. So, to recap - how do I figure out the mariadb thing? And what else might I do before replacing the database with a fresh one?
note: just checked and it looks like Fedora did not make mariadb a dependency install. Going to install it and restart Amarok to see if that solves the issue.
(In reply to comment #7) > note: just checked and it looks like Fedora did not make mariadb a > dependency install. Going to install it and restart Amarok to see if that > solves the issue. When I try to install it - it says it conflicts with mysql....
some more interesting info: [CollectionManager] initializing "amarok_collection-mysqlecollection" amarok: [MySqlStorage] Connected to MySQL server 5.5.30-embedded amarok: Connected to MySQL server 5.5.30-embedded amarok: [MySqlStorage] Initialized thread, count== 1 amarok: BEGIN: SqlRegistry::SqlRegistry(Collections::SqlCollection*) amarok: END__: SqlRegistry::SqlRegistry(Collections::SqlCollection*) [Took: 0.52s] amarok: BEGIN: MountPointManager::MountPointManager(QObject*, SqlStorage*) BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlpodcastuid://2" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: void Playlists::SqlUserPlaylistProvider::checkTables() amarok: END__: void Playlists::SqlUserPlaylistProvider::checkTables() [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://1" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://2" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr ... amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://196" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://197" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://198" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://199" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://200" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://201" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://202" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://203" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://204" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://206" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://207" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://208" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://209" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://210" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://211" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://212" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://213" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://214" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://205" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://215" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://217" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://216" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://218" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://219" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://220" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://221" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://222" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://223" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://224" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://225" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://35" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://36" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://38" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://42" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: "UIDurl: amarok-sqlplaylistuid://44" amarok: END__: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) [Took: 0s] amarok: BEGIN: virtual SyncedPlaylistPtr KConfigSyncRelStore::asSyncedPlaylist(Playlists::PlaylistPtr) amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='file:///home/ermesa/Music/Tom_Lehrer/An_Evening_Wasted_with_Tom_Lehrer/05_Tom_Lehrer_An_Evening_Wasted_with_Tom_Lehrer_Oedipus_Rex.ogg' OR url='file:///home/ermesa/Music/Tom_Lehrer/An_Evening_Wasted_with_Tom_Lehrer/05_Tom_Lehrer_An_Evening_Wasted_with_Tom_Lehrer_Oedipus_Rex.ogg' OR localurl='file:///home/ermesa/Music/Tom_Lehrer/An_Evening_Wasted_with_Tom_Lehrer/05_Tom_Lehrer_An_Evening_Wasted_with_Tom_Lehrer_Oedipus_Rex.ogg';" amarok: [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (130) Incorrect file format 'podcastepisodes' on SELECT id FROM podcastepisodes WHERE guid='http://www.podtrac.com/pts/redirect.mp3/download.publicradio.org/podcast/dinnerpartydownload/2013/04/05/dpd_20130405_128.mp3' OR url='http://www.podtrac.com/pts/redirect.mp3/download.publicradio.org/podcast/dinnerpartydownload/2013/04/05/dpd_20130405_128.mp3' OR localurl='http://www.podtrac.com/pts/redirect.mp3/download.publicradio.org/podcast/dinnerpartydownload/2013/04/05/dpd_20130405_128.mp3';" amarok: BEGIN: MetaStream::Track::Track(const KUrl&) Ironically that last one IS a podcast episode that I added to the playlist.
Subscribing Rex as he is the Fedora guy.
(In reply to comment #6) > I haven't done anything. This just happened after the most recent update. > How do I check what's going on with mariadb/mysql, etc? I'm using mysqle - > the embedded one. Please follow the guide at http://www.thegeekstuff.com/2008/09/how-to-repair-corrupted-mysql-tables-using-myisamchk/ to try to diagnose/repair your database at ~/.kde/share/apps/amarok. (make a backup first). > I'd prefer not to lose my database - that would make it the fourth time I've > lost it and then I lost all my labels and last played and first played. I > would prefer to figure this out in a way that doesn't lose the db. I understand. When this is fixed, consider using last.fm stats synchronization to make a "backup" of your statistics/ratings/labels.. > After all, the databse appears to be fine - the left side of Amarok is fine. > It's the right side, the playlist that seems to be having some issue. Well it's true the 2 issues may be unrelated, however Amarok depends on the database so heavily that we try to fix problems with it first. > So, to recap - how do I figure out the mariadb thing? And what else might I > do before replacing the database with a fresh one? Already answered above. Also please note that this is rather a user support question than a bug report, it would much more belong to forum.kde.org (however let's keep the discussion here, it's late to move it).
Definitely think you were on the right track. Now only did a lot of the tables say they should be fixed, but I also got the following error: myisamchk: error: 'podcastepisodes.MYI' is not a MyISAM-table
OK, so it appears that fixing the tables has fixed the issue that I originally opened the bug for. I was still unable to fix the myisamchk: error: 'podcastepisodes.MYI' is not a MyISAM-table error. Don't really have anything important going on with podcast episodes. If I just delete the MYI, frm, and MYD files associated with podcastepisodes will amarok recreate it?
(In reply to comment #13) > myisamchk: error: 'podcastepisodes.MYI' is not a MyISAM-table > > error. Don't really have anything important going on with podcast episodes. > If I just delete the MYI, frm, and MYD files associated with podcastepisodes > will amarok recreate it? Unfortunetly not, but you can do the following trick 1. temporarily rename the .kde/share/apps/amarok/mysqle directory 2. start Amaork to create the fresh tables 3. copy relevant fresh tables over the offending old ones 4. rename the folder back Of course, do have a backup for the case anything goes wrong.
changed status because after a reboot (and I replaced/fixed the files as outline above), it's still happening. Running myisamchk after a rebook and startup of amarok yields: myisamchk *.MYI >> ~/tmp/myisamchk_log.txt myisamchk: warning: 1 client is using or hasn't closed the table properly MyISAM-table 'playlist_tracks.MYI' is usable but should be fixed I fix it and then on next reboot it's messed up again.
(In reply to comment #15) > changed status because after a reboot (and I replaced/fixed the files as > outline above), it's still happening. Please don't change status of bugs once it is set by a developer. > Running myisamchk after a reboot and startup of amarok yields: > > myisamchk *.MYI >> ~/tmp/myisamchk_log.txt > myisamchk: warning: 1 client is using or hasn't closed the table properly > MyISAM-table 'playlist_tracks.MYI' is usable but should be fixed > > I fix it and then on next reboot it's messed up again. Perhaps your window manager doesn't tell Amarok to quit properly and just kills it (after a timeout?), perhaps your mysqld implementation crashes on exit, perhaps a script is blocking Amarok from shutting down properly, perhaps your distribution shutdown script doesn't unmount the volume properly, etc. etc. You may want to try to reproduce this with a new user account, even better on a different machine. Please note that Amarok Forum is much more appropriate for user support than bugzilla.