[Nanomani]

Is it safe to install and use this now?

Sorry to say that. But I didn't have a good experience.
So backup, backup and backup your database before   

[Klojum]

But I didn't have a good experience.

So ... -what- went wrong?

[Nanomani]

But I didn't have a good experience.

So ... -what- went wrong?

Thank you for your interest.
For many movies the list of movies by the same director had become empty.

Edit1 : when I have some free time I can do a new test with a debug log if this make a interest for someone here

[Klojum]

For many movies the list of movies by the same director had become empty.

Is this only for 1 director, is the c06 field for every movie suddenly empty?
If it is only just for 1 director, I doubt the VDC tool is the problem.
Or maybe, your director_link database table is corrupted.

Are your SQL savvy enough to check that for us?

[Nanomani]

Is this only for 1 director, is the c06 field for every movie suddenly empty?

I know what you mean. I thinks is effectively c06 field but not for all
I have to take a new test to answer to these questions precisely.

If it is only just for 1 director, I doubt the VDC tool is the problem.
Or maybe, your director_link database is corrupted.

What is sure is that I had this problem every time after using this tool.
I have several attempts by restoring my video base each time to be sure.

Are your SQL savvy enough to check that for us?

Yes I can do that for you.

give me just some time please. 
thanks

[Klojum]

@kenmills

I'm thinking of renaming the thread's title. "Pre-wash scrub" is a bit vague to much. Also the tool can be used at any time, so nothing to do with pre-washing something.
The original add-on authors already used the term 'Video database cleaner', so perhaps we should go with that from now on.

[kenmills]

@kenmills

I'm thinking of renaming the thread's title. "Pre-wash scrub" is a bit vague to much. Also the tool can be used at any time, so nothing to do with pre-washing something.
The original add-on authors already used the term 'Video database cleaner', so perhaps we should go with that from now on.

Hey mate - I agree, please rename it to Video Database Cleaner.  It helps with searches also :-)

[kidbizkit]

Is it safe to install and use this now?

Hey - for Matrix yes.

Then i will install and use it now. Thank you very much

[Nanomani]

Is this only for 1 director, is the c06 field for every movie suddenly empty?

I know what you mean. I thinks is effectively c06 field but not for all
I have to take a new test to answer to these questions precisely.

If it is only just for 1 director, I doubt the VDC tool is the problem.
Or maybe, your director_link database is corrupted.

What is sure is that I had this problem every time after using this tool.
I have several attempts by restoring my video base each time to be sure.

Are your SQL savvy enough to check that for us?

Yes I can do that for you.

give me just some time please. 
thanks

I have make a new test. Same result here.
button "Same director" from "video info dialog" display "Result empty" or the correct result

Eg :




before "VDC"






after "VDC" 






I see no difference in "MyVideos119.db" before and after

debug log : https://paste.kodi.tv/nuwamapeme.kodi

If you want a link for the files "MyVideos119.db" before and after please ping me.
I will send you by PM

[Klojum]

If you want a link for the files "MyVideos119.db" before and after please ping me.

Not just yet..

It seems that the Movie Information page is containing information, but the Search function is not working.
Can you try and run this SQL query with a few movie titles in your collection? This one uses the director_link table.

sql:
SELECT

	m.c00 AS title,

	a.name AS director

FROM

	actor a,

	director_link d,

    movie m

WHERE

	a.actor_id = d.actor_id

    AND

    d.media_id = m.idMovie

    AND

	m.c00 LIKE "12 Angry Men"

[Nanomani]

If you want a link for the files "MyVideos119.db" before and after please ping me.

Not just yet..

It seems that the Movie Information page is containing information, but the Search function is not working.
Can you try and run this SQL query with a few movie titles in your collection? This one uses the director_link table.

sql:
SELECT

m.c00 AS title,

a.name AS director

FROM

actor a,

director_link d,

movie m

WHERE

a.actor_id = d.actor_id

AND

d.media_id = m.idMovie

AND

m.c00 LIKE "12 Angry Men"

I have somes result correct and sometime no result

[Klojum]

I have somes result correct and sometime no result

Perhaps the cleaning has become a bit too aggressive...

[Klojum]

I have somes result correct and sometime no result

The movies that are NOT showing with this query, do they still with full info in Kodi's information page?

[Nanomani]

I have somes result correct and sometime no result

The movies that are NOT showing with this query, do they still with full info in Kodi's information page?

Yes.
The consistancy is that the movies that have "empty result for "same director" have a empty result with your query.

Edit 1: this addon is very promising. But it is not for the beginner. IMHO a disclaimer is very usefull yet 

[kidbizkit]

Is it safe to install and use this now?

Sorry to say that. But I didn't have a good experience.
So backup, backup and backup your database before   

thank you for that. i will then hold on for a bit more before I install this amazing addon.