fehlow Posted January 13, 2017 Report Share Posted January 13, 2017 Hello, 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 Clemens 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. Quote Link to comment Share on other sites More sharing options...
Uwe Posted January 14, 2017 Report Share Posted January 14, 2017 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 Quote Link to comment Share on other sites More sharing options...
Murat Posted January 14, 2017 Report Share Posted January 14, 2017 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). Quote Link to comment Share on other sites More sharing options...
fehlow Posted January 15, 2017 Author Report Share Posted January 15, 2017 Thanks a lot for your answers. The automatic backup saved it for me this time. As none of the new features of current update are essential for me I decided staying with version 4.5. Regards,Clemens Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.