• Fixed advancedsettings.xml parsing errors for space characters
  
• Significantly improved advancedsettings.xml parsing to provide specific error details
  
• Improved messaging for not supporting MySQL backups
  
• Added support to allow local database backups with mixed MySQL and Local databases
  
• Improved Kodi profile support vs. only the master profile
  

(2024-01-25, 19:31)PnoT Wrote:

(2024-01-25, 15:01)jbinkley60 Wrote:

(2024-01-24, 22:23)PnoT Wrote: Does the application support using the username and password for the Kodi database in the advancedsettings file? 

I can't seem to get it to connect to my database and here is the error: error <general>: EXCEPTION IN (C:Kodi\addons\plugin.program.kscleaner\resources\lib\common.py, LINE 189 "db = mysql.connector.connect(**config)"): connect() argument after ** must be a mapping, not NoneType

I've tried:

default
xbmc_videos
xbmc_videos121

My adv file contains the db name, IP of server, username, and password.

Yes, Kodi Selective Cleaner reads your advancedsettings.xml file to get username, password etc.  See here for more information.  That error is a generic error which I will fix in the next release of code.  It typically means there was a problem parsing your advancedsettings.xml file.  Can you post all of the exception messages from your Kodi.log file.  ?  This is typically the second one.  The first one which is likely the XML parsing exception should hold the key.  Worst case I may need to get a copy of your advancedsettings.xml file to see the cause.  One cause I often see is a space character as the first character on the first line.  If there is a space try removing it.  That is being fixed in the next release too where the XML parser will ignore it.

Thanks,

Jeff

I looked again at the logs, and it was complaining about not being able to parse the port. further inspection of my advancedsettings.xml showed that for the videos database, there was no <port> entry. I modified the settings and changed the names of my databases in the addon, and everything worked!

I noticed that the database name in the addon configuration had to be exact.  I tried just xbmc_videos and it wouldn't work without adding "121" which is the version.  According to the document, it should append the version number.

Quote:2024-02-12 16:09:31.632 T:1104     info <general>: KS Cleaner MySQL server database not found: myvideos124

(2024-02-12, 22:56)HeresJohnny Wrote: UniqueID cleaning seems to work without problems.

However, something else is strange. When cleaning my video database, over 4000 entries are scrubbed, most of them in the "seasons" table. When I update my video database afterwards, all of that seems to added to the db again. KSC then cleans it again on the next run. This can be repeated ad infinitum.

All this leads me to believe that there might be an error in the cleaning logic. I'm providing you with various files to analyze and test per PM, maybe you see something.

(2024-02-12, 23:25)theoneyouknowleast Wrote: Just trying out this plugin for the first time, but it doesn't seem to be able to connect to my mysql DB.

Seeing this error in the logs and I'm am running Kodi 21 Beta 2 on Windows. I tried 1.04 and 1.04b

Quote:2024-02-12 16:09:31.632 T:1104     info <general>: KS Cleaner MySQL server database not found: myvideos124

advancedsettings:


<advancedsettings>

    <videodatabase>

        <type>mysql</type>

        <host>1.2.3.4</host>

        <port>3306</port>

        <user>kodi</user>

        <pass>kodi</pass>

    </videodatabase>



    <musicdatabase>

        <type>mysql</type>

        <host>1.2.3.4</host>

        <port>3306</port>

        <user>kodi</user>

        <pass>kodi</pass>

    </musicdatabase>

</advancedsettings>

DB:


MariaDB [(none)]> SHOW DATABASES;

+--------------------+

| Database           |

+--------------------+

| MyMusic82          |

| MyMusic83          |

| MyVideos121        |

| MyVideos124        |

| information_schema |

| mysql              |

| performance_schema |

| sys                |

+--------------------+

(2024-02-13, 02:41)theoneyouknowleast Wrote: Just an update, setting the DB name manually to "MyMusic83" & "MyVideos124" resolved the issue. Seems its case-sensitive.

(2024-02-13, 00:41)jbinkley60 Wrote: I've not made any changes to the seasons cleaner / analyzer code in some time. 

Jeff

(2024-02-17, 09:35)bossanova808 Wrote: Finally got a quick moment to test the test version - I went gung ho and 'cleaned all tables' of the video database (~46000 records, and I use profiles...) - all seems to have gone ok, no major breakage I can see....so I switched to our other profile (kids) - and ran it there too.

Again seems to work well, thanks!  Looking at the logs for both I can see it referring to shows I've moved between profiles or completely nuked, all as expected as far as I can tell in a fairly quick look.  Definitely working with profiles now, though.

Although when cleaning seasons it just shows 'name' rather than the actual show name, I think?