* [gentoo-user] amarok can't use mysql collection @ 2009-11-16 8:24 Alan McKinnon 2009-11-16 19:26 ` [gentoo-user] " Doug Hunley ` (2 more replies) 0 siblings, 3 replies; 13+ messages in thread From: Alan McKinnon @ 2009-11-16 8:24 UTC (permalink / raw To: gentoo-user Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? I get errors like this whenever amarok updates the collection: amarok: [ERROR!] GREPME MySQL query failed! No database selected on "INSERT INTO images SELECT * FROM images_temp;" It's not just the above versions, I've tried amarok-1.9.*, various versions of mysql-5.0 and mysql-community-5.1.*, always with the same results. $ eix -e amarok Installed versions: 2.2.0(4)(20:08:42 15/11/09)(cdda ipod linguas_en_GB mp3tunes mtp opengl semantic-desktop -aqua -daap -debug -lastfm -linguas_bg - linguas_ca -linguas_cs -linguas_da -linguas_de -linguas_es -linguas_et - linguas_eu -linguas_fi -linguas_fr -linguas_it -linguas_ja -linguas_km - linguas_nb -linguas_nds -linguas_nl -linguas_pa -linguas_pl -linguas_pt - linguas_pt_BR -linguas_ru -linguas_sl -linguas_sr -linguas_sr@latin - linguas_sv -linguas_th -linguas_tr -linguas_uk -linguas_wa -linguas_zh_TW) $ eix -e mysql Installed versions: 5.0.84-r1(04:18:46 14/11/09)(community embedded perl ssl -berkdb -big-tables -cluster -debug -extraengine -latin1 -max-idx-128 - minimal -profiling -selinux -static) Google and b.g.o don't return much useful info. Moving the amarok db and config files out of the way and restarting doesn't correct the error. -- alan dot mckinnon at gmail dot com ^ permalink raw reply [flat|nested] 13+ messages in thread
* [gentoo-user] Re: amarok can't use mysql collection 2009-11-16 8:24 [gentoo-user] amarok can't use mysql collection Alan McKinnon @ 2009-11-16 19:26 ` Doug Hunley 2009-11-16 22:19 ` Alan McKinnon 2009-11-16 19:36 ` [gentoo-user] " Volker Armin Hemmann 2009-11-16 19:40 ` Alex Schuster 2 siblings, 1 reply; 13+ messages in thread From: Doug Hunley @ 2009-11-16 19:26 UTC (permalink / raw To: gentoo-user On Mon, Nov 16, 2009 at 03:24, Alan McKinnon <alan.mckinnon@gmail.com> wrote: > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? I haven't had any issues w/ amarok 2.2.0 and mysql 5.0.84-r1 (once I figured out how to get amarok to _not_ use the embedded mysql) -- Douglas J Hunley, RHCT doug.hunley@gmail.com : http://douglasjhunley.com : Twitter: @hunleyd Obsessively opposed to the typical. ^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-user] Re: amarok can't use mysql collection 2009-11-16 19:26 ` [gentoo-user] " Doug Hunley @ 2009-11-16 22:19 ` Alan McKinnon 2009-11-16 22:22 ` Volker Armin Hemmann 2009-11-17 18:41 ` Doug Hunley 0 siblings, 2 replies; 13+ messages in thread From: Alan McKinnon @ 2009-11-16 22:19 UTC (permalink / raw To: gentoo-user On Monday 16 November 2009 21:26:02 Doug Hunley wrote: > On Mon, Nov 16, 2009 at 03:24, Alan McKinnon <alan.mckinnon@gmail.com> wrote: > > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? > > I haven't had any issues w/ amarok 2.2.0 and mysql 5.0.84-r1 (once I > figured out how to get amarok to _not_ use the embedded mysql) That's a common complaint about amarok lately. The devs reckon they must use multi-user mysql because it's almost impossible to get sqlite to do it properly and totally impossible to get it to do it remotely. This puzzles me. How many users out their use their music player in multi-user mode with a collection db on a remote machine? Apart from LTSP installs, I'll bet it's none. And LTSP is better off using mpd, so why didn't the amarok devs simply include mpd support? To answer your question, does Settings -> Collection -> enable check box & fill in bottom half of dialog do what you want? -- alan dot mckinnon at gmail dot com ^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-user] Re: amarok can't use mysql collection 2009-11-16 22:19 ` Alan McKinnon @ 2009-11-16 22:22 ` Volker Armin Hemmann 2009-11-17 0:21 ` Alan McKinnon 2009-11-17 18:41 ` Doug Hunley 1 sibling, 1 reply; 13+ messages in thread From: Volker Armin Hemmann @ 2009-11-16 22:22 UTC (permalink / raw To: gentoo-user On Montag 16 November 2009, Alan McKinnon wrote: > On Monday 16 November 2009 21:26:02 Doug Hunley wrote: > > On Mon, Nov 16, 2009 at 03:24, Alan McKinnon <alan.mckinnon@gmail.com> > > wrote: > > > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? > > > > I haven't had any issues w/ amarok 2.2.0 and mysql 5.0.84-r1 (once I > > figured out how to get amarok to _not_ use the embedded mysql) > > That's a common complaint about amarok lately. The devs reckon they must > use multi-user mysql because it's almost impossible to get sqlite to do it > properly and totally impossible to get it to do it remotely. > > This puzzles me. How many users out their use their music player in > multi-user mode with a collection db on a remote machine? Apart from LTSP > installs, I'll bet it's none. And LTSP is better off using mpd, so why > didn't the amarok devs simply include mpd support? > > To answer your question, does Settings -> Collection -> enable check box & > fill in bottom half of dialog do what you want? > there had been other reasons. Many people have huge collections - and sqlite sucks with huge collections. ^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-user] Re: amarok can't use mysql collection 2009-11-16 22:22 ` Volker Armin Hemmann @ 2009-11-17 0:21 ` Alan McKinnon 0 siblings, 0 replies; 13+ messages in thread From: Alan McKinnon @ 2009-11-17 0:21 UTC (permalink / raw To: gentoo-user On Tuesday 17 November 2009 00:22:57 Volker Armin Hemmann wrote: > On Montag 16 November 2009, Alan McKinnon wrote: > > On Monday 16 November 2009 21:26:02 Doug Hunley wrote: > > > On Mon, Nov 16, 2009 at 03:24, Alan McKinnon <alan.mckinnon@gmail.com> > > > > wrote: > > > > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? > > > > > > I haven't had any issues w/ amarok 2.2.0 and mysql 5.0.84-r1 (once I > > > figured out how to get amarok to _not_ use the embedded mysql) > > > > That's a common complaint about amarok lately. The devs reckon they must > > use multi-user mysql because it's almost impossible to get sqlite to do > > it properly and totally impossible to get it to do it remotely. > > > > This puzzles me. How many users out their use their music player in > > multi-user mode with a collection db on a remote machine? Apart from > > LTSP installs, I'll bet it's none. And LTSP is better off using mpd, so > > why didn't the amarok devs simply include mpd support? > > > > To answer your question, does Settings -> Collection -> enable check box > > & fill in bottom half of dialog do what you want? > > there had been other reasons. Many people have huge collections - and > sqlite sucks with huge collections. I misread his post - I though he wanted to know how to disable mysqle (he'd figured that out already), then my train of though went off into other (even wronger) directions with embedded vs non-embedded mysql for amarok. Meanwhile I compared by flags to yours and tried rebuilding mysql with -community -berkdb then rebuilding Amarok. This didn't change anything. Busy downgrading binutils (#290662) now and trying again -- alan dot mckinnon at gmail dot com ^ permalink raw reply [flat|nested] 13+ messages in thread
* [gentoo-user] Re: amarok can't use mysql collection 2009-11-16 22:19 ` Alan McKinnon 2009-11-16 22:22 ` Volker Armin Hemmann @ 2009-11-17 18:41 ` Doug Hunley 1 sibling, 0 replies; 13+ messages in thread From: Doug Hunley @ 2009-11-17 18:41 UTC (permalink / raw To: gentoo-user On Mon, Nov 16, 2009 at 17:19, Alan McKinnon <alan.mckinnon@gmail.com> wrote: > On Monday 16 November 2009 21:26:02 Doug Hunley wrote: >> On Mon, Nov 16, 2009 at 03:24, Alan McKinnon <alan.mckinnon@gmail.com> > wrote: >> > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? >> >> I haven't had any issues w/ amarok 2.2.0 and mysql 5.0.84-r1 (once I >> figured out how to get amarok to _not_ use the embedded mysql) > > That's a common complaint about amarok lately. The devs reckon they must use > multi-user mysql because it's almost impossible to get sqlite to do it > properly and totally impossible to get it to do it remotely. > > This puzzles me. How many users out their use their music player in multi-user > mode with a collection db on a remote machine? Apart from LTSP installs, I'll > bet it's none. And LTSP is better off using mpd, so why didn't the amarok devs > simply include mpd support? > > To answer your question, does Settings -> Collection -> enable check box & > fill in bottom half of dialog do what you want? I had done that actually, and it completely *ignored* it until I killed all amarok processes and removed the mysqle directory (I think that was the name). Thankfully, I found this solution on some random blog somewhere that google pointed me to -- Douglas J Hunley, RHCT doug.hunley@gmail.com : http://douglasjhunley.com : Twitter: @hunleyd Obsessively opposed to the typical. ^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-user] amarok can't use mysql collection 2009-11-16 8:24 [gentoo-user] amarok can't use mysql collection Alan McKinnon 2009-11-16 19:26 ` [gentoo-user] " Doug Hunley @ 2009-11-16 19:36 ` Volker Armin Hemmann 2009-11-16 19:40 ` Alex Schuster 2 siblings, 0 replies; 13+ messages in thread From: Volker Armin Hemmann @ 2009-11-16 19:36 UTC (permalink / raw To: gentoo-user On Montag 16 November 2009, Alan McKinnon wrote: > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? yes > > $ eix -e amarok > Installed versions: 2.2.0(4)(20:08:42 15/11/09)(cdda ipod > linguas_en_GB mp3tunes mtp opengl semantic-desktop -aqua -daap -debug > -lastfm -linguas_bg - linguas_ca -linguas_cs -linguas_da -linguas_de > -linguas_es -linguas_et - linguas_eu -linguas_fi -linguas_fr -linguas_it > -linguas_ja -linguas_km - linguas_nb -linguas_nds -linguas_nl -linguas_pa > -linguas_pl -linguas_pt - linguas_pt_BR -linguas_ru -linguas_sl > -linguas_sr -linguas_sr@latin - linguas_sv -linguas_th -linguas_tr > -linguas_uk -linguas_wa -linguas_zh_TW) eix -e amarok [I] media-sound/amarok Installed versions: 2.2.0(4){tbz2}(22:59:03 02.10.2009)(cdda linguas_de mtp opengl semantic-desktop -aqua -daap -debug -ipod -lastfm -linguas_bg - linguas_ca -linguas_cs -linguas_da -linguas_en_GB -linguas_es -linguas_et - linguas_eu -linguas_fi -linguas_fr -linguas_it -linguas_ja -linguas_km - linguas_nb -linguas_nds -linguas_nl -linguas_pa -linguas_pl -linguas_pt - linguas_pt_BR -linguas_ru -linguas_sl -linguas_sr -linguas_sr@latin - linguas_sv -linguas_th -linguas_tr -linguas_uk -linguas_wa -linguas_zh_TW - mp3tunes) > > $ eix -e mysql > Installed versions: 5.0.84-r1(04:18:46 14/11/09)(community embedded > perl ssl -berkdb -big-tables -cluster -debug -extraengine -latin1 > -max-idx-128 - minimal -profiling -selinux -static) eix -e mysql [I] dev-db/mysql Installed versions: 5.0.84-r1{tbz2}(22:28:14 09.09.2009)(berkdb community embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 - max-idx-128 -minimal -profiling -selinux -static) have you built qt with the right flags? ^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-user] amarok can't use mysql collection 2009-11-16 8:24 [gentoo-user] amarok can't use mysql collection Alan McKinnon 2009-11-16 19:26 ` [gentoo-user] " Doug Hunley 2009-11-16 19:36 ` [gentoo-user] " Volker Armin Hemmann @ 2009-11-16 19:40 ` Alex Schuster 2009-11-17 0:44 ` Alan McKinnon 2 siblings, 1 reply; 13+ messages in thread From: Alex Schuster @ 2009-11-16 19:40 UTC (permalink / raw To: gentoo-user Alan McKinnon writes: > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? Sort of. > I get errors like this whenever amarok updates the collection: > > amarok: [ERROR!] GREPME MySQL query failed! No database > selected on "INSERT INTO images SELECT * FROM images_temp;" Not here. Sometimes the collection gets screwed up a little, but I do not get any output when re-scanning the collection. > $ eix -e amarok > Installed versions: 2.2.0(4)(20:08:42 15/11/09)(cdda ipod > linguas_en_GB mp3tunes mtp opengl semantic-desktop -aqua -daap -debug > -lastfm -linguas_bg - linguas_ca -linguas_cs -linguas_da -linguas_de > -linguas_es -linguas_et - linguas_eu -linguas_fi -linguas_fr > -linguas_it -linguas_ja -linguas_km - linguas_nb -linguas_nds > -linguas_nl -linguas_pa -linguas_pl -linguas_pt - linguas_pt_BR > -linguas_ru -linguas_sl -linguas_sr -linguas_sr@latin - linguas_sv > -linguas_th -linguas_tr -linguas_uk -linguas_wa -linguas_zh_TW) 2.2.0(4)(10:58:59 10.10.2009)(linguas_de opengl semantic-desktop -aqua -cdda -daap -debug -ipod -lastfm -linguas_bg - linguas_ca -linguas_cs -linguas_da -linguas_en_GB -linguas_es -linguas_et -linguas_eu -linguas_fi -linguas_fr -linguas_it -linguas_ja -linguas_km - linguas_nb -linguas_nds -linguas_nl -linguas_pa -linguas_pl -linguas_pt - linguas_pt_BR -linguas_ru -linguas_sl -linguas_sr -linguas_sr@latin - linguas_sv -linguas_th -linguas_tr -linguas_uk -linguas_wa -linguas_zh_TW -mp3tunes -mtp) > $ eix -e mysql > Installed versions: 5.0.84-r1(04:18:46 14/11/09)(community > embedded perl ssl -berkdb -big-tables -cluster -debug -extraengine > -latin1 -max-idx-128 - minimal -profiling -selinux -static) Installed versions: 5.0.84-r1(15:58:02 12.11.2009)(berkdb community embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -max- idx-128 -minimal -profiling -selinux -static) Wonko ^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-user] amarok can't use mysql collection 2009-11-16 19:40 ` Alex Schuster @ 2009-11-17 0:44 ` Alan McKinnon 2009-11-17 12:28 ` Volker Armin Hemmann ` (2 more replies) 0 siblings, 3 replies; 13+ messages in thread From: Alan McKinnon @ 2009-11-17 0:44 UTC (permalink / raw To: gentoo-user On Monday 16 November 2009 21:40:42 Alex Schuster wrote: > Alan McKinnon writes: > > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? > > Sort of. > > > I get errors like this whenever amarok updates the collection: > > > > amarok: [ERROR!] GREPME MySQL query failed! No database > > selected on "INSERT INTO images SELECT * FROM images_temp;" > > Not here. Sometimes the collection gets screwed up a little, but I do not > get any output when re-scanning the collection. > > > $ eix -e amarok > > Installed versions: 2.2.0(4)(20:08:42 15/11/09)(cdda ipod > > linguas_en_GB mp3tunes mtp opengl semantic-desktop -aqua -daap -debug > > -lastfm -linguas_bg - linguas_ca -linguas_cs -linguas_da -linguas_de > > -linguas_es -linguas_et - linguas_eu -linguas_fi -linguas_fr > > -linguas_it -linguas_ja -linguas_km - linguas_nb -linguas_nds > > -linguas_nl -linguas_pa -linguas_pl -linguas_pt - linguas_pt_BR > > -linguas_ru -linguas_sl -linguas_sr -linguas_sr@latin - linguas_sv > > -linguas_th -linguas_tr -linguas_uk -linguas_wa -linguas_zh_TW) > > 2.2.0(4)(10:58:59 10.10.2009)(linguas_de opengl > semantic-desktop -aqua -cdda -daap -debug -ipod -lastfm -linguas_bg - > linguas_ca -linguas_cs -linguas_da -linguas_en_GB -linguas_es -linguas_et > -linguas_eu -linguas_fi -linguas_fr -linguas_it -linguas_ja -linguas_km - > linguas_nb -linguas_nds -linguas_nl -linguas_pa -linguas_pl -linguas_pt - > linguas_pt_BR -linguas_ru -linguas_sl -linguas_sr -linguas_sr@latin - > linguas_sv -linguas_th -linguas_tr -linguas_uk -linguas_wa -linguas_zh_TW > -mp3tunes -mtp) > > > $ eix -e mysql > > Installed versions: 5.0.84-r1(04:18:46 14/11/09)(community > > embedded perl ssl -berkdb -big-tables -cluster -debug -extraengine > > -latin1 -max-idx-128 - minimal -profiling -selinux -static) > > Installed versions: 5.0.84-r1(15:58:02 12.11.2009)(berkdb community > embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -max- > idx-128 -minimal -profiling -selinux -static) <sigh> My stuff is similar to yours and Volker's, didn't work with mysqle. Even tried downgrading binutils, which fixed one error and revealed another. I have now made a decision. I was a faithful amarok user for 5 years. In the kde-3.5 days it worked flawlessly and never gave a day's trouble. The switch to KDE-4 has been fraught with problems from day 1 - all the decent features went away, then the devs spent two years fiddling with the gui while the palyer didn't *actually* play music (gee whizz, whodathunkedit? That a user might actually play music on his media player). Then the monumental cock-up with MySQL and -fPIC, the jumping through hoops that caused with every single distro out there, mysql-5.1.* is still not in the tree un-hardmasked, and now this crap. Amarok, it was nice knowing you. One day you might build and play music again on all sane systems out there. Meanwhile, I think I want to hear songs play so some other player is going on this machine and you are coming off. Bye bye now, and don't bump your head on the door when you leave. -- alan dot mckinnon at gmail dot com ^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-user] amarok can't use mysql collection 2009-11-17 0:44 ` Alan McKinnon @ 2009-11-17 12:28 ` Volker Armin Hemmann 2009-11-17 16:52 ` Alex Schuster 2009-11-17 19:27 ` James Ausmus 2 siblings, 0 replies; 13+ messages in thread From: Volker Armin Hemmann @ 2009-11-17 12:28 UTC (permalink / raw To: gentoo-user On Dienstag 17 November 2009, Alan McKinnon wrote: > On Monday 16 November 2009 21:40:42 Alex Schuster wrote: > > Alan McKinnon writes: > > > Does anyone here successfully use amarok-2.2.0 with mysql-5.0.84-r1? > > > > Sort of. > > > > > I get errors like this whenever amarok updates the collection: > > > > > > amarok: [ERROR!] GREPME MySQL query failed! No database > > > selected on "INSERT INTO images SELECT * FROM images_temp;" > > > > Not here. Sometimes the collection gets screwed up a little, but I do not > > get any output when re-scanning the collection. > > > > > $ eix -e amarok > > > Installed versions: 2.2.0(4)(20:08:42 15/11/09)(cdda ipod > > > linguas_en_GB mp3tunes mtp opengl semantic-desktop -aqua -daap -debug > > > -lastfm -linguas_bg - linguas_ca -linguas_cs -linguas_da -linguas_de > > > -linguas_es -linguas_et - linguas_eu -linguas_fi -linguas_fr > > > -linguas_it -linguas_ja -linguas_km - linguas_nb -linguas_nds > > > -linguas_nl -linguas_pa -linguas_pl -linguas_pt - linguas_pt_BR > > > -linguas_ru -linguas_sl -linguas_sr -linguas_sr@latin - linguas_sv > > > -linguas_th -linguas_tr -linguas_uk -linguas_wa -linguas_zh_TW) > > > > 2.2.0(4)(10:58:59 10.10.2009)(linguas_de opengl > > semantic-desktop -aqua -cdda -daap -debug -ipod -lastfm -linguas_bg - > > linguas_ca -linguas_cs -linguas_da -linguas_en_GB -linguas_es -linguas_et > > -linguas_eu -linguas_fi -linguas_fr -linguas_it -linguas_ja -linguas_km - > > linguas_nb -linguas_nds -linguas_nl -linguas_pa -linguas_pl -linguas_pt - > > linguas_pt_BR -linguas_ru -linguas_sl -linguas_sr -linguas_sr@latin - > > linguas_sv -linguas_th -linguas_tr -linguas_uk -linguas_wa -linguas_zh_TW > > -mp3tunes -mtp) > > > > > $ eix -e mysql > > > Installed versions: 5.0.84-r1(04:18:46 14/11/09)(community > > > embedded perl ssl -berkdb -big-tables -cluster -debug -extraengine > > > -latin1 -max-idx-128 - minimal -profiling -selinux -static) > > > > Installed versions: 5.0.84-r1(15:58:02 12.11.2009)(berkdb community > > embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -max- > > idx-128 -minimal -profiling -selinux -static) > > <sigh> > > My stuff is similar to yours and Volker's, didn't work with mysqle. > > Even tried downgrading binutils, which fixed one error and revealed > another. > > I have now made a decision. I was a faithful amarok user for 5 years. In > the kde-3.5 days it worked flawlessly and never gave a day's trouble. The > switch to KDE-4 has been fraught with problems from day 1 - all the decent > features went away, then the devs spent two years fiddling with the gui > while the palyer didn't *actually* play music (gee whizz, whodathunkedit? > That a user might actually play music on his media player). Then the > monumental cock-up with MySQL and -fPIC, the jumping through hoops that > caused with every single distro out there, mysql-5.1.* is still not in the > tree un-hardmasked, and now this crap. > > Amarok, it was nice knowing you. One day you might build and play music > again on all sane systems out there. Meanwhile, I think I want to hear > songs play so some other player is going on this machine and you are > coming off. > > Bye bye now, and don't bump your head on the door when you leave. > qmmp is nice alsaplayer is my favorite for 'keep it simple' ^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-user] amarok can't use mysql collection 2009-11-17 0:44 ` Alan McKinnon 2009-11-17 12:28 ` Volker Armin Hemmann @ 2009-11-17 16:52 ` Alex Schuster 2009-11-17 18:36 ` Alan McKinnon 2009-11-17 19:27 ` James Ausmus 2 siblings, 1 reply; 13+ messages in thread From: Alex Schuster @ 2009-11-17 16:52 UTC (permalink / raw To: gentoo-user Alan McKinnon writes: > On Monday 16 November 2009 21:40:42 Alex Schuster wrote: > > Alan McKinnon writes: > > > I get errors like this whenever amarok updates the collection: > > > > > > amarok: [ERROR!] GREPME MySQL query failed! No database > > > selected on "INSERT INTO images SELECT * FROM images_temp;" > > > > Not here. Sometimes the collection gets screwed up a little, but I do > > not get any output when re-scanning the collection. It just happened again. I added a new folder to my /data/mp3 hierarchy (metal), put some folders of music into it, marked it as collection folder and told amarok to re-scan the collection. When I search for 'metallica', it finds 'Rapoon'. When I drag a metallica album folder directly into amarok, it shows the album's name correctly, but the artist is 'Rapoon'. I unmarked all of my collection's folders, let amarok re-scan, and now the collection is empty. I added all the folders again, scanned, and I have the same problem. I deleted ~/.kde4/share/apps/amarok/mysqle, started amarok and let it scan, now all is fine again. Seems I have to do this once in a while. > I have now made a decision. I was a faithful amarok user for 5 years. > In the kde-3.5 days it worked flawlessly and never gave a day's > trouble. The switch to KDE-4 has been fraught with problems from day 1 > - all the decent features went away, then the devs spent two years > fiddling with the gui while the palyer didn't *actually* play music > (gee whizz, whodathunkedit? That a user might actually play music on > his media player). Then the monumental cock-up with MySQL and -fPIC, > the jumping through hoops that caused with every single distro out > there, mysql-5.1.* is still not in the tree un-hardmasked, and now > this crap. I had my bunch of problems with the new amarok, too. And still, I like it. I got used to it, I like the new layout, it gets song texts fine (which stopped working for the old amarok some time ago). > Amarok, it was nice knowing you. One day you might build and play music > again on all sane systems out there. Meanwhile, I think I want to hear > songs play so some other player is going on this machine and you are > coming off. What about using amarok 1.4, until 2.x works fine for you? Mine does not work any longer, though. Just noted this when I started it to compare with the 2.2 one, did not do this a while ago. /usr/kde/3.5/bin/amarok immediately throws an 'illegal instruction' error. Huh? I did not change my CFLAGS, they are "-march=k8-sse3 -mfpmath=sse -O2 -pipe -fomit-frame-pointer" on a AMD Athlon 4850e. The k8-sse3 should be sane, gcc -Q --help=target -march=native lists it. I am not sure where I got the -mfpmath=sse from. I rebuilt amarok 1.4, and get the same error, probably somewhere in kdelibs or such stuff. Strange. Let's see if this happens with other stuff, too. Wonko ^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-user] amarok can't use mysql collection 2009-11-17 16:52 ` Alex Schuster @ 2009-11-17 18:36 ` Alan McKinnon 0 siblings, 0 replies; 13+ messages in thread From: Alan McKinnon @ 2009-11-17 18:36 UTC (permalink / raw To: gentoo-user On Tuesday 17 November 2009 18:52:00 Alex Schuster wrote: > Alan McKinnon writes: > > On Monday 16 November 2009 21:40:42 Alex Schuster wrote: > > > Alan McKinnon writes: > > > > I get errors like this whenever amarok updates the collection: > > > > > > > > amarok: [ERROR!] GREPME MySQL query failed! No database > > > > selected on "INSERT INTO images SELECT * FROM images_temp;" > > > > > > Not here. Sometimes the collection gets screwed up a little, but I do > > > not get any output when re-scanning the collection. > > It just happened again. I added a new folder to my /data/mp3 hierarchy > (metal), put some folders of music into it, marked it as collection folder > and told amarok to re-scan the collection. When I search for 'metallica', > it finds 'Rapoon'. When I drag a metallica album folder directly into > amarok, it shows the album's name correctly, but the artist is 'Rapoon'. > > I unmarked all of my collection's folders, let amarok re-scan, and now the > collection is empty. I added all the folders again, scanned, and I have > the same problem. > > I deleted ~/.kde4/share/apps/amarok/mysqle, started amarok and let it > scan, now all is fine again. Seems I have to do this once in a while. To me, that is intolerable on production code with a version number of 2.2.0. It' supposed to be mature, it's not supposed to trash it's own data store! What o you think would happen if Firefox dumped it's browser history and cookies once a week in sync with phases of the moon? If any vendor tried to sell me crap code like that at work, they would be out the door on their arse [snip] > > Amarok, it was nice knowing you. One day you might build and play music > > again on all sane systems out there. Meanwhile, I think I want to hear > > songs play so some other player is going on this machine and you are > > coming off. > > What about using amarok 1.4, until 2.x works fine for you? 1.4 links to kdelibs-3.5 right? I just spent nearly a year getting rid of 3.5 apps... > Mine does not work any longer, though. Just noted this when I started it > to compare with the 2.2 one, did not do this a while ago. > /usr/kde/3.5/bin/amarok immediately throws an 'illegal instruction' error. > Huh? I did not change my CFLAGS, they are "-march=k8-sse3 -mfpmath=sse -O2 > -pipe -fomit-frame-pointer" on a AMD Athlon 4850e. The k8-sse3 should be > sane, gcc -Q --help=target -march=native lists it. I am not sure where I > got the -mfpmath=sse from. I rebuilt amarok 1.4, and get the same error, > probably somewhere in kdelibs or such stuff. Strange. Let's see if this > happens with other stuff, too. that looks like you built amarok with binutils-2.20. It affects many apps. Try downgrade binutils, rebuild offending apps and see if it makes a difference. Or you could try rebuild current binutils with USE=gold. I have no idea what it does, but there's a few references on b.g.o. about this working in some cases. -- alan dot mckinnon at gmail dot com ^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-user] amarok can't use mysql collection 2009-11-17 0:44 ` Alan McKinnon 2009-11-17 12:28 ` Volker Armin Hemmann 2009-11-17 16:52 ` Alex Schuster @ 2009-11-17 19:27 ` James Ausmus 2 siblings, 0 replies; 13+ messages in thread From: James Ausmus @ 2009-11-17 19:27 UTC (permalink / raw To: gentoo-user [-- Attachment #1: Type: text/plain, Size: 698 bytes --] On Mon, Nov 16, 2009 at 4:44 PM, Alan McKinnon <alan.mckinnon@gmail.com>wrote: <snip> > > Amarok, it was nice knowing you. One day you might build and play music > again > on all sane systems out there. Meanwhile, I think I want to hear songs play > so > some other player is going on this machine and you are coming off. > > I've been fairly happy with Juk - it's already installed if you are running KDE (depended on by the kde-base/kdemultimedia-meta package). It's fairly simple, not nearly as powerful as Amarok, but it's been a decent substitute while Amarok has been having its growing pains... I haven't tried 2.2 yet, but it sounds like there are still a few too many issues... :( -James [-- Attachment #2: Type: text/html, Size: 1043 bytes --] ^ permalink raw reply [flat|nested] 13+ messages in thread
end of thread, other threads:[~2009-11-17 19:27 UTC | newest] Thread overview: 13+ messages (download: mbox.gz follow: Atom feed -- links below jump to the message on this page -- 2009-11-16 8:24 [gentoo-user] amarok can't use mysql collection Alan McKinnon 2009-11-16 19:26 ` [gentoo-user] " Doug Hunley 2009-11-16 22:19 ` Alan McKinnon 2009-11-16 22:22 ` Volker Armin Hemmann 2009-11-17 0:21 ` Alan McKinnon 2009-11-17 18:41 ` Doug Hunley 2009-11-16 19:36 ` [gentoo-user] " Volker Armin Hemmann 2009-11-16 19:40 ` Alex Schuster 2009-11-17 0:44 ` Alan McKinnon 2009-11-17 12:28 ` Volker Armin Hemmann 2009-11-17 16:52 ` Alex Schuster 2009-11-17 18:36 ` Alan McKinnon 2009-11-17 19:27 ` James Ausmus
This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox