Bug#312386: amarok: SQLite empty
Package: amarok Version: 1.2.4-1 Followup-For: Bug #312386 I just reinstalled my computer and when i try to build the collection using sqlite the scan don't show any errors but no collection is created, collection.db it's created but empty. I haven't try with MySQL. [EMAIL PROTECTED]:~/.kde/share/apps/amarok$ sqlite3 collection.db SQLite version 3.2.5 Enter ".help" for instructions sqlite> .tables albumgenrestatistics artist images tags directories related_artists year sqlite> select * from artist; sqlite> select * from album; sqlite> -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable'), (1, 'experimental') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.8-2-686 Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15) Versions of packages amarok depends on: ii amarok-arts [amarok-engin 1.2.4-1aRts engine for the amaroK audio p ii amarok-engines1.2.4-1output engines for the amaroK audi ii amarok-gstreamer [amarok- 1.2.4-1GStreamer engine for the amaroK au ii amarok-xine [amarok-engin 1.2.4-1xine engine for the amaroK audio p ii kdelibs4 4:3.4.1-1 core libraries for all KDE applica ii libaudio2 1.7-2 The Network Audio System (NAS). (s ii libc6 2.3.5-6GNU C Library: Shared libraries an ii libfontconfig12.3.2-1generic font configuration library ii libfreetype6 2.1.10-1 FreeType 2 font engine, shared lib ii libgcc1 1:4.0.1-6 GCC support library ii libice6 6.8.2.dfsg.1-5 Inter-Client Exchange library ii libmysqlclient12 4.0.24-10 mysql database client library ii libpng12-01.2.8rel-1 PNG library - runtime ii libqt3c102-mt 3:3.3.4-3 Qt GUI Library (Threaded runtime v ii libsm66.8.2.dfsg.1-5 X Window System Session Management ii libsqlite3-0 3.2.5-1SQLite 3 shared library ii libstdc++51:3.3.6-9 The GNU Standard C++ Library v3 ii libtag1 1.3.1-1TagLib Audio Meta-Data Library ii libtunepimp2 0.3.0-4MusicBrainz tagging library and si ii libx11-6 6.8.2.dfsg.1-5 X Window System protocol client li ii libxcursor1 1.1.3-1X cursor management library ii libxext6 6.8.2.dfsg.1-5 X Window System miscellaneous exte ii libxft2 2.1.7-1FreeType-based font drawing librar ii libxrandr26.8.2.dfsg.1-5 X Window System Resize, Rotate and ii libxrender1 1:0.9.0-2 X Rendering Extension client libra ii libxt66.8.2.dfsg.1-5 X Toolkit Intrinsics ii xlibmesa-gl [libgl1] 6.8.2.dfsg.1-5 Mesa 3D graphics library [X.Org] ii xlibs 6.8.2.dfsg.1-5 X Window System client libraries m ii zlib1g1:1.2.3-4 compression library - runtime Versions of packages amarok recommends: ii kdemultimedia-kio-plugins 4:3.4.1-1 enables the browsing of audio CDs -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#312386: amarok: SQLite empty
Compiling amarok with included sqlite solves this problem. That's the easiest fix I could find. I guess there are some incompatibilities between the sqlite version shipped with debian and the one amarok expects. -- E-Mail: [EMAIL PROTECTED] WWW: http://www.teco.edu/ TecO (Telecooperation Office) Vincenz-Priessnitz-Str.1 University of Karlsruhe 76131 Karlsruhe, Germany signature.asc Description: OpenPGP digital signature
Bug#312386: amarok: SQLite empty
* Michael Biebl [Sun, 04 Sep 2005 01:25:12 +0200]: > Compiling amarok with included sqlite solves this problem. That's the > easiest fix I could find. I guess there are some incompatibilities > between the sqlite version shipped with debian and the one amarok expects. What about amarok 1.3.0-1 in sid? Does it suffer the problem? Thanks, -- Adeodato Simó EM: asp16 [ykwim] alu.ua.es | PK: DA6AE621 If you think nobody cares if you're alive, try missing a couple of car payments. -- Earl Wilson -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#312386: amarok: SQLite empty
Adeodato Simó schrieb: > * Michael Biebl [Sun, 04 Sep 2005 01:25:12 +0200]: > > >>Compiling amarok with included sqlite solves this problem. That's the >>easiest fix I could find. I guess there are some incompatibilities >>between the sqlite version shipped with debian and the one amarok expects. > > > What about amarok 1.3.0-1 in sid? Does it suffer the problem? Unfortunately yes, 1.3.0-1 is still affected by this problem. In order to get amarok working again I grabbed the source and removed "--without-included-sqlite" from debian/rules. I haven't tested yet but I think libsqlite3-dev in debian/control could then be dropped too. This makes the binary approx. 200kb bigger but in return it makes amarok work reliably. Cheers, Michael -- E-Mail: [EMAIL PROTECTED] WWW: http://www.teco.edu/ TecO (Telecooperation Office) Vincenz-Priessnitz-Str.1 University of Karlsruhe 76131 Karlsruhe, Germany signature.asc Description: OpenPGP digital signature
Bug#312386: amarok: SQLite empty
> What about amarok 1.3.0-1 in sid? Does it suffer the problem? Seems to suffer. I just upgraded to 1.3.0-1, and now amaroK seems to scan my collection (collection_scan.log doesn't have any errors), then just shows the "Hello amaroK user!" context sidebar with the "Build Collection..." button. Nothing helps, the collection always stays empty. It doesn't seem to have touched the "statistics" table though. What kind of weird sqlite mod does amarok use, anyway? =/ -- [Urpo Lankinen] [aka. Weyfour olf, Just another lupine technomancer] [EMAIL PROTECTED] http://www.iki.fi/olf/> -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
