# What does it mean to report a duplicate path

**URL:** <https://forum.duplicati.com/t/what-does-it-mean-to-report-a-duplicate-path/1997>\
**Category:** Uncategorized\
**Created:** [January 6, 2018, 12:23pm UTC](https://forum.duplicati.com/t/what-does-it-mean-to-report-a-duplicate-path/1997 "2018-01-06T12:23:06Z")\
**Posts on this page:** 1\
**Showing post:** 16

<div class="post-metadata">

**Author:** ![gianlucabertaina](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/g/22d042/32.png) [@gianlucabertaina](https://forum.duplicati.com/u/gianlucabertaina)\
**Post date:** [December 3, 2018, 1:24pm UTC](https://forum.duplicati.com/t/what-does-it-mean-to-report-a-duplicate-path/1997/16 "2018-12-03T13:24:13Z")

</div>

> [@JonMikelV](#):
>
> SELECT ““G””.““BlocksetID””, ““G””.““ID””, ““G””.““Path””, ““G””.““Length””, ““G””.““FullHash””, ““G””.““Lastmodified””, ““G””.““FirstMetaBlockHash””, ““H””.““Hash”” AS ““MetablocklistHash”” FROM ( SELECT ““B””.““BlocksetID””, ““B””.““ID””, ““B””.““Path””, ““D””.““Length””, ““D””.““FullHash””, ““A””.““Lastmodified””, ““F””.““Hash”” AS ““FirstMetaBlockHash””, ““C””.““BlocksetID”” AS ““MetaBlocksetID”” FROM ““FilesetEntry”” A, ““File”” B, ““Metadataset”” C, ““Blockset”” D, ““BlocksetEntry”” E, ““Block”” F WHERE ““A””.““FileID”” = ““B””.““ID”” AND ““B””.““MetadataID”” = ““C””.““ID”” AND ““C””.““BlocksetID”” = ““D””.““ID”” AND ““E””.““BlocksetID”” = ““C””.““BlocksetID”” AND ““E””.““BlockID”” = ““F””.““ID”” AND ““E””.““Index”” = 0 AND (““B””.““BlocksetID”” = ? OR ““B””.““BlocksetID”” = ?) AND ““A””.““FilesetID”” = ? ) G LEFT OUTER JOIN ““BlocklistHash”” H ON ““H””.““BlocksetID”” = ““G””.““MetaBlocksetID”” ORDER BY ““G””.““Path””, ““H””.““Index””

Thank you. I used sqlitebrowser on my duplicati backup database. I had to substitute “” with " in your script. The result is however

```plaintext
0 Rows returned

```

---

_[View the full topic](https://forum.duplicati.com/t/what-does-it-mean-to-report-a-duplicate-path/1997)._