Re: [gentoo-user] amarok can't use mysql collection

[Alan McKinnon <alan.mckinnon@gmail.com>]

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