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

Doesnt scan collection

Tags: None
(comma "," separated)
hookum
Registered Member
Posts
3
Karma
0

Doesnt scan collection

Mon Sep 08, 2008 4:10 am
I installed Amarok 2 SVN from a Gentoo overlay. It works fine (aside from crashing every once in a while). However, it won't scan my collection. When I click "Rescan Collection" in the Tools menu, the status bar shows "Scanning music..." and a progress bar at 0% for about 15 seconds, then disappears. Nothing is added to the collection.

This is what appears in the console when rescan is selected:

Code: Select all
amarok: BEGIN: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*)
amarok:      p before:  QPoint(2,-15)
amarok:      p after:  QPoint(170,831)
amarok: BEGIN: KDE::ProgressBar& KDE::ProgressBar::setAbortSlot(QObject*, const char*)
amarok: END__: KDE::ProgressBar& KDE::ProgressBar::setAbortSlot(QObject*, const char*)- Took 0.00011s
amarok: END__: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*) - Took 0.0012s
amarok: BEGIN: virtual void XmlParseJob::run()
amarok: BEGIN: ScanResultProcessor::ScanResultProcessor(SqlCollection*)
amarok: END__: ScanResultProcessor::ScanResultProcessor(SqlCollection*) - Took 1.7e-05s
amarok: END__: void ScanManager::startFullScan() - Took 0.038s
QGArray::find: Index 0 out of range
amarok: BEGIN: void DatabaseUpdater::createTemporaryTables()
amarok: END__: void DatabaseUpdater::createTemporaryTables() - Took 0.011s
amarok:    [ERROR!]  sqlite3_compile error:
amarok:    [ERROR!] table directories_temp has 4 columns but 3 values were supplied
amarok:    [ERROR!] on query:  "INSERT INTO directories_temp SELECT * FROM directories;"
QDom: saving invalid character , the document will not be well-formed
amarok:    [WARNING!] NOT-IMPLEMENTED:  int ScanResultProcessor::checkExistingAlbums(const QString&)


Any help resolving this would be greatly appreciated.
User avatar
markey
KDE Developer
Posts
2286
Karma
3
OS

Re: Doesnt scan collection

Mon Sep 08, 2008 7:02 am
You need to nuke your collection.db. The database schema was changed shortly before beta1 release.


--
Mark Kretschmann - Amarok Developer
hookum
Registered Member
Posts
3
Karma
0

Re: Doesnt scan collection

Mon Sep 08, 2008 5:11 pm
Already did that. I deleted the entire ~/.kde/share/apps/amarok/ directory, plus all amarok files in ~/.kde/share/config/

Same thing. I'll try it again however, and see if the third time's a charm.

I also have vers. 1.4.9 installed. When A2 starts up, it displays the 1.4 splash screen. Not sure if this matters, but thought I would include it just in case.

Last edited by hookum on Mon Sep 08, 2008 5:18 pm, edited 1 time in total.
hookum
Registered Member
Posts
3
Karma
0

Re: Doesnt scan collection

Mon Sep 08, 2008 8:21 pm
OK, I uninstalled all versions of Amarok, and re-installed A2. Now it displays the proper splash on startup. When it scans the collection, now the progress bar and status message remain, but the progress bar never moves, nothing gets added to the Local Collection. Now the errors while scanning are:

Code: Select all
BEGIN: virtual void UrlUpdateJob::run()
amarok:      [ERROR!]  sqlite3_compile error:
amarok:      [ERROR!] no such table: tags
amarok:      [ERROR!] on query:  "SELECT s.deviceid,s.url FROM statistics AS s LEFT JOIN tags AS t ON s.deviceid = t.deviceid AND s.url = t.url WHERE t.url IS NULL AND s.deviceid != -2;"
amarok:     [MountPointManager] Trying to update  0  statistics rows
amarok:      [ERROR!]  sqlite3_compile error:
amarok:      [ERROR!] no such table: tags_labels
amarok:      [ERROR!] on query:  "SELECT l.deviceid,l.url FROM tags_labels AS l LEFT JOIN tags as t ON l.deviceid = t.deviceid AND l.url = t.url WHERE t.url IS NULL;"
amarok:     [MountPointManager] Trying to update  0  tags_labels rows
amarok: END__: virtual void UrlUpdateJob::run() - Took 0.00023s


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], kde-naveen, Sogou [Bot], Yahoo [Bot]