[jbinkley60]

Hey - just installed this add on to try it out.

I am using MySQL dbs, and when I set it to them, it told me they weren't found. Is there a configuration that needs to happen? (I know they're up and working, just connected to them with another db tool)

Here's the Wiki link on setting up MySQL connectivity.  If this doesn't help then I need to understand your addon settings for MySQL Database Names, your database names and your advancedsettings.zml database name fields.  It would also help to see the exact log message from the kodi.log file.


Thanks,

Jeff

[sufreak]

Hey - just installed this add on to try it out.

I am using MySQL dbs, and when I set it to them, it told me they weren't found. Is there a configuration that needs to happen? (I know they're up and working, just connected to them with another db tool)

Here's the Wiki link on setting up MySQL connectivity.  If this doesn't help then I need to understand your addon settings for MySQL Database Names, your database names and your advancedsettings.zml database name fields.  It would also help to see the exact log message from the kodi.log file.


Thanks,

Jeff

2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25):  default.py
2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25, /storage/.kodi/addons/plugin.program.kscleaner/default.py): entering source directory /storage/.kodi/addons/plugin.program.kscleaner
2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25, /storage/.kodi/addons/plugin.program.kscleaner/default.py): instantiating addon using automatically obtained id of "plugin.program.kscleaner" dependent on version 3.0.0 of the xbmc.python api
2024-05-15 15:52:36.815 T:4064     info <general>: KS Cleaner logging database check successful.  Addon started.
2024-05-15 15:52:36.830 T:4064     info <general>: Kodi Selective Cleaner Python vesion is: 3.11.2
2024-05-15 15:52:36.850 T:4064     info <general>: KS Cleaner music DB trigger checking is disabled
2024-05-15 15:52:36.902 T:4064    debug <general>: KS Cleaner parse: mysql 192.168.10.125 3306 kodi <removed> myvideos121
2024-05-15 15:52:37.422 T:720     debug <general>: ------ Window Init (DialogConfirm.xml) ------
2024-05-15 15:52:41.535 T:724     debug <general>: LIRC: - NEW 160 0 KEY_OK devinput (KEY_OK)
2024-05-15 15:52:41.572 T:720     debug <general>: HandleKey: 11 (0xb, obc244) pressed, window 12002, action is Select
2024-05-15 15:52:41.849 T:720     debug <general>: ------ Window Deinit (DialogConfirm.xml) ------
2024-05-15 15:52:41.872 T:4064     info <general>: KS Cleaner MySQL server database not found: myvideos121
2024-05-15 15:52:42.040 T:4064    debug <general>: KS Cleaner parse: mysql 192.168.10.105 3306 kodi <removed> mymusic82

I wonder if is case sensitive. My dbs are MyVideos121 and MyMusic82

[jbinkley60]

Hey - just installed this add on to try it out.

I am using MySQL dbs, and when I set it to them, it told me they weren't found. Is there a configuration that needs to happen? (I know they're up and working, just connected to them with another db tool)

Here's the Wiki link on setting up MySQL connectivity.  If this doesn't help then I need to understand your addon settings for MySQL Database Names, your database names and your advancedsettings.zml database name fields.  It would also help to see the exact log message from the kodi.log file.


Thanks,

Jeff

2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25):  default.py
2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25, /storage/.kodi/addons/plugin.program.kscleaner/default.py): entering source directory /storage/.kodi/addons/plugin.program.kscleaner
2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25, /storage/.kodi/addons/plugin.program.kscleaner/default.py): instantiating addon using automatically obtained id of "plugin.program.kscleaner" dependent on version 3.0.0 of the xbmc.python api
2024-05-15 15:52:36.815 T:4064     info <general>: KS Cleaner logging database check successful.  Addon started.
2024-05-15 15:52:36.830 T:4064     info <general>: Kodi Selective Cleaner Python vesion is: 3.11.2
2024-05-15 15:52:36.850 T:4064     info <general>: KS Cleaner music DB trigger checking is disabled
2024-05-15 15:52:36.902 T:4064    debug <general>: KS Cleaner parse: mysql 192.168.10.125 3306 kodi <removed> myvideos121
2024-05-15 15:52:37.422 T:720     debug <general>: ------ Window Init (DialogConfirm.xml) ------
2024-05-15 15:52:41.535 T:724     debug <general>: LIRC: - NEW 160 0 KEY_OK devinput (KEY_OK)
2024-05-15 15:52:41.572 T:720     debug <general>: HandleKey: 11 (0xb, obc244) pressed, window 12002, action is Select
2024-05-15 15:52:41.849 T:720     debug <general>: ------ Window Deinit (DialogConfirm.xml) ------
2024-05-15 15:52:41.872 T:4064     info <general>: KS Cleaner MySQL server database not found: myvideos121
2024-05-15 15:52:42.040 T:4064    debug <general>: KS Cleaner parse: mysql 192.168.10.105 3306 kodi <removed> mymusic82

I wonder if is case sensitive. My dbs are MyVideos121 and MyMusic82

Certain Kodi platforms are case sensitive.  What's the  OS on which you are running the addon ?  You can manually add MyVideos and MyMusic to the addon database name settings and see if that fixes it or update your advancedsettings.xml file to proper case.


Thanks,

Jeff

[sufreak]

Certain Kodi platforms are case sensitive.  What's the  OS on which you are running the addon ?  You can manually add MyVideos and MyMusic to the addon database name settings and see if that fixes it or update your advancedsettings.xml file to proper case.
Thanks,
Jeff

I'm running on Linux, both Kodi and my sql db server. I'll try to mess with the add on later

[Karellen]

Maybe try adding the <name>MyVideos121</name> tag

[jbinkley60]

Maybe try adding the <name>MyVideos121</name> tag

Yes, that should work.  Right now the Kodi Selective Cleaner is seeing the name tag as all lowercase and Linux is case sensitive..


Thanks,

Jeff

[sufreak]

I added the names to the addon instead of default and it seemed to work.  Hopefully the next version can patch that.

[jbinkley60]

I added the names to the addon instead of default and it seemed to work.  Hopefully the next version can patch that.

There isn't anything the addon can do here.  Your advancedsettings.xml name doesn't match your database name for proper case.  If you changed the database settings back to Default and updated your  advancedsettings.xml file that should work too.


Thanks,

Jeff

[sufreak]

My advancedsettings.xml doesn't specify a name, it uses default.

<videodatabase>
        <type>mysql</type>
        <host>192.168.10.125</host>
        <port>3306</port>
        <user>Removed</user>
        <pass>Removed</pass>
    </videodatabase>

Looking at common.py, changing:

line 145, myvideos  > MyVideos
line 205, mymusic > MyMusic

Wouldn't that solve the problem?

The Kodi documentation https://kodi.wiki/index.php?title=Databases states the names as  MyVideos and  MyMusic

[jbinkley60]

My advancedsettings.xml doesn't specify a name, it uses default.

<videodatabase>
        <type>mysql</type>
        <host>192.168.10.125</host>
        <port>3306</port>
        <user>Removed</user>
        <pass>Removed</pass>
    </videodatabase>

Looking at common.py, changing:

line 145, myvideos  > MyVideos
line 205, mymusic > MyMusic

Wouldn't that solve the problem?

The Kodi documentation https://kodi.wiki/index.php?title=Databases states the names as  MyVideos and  MyMusic

So you do not have name tags in your advancedsettings.xml file ?  If so, then your suggestion would fix it.  I presumed you had lowercase name tags.


Jeff

[jbinkley60]

Looking at common.py, changing:

line 145, myvideos  > MyVideos
line 205, mymusic > MyMusic

Wouldn't that solve the problem?

The Kodi documentation https://kodi.wiki/index.php?title=Databases states the names as  MyVideos and  MyMusic

I have posted version 1.0.5d which has the suggested change.  Once you install this version reset the database names back to Default and see if it works.


Thanks,

Jeff

[kittmaster]

I like it. 

I would recommend one creature feature add, you have "clean all tables" which is great when turned on. Each database item has an analyze which is nice, but 15 times in and out to "check" is laborious. Would you consider an "Analyze all tables" and display that to reduce the click in and outs to either find a problem in a particular DB item vs. the large hammer where all are cleaned but don't know what 'til it's over i.e. clean all tables.

I do like the feature and will be adding it to my addons.

Greetz,
Chris

[jbinkley60]

I like it. 

I would recommend one creature feature add, you have "clean all tables" which is great when turned on. Each database item has an analyze which is nice, but 15 times in and out to "check" is laborious. Would you consider an "Analyze all tables" and display that to reduce the click in and outs to either find a problem in a particular DB item vs. the large hammer where all are cleaned but don't know what 'til it's over i.e. clean all tables.

I do like the feature and will be adding it to my addons.

Analyzing all tables is a bit more challenging than cleaning all tables due to the differences in displaying the output results for each table.  Yours' is the second request for this.  What about Analyze All but output it to a CSV or text file vs. the screen ?  I'll give this some thought.  A text file output would likely be the easiest.


Thanks,

Jeff

[jbinkley60]

I have posted a new release version 1.0.6  of Kodi Selective Cleaner.  This version has a number of fixes and features, including support for the Kodi Omega 21 videroversion tables.  I appreciate all who provided feature suggestions and helped test this release.


Here's the complete list of highlights since 1.0.5

• Changed cleaning seasons from displaying season name to associated TV Show names
• Added videoversion and videoversiontype tables to CSV export
• Added logging of Kodi version detected to KS Cleaner logger
• Added videoversion table to the video database analyzer
• Added repairing of missing triggers for MySQL music databases.  Previously only detection was supported.
• Added CSV export for video database tag and tag_link tables
• Fixed MySQL default database names from all lowercase to propercase


Now to begin the feature requests for v1.0.7  


Thanks,

Jeff

[Meth0d]

There really should be a "Clean all" after "Analyse all" option, as said before going manually through all tables back and forth through the menu feels very stupid

I guess this will not be requested by many but i would find it very usefull if you could trigger the script(s) from ssh.
I run libreelec in my livingroom mostly headless and would rather do all the "library stuff" like keeping tvshows up2date from somwhere else ie my Desktop