Digikam 5.3.0-01 database migration: Out of Range value for column 'fileSize'

[Brian J Hoskins]

I solved the problem below by changing the variable type for 'fileSize'
in the images table to BigInt.  But then it got to 99% and complained
about a file /name/ of some description.  It would be useful if the
migration tool offered the name of the offending file in the error dialogue.


On 14/11/16 20:37, Brian J Hoskins wrote:
> Hello digiKam users.
>
> I am trying out version 5.3 of digiKam for the first time, using the
> Application Bundle.  Previously I have used version 4.12 and I have an
> existing SQLite database.
>
> When trying to migrate the database I get to around 30% completion when
> the following error is reported:
>
> "Error while converting the database.
> Details: Out of range value for column 'fileSize' at row 1"
>
> I have quite a few video files in the database, and I wonder if one of
> these is larger than the database was expecting.
>
> Unfortunately the migration tool gives up at this point, so I am not
> able to get more information about the problem or even skip and continue.
>
> Does anyone have useful advice to offer here?
>
> Many thanks,
>
> Brian.
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20161114/4881eec8/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20161114/4881eec8/attachment.sig>