Reply to thread

Message

<blockquote data-quote="Midget" data-source="post: 223111" data-attributes="member: 57489">Only 2 errors and not related to the message box showing up in the console, I think it's related to service's start:Error: StatementErrorUnclassifiedGentle.Common.GentleException: select top 100 GuideProgramId, GuideChannelId, Title, StartTime, StopTime, SubTitle, Description, Category, IsRepeat, IsPremiere, VideoAspect, SeriesNumber, EpisodeNumberDisplay, EpisodeNumber, EpisodeNumberTotal, EpisodePart, EpisodePartTotal, Rating, StarRating, Director, Actors, LastModifiedTime, IsDeleted, Version from GuideProgram where Title = @Title and () and IsDeleted = @IsDeleted and StopTime &gt;= @StopTime order by StartTime; ---&gt; System.Data.SqlClient.SqlException: Sintassi non corretta in prossimità di ')'.I want to be sure not to lost schedule data. Do you know any trick ? (could I dump the TvSchedule table to disk ?)Well, I've changed the grabber in WebEPGConf. I think the new grabber had different channel names that match same MediaPortal channels (generic example: Channel1 -&gt; ChannelOne -&gt; Channel-1)When importing new tvguide.xml file in TvScheduler, the console showed duplicate channels with same names (in both TV Guide and TV Channels pages) but no error messages. To discriminate between old and new channels I've examined guide data and deleted old channels from TV Channels page. Returning in the TV Guide page I've got the &quot;error on database: concurrent change made by another user?&quot; message (not exactly, but the meaning is this).With SQL server management console I've tried to clean the db from channels references. I've emptied all the tables leaving only Configuration, DbVersion and TvSchedule. Then I've tried to re-import tvguide.xml file and now in any console page I'm getting the error message &quot;the server was unable to process the request due to an internal error...&quot;Thank you for support <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" /></blockquote>

[QUOTE="Midget, post: 223111, member: 57489"] Only 2 errors and not related to the message box showing up in the console, I think it's related to service's start: Error: StatementErrorUnclassified Gentle.Common.GentleException: select top 100 GuideProgramId, GuideChannelId, Title, StartTime, StopTime, SubTitle, Description, Category, IsRepeat, IsPremiere, VideoAspect, SeriesNumber, EpisodeNumberDisplay, EpisodeNumber, EpisodeNumberTotal, EpisodePart, EpisodePartTotal, Rating, StarRating, Director, Actors, LastModifiedTime, IsDeleted, Version from GuideProgram where Title = @Title and () and IsDeleted = @IsDeleted and StopTime >= @StopTime order by StartTime; ---> System.Data.SqlClient.SqlException: Sintassi non corretta in prossimità di ')'. I want to be sure not to lost schedule data. Do you know any trick ? (could I dump the TvSchedule table to disk ?) Well, I've changed the grabber in WebEPGConf. I think the new grabber had different channel names that match same MediaPortal channels (generic example: Channel1 -> ChannelOne -> Channel-1) When importing new tvguide.xml file in TvScheduler, the console showed duplicate channels with same names (in both TV Guide and TV Channels pages) but no error messages. To discriminate between old and new channels I've examined guide data and deleted old channels from TV Channels page. Returning in the TV Guide page I've got the "error on database: concurrent change made by another user?" message (not exactly, but the meaning is this). With SQL server management console I've tried to clean the db from channels references. I've emptied all the tables leaving only Configuration, DbVersion and TvSchedule. Then I've tried to re-import tvguide.xml file and now in any console page I'm getting the error message "the server was unable to process the request due to an internal error..." Thank you for support ;) [/QUOTE]

Verification