Local Collection Not Building Right
Maximilian Kossick
maximilian.kossick at googlemail.com
Sun Jul 6 13:35:18 CEST 2008
It looks like you haven't deleted your collection.db after Seb made
the changes to the album art handling in SqlCollection. Please check
if the errors still ocur with a clen collection.db
On Sun, Jul 6, 2008 at 9:05 AM, Alejandro Wainzinger
<aikawarazuni at gmail.com> wrote:
> For a few weeks now, my rescan of the local collection has given me
> only "Various Artists," and an empty "Unknown" album within it. Often
> it reaches about 70'ish percent on the bar, and then stops. I don't
> think I have any problematic files, as Amarok 1.4 handles this scan
> perfectly. Here's the debug output:
>
> amarok: BEGIN: void ScanManager::startFullScan()
> amarok(11071) KDE::ProgressBar::ProgressBar: " "
> amarok: p before: QPoint(0,-18)
> amarok: p after: QPoint(0,951)
> amarok: END__: void ScanManager::startFullScan() - Took 0.098s
> amarok: BEGIN: virtual void XmlParseJob::run()
> amarok: BEGIN: ScanResultProcessor::ScanResultProcessor(SqlCollection*)
> amarok: END__: ScanResultProcessor::ScanResultProcessor(SqlCollection*)
> - Took 0.00012s
> amarok: BEGIN: void DatabaseUpdater::createTemporaryTables()
> amarok: END__: void DatabaseUpdater::createTemporaryTables() - Took 0.27s
> amarok: BEGIN: void ScanManager::slotFinished()
> amarok: END__: void ScanManager::slotFinished() - Took 0.0001s
> amarok: [ERROR!] sqlite3_compile error:
> amarok: [ERROR!] no such table: images
> amarok: [ERROR!] on query: "DELETE FROM images;"
> amarok: BEGIN: void DatabaseUpdater::copyToPermanentTables()
> amarok: [ERROR!] sqlite3_compile error:
> amarok: [ERROR!] no such table: images
> amarok: [ERROR!] on query: "DELETE FROM images;"
> amarok: [ERROR!] sqlite3_compile error:
> amarok: [ERROR!] no such table: images
> amarok: [ERROR!] on insert: "INSERT INTO images SELECT * FROM
> images_temp;"
> amarok: [ERROR!] sqlite3_compile error:
> amarok: [ERROR!] table albums has 3 columns but 4 values were supplied
> amarok: [ERROR!] on insert: "INSERT INTO albums SELECT * FROM
> albums_temp WHERE albums_temp.id NOT IN ( -1 );"
> amarok: END__: void DatabaseUpdater::copyToPermanentTables() - Took 0.073s
> amarok: BEGIN: void DatabaseUpdater::removeTemporaryTables()
> amarok: END__: void DatabaseUpdater::removeTemporaryTables() - Took 0.015s
> amarok: BEGIN: ScanResultProcessor::~ScanResultProcessor()
> amarok: END__: ScanResultProcessor::~ScanResultProcessor() - Took 4e-05s
> amarok: END__: virtual void XmlParseJob::run() - Took 8.3s
> amarok: BEGIN: void Dynamic::BiasedPlaylist::startSolver()
> amarok: END__: void Dynamic::BiasedPlaylist::startSolver() - Took 8.9e-05s
> amarok: BEGIN: void CollectionTreeItemModel::update()
> amarok: thread starting up
> amarok: END__: void CollectionTreeItemModel::update() - Took 0.0025s
> amarok: BEGIN: void Dynamic::BiasedPlaylist::startSolver()
> amarok: END__: void Dynamic::BiasedPlaylist::startSolver() - Took 6.2e-05s
> amarok: BEGIN: void CollectionTreeItemModel::update()
> amarok: Calling runQuery()
> amarok: END__: void CollectionTreeItemModel::update() - Took 0.00061s
> amarok(11071) KDE::ProgressBar::~ProgressBar: ""
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 100 , 0.48 , 2.03704e-11 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 200 , 0.46 , 4.14952e-21 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 300 , 0.45 , 8.45271e-31 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 400 , 0.44 , 1.72185e-40 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 500 , 0.41 , 3.50747e-50 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 600 , 0.39 , 7.14483e-60 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 700 , 0.38 , 1.45543e-69 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 800 , 0.36 , 2.96476e-79 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 900 , 0.34 , 6.03932e-89 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 1000 , 0.34 , 1.23023e-98 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 1100 , 0.33 , 2.50603e-108 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 1200 , 0.29 , 5.10487e-118 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 1300 , 0.28 , 1.03988e-127 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 1400 , 0.27 , 2.11827e-137 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 1500 , 0.27 , 4.315e-147 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 1600 , 0.26 , 8.7898e-157 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 1700 , 0.25 , 1.79051e-166 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 1800 , 0.23 , 3.64734e-176 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 1900 , 0.2 , 7.42977e-186 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 2000 , 0.2 , 1.51347e-195 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 2100 , 0.2 , 3.08299e-205 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 2200 , 0.19 , 6.28017e-215 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 2300 , 0.18 , 1.27929e-224 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 2400 , 0.17 , 2.60597e-234 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 2500 , 0.14 , 5.30845e-244 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 2600 , 0.13 , 1.08135e-253 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 2700 , 0.13 , 2.20275e-263 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 2800 , 0.13 , 4.48708e-273 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 2900 , 0.12 , 9.14034e-283 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 3000 , 0.11 , 1.86192e-292 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 3100 , 0.11 , 3.7928e-302 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 3200 , 0.1 , 7.72607e-312 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 3300 , 0.09 , 1.57113e-321 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 3400 , 0.07 , 9.88131e-324 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 3500 , 0.07 , 9.88131e-324 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 3600 , 0.06 , 9.88131e-324 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 3700 , 0.06 , 9.88131e-324 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 3800 , 0.06 , 9.88131e-324 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 3900 , 0.04 , 9.88131e-324 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 4000 , 0.03 , 9.88131e-324 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 4100 , 0.02 , 9.88131e-324 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 4200 , 0.02 , 9.88131e-324 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: BiasSolver: (i, E, T) = ( 4300 , 0.01 , 9.88131e-324 )
> amarok: thread starting up
> amarok: Calling runQuery()
> amarok: [ERROR!] sqlite3_compile error:
> amarok: [ERROR!] no such table: images
> amarok: [ERROR!] on query: "SELECT path FROM images, albums WHERE
> albums.image = images.id AND albums.id = 0;"
> _______________________________________________
> Amarok-devel mailing list
> Amarok-devel at kde.org
> https://mail.kde.org/mailman/listinfo/amarok-devel
>
More information about the Amarok-devel
mailing list