Jump to content

Cannot add new pictures


Recommended Posts



I have installed Daminion 5 and opened the catalogue in the new version. Because of no appropriate licence I downgraded to previous version 4.5 (1443). Now I noticed that I cannot add new files to the catalogue (see the error message below). Were there any changes in the database format? Any help is welcome.


Thank you




constraint failed

NOT NULL constraint failed: Files.IsPrimary

bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)

bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)

bei System.Data.SQLite.SQLiteDataReader.NextResult()

bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)

bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)

bei System.Data.SQLite.SQLiteCommand.ExecuteScalar(CommandBehavior behavior)

bei System.Data.SQLite.SQLiteCommand.ExecuteScalar()

bei PicaJet.Daminion.Service.Utils.Mapper.FileMapper.Insert(IDatabaseEnvironment databaseEnvironment, IDbCommand command, FileInfo insertItem) in c:\DaminionAuto\Code\Service.Utils\Mapper\FileMapper.cs:Zeile 109.

bei PicaJet.Daminion.Service.Utils.Mapper.FileMapper.Insert(IDatabaseEnvironment databaseEnvironment, IDbCommand command, Object insertItem) in c:\DaminionAuto\Code\Service.Utils\Mapper\FileMapper.cs:Zeile 197.

bei PicaJet.Daminion.Service.DbCommandHelper.Insert[T](DbConnection connection, IMapper mapper, T obj) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:Zeile 270.

bei PicaJet.Daminion.Service.DbCommandHelper.Insert[T](DbConnection connection, T obj) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:Zeile 263.

bei PicaJet.Daminion.Service.Utils.MediaItemHelper.SaveMediaItemInfo(Int64 sessionId, String filePath, IndexedTagValueHelper indexedTagValueHelper) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\MediaItemHelper.cs:Zeile 161.

bei PicaJet.Daminion.Service.Utils.ImportMediaItemFromFileCommand.Start(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\ImportMediaItemFromFileCommand.cs:Zeile 56.

Link to comment
Share on other sites

Hello Clemens,

yes there are changes in the database between 4.5 and 5.0 because of the the new functions. If you go back to 4.5 you have to restore the backup of the catalog you hopefully made with version 4.5.

But I don't know if this error belongs to the changes of the database between 4.5 and 5.0

Regards, Uwe

Link to comment
Share on other sites

Uwe is right - Daminion 4.5 version doesn't work properly with Daminion 5.0 catalogs, thus we do automatic backups before upgrading them.


You can prolong your maintenance here and upgrade to any Daminion release up to Jan 2018 or downgrade your catalog to 4.5 or 4.6 and restore your catalog from automatic backup file (by renaming it).

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...