Project

General

Profile

"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