Reply to thread

Message

<blockquote data-quote="Remco" data-source="post: 893718" data-attributes="member: 122113">Repair is gelukt:C:\Program Files\MySQL\MySQL Server 5.1\bin&gt; mysqlcheck mptvdb ---u root -pEnter password: ***********mptvdb.canceledschedule&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.card&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.cardgroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.cardgroupmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.channelwarning&nbsp; : 3 clients are using or haven't closed the table properstatus&nbsp;&nbsp; : OKmptvdb.channelgroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.channellinkagemap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.channelmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.conflict&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.diseqcmotor&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.favorite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.groupmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.historywarning&nbsp; : 1 client is using or hasn't closed the table properlystatus&nbsp;&nbsp; : OKmptvdb.keyword&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.keywordmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.pendingdeletion&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.personaltvguidemap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.programwarning&nbsp; : Table is marked as crashedwarning&nbsp; : 5 clients are using or haven't closed the table properwarning&nbsp; : Found 908468 deleted space in delete link chain. Shoulerror&nbsp; &nbsp; : Found more than the expected 5832 deleted rows in deleerror&nbsp; &nbsp; : record delete-link-chain corruptederror&nbsp; &nbsp; : Corruptmptvdb.radiochannelgroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.radiogroupmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.recording&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.satellite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.schedule&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.server&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.setting&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.softwareencoder&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OKmptvdb.timespan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.tuningdetail&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.tvmoviemapping&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OKmptvdb.version&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; OK&nbsp;Repairing tablesmptvdb.programwarning&nbsp; : Number of rows changed from 21194 to 21175status&nbsp;&nbsp; : OK&nbsp;C:\Program Files\MySQL\MySQL Server 5.1\bin&gt;&nbsp;&nbsp;Maar nu heb ik issue's met decoderen van de kanalen. Nieuwe uitdaging. iemand advies[DOUBLEPOST=1345750709][/DOUBLEPOST]dit is volgens mij het probleem.. nu de oplossing nog.2012-08-23 21:28:19.710061 [(19)]: **************************************************2012-08-23 21:28:19.711061 [(19)]: ***** SIGNAL LEVEL: 100, SIGNAL QUALITY: 100 *****2012-08-23 21:28:19.713062 [(19)]: **************************************************2012-08-23 21:28:19.714062 [(19)]: card: tuned user: epg subchannel: 02012-08-23 21:28:19.715062 [(19)]: user:epg add2012-08-23 21:28:19.719062 [DVB EPG timer(4)]: Controller: GrabEpg on card ID == 22012-08-23 21:28:19.726062 [DVB EPG timer(4)]: dvb:grab epg...2012-08-23 21:28:21.059138 [scheduler thread(14)]: scheduler: SchedulerWorker inner exception Error: DeveloperErrorUnclassifiedGentle.Common.GentleException: The columns idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating in table Program do not exist.&nbsp;&nbsp; at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)&nbsp;&nbsp; at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)&nbsp;&nbsp; at Gentle.Common.Check.Fail(Error error, Object[] args)&nbsp;&nbsp; at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)&nbsp;&nbsp; at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)&nbsp;&nbsp; at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)&nbsp;&nbsp; at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)&nbsp;&nbsp; at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)&nbsp;&nbsp; at TvDatabase.Channel.GetProgramAt(DateTime date, String title)&nbsp;&nbsp; at TvService.Scheduler.IsTimeToRecordWeeklyEveryTimeOnThisChannel(Schedule schedule, DateTime currentTime)&nbsp;&nbsp; at TvService.Scheduler.IsTimeToRecord(Schedule schedule, DateTime currentTime, RecordingDetail&amp; newRecording)&nbsp;&nbsp; at TvService.Scheduler.StartAnyDueRecordings()&nbsp;&nbsp; at TvService.Scheduler.DoScheduleWork()&nbsp;&nbsp; at TvService.Scheduler.SchedulerWorker()2012-08-23 21:28:21.483163 [Digital Devices CiMenuHandler(21)]: Menu received (ID 3 Type 1 Choices 2)2012-08-23 21:28:36.115796 [scheduler thread(14)]: scheduler: SchedulerWorker inner exception Error: DeveloperErrorUnclassifiedGentle.Common.GentleException: The columns idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating in table Program do not exist.&nbsp;&nbsp; at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)&nbsp;&nbsp; at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)&nbsp;&nbsp; at Gentle.Common.Check.Fail(Error error, Object[] args)&nbsp;&nbsp; at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)&nbsp;&nbsp; at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)&nbsp;&nbsp; at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)&nbsp;&nbsp; at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)&nbsp;&nbsp; at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)&nbsp;&nbsp; at TvDatabase.Channel.GetProgramAt(DateTime date, String title)&nbsp;&nbsp; at TvService.Scheduler.IsTimeToRecordWeeklyEveryTimeOnThisChannel(Schedule schedule, DateTime currentTime)&nbsp;&nbsp; at TvService.Scheduler.IsTimeToRecord(Schedule schedule, DateTime currentTime, RecordingDetail&amp; newRecording)&nbsp;&nbsp; at TvService.Scheduler.StartAnyDueRecordings()&nbsp;&nbsp; at TvService.Scheduler.DoScheduleWork()&nbsp;&nbsp; at TvService.Scheduler.SchedulerWorker()</blockquote>

[QUOTE="Remco, post: 893718, member: 122113"] Repair is gelukt: C:\Program Files\MySQL\MySQL Server 5.1\bin> mysqlcheck mptvdb -- -u root -p Enter password: *********** mptvdb.canceledschedule OK mptvdb.card OK mptvdb.cardgroup OK mptvdb.cardgroupmap OK mptvdb.channel warning : 3 clients are using or haven't closed the table proper status : OK mptvdb.channelgroup OK mptvdb.channellinkagemap OK mptvdb.channelmap OK mptvdb.conflict OK mptvdb.diseqcmotor OK mptvdb.favorite OK mptvdb.groupmap OK mptvdb.history warning : 1 client is using or hasn't closed the table properly status : OK mptvdb.keyword OK mptvdb.keywordmap OK mptvdb.pendingdeletion OK mptvdb.personaltvguidemap OK mptvdb.program warning : Table is marked as crashed warning : 5 clients are using or haven't closed the table proper warning : Found 908468 deleted space in delete link chain. Shoul error : Found more than the expected 5832 deleted rows in dele error : record delete-link-chain corrupted error : Corrupt mptvdb.radiochannelgroup OK mptvdb.radiogroupmap OK mptvdb.recording OK mptvdb.satellite OK mptvdb.schedule OK mptvdb.server OK mptvdb.setting OK mptvdb.softwareencoder OK mptvdb.timespan OK mptvdb.tuningdetail OK mptvdb.tvmoviemapping OK mptvdb.version OK Repairing tables mptvdb.program warning : Number of rows changed from 21194 to 21175 status : OK C:\Program Files\MySQL\MySQL Server 5.1\bin> Maar nu heb ik issue's met decoderen van de kanalen. Nieuwe uitdaging. iemand advies[DOUBLEPOST=1345750709][/DOUBLEPOST]dit is volgens mij het probleem.. nu de oplossing nog. 2012-08-23 21:28:19.710061 [(19)]: ************************************************** 2012-08-23 21:28:19.711061 [(19)]: ***** SIGNAL LEVEL: 100, SIGNAL QUALITY: 100 ***** 2012-08-23 21:28:19.713062 [(19)]: ************************************************** 2012-08-23 21:28:19.714062 [(19)]: card: tuned user: epg subchannel: 0 2012-08-23 21:28:19.715062 [(19)]: user:epg add 2012-08-23 21:28:19.719062 [DVB EPG timer(4)]: Controller: GrabEpg on card ID == 2 2012-08-23 21:28:19.726062 [DVB EPG timer(4)]: dvb:grab epg... 2012-08-23 21:28:21.059138 [scheduler thread(14)]: scheduler: SchedulerWorker inner exception Error: DeveloperErrorUnclassified Gentle.Common.GentleException: The columns idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating in table Program do not exist. at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg) at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args) at Gentle.Common.Check.Fail(Error error, Object[] args) at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map) at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type) at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type) at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator) at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type) at TvDatabase.Channel.GetProgramAt(DateTime date, String title) at TvService.Scheduler.IsTimeToRecordWeeklyEveryTimeOnThisChannel(Schedule schedule, DateTime currentTime) at TvService.Scheduler.IsTimeToRecord(Schedule schedule, DateTime currentTime, RecordingDetail& newRecording) at TvService.Scheduler.StartAnyDueRecordings() at TvService.Scheduler.DoScheduleWork() at TvService.Scheduler.SchedulerWorker() 2012-08-23 21:28:21.483163 [Digital Devices CiMenuHandler(21)]: Menu received (ID 3 Type 1 Choices 2) 2012-08-23 21:28:36.115796 [scheduler thread(14)]: scheduler: SchedulerWorker inner exception Error: DeveloperErrorUnclassified Gentle.Common.GentleException: The columns idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating in table Program do not exist. at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg) at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args) at Gentle.Common.Check.Fail(Error error, Object[] args) at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map) at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type) at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type) at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator) at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type) at TvDatabase.Channel.GetProgramAt(DateTime date, String title) at TvService.Scheduler.IsTimeToRecordWeeklyEveryTimeOnThisChannel(Schedule schedule, DateTime currentTime) at TvService.Scheduler.IsTimeToRecord(Schedule schedule, DateTime currentTime, RecordingDetail& newRecording) at TvService.Scheduler.StartAnyDueRecordings() at TvService.Scheduler.DoScheduleWork() at TvService.Scheduler.SchedulerWorker() [/QUOTE]

Verification