[solved]Duplicated files (only one source, double slash path pb)

Help and Support
1

Hi,

I’m using osmc for a while and a couple of weeks ago, all my movies have been duplicated.
I don’t think I have made any config modification.
I tried to delete the unique source I have (/media/SouSou/Movie), all the files disappears; and when I add it again, all the files appears twice again.

I am using a mysql database. When I type select * from files WHERE strFilename LIKE '%anexamplemovie%', all my files appears twice with 2 different strPath. Then I did a select * from path WHERE idPath=xx; : the 2 paths are almost the same, but once with one slash and the other with a double slash.example: /media/SouSou/Movie/anexamplemovie and /media/SouSou/Movie//anexamplemovie

How is this possible?

Thanks in advance!

2

To get a better understanding of the problem you are experiencing we need more information from you. The best way to get this information is for you to upload logs that demonstrate your problem. You can learn more about how to submit a useful support request here.

Thanks for your understanding. We hope that we can help you get up and running again shortly.

3

Hi,

I don’t get what you’d like me to do while saving logs. Do you want me to remove the source with all my movies and add it again to reproduce the scanning (I’ts gonna take a while and the log will be huge). Or just access my movie list?

Thanks

4

Let’s just try accessing the list first.

5

Hi,

Here it is!
http://paste.osmc.tv/urerezeqac

Thanks

6

One possibility is that your themoviedb cache has become corrupted. You’ll find it at ~/.kodi/temp/scrapers/metadata.themoviedb.org

You can either remove it or move it somewhere else and then rescan your movies.

7

Hi, I removed this directory but nothing has changed…
Any other idea?

I removed and added again the source, here is the log if it helps… https://paste.osmc.tv/necadelisi

8

I see that in the first log your sources.xml contains:

    <source>
        <name>Séries</name>
        <path pathversion="1">/media/SouSou/Séries</path>
        <allowsharing>true</allowsharing>
    </source>
    <source>
        <name>Films</name>
        <path pathversion="1">/media/SouSou/Films</path>
        <allowsharing>true</allowsharing>
    </source>

whereas the new log shows:

    <source>
        <name>Séries</name>
        <path pathversion="1">/media/SouSou/Séries/</path>
        <allowsharing>true</allowsharing>
    </source>
    <source>
        <name>Films</name>
        <path pathversion="1">/media/SouSou/Films/</path>
        <allowsharing>true</allowsharing>
    </source>

The difference being that the first log is without a trailing / in the path names. (My system shows a trailing / in path names.) I don’t know if this is significant.

If you, stop mediacenter, remove the MyVideos107 database, then start mediacenter and rescan, it would be interestng to see if the problem persists.

9

I tried to stop, remove the folder and rescan, but still the same problem…

About the differences in the sources.xml, I tried to remove the “/” manually to see if something happens, but it doesn’t change a thing…

Any other idea?

10

Why didn’t you provide a debug enabled log that demonstrates the rescan? This would have likely held clues

11

Here it is: https://paste.osmc.tv/necadelisi

12

You’re using a MySQL database, so I was talking about dropping the database:

osmc@osmc:~$ sudo systemctl stop mediacenter
osmc@osmc:~$ mysql -u kodi -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 99
Server version: 10.0.32-MariaDB-0+deb8u1 (Debian)

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| MyMusic60          |
| MyVideos107        |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
5 rows in set (0.00 sec)

MariaDB [(none)]> drop database MyVideos107;
Query OK, 30 rows affected (2.23 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| MyMusic60          |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]> quit
Bye
1 Like
13

Yeah it worked thanks!!