SQLite error no such column: S.BlocksetID

ts678 · December 29, 2020, 2:18am

Welcome to the forum @Freemann

When is it seen? Did 2.0.5.107 work?

SQLite Error No Such Column S.BlocksetID has more descriptions, except version history isn’t said.

Maybe the message is from last line below. Code was changed for 2.0.5.111, and I’m asking about it.

duplicati/duplicati/blob/45c4f865e8b5c2e79c96628383d8dca4cdc5317d/Duplicati/Library/Main/Database/LocalRestoreDatabase.cs#L1242-L1247


      
          public IEnumerable<IFastSource> GetFilesAndSourceBlocksFast(long blocksize)

          {

              var latestBlockTable = "LatestBlocksetIds-" + m_temptabsetguid;

              var whereclause = string.Format(@" ""{0}"".""ID"" = ""{1}"".""FileID"" AND ""{1}"".""Restored"" = 0 AND ""{1}"".""Metadata"" = 0 AND ""{0}"".""TargetPath"" != ""{0}"".""Path"" ", m_tempfiletable, m_tempblocktable);        

              var sourcePaths = string.Format(@"SELECT DISTINCT ""{0}"".""Path"" FROM ""{0}"", ""{1}"" WHERE " + whereclause, m_tempfiletable, m_tempblocktable);

              var sources = string.Format(@"SELECT DISTINCT ""{0}"".""TargetPath"", ""{0}"".""Path"", ""{0}"".""ID"", ""{1}"".""Index"", ""{1}"".""Hash"", ""{1}"".""Size"" FROM ""{0}"", ""{1}"", ""{2}"" S, ""Block"", ""BlocksetEntry"" WHERE ""BlocksetEntry"".""BlocksetID"" = ""S"".""BlocksetID"" AND ""BlocksetEntry"".""BlockID"" = ""Block"".""ID"" AND ""{1}"".""Hash"" = ""Block"".""Hash"" AND ""{1}"".""Size"" = ""Block"".""Size"" AND ""S"".""Path"" = ""{0}"".""Path"" AND ""{1}"".""Index"" = ""BlocksetEntry"".""Index"" AND " + whereclause + @" ORDER BY ""{0}"".""ID"", ""{1}"".""Index"" ", m_tempfiletable, m_tempblocktable, latestBlockTable);