Kodi Community Forum

Full Version: SQL: Abort due to constraint violation
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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 Smile

Thanks for reading

My configuration : Fresh install of Openelec 5.95.3 (Kodi Isengard 15.0 RC2), Tvheadend 6.0.1 on an ARCTIC MC001