Local collection empty

[Elfy]

Binary package hint: amarok

After the recent update the local collection appeared empty.

A rescan of collection resulted in the same empty local collection

Removing the config files and starting from afresh results in the same empty local collection.

ProblemType: Bug
Architecture: i386
Date: Wed Feb 17 16:10:55 2010
DistroRelease: Ubuntu 10.04
InstallationMedia: Ubuntu 10.04 "Lucid Lynx" - Alpha i386 (20100113)
NonfreeKernelModules: nvidia
Package: amarok 2:2.2.2.90-0ubuntu1
ProcEnviron:
 LANG=en_GB.utf8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.32-13.18-generic
SourcePackage: amarok
Uname: Linux 2.6.32-13-generic i686

[Doug McMahon (mc3man)]

Notice the same behaviour in an updated 2:2.2.2.90-0ubuntu1 amarok, additionally amarok isno longer quitting properly.

[Myriam Schweingruber (myriam)]

How many MySQL versions do you have installed? This looks like a MySQL version mismatch. Version 5.1 should be enough. Also you didn't specify if you were using the default MySQL embedded or an external one for your collection.

[Elfy (elfy)]

I am using the default embedded MySQL

Appear to only have MySQL-common installed - 5.1.41-3ubuntu4

[Myriam Schweingruber (myriam)]

Then I guess it is Lucid related, since everything works fine here on Karmic, Using Amarok from git witht he current user and 2.2.90 with a different user. Never had any collection problems since 2.2.2
Now to know what went wrong here...

[Elfy (elfy)]

Doing this gets it going again - thanks mc4man

Installed the following packages:
libhtml-template-perl (2.9-1)
mysql-server (5.1.41-3ubuntu6)
mysql-server-5.1 (5.1.41-3ubuntu6)
mysql-server-core-5.1 (5.1.41-3ubuntu6)

exact method was revert the 3 amarok packages to 2:2.2.2-0ubuntu1, install above, run amarok once, update amarok

[Doug McMahon (mc3man)]

To add additionally
As noted, - from a prev. amarok 2,22 install for the upgrade to work some packages need to be installed, 2.22 run once, then upgrade. However from a fresh, fully updated lucid install (02/21

Installed amarok 2:2.2.2.90-0ubuntu1 - no collection found, mysql not initialised, unclean amarok exit

After installing the mentioned server packages, then amarok 2:2.2.2.90-0ubuntu1 works fine, exits cleanly

The install of the server packages would be all of these due to depends, so it may be one or more that does the trick - possibly the client if not the server..? ( though the server seems most likely

libdbd-mysql-perl (4.012-1ubuntu1)
libdbi-perl (1.609-1)
libhtml-template-perl (2.9-1)
libnet-daemon-perl (0.43-1)
libplrpc-perl (0.2020-2)
mysql-client-5.1 (5.1.41-3ubuntu6)
mysql-server (5.1.41-3ubuntu6)
mysql-server-5.1 (5.1.41-3ubuntu6)
mysql-server-core-5.1 (5.1.41-3ubuntu6)

Also possibly of interest may be the msqle debian patch

[Doug McMahon (mc3man)]

having got around to trying from a live cd (02-25), the install of the server package restores amarok to proper function
mysql-server

[ekpyrosis (mvdwerf2001)]

Works for me:
First installing:
libdbd-mysql-perl (4.012-1ubuntu1)
libdbi-perl (1.609-1)
libhtml-template-perl (2.9-1)
libnet-daemon-perl (0.43-1)
libplrpc-perl (0.2020-2)
mysql-client-5.1 (5.1.41-3ubuntu6)
mysql-server (5.1.41-3ubuntu6)
mysql-server-5.1 (5.1.41-3ubuntu6)
mysql-server-core-5.1 (5.1.41-3ubuntu6)
and then installing amarok

Local Collections are back again.

[Doug McMahon (mc3man)]

This is continuing to be an issue - at least with gnome.

If you can't or aren't inclined to fix then maybe add mysql-server-core-5.1 as a recommend

[Rich (rich-fordmondeo)]

Agreed. I've just been stung by this.

A day or two ago, apt-get suggested some now unused applications, and suggested cleaning up by using the autoremove option. I still had Amarok installed, but it obviously didn't seem to tell apt that mysql-server was a requirement. Even though I hadn't configured Amarok to use MySQL.

Ubuntu 10.04, Amarok and Klibido are the only KDE apps I have installed.

[Germán Bassi (germanbassi)]

After a fresh install of Lucid, there was no collection and Amarok didn't have a clean exit. I installed mysql-server-core-5.1 and this was fixed.

[fermulator (fermulator)]

I'm running an external MySQL DB, why do we need to install mysql-server-core-5.1 on the client side?

[fermulator (fermulator)]

(NOTE: Also affects latest amarok 2.3.0)

[Bill Yiannakos (billyiannakos)]

The same here: just upgraded from Ubuntu 9.10 to 10.04 and from Amarok 1.1.4 to 2.3 and also had this issue. It was resolved by installing mysql-server-core-5.1, as mentioned on a comment above....

[Doug McMahon (mc3man)]

The amarok version in maverick - 2.3.1 - does not have this issue so that is also an option - find a ppa or whatever
Though they could just update amarok in lucid, wouldn't hold breath there

[Doetoe (doetoe)]

I have the same problem running maverick 64 bits, amarok 2.3.2.

[SteveLoughran (steve-loughran)]

amarok should work with sqllite without needing mysql, so perhaps the problem is the sqllite dependencies are missing on a clean install. Mysql is overkill

(pause)

yes, installing sqllite is sufficient for Amarok on a clean 10.04 install to store music and to terminate cleanly. You do not appear to need mysql.

[Myriam Schweingruber (myriam)]

Steve, that is simply not true, Amarok 2.x needs either mysql embedded or a mysql server, neither sqlite nor postgresql are supported.
FWIW, this bug is solved since quite some time, it was a packaging error.

[Maarten Bezemer (veger)]

This bug report is being closed due to your last comment regarding this being fixed.