Jump to content

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


Recommended Posts

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

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.
Note: Your post will require moderator approval before it will be visible.

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...