[flurpy]

This program, written in Python, will let you easily set the genre(s) and tag(s) assigned to TV Shows or Movies in your Kodi MySQL database.


Background: I use genres to categorize TV shows for our household. Shows that we all watch together have a genre of Family. Shows that are only watched by kids have a genre of Kids. Shows that only hold the interest of one person in the family has a genre with their name. This program was written to quickly replace the genre(s) that get scraped/assigned when the show is first added to the library. It can do the same for Movies as well. I also use the tags feature to organize movies that are suitable for the whole family or of interest to only one person. I use tags for movies since I do want to keep the genres in place. I use genres for TV simply because that's what I did from the begining several years ago and my family is used to it.

I'm hoping that the use of this tool is intuitive and I have not yet written up any documentation. If you have any questions, feel free to send me a message.

Tested on: Kodi 17.3 and 17.4 and mysql Ver 15.1 Distrib 10.1.26-MariaDB



Download from https://github.com/flurpy/Kodi-Genre-Tag...aster/dist

[ziggy73701]

Hello, been wanting to have a look at this but am unable to get it to connect to the database. Am using MariaDB 10.2 KODI connection etc works a treat.

[flurpy]

Hello, been wanting to have a look at this but am unable to get it to connect to the database. Am using MariaDB 10.2 KODI connection etc works a treat.

Hello, can you take a look at the log file in your user's home directory plus .LucidDev\KodiDBeditor\logs\KodiDBeditor.log and let me know what it shows? Which version of Kodi are you running?

[ziggy73701]

Can send whole log if needs be..
2017-10-22 22:16:47,904 INFO : Starting up
2017-10-22 22:16:48,099 DEBUG : MySQL Server List is [(u'nas02', u'10.12.0.9', 3306, u'kodi', u'kodi')]
2017-10-22 22:16:48,147 INFO : Connecting to nas02 MySQL server
2017-10-22 22:16:48,176 DEBUG : The following databases are available []

Running multiple instances of kodi 17.3 and SPMC

[flurpy]

Can send whole log if needs be..
2017-10-22 22:16:47,904 INFO : Starting up
2017-10-22 22:16:48,099 DEBUG : MySQL Server List is [(u'nas02', u'10.12.0.9', 3306, u'kodi', u'kodi')]
2017-10-22 22:16:48,147 INFO : Connecting to nas02 MySQL server
2017-10-22 22:16:48,176 DEBUG : The following databases are available []

Running multiple instances of kodi 17.3 and SPMC

If you wouldn't mind sending the whole log that would be good. Also, can you connect to your mysql server and run 'show databases;'?  The program is looking for databases that start with MyVideos. Based on the last log entry above, it would seem that it connected to the MySQL server but no databases started with MyVideos. Here's what mine looks like:

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