ERROR: SQL: Abort due to constraint violation
#1
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
Reply
#2
clear/remove your TV database files. it has some invalid data in it, so it can't be upgraded.
opdenkamp / dushmaniac

xbmc-pvr [Eden-PVR builds] [now included in mainline XBMC, so no more source link here :)]
personal website: [link]

Found a problem with PVR? Report it on Trac, under "PVR - core components". Please attach the full debug log.

If you like my work, please consider donating to me and/or Team XBMC.
Reply
#3
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
Reply
#4
Thats resolved my issue, thanks Smile
Reply
#5
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'
Reply

Logout Mark Read Team Forum Stats Members Help
ERROR: SQL: Abort due to constraint violation1