This forum has been archived. All content is frozen. Please use KDE Discuss instead.

I get "Failed: No tracks were imported" when trying to import from 1.4 MySQL db

Tags: None
(comma "," separated)
motin
Registered Member
Posts
5
Karma
0
After searching all over for the Tools -> Import feature from Beta 3+, I finally found it in Configure Amarok -> Settings -> Import collection.

Attempting to import from my 1.4 collection (in MySQL), however just returns "Failed: No tracks were imported".

I ran amarok --debug and got this output during the procedure:

Code: Select all
amarok: BEGIN: void DatabaseImporterDialog::pageChanged(KPageWidgetItem*, KPageWidgetItem*)
amarok: BEGIN: void DatabaseImporterDialog::selectImporter()
Object::connect: No such signal DatabaseImporter::importFinished() in /build/buildd/amarok-2.0.1.1mysql5.1.30/amarok-2.0.1.1/src/databaseimporter/DatabaseImporter.cpp:36
amarok: END__: void DatabaseImporterDialog::selectImporter() - Took 0.0046s
amarok: END__: void DatabaseImporterDialog::pageChanged(KPageWidgetItem*, KPageWidgetItem*) - Took 0.0051s
amarok: BEGIN: void DatabaseImporterDialog::pageChanged(KPageWidgetItem*, KPageWidgetItem*)
amarok: BEGIN: virtual void DatabaseImporter::startImporting()
amarok: BEGIN: virtual void FastForwardImporter::import()
amarok: BEGIN: virtual void FastForwardWorker::run()
amarok: BEGIN: QSqlDatabase FastForwardWorker::databaseConnection()
amarok: END__: QSqlDatabase FastForwardWorker::databaseConnection() - Took 0.016s
amarok: END__: virtual void FastForwardWorker::run() - Took 0.025s
amarok: END__: virtual void FastForwardImporter::import() - Took 0.034s
amarok: END__: virtual void DatabaseImporter::startImporting() - Took 0.035s
amarok: END__: void DatabaseImporterDialog::pageChanged(KPageWidgetItem*, KPageWidgetItem*) - Took 0.036s
amarok: BEGIN: void FastForwardImporter::finishUp()
amarok: END__: void FastForwardImporter::finishUp() - Took 0.003s
amarok: BEGIN: void ScanManager::startIncrementalScan()
amarok: BEGIN: QStringList ScanManager::getDirsToScan() const
amarok: END__: QStringList ScanManager::getDirsToScan() const - Took 0.11s
amarok:    GOING TO SCAN:
amarok:    Scanning nothing, return.
amarok: END__: void ScanManager::startIncrementalScan() - Took 0.11s


Is this because amarok2 automatically scanned the same collection directories when I started it and since the 1.4 collection has the same directories, it finds nothing to import? In that case, that's a serious bug, as it causes all the metadata not to be imported!

How do I get my precious ratings, score, lyrics info etc imported from 1.4?

EDIT: Btw I have tested the mysql credentials etc and they are correct for sure.

EDIT 2: Tried it again and this time amarok crasched. I have all the debuggin symbols installed but still got a useless backtrace. However I got this in stdout:
Code: Select all
amarok: BEGIN: virtual void FastForwardWorker::run()
amarok: BEGIN: QSqlDatabase FastForwardWorker::databaseConnection()
KCrash: Application 'amarok' crashing...

Last edited by motin on Sun Mar 01, 2009 1:47 pm, edited 1 time in total.
User avatar
markey
KDE Developer
Posts
2286
Karma
3
OS
We have a number of bug reports and known issues with the Importer component. Please see here for a full list of our reports, and then just search for "import":

http://tinyurl.com/amarok2bugs


--
Mark Kretschmann - Amarok Developer
madsepperl
Registered Member
Posts
12
Karma
0
OS
thanks for the url with the bug tracker.

i've had this problem since several months.... replacing "localhost" with "127.0.0.1" in the import sql dialog did the trick for me !

cheers,
chris
kozaki
Registered Member
Posts
1
Karma
0
Same issue in this location.
Following was accomplished with 'localhost' as the host name. Whenever i put 127.0.0.1 or system's uname, amarok importer simply 'can't connect to the DB'.

All is going well after i deleted old ~/.kde4 (maybe ~/.kde4/share/apps/amarok is sufficient but i didn't try)
Note: it takes ages as i had hundreds of covers in Amarok 1.4

EDIT : all *was* looking good but issues persist at the end of the import: nothing was imported :-(

Here's the end of the log:
---
QObject::connect: Cannot queue arguments of type 'KIO::filesize_t'
(Make sure 'KIO::filesize_t' is registered using qRegisterMetaType().)
amarok:    image copy: "ff896679d61cdc04b7e928c56e6cbbb4"  :  "/home/me/.kde/share/apps/amarok/albumcovers/large/ff896679d61cdc04b7e928c56e6cbbb4"
kio_file(31829) FileProtocol::copy: copy():  KUrl("file:///home/me/.kde/share/apps/amarok/albumcovers/large/ff896679d61cdc04b7e928c56e6cbbb4")  ->  KUrl("file:///home/me/.kde4/share/apps/amarok/albumcovers/large/ff896679d61cdc04b7e928c56e6cbbb4") , mode= -1
QObject::connect: Cannot queue arguments of type 'KIO::filesize_t'
(Make sure 'KIO::filesize_t' is registered using qRegisterMetaType().)
QObject::connect: Cannot queue arguments of type 'KIO::filesize_t'
(Make sure 'KIO::filesize_t' is registered using qRegisterMetaType().)
amarok:    image copy: "ffd87ac964cbaea1e89dd7cda0a29f79"  :  "/home/me/.kde/share/apps/amarok/albumcovers/large/ffd87ac964cbaea1e89dd7cda0a29f79"
kio_file(32363) FileProtocol::copy: copy():  KUrl("file:///home/me/.kde/share/apps/amarok/albumcovers/large/ffd87ac964cbaea1e89dd7cda0a29f79")  ->  KUrl("file:///home/me/.kde4/share/apps/amarok/albumcovers/large/ffd87ac964cbaea1e89dd7cda0a29f79") , mode= -1
QObject::connect: Cannot queue arguments of type 'KIO::filesize_t'
(Make sure 'KIO::filesize_t' is registered using qRegisterMetaType().)
QObject::connect: Cannot queue arguments of type 'KIO::filesize_t'
(Make sure 'KIO::filesize_t' is registered using qRegisterMetaType().)
amarok: END__: virtual void FastForwardWorker::run() - Took 6e+02s
amarok: BEGIN: void FastForwardImporter::finishUp()
amarok: END__: void FastForwardImporter::finishUp() - Took 0.12s
amarok: BEGIN: void ScanManager::startIncrementalScan()
amarok: BEGIN: QStringList ScanManager::getDirsToScan() const
amarok: END__: QStringList ScanManager::getDirsToScan() const - Took 0s
amarok:    GOING TO SCAN:
amarok:    Scanning nothing, return.
amarok: END__: void ScanManager::startIncrementalScan() - Took 0s
amarok: BEGIN: void ScanManager::startIncrementalScan()
amarok: BEGIN: QStringList ScanManager::getDirsToScan() const
amarok: END__: QStringList ScanManager::getDirsToScan() const - Took 0s
amarok:    GOING TO SCAN:
amarok:    Scanning nothing, return.
amarok: END__: void ScanManager::startIncrementalScan() - Took 0s
amarok: BEGIN: virtual FastForwardImporter::~FastForwardImporter()
amarok: END__: virtual FastForwardImporter::~FastForwardImporter() - Took 0s
X Error: BadWindow (invalid Window parameter) 3
  Major opcode: 20 (X_GetProperty)
  Resource id:  0x1a0228a
amarok: BEGIN: void ScanManager::startIncrementalScan()
amarok: BEGIN: QStringList ScanManager::getDirsToScan() const
amarok: END__: QStringList ScanManager::getDirsToScan() const - Took 0s
amarok:    GOING TO SCAN:
amarok:    Scanning nothing, return.
amarok: END__: void ScanManager::startIncrementalScan() - Took 0s
---

Last edited by kozaki on Fri Mar 13, 2009 4:49 pm, edited 1 time in total.
w46
Registered Member
Posts
1
Karma
0
Scan all collection and next import from MySQL
User avatar
Dieter Schroeder
Registered Member
Posts
714
Karma
7
OS
Wot?
Have you noticed, that this topic is nearly 4 month old.

m0nk


If men could get pregnant, abortion would be a sacrament.
steff123
Registered Member
Posts
5
Karma
0
OS
Yeah, four month old and this annoying bugger is still around. I WANT MY RATINGS BACK! Give me that import!

Oh well,
Steff
User avatar
Dieter Schroeder
Registered Member
Posts
714
Karma
7
OS
Amarok version?
Have you done an initial scan first and imported afterwards?


If men could get pregnant, abortion would be a sacrament.
steff123
Registered Member
Posts
5
Karma
0
OS
Oh, hello. Shure: The rocker's version is 2.1.1 in KDE 4.2.2 - an up-to-date kubuntu Jaunty.

Usually I'm tracking the bug here http://bugs.kde.org/show_bug.cgi?id=174269 but it seems there is no cure from this pain up to now...

Cheers


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Yahoo [Bot]