"SQL: Abort due to constraint violation" > DB structure or bad channel input ?
Added by Yann _ over 9 years ago
Hello,
I recently encountered some problem with Tvheadend HTSP Client v2.1.16. I do not have any "TV" button since the HTSP Client can't escape from loading stages. Kodi debug log says :
ERROR: SQL: Abort due to constraint violation Query: INSERT INTO channels (iUniqueId, bIsRadio, bIsHidden, bIsUserSetIcon, bIsUserSetName, bIsLocked, sIconPath, sChannelName, bIsVirtual, bEPGEnabled, sEPGScraper, iLastWatched, iClientId, idEpg) VALUES (647343397, 1, 0, 0, 0, 0, 'http://127.0.0.1:9981/1_0_2_2158_2_20FA_EEEE0000_0_0_0.png', 'NRJ', 0, 1, 'client', 0, 786, -1)
Source : [[http://xbmclogs.com/pkhlmg9qv#line-620]]
When disabling the 'NRJ' radio Channel everything is working fine. Maybe someone will have an explanation to this bad SQL request (or bad SQL database constraints ?) that may lead to a resolution
Thanks for reading
My configuration : Fresh install of Openelec 5.95.3 (Kodi Isengard 15.0 RC2), Tvheadend (seems to be 6.0.1 as indicated in the addon browser) on an ARCTIC MC001