Build 1713 Cannot create new catalog: SQL logic error or missing database no such table: VirtualFolder_Tree

[WilfriedB]

When I try to create a new catalog with Daminion standalone client 5.5 Build 1713, I receive error message "SQL logic error or missing database no such table: VirtualFolder_Tree" for each image and the catalog stays empty.

I did some investigation:

• re-installed build 1679,
• created a new catalog with just a single image,
• installed build 1713 again
• I was able to open the new catalog and add more images

It seems to me that existing catalogs are converted to a new format of the database (additional tables?), while build 1713 does not create new catalogs correctly according to the format ....?

 

Full error message:

 

SQL logic error or missing database
no such table: VirtualFolder_Tree
  at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
  at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
  at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
  at System.Data.SQLite.SQLiteDataReader.NextResult()
  at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
  at PicaJet.Daminion.Service.Utils.UpdateDatabaseVersion9.UpdateHierarchiLinks(String tableName, Int64 id, Int64 parentId, DbConnection connection, UniversalCatalogService service) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\UpdateDatabaseVersion9.cs:line 302
  at PicaJet.Daminion.Service.Utils.IndexedTagValueHelper.SaveOrUpdateByIndexedTagAndValue(IndexedTagInfo indexedTag, IIndexedTagValue tagValue, Int64 siblingId, IMapper mapper, Boolean needSearchExistsValue) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\IndexedTagValueHelper.cs:line 60
  at PicaJet.Daminion.Service.Utils.IndexedTagValueHelper.ProcessHierarchycalIndexedTagValues(IndexedTagInfo indexedTag, ITagItem tagItem, Boolean isApproved) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\IndexedTagValueHelper.cs:line 801
  at PicaJet.Daminion.Service.Utils.MediaItemHelper.UpdateMediaItemsTable(Int64 mediaItemId, String filePath, IndexedTagValueHelper indexedTagValueHelper, Dictionary`2 linearPair, Dictionary`2 linear, List`1 indexed, List`1 indexedCatalogTags) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\MediaItemHelper.cs:line 669
  at PicaJet.Daminion.Service.Utils.MediaItemHelper.SaveMediaItemTags(Int64 mediaItemId, String filePath, IndexedTagValueHelper indexedTagValueHelper) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\MediaItemHelper.cs:line 581
  at PicaJet.Daminion.Service.Utils.MediaItemHelper.SaveMediaItemInfo(Int64 sessionId, String filePath, IndexedTagValueHelper indexedTagValueHelper) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\MediaItemHelper.cs:line 254
  at PicaJet.Daminion.Service.Utils.ImportMediaItemFromFileCommand.Start(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\ImportMediaItemFromFileCommand.cs:line 58

[Alexius]

Hello Wilfried. Yes, I confirm it. Will be fixed soon.

[WilfriedB]

Hello Wilfried. Yes, I confirm it. Will be fixed soon.

Thanks Alexey, it does work with Build 1715 now