Bug 528312 - Amarok 2.1.1 doesn't want to load local collection
Summary: Amarok 2.1.1 doesn't want to load local collection
Status: VERIFIED FIXED
: 530562 534063 (view as bug list)
Alias: None
Product: openSUSE 11.2
Classification: openSUSE
Component: KDE4 Applications (show other bugs)
Version: Factory
Hardware: x86 openSUSE 11.1
: P2 - High : Major with 10 votes (vote)
Target Milestone: ---
Assignee: E-mail List
QA Contact: E-mail List
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-08-05 09:19 UTC by Mikhail Krasilnikov
Modified: 2009-09-14 07:43 UTC (History)
9 users (show)

See Also:
Found By: ---
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---


Attachments
Screenshot with message (18.33 KB, image/png)
2009-08-05 16:02 UTC, Mikhail Krasilnikov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mikhail Krasilnikov 2009-08-05 09:19:10 UTC
User-Agent:       Mozilla/5.0 (X11; U; Linux i686; ru; rv:1.9.1.2) Gecko/20090730 SUSE/3.5.2-1.1 Firefox/3.5.2

Amarok doesn't want to load local collection after upgrading to version 2.1.1.
Collection rescan doesn't help.

Reproducible: Always

Steps to Reproduce:
1. Start Amarok
2. Open "Collection" tab
Actual Results:  
Message "Local collection" and below "Calculation" (my translation of russian word "Подсчёт").

Expected Results:  
List of music in my collection.
Comment 1 Mikhail Krasilnikov 2009-08-05 16:02:39 UTC
Created attachment 310824 [details]
Screenshot with message
Comment 2 Forgotten User OIWrdPIkbR 2009-08-06 16:32:39 UTC
I also seem to experience this bug.

If I start Amarok with "amarok --debug" I have a lot of these errors:
[ERROR!] Tried to perform query on uninitialized MySQLe

Seems that MySQLe is not correctly packaged.
Comment 3 kevin vandeventer 2009-08-09 23:39:58 UTC
I have this experience also. Mine says Local Collection-counting. If I right click on Local Collection, nothing happens when I click on any of the choices in the contextual menu. 

Also, the cover manager shows nothing. If I right click on the cd icon of a song in my playlist, there is no Fetch Album Art option.
Comment 4 Alex Breidenbroich 2009-08-17 11:54:23 UTC
Same here with latest factory. When trying to scan through the files, i get lots of:

amarok:    [ERROR!] Tried to perform escape() on uninitialized MySQLe                                                    
amarok:    [ERROR!] Tried to perform insert on uninitialized MySQLe                                                      
amarok:    [ERROR!] Tried to perform query on uninitialized MySQLe 

(I deleted all amarok files in my .kde4 dir first, if this helps in any way...)
Comment 5 Alex Breidenbroich 2009-08-17 12:43:51 UTC
(Maybe) related bug from bugs.kde.org:

https://bugs.kde.org/show_bug.cgi?id=199429

Deleting the package libqt4-sql-mysql, as mentioned in the linked page in the bug report doesn't help, just to note that down...
Comment 6 Stephan Binner 2009-08-18 21:44:27 UTC
*** Bug 530562 has been marked as a duplicate of this bug. ***
Comment 7 Stephan Binner 2009-08-19 06:58:24 UTC
This seems to be caused by the upgrade to MySQL 5.1 (building Amarok on 11.1 against it breaks too). Any idea what could cause it Michal? Is the embedded server still built with innodb support</randomguess>?
Comment 8 Stephan Binner 2009-08-19 07:09:59 UTC
And is it correct that bug 420313 has reappeared/fix was reverted?
Comment 9 Stephan Binner 2009-08-24 10:06:10 UTC
Tried a mysql 5.1.37 update and brought no improvement. :-(
Comment 10 Wim De Meester 2009-08-24 15:28:54 UTC
I have the same problem... Are there already work arounds for this bug?
Comment 11 Stephan Binner 2009-08-25 14:54:01 UTC
*** Bug 534063 has been marked as a duplicate of this bug. ***
Comment 12 Stephan Binner 2009-08-25 21:25:51 UTC
Re work-around, you can use the amarok rpm built against older mysql from http://download.opensuse.org/repositories/home:/Beineri:/amarok-mysql50/openSUSE_Factory/
Comment 13 Michal Hrusecky 2009-08-27 09:10:38 UTC
My finding so far:
- Bug 420313 has reappeared, fix sent to the Factory (sr#18952), but this fix doesn't solve this issue...
- I believe that the real problem was incompatible errmsg file and other options passed to the embedded MySQL.

I thought about few solutions:
1) Depend on MySQL package and don't ship errmsg file - I think this is not a good idea
2) Split errmsg files out of MySQL creating new package on which packages like Amarok can depend
   - advantage: translations of error messages
   - advantage: save a space a little bit
   - disadvantage: adding buildservice repository with newer MySQL can break Amarok again
   - disadvantage: not sure if it isn't too late for this
3) Use always up to date errmsg file (sr#18953)
   - advatages and disadvantages corresponds to the previous one, just inverted
Comment 14 Stephan Binner 2009-08-27 12:23:06 UTC
Great finding, would have never considered errmsg file incompatibity as reason. :-(

Accepted 3), tweaked to continue to build for older distros and submitted for Factory.
Comment 15 Tim Fechtner 2009-09-14 07:43:26 UTC
Working fine in M7