Reply to thread

Message

<blockquote data-quote="Aquarius" data-source="post: 874916" data-attributes="member: 10507">@mmThanks for taking care.&nbsp;Now, ... I have a problem ... It works ! <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />&nbsp;What I did ? I stopped TvService to make a DB-dump and restarted and TVService did not complain about anything.The upmentioned error message &quot; Orphaned once schedule found &quot; did not appear any more. The recording was scheduled and executed.&nbsp;Thanks for your support, perhaps some magic behind.&nbsp;For those who like to do the same, here is my little SQl-statement to insert a scheduled recording without any add-on. Just with what MP already supplies. This SQL statement is inserts a&nbsp; one time schedule not bound to any TV-card, searching in programs title or - descriptiontext for keywords or sentence.&nbsp;Add this line to a file e.g. UpdateEPG.sql &nbsp;[CODE]-- Start with :-- mysql.exe -u root -pMediaPortal -h localhost --verbose &lt;UpdateEPG.sql 1&gt;UpdateEPG.log-- MySQL :: MySQL 5.5 Reference Manual :: 4.5.1 mysql — The MySQL Command-Line Tool-- http://dev.mysql.com/doc/refman//5.5/en/batch-commands.htmlUSE mptvdbinsert into schedule (idChannel, scheduleType, programName, startTime, endTime, maxAirings, priority, directory, quality, keepMethod, keepDate, preRecordInterval, postRecordInterval, canceled, recommendedCard, series, idParentSchedule)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; select idChannel,&nbsp; '0', title, startTime, endTime, 2147483647, 0, '', 73, 0, '2000-01-01 00:00:00.0', 0,5,&quot;2000-01-01 00:00:00.0&quot;,-1,0,-1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; from program&nbsp; where&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; title like&nbsp; '%your search pattern here%'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; or description&nbsp; &nbsp; like&nbsp; '%your search pattern here%'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; or title like&nbsp; '%another earch pattern%'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; or description&nbsp; &nbsp; like&nbsp; '%another search pattern%'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ;commit;[/CODE]Feel fee to enhance SQL.&nbsp;And execute it it with this line:&nbsp;&quot;C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe&quot; -u root -pMediaPortal -h localhost --verbose &lt; UpdateEPG.sql &gt;UpdateEPG.log&nbsp;Add this line to a CMD - file (adjust the path to MySQL) and add it to Windows- Scheduler.That's it. Easy and flexible.&nbsp;Good luck !&nbsp;RegardsGerd</blockquote>

[QUOTE="Aquarius, post: 874916, member: 10507"] @mm Thanks for taking care. Now, ... I have a problem ... It works ! :) What I did ? I stopped TvService to make a DB-dump and restarted and TVService did not complain about anything. The upmentioned error message "[I] Orphaned once schedule found " [/I]did not appear any more. The recording was scheduled and executed. Thanks for your support, perhaps some magic behind. For those who like to do the same, here is my little SQl-statement to insert a scheduled recording without any add-on. Just with what MP already supplies. This SQL statement is inserts a one time schedule not bound to any TV-card, searching in programs title or - descriptiontext for keywords or sentence. Add this line to a file e.g. [I]UpdateEPG.sql [/I] [CODE]-- Start with : -- mysql.exe -u root -pMediaPortal -h localhost --verbose <UpdateEPG.sql 1>UpdateEPG.log -- MySQL :: MySQL 5.5 Reference Manual :: 4.5.1 mysql — The MySQL Command-Line Tool -- http://dev.mysql.com/doc/refman//5.5/en/batch-commands.html USE mptvdb insert into schedule (idChannel, scheduleType, programName, startTime, endTime, maxAirings, priority, directory, quality, keepMethod, keepDate, preRecordInterval, postRecordInterval, canceled, recommendedCard, series, idParentSchedule) select idChannel, '0', title, startTime, endTime, 2147483647, 0, '', 73, 0, '2000-01-01 00:00:00.0', 0,5,"2000-01-01 00:00:00.0",-1,0,-1 from program where title like '%your search pattern here%' or description like '%your search pattern here%' or title like '%another earch pattern%' or description like '%another search pattern%' ; commit; [/CODE] Feel fee to enhance SQL. And execute it it with this line: [I]"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe" -u root -pMediaPortal -h localhost --verbose < UpdateEPG.sql >UpdateEPG.log[/I] Add this line to a CMD - file (adjust the path to MySQL) and add it to Windows- Scheduler. That's it. Easy and flexible. Good luck ! Regards Gerd [/QUOTE]

Verification