Reply to thread

Message

<blockquote data-quote="Aquarius" data-source="post: 874697" data-attributes="member: 10507">Hi all,I tried to circumvent the official introduction of recordings into the DB by just applying some SQL.&nbsp;Insertion works just fine, but the TVServer throws out my inserted record with the following message:2012-06-14 21:40:33.265625 [scheduler thread(30)]: Scheduler: Orphaned once schedule found 333 - removing&nbsp;The SQL statement looks like this.&nbsp; insert into schedule (idChannel, scheduleType, programName, startTime, endTime, ... ) select idChannel, '0' , title, startTime, endTime, ... from program where description like ... ; &nbsp;My suspicion is the field &quot;schedule.id...&quot; , which is an autoincrement. Does TVServer perhaps remember this value internally ?&nbsp;Background: I wanted to create a very lightweight recording filter using simple search mechanisms in the programs database without the hassle of plugins (like &quot;ForTheRecord&quot;) or whatever.&nbsp;If somebody knows another pragmatic, simple way to insert recordings, I would be thankful.&nbsp;Thanks/Gerd</blockquote>

[QUOTE="Aquarius, post: 874697, member: 10507"] Hi all, I tried to circumvent the official introduction of recordings into the DB by just applying some SQL. Insertion works just fine, but the TVServer throws out my inserted record with the following message: [I]2012-06-14 21:40:33.265625 [scheduler thread(30)]: Scheduler: Orphaned once schedule found 333 - removing[/I] The SQL statement looks like this. [I] insert into schedule (idChannel, scheduleType, programName, startTime, endTime, ... )[/I] [I] select idChannel, '0' , title, startTime, endTime, ... [/I] [I] from program where description like ... ; [/I] My suspicion is the field "schedule.id..." , which is an autoincrement. Does TVServer perhaps remember this value internally ? Background: I wanted to create a very lightweight recording filter using simple search mechanisms in the programs database without the hassle of plugins (like "ForTheRecord") or whatever. If somebody knows another pragmatic, simple way to insert recordings, I would be thankful. Thanks /Gerd [/QUOTE]

Verification