Kodi Community Forum

Full Version: ERROR: SQL: Abort due to constraint violation
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Any ideas why i am getting these errors,

http://pastebin.com/4zygR06d

also when i start xbmc for the first time or reboot i get message that no PVR is enabled, then it takes about 10mins saying importing channels, but no progress bar for 10mins

i have compiled with the latest commits here

https://github.com/OpenELEC/OpenELEC.tv/...f95d0d0603

and still the same
clear/remove your TV database files. it has some invalid data in it, so it can't be upgraded.
dushmaniac Wrote:clear/remove your TV database files. it has some invalid data in it, so it can't be upgraded.

Thanks, i will give that a try
Thats resolved my issue, thanks Smile
i have the exact same problem. however i moved the complete .xbmc folder to .xbmc.bak and let it redo a new folder structure. Problem persists.

Any idea where to start looking ?

15:14:10 T:139657631229696 ERROR: SQL: Abort due to constraint violation
Query: INSERT INTO channels (iUniqueId, bIsRadio, bIsHidden, bIsUserSetIcon, sIconPath, sChannelName, bIsVirtual, bEPGEnabled, sEPGScraper, iLastWatched, iClientId, iClientChannelNumber, sInputFormat, sStreamURL, iEncryptionSystem, idEpg) VALUES (1723, 0, 0, 0, '1_0_1_1841_7D9_2_11A0000_0_0_0.png', 'Disc.Turbo', 0, 1, 'client', 0, 1, 1723, '', 'pvr://stream/tv/1723.ts', 0, -1)
15:14:10 T:139657631229696 ERROR: ExecuteQuery - failed to execute query 'INSERT INTO channels (iUniqueId, bIsRadio, bIsHidden, bIsUserSetIcon, sIconPath, sChannelName, bIsVirtual, bEPGEnabled, sEPGScraper, iLastWatched, iClientId, iClientChannelNumber, sInputFormat, sStreamURL, iEncryptionSystem, idEpg) VALUES (1723, 0, 0, 0, '1_0_1_1841_7D9_2_11A0000_0_0_0.png', 'Disc.Turbo', 0, 1, 'client', 0, 1, 1723, '', 'pvr://stream/tv/1723.ts', 0, -1)'
15:14:10 T:139657631229696 ERROR: CPVRChannelGroupInternal - Persist - failed to persist channel 'Disc.Turbo'