[Digikam-devel] [digikam] [Bug 320466] after a batch process lot of files are missing in preview

[Nathan]

https://bugs.kde.org/show_bug.cgi?id=320466

--- Comment #15 from Nathan <nathan at deckinga.com> ---
(In reply to comment #14)
> I experienced this bug on import of photos and turned on the general log at
> that point.  Deleted and re-imported the files.  The same files were missing
> and it appears that the reason it is always the same files is that the
> insert into ImageInformation uses the previous row as the source for the new
> import.  Would it be possible for import to do it from scratch each time
> instead of trying to be smart about it and failing consistently?
> 
> Line from the log:
> INSERT INTO ImageInformation  (imageid, rating, creationDate,
> digitizationDate, orientation,   width, height, format, colorDepth,
> colorModel) SELECT 224073, rating, creationDate, digitizationDate,
> orientation,   width, height, format, colorDepth, colorModel FROM
> ImageInformation WHERE imageid=224056

(In reply to comment #14)
> I experienced this bug on import of photos and turned on the general log at
> that point.  Deleted and re-imported the files.  The same files were missing
> and it appears that the reason it is always the same files is that the
> insert into ImageInformation uses the previous row as the source for the new
> import.  Would it be possible for import to do it from scratch each time
> instead of trying to be smart about it and failing consistently?
> 
> Line from the log:
> INSERT INTO ImageInformation  (imageid, rating, creationDate,
> digitizationDate, orientation,   width, height, format, colorDepth,
> colorModel) SELECT 224073, rating, creationDate, digitizationDate,
> orientation,   width, height, format, colorDepth, colorModel FROM
> ImageInformation WHERE imageid=224056

I believe the missing row in "ImageInformation" is controlling as the query run
when viewing a gallery joins to that table.  Such as:
SELECT DISTINCT Images.id, Images.name, Images.album,       
ImageInformation.rating, Images.category,        ImageInformation.format,
ImageInformation.creationDate,        Images.modificationDate, Images.fileSize,
       ImageInformation.width, ImageInformation.height  FROM Images       
INNER JOIN ImageInformation ON Images.id=ImageInformation.imageid  WHERE
Images.status=1 AND Images.album = ?


I have yet to capture the initial insertion for the parent file into
ImageInformation for why it failed.

-- 
You are receiving this mail because:
You are the assignee for the bug.