2016-06-27, 22:43
@BigMong
I use the default Kodi Watch Status.
pressing W or Context menu Mark as Watched.
Once I have my "Matt" DB created I open Kodi and test the Watch Status work.
After I implement the code:
The watched status does not function anymore.
From the Log:
I have narrowed it down to this code, and this is the first and only SQL Queries I have run.
I believe Kodi 16.1 Jarvis has made some changes that after we ALTER the Tables/Views this breaks.
This was working on 15 Isengrad
I use the default Kodi Watch Status.
pressing W or Context menu Mark as Watched.
Once I have my "Matt" DB created I open Kodi and test the Watch Status work.
After I implement the code:
Code:
RENAME TABLE `Sushi99`.`files` TO `Sushi99`.`globalfiles`;
ALTER TABLE `Sushi99`.`globalfiles` CHANGE playCount playCountSushi INT(11);
ALTER TABLE `Sushi99`.`globalfiles` CHANGE lastPlayed lastPlayedSushi TEXT;
ALTER TABLE `Sushi99`.`globalfiles` ADD playCountChloe INT(11) AFTER lastPlayedSushi;
ALTER TABLE `Sushi99`.`globalfiles` ADD lastPlayedChloe TEXT AFTER playCountChloe;
ALTER TABLE `Sushi99`.`globalfiles` ADD playCountFelicia INT(11) AFTER lastPlayedChloe;
ALTER TABLE `Sushi99`.`globalfiles` ADD lastPlayedFelicia TEXT AFTER playCountFelicia;
CREATE VIEW `Sushi99`.`files` AS SELECT
`Sushi99`.`globalfiles`.`idFile` AS `idFile`,
`Sushi99`.`globalfiles`.`idPath` AS `idPath`,
`Sushi99`.`globalfiles`.`strFilename` AS `strFilename`,
`Sushi99`.`globalfiles`.`playCountSushi` AS `playCount`,
`Sushi99`.`globalfiles`.`lastPlayedSushi` AS `lastPlayed`,
`Sushi99`.`globalfiles`.`dateAdded` AS `dateAdded`
FROM `Sushi99`.`globalfiles`;
The watched status does not function anymore.
From the Log:
Code:
16:48:27 T:9872 DEBUG: CInputManager::OnKey: w (0xf057) pressed, action is ToggleWatched
16:48:27 T:2948 DEBUG: Mysql Start transaction
16:48:27 T:2948 DEBUG: Mysql execute: update files set playCount=NULL,lastPlayed=NULL where idFile=2
16:48:27 T:2948 ERROR: SQL: [sushi99] Undefined MySQL error: Code (1288)
Query: update files set playCount=NULL,lastPlayed=NULL where idFile=2
16:48:27 T:2948 ERROR: CVideoDatabase::SetPlayCount failed
16:48:27 T:2948 DEBUG: Mysql commit transaction
I have narrowed it down to this code, and this is the first and only SQL Queries I have run.
I believe Kodi 16.1 Jarvis has made some changes that after we ALTER the Tables/Views this breaks.
This was working on 15 Isengrad