Hello
I am trying to migrate from SQLite to MariaDB under Kodi 19 after replacing my android device to a Debian base device. I couldn't simply move my user space as one used SMB and the other has NFS mounts and so the files look local. Also the android Kodi 19 combo felt buggy so I didn't want to bring the "android Kodi 19 converted from 18 userspace" to a fresh machine.
And when I connected the two devices to the common sql server after scanning all the media WatchedList was reporting a lot less watched than what was in the .db file. I assumed it was because it started fresh.
I then decided to follow the instructions at
https://kodi.wiki/view/Add-on:WatchedLis...l_database
It mostly went without an issue except for SQLite browser using the wrong quotes but except for that the imports went fine and MariaDB is reporting the right amount of information.
But now starting the WatchedList add on if giving me unlimited (one for each watched entry ie thousands) full screen errors asking me to report said errors. I reported 3/4 to help and then killed Kodi. Looking at the logs I am assuming that going from SQLite to MariaDB the column types changed. Can someone tell me what to change ?
Thank you
Here is an extract of the SQL file after the regex replaces "successfully" used:
sql:
DROP DATABASE `WatchedList`;
CREATE DATABASE `WatchedList`;
USE `WatchedList`;
CREATE TABLE IF NOT EXISTS `movie_watched` (
`idMovieImdb` INTEGER,
`playCount` INTEGER,
`lastChange` INTEGER,
`lastPlayed` INTEGER,
`title` TEXT,
PRIMARY KEY(`idMovieImdb`)
);
CREATE TABLE IF NOT EXISTS `episode_watched` (
`idShow` INTEGER,
`season` INTEGER,
`episode` INTEGER,
`playCount` INTEGER,
`lastChange` INTEGER,
`lastPlayed` INTEGER,
PRIMARY KEY(`idShow`,`season`,`episode`)
);
CREATE TABLE IF NOT EXISTS `tvshows` (
`idShow` INTEGER,
`title` TEXT,
PRIMARY KEY(`idShow`)
);
INSERT IGNORE INTO `movie_watched` VALUES (50083,1,FROM_UNIXTIME(1609621468),FROM_UNIXTIME(1609621312),'12 Angry Men (1957)');
INSERT IGNORE INTO `episode_watched` VALUES (152831,5,1,1,FROM_UNIXTIME(1616169501),FROM_UNIXTIME(1616167865));
INSERT INTO `tvshows` VALUES (386465,'Red Dwarf: The First Three Million Years');
COMMIT;
Here are the logs:
kodi.log