[MAX404]

adding the black_eagle repo gives me version 0.59 of the script. it shows that there are 425 entries that can be deleted but after letting it run for 2 hours it still shows the same 425 entries that it wants to delete. so i guess it failed. maybe its because of the "old" script version. so my question is: how can i update the version to 0.61?

Hi

Try HERE

[AnthonyB]

First, thanks to the original authors for this tool, I have used this in the past with Leia, and it worked great,
and Thanks to Scott967 for fixing it for Matrix.

Just FYI:
I had a small problem getting this working with Matrix,
solution was changing line 53 in Default.py from: MAX_VIDEODB_VERSION = 116 to MAX_VIDEODB_VERSION = 117

Cheers,
Ron

Thanks to scott967 and rb26 for the Matrix fork and note above respectively.

Now that Matrix (Kodi 19) is released line 53 in Default.py needs to change from: MAX_VIDEODB_VERSION = 116 to MAX_VIDEODB_VERSION = 119

Kodi 19 MyVideos database version is 119 (Ref - https://kodi.wiki/view/Databases)

[lazysmurf]

I always get this error

ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
                                             - NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
                                            Error Type: <class 'sqlite3.OperationalError'>
                                            Error Contents: Could not decode to UTF-8 column 'strPath' with text 'rtmp://play.finecast.tv:1935/live?wmsauthsign=c2vydmvyx3rpbwu9my8xmc8ymde2idewojexoja4iefnjmhhc2hfdmfsdwu9rtqyv1joq3bnmgpqwjnty3dtdze5zz09jnzhbg
                                            Traceback (most recent call last):
                                              File "C:\Users\\AppData\Roaming\Kodi\addons\script.database.cleaner\default.py", line 687, in <module>
                                                cleaner_log_file(our_select, False)
                                              File "C:\Users\\AppData\Roaming\Kodi\addons\script.database.cleaner\default.py", line 292, in cleaner_log_file
                                                my_data = cursor.fetchall()
                                            OperationalError: Could not decode to UTF-8 column 'strPath' with text 'rtmp://play.finecast.tv:1935/live?wmsauthsign=c2vydmvyx3rpbwu9my8xmc8ymde2idewojexoja4iefnjmhhc2hfdmfsdwu9rtqyv1joq3bnmgpqwjnty3dtdze5zz09jnzhbg
                                            -->End of Python script error report<--

[xbmcjas]

First, thanks to the original authors for this tool, I have used this in the past with Leia, and it worked great,
and Thanks to Scott967 for fixing it for Matrix.

Just FYI:
I had a small problem getting this working with Matrix,
solution was changing line 53 in Default.py from: MAX_VIDEODB_VERSION = 116 to MAX_VIDEODB_VERSION = 117

Cheers,
Ron

Thanks to scott967 and rb26 for the Matrix fork and note above respectively.

Now that Matrix (Kodi 19) is released line 53 in Default.py needs to change from: MAX_VIDEODB_VERSION = 116 to MAX_VIDEODB_VERSION = 119

Kodi 19 MyVideos database version is 119 (Ref - https://kodi.wiki/view/Databases)

Is there any chance you can post the zip file with this change? Every time I try, I mess something up. I'm not sure what I'm doing wrong.

[kidbizkit]

First, thanks to the original authors for this tool, I have used this in the past with Leia, and it worked great,
and Thanks to Scott967 for fixing it for Matrix.

Just FYI:
I had a small problem getting this working with Matrix,
solution was changing line 53 in Default.py from: MAX_VIDEODB_VERSION = 116 to MAX_VIDEODB_VERSION = 117

Cheers,
Ron

Thanks to scott967 and rb26 for the Matrix fork and note above respectively.

Now that Matrix (Kodi 19) is released line 53 in Default.py needs to change from: MAX_VIDEODB_VERSION = 116 to MAX_VIDEODB_VERSION = 119

Kodi 19 MyVideos database version is 119 (Ref - https://kodi.wiki/view/Databases)

it would be truly appreciated if you can share the version compatible to Kodi Matrix

[Klojum]

Now that Matrix (Kodi 19) is released line 53 in Default.py needs to change from: MAX_VIDEODB_VERSION = 116 to MAX_VIDEODB_VERSION = 119

I have notified @black_eagle of this (he has been AFK for a couple of months but is now back slowly but surely), and he'd put it on his to-do list.

[richardsim7]

The database cleaner finds 125 entries to remove, so I click "clean" and then an clean library runs. But the entries still remain, and are still there when I run the cleaner again - any ideas?

[kenmills]

Now that Matrix (Kodi 19) is released line 53 in Default.py needs to change from: MAX_VIDEODB_VERSION = 116 to MAX_VIDEODB_VERSION = 119

I have notified @black_eagle of this (he has been AFK for a couple of months but is now back slowly but surely), and he'd put it on his to-do list.

The addon need more than the DB version changed.  The code needs to be amended for Python 3. The unicode calls etc need to be changed.  I have attempted to amend it but only got about halfway.
If you would like to have black_eagle reach out to me, I'll be happy to share my edits :-)
Cheers,
Ken

[Klojum]

If you would like to have black_eagle reach out to me, I'll be happy to share my edits :-)

@black_eagle is a regular forum visitor, so he shouldn't be too far.

[kenmills]

If you would like to have black_eagle reach out to me, I'll be happy to share my edits :-)

@black_eagle is a regular forum visitor, so he shouldn't be too far.

Awesome thx!  I look forward to hearing from him

[black_eagle]

Awesome thx!  I look forward to hearing from him

Yeah, I'm aware that it needs an update (badly).  I will get around to it as soon as I can, just real life keeps getting in the way!  If you want to fork it, improve it and/or maintain it then go right ahead.

[kenmills]

Awesome thx!  I look forward to hearing from him

Yeah, I'm aware that it needs an update (badly).  I will get around to it as soon as I can, just real life keeps getting in the way!  If you want to fork it, improve it and/or maintain it then go right ahead.

Hey mate!  Nice to meet you!  

I totally get it; RL is crazy these days, hey?  The lockdowns in Canada are crazy, and the US isn't any better 

I just downloaded and opened the addon locally on  my PC, and edited the default.py to adhere to Python 3 standards, and almost got it to work with Matrix...  The addon installs, and runs, but when it executes it fails.   

I am just stuck on a single line - I think.  I am not a developer, nor am I that familiar with Python, let alone Python 3 :-)  I just plodded through.

I'll see about setting up a github account and forking it officially etc...  However, if you have 2 mins, and can easily solve the following, I think we may have a working addon....

The line that gets stuck is:

json_query = unicode(json_query, 'utf-8', errors='ignore')

Now I know that Python 3, you switch str for unicode, since the queries are all encoded.  However, when I do that and use json_query = str(json_query, 'utf-8', errors='ignore')

I get the error:

 json_query = str(json_query, 'utf-8', errors='ignore')
TypeError: decoding str is not supported

The entire chunk of code is:

json_query = unicode(json_query, 'utf-8', errors='ignore')
json_query = jsoninterface.loads(json_query)
if json_query.has_key('result'):
     dbglog('Clean library sucessfully called')


Anyways, if you know how to fix that chunk or line, I'll test and if it works, then we have a Matrix compatible version :-)

Cheers!
Ken

[scott967]

Awesome thx!  I look forward to hearing from him

Yeah, I'm aware that it needs an update (badly).  I will get around to it as soon as I can, just real life keeps getting in the way!  If you want to fork it, improve it and/or maintain it then go right ahead.

Hey mate!  Nice to meet you!  

I totally get it; RL is crazy these days, hey?  The lockdowns in Canada are crazy, and the US isn't any better 

I just downloaded and opened the addon locally on  my PC, and edited the default.py to adhere to Python 3 standards, and almost got it to work with Matrix...  The addon installs, and runs, but when it executes it fails.   

I am just stuck on a single line - I think.  I am not a developer, nor am I that familiar with Python, let alone Python 3 :-)  I just plodded through.

I'll see about setting up a github account and forking it officially etc...  However, if you have 2 mins, and can easily solve the following, I think we may have a working addon....

The line that gets stuck is:

json_query = unicode(json_query, 'utf-8', errors='ignore')

Now I know that Python 3, you switch str for unicode, since the queries are all encoded.  However, when I do that and use json_query = str(json_query, 'utf-8', errors='ignore')

I get the error:

 json_query = str(json_query, 'utf-8', errors='ignore')
TypeError: decoding str is not supported

The entire chunk of code is:

json_query = unicode(json_query, 'utf-8', errors='ignore')
json_query = jsoninterface.loads(json_query)
if json_query.has_key('result'):
     dbglog('Clean library sucessfully called')


Anyways, if you know how to fix that chink or line, I'll test and if it works, then we have a Matrix compatible version :-)

Cheers!
Ken

There's a separate addon developer forum which is a better place to ask.   Try just remove the line that calls the unicode() as it isn't needed. json_query is already a (unicode) string.

scott s.
.

[kenmills]

Yeah, I'm aware that it needs an update (badly).  I will get around to it as soon as I can, just real life keeps getting in the way!  If you want to fork it, improve it and/or maintain it then go right ahead.

Hey mate!  Nice to meet you!  

I totally get it; RL is crazy these days, hey?  The lockdowns in Canada are crazy, and the US isn't any better 

I just downloaded and opened the addon locally on  my PC, and edited the default.py to adhere to Python 3 standards, and almost got it to work with Matrix...  The addon installs, and runs, but when it executes it fails.   

I am just stuck on a single line - I think.  I am not a developer, nor am I that familiar with Python, let alone Python 3 :-)  I just plodded through.

I'll see about setting up a github account and forking it officially etc...  However, if you have 2 mins, and can easily solve the following, I think we may have a working addon....

The line that gets stuck is:

json_query = unicode(json_query, 'utf-8', errors='ignore')

Now I know that Python 3, you switch str for unicode, since the queries are all encoded.  However, when I do that and use json_query = str(json_query, 'utf-8', errors='ignore')

I get the error:

 json_query = str(json_query, 'utf-8', errors='ignore')
TypeError: decoding str is not supported

The entire chunk of code is:

json_query = unicode(json_query, 'utf-8', errors='ignore')
json_query = jsoninterface.loads(json_query)
if json_query.has_key('result'):
     dbglog('Clean library sucessfully called')


Anyways, if you know how to fix that chink or line, I'll test and if it works, then we have a Matrix compatible version :-)

Cheers!
Ken

There's a separate addon developer forum which is a better place to ask.   Try just remove the line that calls the unicode() as it isn't needed. json_query is already a (unicode) string.

scott s.
.

Probably a good idea to post in the add-on dev forum. Will do, thx!

[kenmills]

OK, I was able to get it working, with the help of @ronie  in the developers forums!

We now have a working Database Cleaner, in Kodi 19 Matrix  

My github fork is located:
https://github.com/klyco/script.database.cleaner

Thanks @black_eagle for the addon - it is brilliant, I was honored to update it.