[hre1]

Hi,

after installing the last nightlies for atv2 and ipad2, i can't access to my vnsi-pvr. the following messages in the xbmc.log appear:

23:20:20 T:237268992 ERROR: SQL: SQL error or missing database
Query: DELETE FROM map_channelgroups_channels WHERE (idGroup = 1) AND (AND idChannel IN (130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148))
23:20:20 T:237268992 ERROR: ExecuteQuery - failed to execute query 'DELETE FROM map_channelgroups_channels WHERE (idGroup = 1) AND (AND idChannel IN (130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148))'
23:20:20 T:237268992 ERROR: PVRChannelGroup - Load - failed to update channels
23:20:20 T:237268992 ERROR: PVRChannelGroupInternal - Load - failed to load channels

i renamed the XBMC directory, so that i started with a virgin installation but i doesn't matter, the error occur everytime when i start the xbmc app. i compiled der vnsi-server plugin from a todays opdenkamps git clone.

the server log says:

Jan 6 23:36:48 home-server vdr: [13509] loading /etc/vdr/plugins/vnsiserver5/allowed_hosts.conf
Jan 6 23:36:48 home-server vdr: [13509] VNSI: Client with ID 0 connected: 192.168.178.20:49494
Jan 6 23:36:48 home-server vdr: [13894] VNSI: Welcome client 'XBMC Media Center' with protocol version '5'
Jan 6 23:36:50 home-server vdr: [13894] VNSI: cxSocket::read: eof, connection closed
Jan 6 23:36:50 home-server vdr: [13509] VNSI: Client with ID 0 seems to be disconnected, removing from client list

what i'm doing wrong?


http://pastebin.com/UBwuaYjE


thanks in advance!

[FernetMenta]

no clue, works on the system I have for testing. strange that it tried to delete even after you deleted .xbmc. are you sure you did that correctly?

[hre1]

thank you for replay fernetmenta! i'm not sure what you mean with correctly? i renamed the complete XBMC folder under /var/mobile/Library/Preferences to XBMC_sik. XBMC starts and created a new XBMC folder with the defaults settings. i can activate the VNSI Plugin and enable LiveTV and i'm able to watch TV, but after shutdown and restarting XBMC, the above error messages appear and the pvr function is disabled.in xbmc i have no clue what i have to do solve the problem. when i delete the TV22.db file and startup XBMC i have to reactivate the VNSI PVR addon and LiveTV works again till the next startup. it seems something doing wrong with handling of that file? the problems occur with one of the last nightlies for ios. if i use a linux build with the vnsi addon i have no problem with the pvr functions. can you please advise what i can do to isolate the problem?

[FernetMenta]

There are two changes to the database which may cause this issue:
https://github.com/xbmc/xbmc/commits/mas...dbwrappers

I pinged xhaggi on this.

[xhaggi]

it's a syntax error in the delete statement, a duplicate AND. Will take a look at this asap.

[xhaggi]

it's fixed with https://github.com/xbmc/xbmc/pull/3987

Thanks

[hre1]

thank you very much for the fast bug fix! there is only one question remaining for me. do you know, when will it be in the nightly ios builds? and thanks again. great work!