Version: 2.2.1 (using KDE 4.3.3) OS: Linux Installed from: Debian testing/unstable Packages Amarok 2.2.x did only show an empty collection an my machine while Amarok 2.1.x did work just fine. The debug log shows tons of the following messages. amarok: [ERROR!] Tried to perform escape() on uninitialized MySQL amarok: [ERROR!] Tried to perform insert on uninitialized MySQL In Debian bug 549543 (http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=549543) the same problem is mentioned and the reporter found its cause, he and I both had a ~/.my.cnf mysql configuration file. Renaming this file works, but is no option for me.
Gunter, can you please test again with Amarok 2.2.2?
I just tried, no change, sorry.
Jeff, is this a bug on our side?
Never heard of this before. I'm pretty sure we pass in the location of the my.cnf to use, so probably one of the following is happening: 1) I'm wrong and we're not passing it in. 2) We're passing it in, but it's empty or nonexistent, and MySQL decides to then look at a ~/.my.cnf 3) It's some sort of MySQL bug. I'll take a look at this soon.
Actually, if the following is the my.cnf file Amarok is supposed to use, it IS empty, in fact: $ ls -la .kde/share/apps/amarok/my.cnf -rw------- 1 gunter gunter 0 12. Jan 2009 .kde/share/apps/amarok/my.cnf The question is, what should be contained therein, and why isn't it? Also, the bug occured on my system soon or immediately after upgrading to Amarok 2.2.x, just as Jeremy describes in Debian bug #549543 - so maybe it's a Debian related issue, after all?
(In reply to comment #5) > The question is, what should be contained therein, and why isn't it? Nothing. It's supposed to be empty. All needed parameters are passed in when the plugin is loaded. I think that mysql actually creates that file on its own. > Also, the bug occured on my system soon or immediately after upgrading to > Amarok 2.2.x, just as Jeremy describes in Debian bug #549543 - so maybe it's a > Debian related issue, after all? Maybe. Will report back after checking here on Arch.
I'm having those same error messages, but I do not have a my.cnf conf file. fermulator@fermmy:~$ ls -al ~ | grep cnf fermulator@fermmy:~$ ls -al ~/.kde/share/apps/amarok | grep cnf -rw-r--r-- 1 fermulator fermulator 0 2010-07-04 01:32 my.cnf fermulator@fermmy:~$ cat ~/.kde/share/apps/amarok/my.cnf Running: * Ubuntu 10.04 * Amarok 2.3.1 * KDE 4.4.2
NOTE: Trying to use an "external MySQL" database.
Can this error be reproduced. I tried it with a recent git version and a ~/.my.cnf is ignored and the correct configuration file written with every Amarok start.
Amarok now explicitly sets the my.cnf that it uses.