Local Collection Not Building Right
Alejandro Wainzinger
aikawarazuni at gmail.com
Sun Jul 6 20:40:48 CEST 2008
Yeah, looks like that was it. Thanks.
On Sun, Jul 6, 2008 at 4:35 AM, Maximilian Kossick
<maximilian.kossick at googlemail.com> wrote:
> 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
>>
> _______________________________________________
> 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