Registered Member
|
I have just upgraded to Amarok 2 (1.92.2) and my collection is empty. I choose the directories and Amarok will begin scanning them. The log (.kde4/share/apps/amarok/collection_scan.log) shows it goes through the entire collection. It stops at the last (alphabetically) file, so everything seems fine. Nevertheless, "local collection" is empty
I'm using Kubuntu and KDE 4.1.2. Linux 2.6.24-21-generic #1 SMP Mon Aug 25 17:32:09 UTC 2008 i686 GNU/Linux . |
Registered Member
|
I have the same problem: scanning goes well and the logfile contains everything that should be there.
However the local collection is empty (and ~/.kde4/share/apps/amarok/mysqle/ is empty). I compiled from svn just a couple of minutes ago, and everything went fine. This is on OpenSuse 11.0 |
KDE Developer
|
Ok let's first get this out out of way:
Collection scanning has received heavy attention lately in SVN. There were many changes and fixes, so that experience from older versions becomes irrelevant. Regarding @spectral, since he's a SVN user I'm interested in the case. Could you please start amarok with the -d argument (for debug) and post a full debug log here?
--
Mark Kretschmann - Amarok Developer |
Registered Member
|
my log looks something like this:
amarok: Selected collection folders: ("/windows/D/Mp3/test") amarok: BEGIN: QStringList MountPointManager::collectionFolders() amarok: END__: QStringList MountPointManager::collectionFolders() - Took 0.00031s amarok: MountPointManager collection folders: ("/windows/D/Mp3/test") amarok: BEGIN: void ScanManager::startFullScan() amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: BEGIN: QStringList MountPointManager::collectionFolders() amarok: END__: QStringList MountPointManager::collectionFolders() - Took 0.00047s amarok: BEGIN: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*) amarok: BEGIN: void ProgressBarNG::setDescription(const QString&) amarok: END__: void ProgressBarNG::setDescription(const QString&) - Took 0.0063s amarok: BEGIN: void CompoundProgressBar::addProgressBar(ProgressBarNG*, QObject*) amarok: setting fixed height: 27 * 1 = 31 amarok: p before: QPoint(2,-32) amarok: p after: QPoint(4,925) amarok: we now have 1 progress ops running amarok: BEGIN: void ProgressBarNG::setDescription(const QString&) amarok: END__: void ProgressBarNG::setDescription(const QString&) - Took 0.00027s amarok: END__: void CompoundProgressBar::addProgressBar(ProgressBarNG*, QObject*) - Took 0.0025s amarok: BEGIN: ProgressBarNG* ProgressBarNG::setAbortSlot(QObject*, const char*) amarok: Setting abort slot for "Scanning music" amarok: connecting to 1deleteLater() amarok: END__: ProgressBarNG* ProgressBarNG::setAbortSlot(QObject*, const char*) - Took 0.00077s amarok: END__: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*) - Took 0.012s amarok: BEGIN: virtual void XmlParseJob::run() amarok: BEGIN: ScanResultProcessor::ScanResultProcessor(SqlCollection*) amarok: END__: ScanResultProcessor::ScanResultProcessor(SqlCollection*) - Took 6.9e-05s amarok: END__: void ScanManager::startFullScan() - Took 0.037s amarok: END__: void CollectionSetup::writeConfig() - Took 0.043s amarok: BEGIN: virtual bool Amarok2ConfigDialog::hasChanged() amarok: BEGIN: virtual bool CollectionConfig::hasChanged() amarok: BEGIN: bool CollectionSetup::hasChanged() const amarok: BEGIN: QStringList MountPointManager::collectionFolders() amarok: END__: QStringList MountPointManager::collectionFolders() - Took 0.00028s amarok: END__: bool CollectionSetup::hasChanged() const - Took 0.00076s amarok: END__: virtual bool CollectionConfig::hasChanged() - Took 0.0011s amarok: BEGIN: virtual bool ServiceConfig::hasChanged() amarok: END__: virtual bool ServiceConfig::hasChanged() - Took 0.003s amarok: END__: virtual bool Amarok2ConfigDialog::hasChanged() - Took 0.0049s amarok: BEGIN: void DatabaseUpdater::createTemporaryTables() amarok: Initialized thread, count== 5 amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: END__: void DatabaseUpdater::createTemporaryTables() - Took 0.001s amarok: [ERROR!] Tried to perform query on uninitialized MySQLe TagLib: MPEG::Header::parse() -- Invalid sample rate. TagLib: MPEG::Header::parse() -- Invalid sample rate. TagLib: MPEG::Header::parse() -- Invalid sample rate. TagLib: MPEG::Header::parse() -- Invalid sample rate. amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: [ERROR!] Tried to perform insert on uninitialized MySQLe amarok: BEGIN: void ScanManager::slotFinished() amarok: END__: void ScanManager::slotFinished() - Took 0.00021s amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: BEGIN: void DatabaseUpdater::copyToPermanentTables() amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: END__: void DatabaseUpdater::copyToPermanentTables() - Took 0.00083s amarok: BEGIN: void DatabaseUpdater::removeTemporaryTables() amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: [ERROR!] Tried to perform query on uninitialized MySQLe amarok: END__: void DatabaseUpdater::removeTemporaryTables() - Took 0.0003s amarok: Sending changed signal amarok: BEGIN: virtual ScanResultProcessor::~ScanResultProcessor() amarok: END__: virtual ScanResultProcessor::~ScanResultProcessor() - Took 5.2e-05s amarok: END__: virtual void XmlParseJob::run() - Took 0.77s amarok: BEGIN: void SqlCollection::updateTrackUrls(TrackUrls) amarok: END__: void SqlCollection::updateTrackUrls(TrackUrls) - Took 0.00019s amarok: BEGIN: virtual XmlParseJob::~XmlParseJob() amarok: BEGIN: void CompoundProgressBar::childBarComplete(ProgressBarNG*) amarok: p before: QPoint(2,-9) amarok: p after: QPoint(4,948) amarok: BEGIN: void ProgressBarNG::setDescription(const QString&) amarok: END__: void ProgressBarNG::setDescription(const QString&) - Took 9.5e-05s amarok: BEGIN: void StatusBar::hideProgress() amarok: END__: void StatusBar::hideProgress() - Took 0.001s amarok: END__: void CompoundProgressBar::childBarComplete(ProgressBarNG*) - Took 0.0017s amarok: END__: virtual XmlParseJob::~XmlParseJob() - Took 0.0035s as it seems there is no database created (also indicated by the empty mysqle dir), but why this is.. no idea. any ideas? and in case you wanted, here is the whole output when amarok starts: http://pastebin.com/m82f1024
Last edited by spectral on Sun Nov 23, 2008 3:02 pm, edited 1 time in total.
|
KDE Developer
|
This is your problem:
"amarok: [ERROR!] Tried to perform query on uninitialized MySQLe" It's not the scanning itself, but your MySQL Embedded. Read up here: http://amarok.kde.org/wiki/Development/MySQL_Embedded
--
Mark Kretschmann - Amarok Developer |
Registered Member
|
Yes that's what i thought, but it's weird that it does indeed compile and everything. On the wiki page it says to install libmysqlclient-devel for OpenSuse 11, but the only version I can find in the repos is 5.0.51 (and someone provided a 5.1.29 package via buildservice, but that doesn't work according to the wiki). I will try again to build against the suse rpm, if that doesn't work i suppose I will have to compile it from source..
EDIT: After removing the silly 5.1.29 package I had apparently installed everything now works. Thanks.
Last edited by spectral on Mon Nov 24, 2008 9:48 am, edited 1 time in total.
|
Registered Member
|
I am experiencing the same problem described here. Amarok scans my directories but does not add anything to the collection. It can load and play the files. The log has the same error described here ([ERROR!] Tried to perform query on uninitialized MySQLe). I am running on OpenSuse 11.1. I am running Amarok 2.0-1.1. I have MySQL-shared, -embedded, -client and -devel installed, versions 5.1.30. I also have libmysqlclient15, libmysqlclient_r15, libmysqlclient-devel and libqt4-sql-mysql each of which is at 5.0.67. Any suggestions or pointers?
|
KDE Developer
|
Please ask directly on the SUSE forums for this, as it is very likely a packaging mistake on their side. They will likely be able to help you better than we could
--
Mark Kretschmann - Amarok Developer |
Registered Member
|
I have the same problem. Amarok scans my collection, but it never fills the database.
amarok -d revealed:
so the problem is I get one of those errors for every file in my library. I'm running Gentoo on amd64. Amarok 2.0.2 and mysql 5.00.76 |
KDE Developer
|
The same is true for you: Your Amarok is probably using an unsuitable version of MySQL, so please approach your distro (Gentoo) about this. It's not quite easy to package MySQL correctly for Amarok 2, as we are using the relatively new Embedded version. Therefore these problems are still rather common, until the distros have sorted out all the little kinks.
--
Mark Kretschmann - Amarok Developer |
Registered Member
|
well, the problem for me wasn't the unsuitable mysql ebuild (package). The problem with that was patched (http://blogs.gentoo.org/jmbsvicetto/200 ... -and-mysql) (https://bugs.gentoo.org/show_bug.cgi?id=238487)
The problem was solved recompiling amarok with the --as-needed LDFLAG |
Registered Member
|
Hi, I've also Gentoo amd64 and I'm also getting the error messages with "No database found". I tried to recompile with --as-needed LDFLAG but it didn't help and I'm not sure if I did it right. I just run: LDFLAGS="--as-needed" emerge amarok ...but it's not working for me. It also seems to me, that the problem is in mysql-5.0.76. According to your post, you have been getting problems with amarok 2.0.2 and this version of mysql. But amarok 2.0.2 with some older version of mysql (it's probably last stable version .70) worked perfectly for me. But I wanted to upgrade to amarok 2.1 beta and this made me to upgrade mysql to newer version. And since that amarok doesn't work and shows errors with "No database found".
bad english teacher -> bad english -> sorry
|
Registered Member
|
uhhhhhmm, what I compiled with the --as-needed flag wasn't amarok but mysql.
the flags you want are LDFLAGS="-Wl,--as-needed" |
Registered Member
|
Oh yes! Finally it's working again. It was few very bad days without my music
bad english teacher -> bad english -> sorry
|
Registered Member
|
I had the same problem today -- whatever --as-needed does, it helped also to rebuild amarok with the flag (not mysql) - I have a collection again
|
Registered users: Bing [Bot], Google [Bot], Sogou [Bot]