Reply to thread

Message

<blockquote data-quote="RonD" data-source="post: 883758" data-attributes="member: 117536">Toch,&nbsp;Looked at the tv.log file and see a number of SQL database messages that look like errors but I'm not an SQL expert. My guess is the MePo WebEPG engine is working correctly but somehow the TV Server database is having problems. We need to get a &quot;MePo SQL guru&quot; to take a look. The SQL guru may want more complete error logs, see log file wiki for info. <a href="http://wiki.team-mediaportal.com/1_MEDIAPORTAL_1/16_Support/3_Forums/2_Log_Files" target="_blank">http://wiki.team-mediaportal.com/1_MEDIAPORTAL_1/16_Support/3_Forums/2_Log_Files</a>&nbsp;I'm not a SQL expert but the following types of messages do not look good,2012-07-01 21:42:03.300229 [SetupTv(1)]:&nbsp;&nbsp; Exec SQL: CREATE TABLE `CanceledSchedule` (`idCanceledSchedule` int(11) NOT NULL auto_increment,`idSchedule` int(11) NOT NULL,`cancelDateTime` datetime NOT NULL,PRIMARY KEY&nbsp; (`idCanceledSchedule`),KEY `FK_CanceledSchedule_Schedule` (`idSchedule`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</blockquote>

[QUOTE="RonD, post: 883758, member: 117536"] Toch, Looked at the tv.log file and see a number of SQL database messages that look like errors but I'm not an SQL expert. My guess is the MePo WebEPG engine is working correctly but somehow the TV Server database is having problems. We need to get a "MePo SQL guru" to take a look. The SQL guru may want more complete error logs, see log file wiki for info. [url]http://wiki.team-mediaportal.com/1_MEDIAPORTAL_1/16_Support/3_Forums/2_Log_Files[/url] I'm not a SQL expert but the following types of messages do not look good, 2012-07-01 21:42:03.300229 [SetupTv(1)]: Exec SQL: CREATE TABLE `CanceledSchedule` (`idCanceledSchedule` int(11) NOT NULL auto_increment,`idSchedule` int(11) NOT NULL,`cancelDateTime` datetime NOT NULL,PRIMARY KEY (`idCanceledSchedule`),KEY `FK_CanceledSchedule_Schedule` (`idSchedule`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; [/QUOTE]

Verification