home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
[BUG] TVServer + MySQL error
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="mkoonstra" data-source="post: 415292" data-attributes="member: 69484"><p>There is a problem in the SQL query here. It should use Card in UpperCamelCase, but instead it uses lowercase, which is not the same on Linix based MySQL servers.</p><p></p><p>[CODE]2009-05-05 18:49:35.281250 [SetupTv]: ---- SetupTv v1.0.1.22244 is starting up on Windows XP (Service Pack 3) ----</p><p>2009-05-05 18:49:35.296875 [SetupTv]: ---- check connection with database ----</p><p>2009-05-05 18:49:35.921875 [SetupTv]: ---- ask user for connection details ----</p><p>2009-05-05 18:57:59.953125 [SetupTv]: ---- SetupDatabaseForm: server = 192.168.1.2, local = False</p><p>2009-05-05 18:58:00.296875 [SetupTv]: ---- SetupTv v1.0.1.22244 is starting up on Windows XP (Service Pack 3) ----</p><p>2009-05-05 18:58:00.296875 [SetupTv]: ---- check connection with database ----</p><p>2009-05-05 18:58:05.515625 [SetupTv]: ---- ask user for connection details ----</p><p>2009-05-05 19:02:27.765625 [SetupTv]: ---- SetupDatabaseForm: server = 192.168.1.2, local = False</p><p>2009-05-05 19:02:27.937500 [SetupTv]: ---- SetupTv v1.0.1.22244 is starting up on Windows XP (Service Pack 3) ----</p><p>2009-05-05 19:02:27.937500 [SetupTv]: ---- check connection with database ----</p><p>2009-05-05 19:02:33.312500 [SetupTv]: ---- check if database needs to be updated/created ----</p><p>2009-05-05 19:02:38.359375 [SetupTv]: ---- create database ----</p><p>2009-05-05 19:02:43.515625 [SetupTv]: Exec SQL: DROP DATABASE IF EXISTS MpTvDb;CREATE DATABASE IF NOT EXISTS MpTvDb;USE MpTvDb;</p><p>2009-05-05 19:02:43.515625 [SetupTv]: 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;</p><p>2009-05-05 19:02:43.609375 [SetupTv]: Exec SQL: CREATE TABLE `Card` (`idCard` int(11) NOT NULL auto_increment,`devicePath` varchar(2000) NOT NULL,`name` varchar(200) NOT NULL,`priority` int(11) NOT NULL,`grabEPG` bit(1) NOT NULL,`lastEpgGrab` datetime NOT NULL,`recordingFolder` varchar(256) NOT NULL,`idServer` int(11) NOT NULL,`enabled` bit(1) NOT NULL,`camType` int(11) NOT NULL,`timeshiftingFolder` varchar(256) NOT NULL,`recordingFormat` int(11) NOT NULL,`decryptLimit` int(11) NOT NULL,PRIMARY KEY (`idCard`),KEY `FK_Card_Server` (`idServer`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.625000 [SetupTv]: Exec SQL: CREATE TABLE `CardGroup` (`idCardGroup` int(11) NOT NULL auto_increment,`name` varchar(255) NOT NULL,PRIMARY KEY (`idCardGroup`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.625000 [SetupTv]: Exec SQL: CREATE TABLE `CardGroupMap` (`idMapping` int(11) NOT NULL auto_increment,`idCard` int(11) NOT NULL,`idCardGroup` int(11) NOT NULL,PRIMARY KEY (`idMapping`),KEY `FK_CardGroupMap_Card` (`idCard`),KEY `FK_CardGroupMap_CardGroup` (`idCardGroup`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.703125 [SetupTv]: Exec SQL: CREATE TABLE `Channel` (`idChannel` int(11) NOT NULL auto_increment,`name` varchar(200) NOT NULL,`isRadio` bit(1) NOT NULL,`isTv` bit(1) NOT NULL,`timesWatched` int(11) NOT NULL,`totalTimeWatched` datetime NOT NULL,`grabEpg` bit(1) NOT NULL,`lastGrabTime` datetime NOT NULL,`sortOrder` int(11) NOT NULL,`visibleInGuide` bit(1) NOT NULL,`externalId` varchar(200) NOT NULL,`freetoair` bit(1) NOT NULL,`displayName` varchar(200) NOT NULL,`epgHasGaps` bit(1) default NULL,PRIMARY KEY (`idChannel`),KEY `idxChannel` (`isTv`,`sortOrder`),KEY `idxChannelRadio` (`isRadio`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.703125 [SetupTv]: Exec SQL: update Channel set `epgHasGaps`=0;CREATE TABLE `ChannelGroup` (`idGroup` int(11) NOT NULL auto_increment,`groupName` varchar(200) NOT NULL,`sortOrder` int(11) NOT NULL,PRIMARY KEY (`idGroup`),KEY `IDX_ChannelGroup` (`sortOrder`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.718750 [SetupTv]: Exec SQL: CREATE TABLE `ChannelLinkageMap` (`idMapping` int(11) NOT NULL auto_increment,`idPortalChannel` int(11) NOT NULL,`idLinkedChannel` int(11) NOT NULL,PRIMARY KEY (`idMapping`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.718750 [SetupTv]: Exec SQL: CREATE TABLE `ChannelMap` (`idChannelMap` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`idCard` int(11) NOT NULL,`epgOnly` bit(1) default NULL,PRIMARY KEY (`idChannelMap`),KEY `FK_ChannelMap_Cards` (`idCard`),KEY `FK_ChannelMap_Channels` (`idChannel`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.734375 [SetupTv]: Exec SQL: update ChannelMap set `epgOnly`=0;CREATE TABLE `Conflict` (`idConflict` int(11) NOT NULL auto_increment,`idSchedule` int(11) NOT NULL,`idConflictingSchedule` int(11) NOT NULL,`idChannel` int(11) NOT NULL,`conflictDate` datetime NOT NULL,`idCard` int(11) default NULL,PRIMARY KEY (`idConflict`),KEY `FK_Conflict_Channel` (`idChannel`),KEY `FK_Conflict_Schedule` (`idSchedule`),KEY `FK_Conflict_Schedule1` (`idConflictingSchedule`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.750000 [SetupTv]: Exec SQL: CREATE TABLE `DiSEqCMotor` (`idDiSEqCMotor` int(11) NOT NULL auto_increment,`idCard` int(11) NOT NULL,`idSatellite` int(11) NOT NULL,`position` int(11) NOT NULL,PRIMARY KEY (`idDiSEqCMotor`),KEY `FK_DisEqcMotor_Satellite` (`idSatellite`),KEY `FK_DisEqcMotor_Card` (`idCard`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.750000 [SetupTv]: Exec SQL: CREATE TABLE `Favorite` (`idFavorite` int(11) NOT NULL auto_increment,`idProgram` int(11) NOT NULL,`priority` int(11) NOT NULL,`timesWatched` int(11) NOT NULL,PRIMARY KEY (`idFavorite`),KEY `FK_Favorites_Programs` (`idProgram`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.765625 [SetupTv]: Exec SQL: CREATE TABLE `GroupMap` (`idMap` int(11) NOT NULL auto_increment,`idGroup` int(11) NOT NULL,`idChannel` int(11) NOT NULL,`SortOrder` int(11) NOT NULL,PRIMARY KEY (`idMap`),KEY `FK_GroupMap_Channel` (`idChannel`),KEY `FK_GroupMap_ChannelGroup` (`idGroup`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.765625 [SetupTv]: Exec SQL: CREATE TABLE `History` (`idHistory` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`title` varchar(1000) NOT NULL,`description` text NOT NULL,`genre` varchar(1000) NOT NULL,`recorded` bit(1) NOT NULL,`watched` int(11) NOT NULL,PRIMARY KEY (`idHistory`),KEY `FK_History_Channel` (`idChannel`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.859375 [SetupTv]: Exec SQL: CREATE TABLE `Keyword` (`idKeyword` int(11) NOT NULL auto_increment,`keywordName` varchar(200) NOT NULL,`rating` int(11) NOT NULL,`autoRecord` bit(1) NOT NULL,`searchIn` int(11) NOT NULL,PRIMARY KEY (`idKeyword`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.875000 [SetupTv]: Exec SQL: CREATE TABLE `KeywordMap` (`idKeywordMap` int(11) NOT NULL auto_increment,`idKeyword` int(11) NOT NULL,`idChannelGroup` int(11) NOT NULL,PRIMARY KEY (`idKeywordMap`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.890625 [SetupTv]: Exec SQL: CREATE TABLE `PersonalTVGuideMap` (`idPersonalTVGuideMap` int(11) NOT NULL auto_increment,`idKeyword` int(11) NOT NULL,`idProgram` int(11) NOT NULL,PRIMARY KEY (`idPersonalTVGuideMap`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.890625 [SetupTv]: Exec SQL: CREATE TABLE `Program` (`idProgram` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`title` varchar(2000) NOT NULL,`description` text NOT NULL,`seriesNum` varchar(200) NOT NULL,`episodeNum` varchar(200) NOT NULL,`genre` varchar(200) NOT NULL,`originalAirDate` datetime NOT NULL,`classification` varchar(200) NOT NULL,`starRating` int(11) NOT NULL,`notify` bit(1) NOT NULL,`parentalRating` int(11) NOT NULL,PRIMARY KEY (`idProgram`),UNIQUE KEY `idProgramBeginEnd` (`idChannel`,`startTime`,`endTime`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.906250 [SetupTv]: Exec SQL: CREATE TABLE `RadioChannelGroup` (`idGroup` int(11) NOT NULL auto_increment,`groupName` varchar(200) NOT NULL,`sortOrder` int(11) NOT NULL,PRIMARY KEY (`idGroup`),KEY `IDX_RadioChannelGroup` (`sortOrder`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.906250 [SetupTv]: Exec SQL: CREATE TABLE `RadioGroupMap` (`idMap` int(11) NOT NULL auto_increment,`idGroup` int(11) NOT NULL,`idChannel` int(11) NOT NULL,`SortOrder` int(11) NOT NULL,PRIMARY KEY (`idMap`),KEY `FK_RadioGroupMap_Channel` (`idChannel`),KEY `FK_RadioGroupMap_ChannelGroup` (`idGroup`),KEY `IDX_RadioGroupMap_SortOrder` (`SortOrder`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.921875 [SetupTv]: Exec SQL: CREATE TABLE `Recording` (`idRecording` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`title` varchar(2000) NOT NULL,`description` varchar(8000) NOT NULL,`genre` varchar(200) NOT NULL,`fileName` varchar(1024) NOT NULL,`keepUntil` int(11) NOT NULL,`keepUntilDate` datetime NOT NULL,`timesWatched` int(11) NOT NULL,`idServer` int(11) NOT NULL,`stopTime` int(11) NOT NULL,PRIMARY KEY (`idRecording`),KEY `FK_Recording_Server` (`idServer`),KEY `FK_Recordings_Channels` (`idChannel`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.937500 [SetupTv]: Exec SQL: CREATE TABLE `Satellite` (`idSatellite` int(11) NOT NULL auto_increment,`satelliteName` varchar(200) NOT NULL,`transponderFileName` varchar(200) NOT NULL,PRIMARY KEY (`idSatellite`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.937500 [SetupTv]: Exec SQL: CREATE TABLE `Schedule` (`id_Schedule` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`scheduleType` int(11) NOT NULL,`programName` varchar(256) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`maxAirings` int(11) NOT NULL,`priority` int(11) NOT NULL,`directory` varchar(1024) NOT NULL,`quality` int(11) NOT NULL,`keepMethod` int(11) NOT NULL,`keepDate` datetime NOT NULL,`preRecordInterval` int(11) NOT NULL,`postRecordInterval` int(11) NOT NULL,`canceled` datetime NOT NULL,`recommendedCard` int(11) NOT NULL,PRIMARY KEY (`id_Schedule`),KEY `FK_Schedule_Channel` (`idChannel`),KEY `IDX_Schedule_ScheduleType` (`scheduleType`),KEY `IDX_Schedule_ProgramName` (`programName`),KEY `IDX_Schedule_StartTime` (`startTime`),KEY `IDX_Schedule_EndTime` (`endTime`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.953125 [SetupTv]: Exec SQL: CREATE TABLE `Server` (`idServer` int(11) NOT NULL auto_increment,`isMaster` bit(1) NOT NULL,`hostName` varchar(256) NOT NULL,PRIMARY KEY (`idServer`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.953125 [SetupTv]: Exec SQL: CREATE TABLE `Setting` (`idSetting` int(11) NOT NULL auto_increment,`tag` varchar(200) NOT NULL,`value` varchar(4096) NOT NULL,PRIMARY KEY (`idSetting`),KEY `IDX_Setting_Tag` (`tag`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:43.968750 [SetupTv]: Exec SQL: CREATE TABLE `Timespan` (`idTimespan` int(11) NOT NULL auto_increment,`idKeyword` int(11) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`dayOfWeek` int(11) NOT NULL,PRIMARY KEY (`idTimespan`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:44.000000 [SetupTv]: Exec SQL: CREATE TABLE `TuningDetail` (`idTuning` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`name` varchar(200) NOT NULL,`provider` varchar(200) NOT NULL,`channelType` int(11) NOT NULL,`channelNumber` int(11) NOT NULL,`frequency` int(11) NOT NULL,`countryId` int(11) NOT NULL,`isRadio` bit(1) NOT NULL,`isTv` bit(1) NOT NULL,`networkId` int(11) NOT NULL,`transportId` int(11) NOT NULL,`serviceId` int(11) NOT NULL,`pmtPid` int(11) NOT NULL,`freeToAir` bit(1) NOT NULL,`modulation` int(11) NOT NULL,`polarisation` int(11) NOT NULL,`symbolrate` int(11) NOT NULL,`diseqc` int(11) NOT NULL,`switchingFrequency` int(11) NOT NULL,`bandwidth` int(11) NOT NULL,`majorChannel` int(11) NOT NULL,`minorChannel` int(11) NOT NULL,`pcrPid` int(11) NOT NULL,`videoSource` int(11) NOT NULL,`tuningSource` int(11) NOT NULL,`videoPid` int(11) NOT NULL,`audioPid` int(11) NOT NULL,`band` int(11) NOT NULL,`satIndex` int(11) NOT NULL,`innerFecRate` int(11) NOT NULL,`pilot` int(11) NOT NULL,`rollOff` int(11) NOT NULL,`url` varchar(200) NOT NULL,`bitrate` int(11) NOT NULL,PRIMARY KEY (`idTuning`),KEY `IDX_TuningDetail1` (`idChannel`),KEY `IDX_TuningDetail_Edit` (`networkId`,`transportId`,`serviceId`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:44.031250 [SetupTv]: Exec SQL: CREATE TABLE `TvMovieMapping` (`idMapping` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`stationName` varchar(200) NOT NULL,`timeSharingStart` varchar(200) NOT NULL,`timeSharingEnd` varchar(200) NOT NULL,PRIMARY KEY (`idMapping`),KEY `FK_TvMovieMapping_Channel` (`idChannel`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:44.062500 [SetupTv]: Exec SQL: CREATE TABLE `Version` (`idVersion` int(11) NOT NULL auto_increment,`versionNumber` int(11) NOT NULL,PRIMARY KEY (`idVersion`)) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>2009-05-05 19:02:44.093750 [SetupTv]: Exec SQL: INSERT INTO `Version` (`idVersion`,`versionNumber`) VALUES(1,38);</p><p>2009-05-05 19:02:44.093750 [SetupTv]: - Database created.</p><p>2009-05-05 19:02:44.109375 [SetupTv]: ---- upgrade database schema ----</p><p>2009-05-05 19:02:44.125000 [SetupTv]: Exec SQL: USE MpTvDb;ALTER TABLE `card`ADD COLUMN `preload` bit(1) NOT NULL;UPDATE `Version` SET `versionNumber`=39;</p><p>2009-05-05 19:02:44.125000 [SetupTv]: ********* SQL statement failed! *********</p><p>2009-05-05 19:02:44.125000 [SetupTv]: ********* Error reason: Table 'MpTvDb.card' doesn't exist</p><p>2009-05-05 19:02:44.125000 [SetupTv]: ********* Error code: 1146 *********</p><p>2009-05-05 19:04:48.484375 [SetupTv]: ---- SetupTv v1.0.1.22244 is starting up on Windows XP (Service Pack 3) ----</p><p>2009-05-05 19:04:48.484375 [SetupTv]: ---- check connection with database ----</p><p>2009-05-05 19:04:53.812500 [SetupTv]: ---- check if database needs to be updated/created ----</p><p>2009-05-05 19:04:58.906250 [SetupTv]: ---- upgrade database schema ----</p><p>2009-05-05 19:05:04.015625 [SetupTv]: Exec SQL: USE MpTvDb;ALTER TABLE `card`ADD COLUMN `preload` bit(1) NOT NULL;UPDATE `Version` SET `versionNumber`=39;</p><p>2009-05-05 19:05:04.015625 [SetupTv]: ********* SQL statement failed! *********</p><p>2009-05-05 19:05:04.015625 [SetupTv]: ********* Error reason: Table 'MpTvDb.card' doesn't exist</p><p>2009-05-05 19:05:04.015625 [SetupTv]: ********* Error code: 1146 *********</p><p>[/CODE]</p></blockquote><p></p>
[QUOTE="mkoonstra, post: 415292, member: 69484"] There is a problem in the SQL query here. It should use Card in UpperCamelCase, but instead it uses lowercase, which is not the same on Linix based MySQL servers. [CODE]2009-05-05 18:49:35.281250 [SetupTv]: ---- SetupTv v1.0.1.22244 is starting up on Windows XP (Service Pack 3) ---- 2009-05-05 18:49:35.296875 [SetupTv]: ---- check connection with database ---- 2009-05-05 18:49:35.921875 [SetupTv]: ---- ask user for connection details ---- 2009-05-05 18:57:59.953125 [SetupTv]: ---- SetupDatabaseForm: server = 192.168.1.2, local = False 2009-05-05 18:58:00.296875 [SetupTv]: ---- SetupTv v1.0.1.22244 is starting up on Windows XP (Service Pack 3) ---- 2009-05-05 18:58:00.296875 [SetupTv]: ---- check connection with database ---- 2009-05-05 18:58:05.515625 [SetupTv]: ---- ask user for connection details ---- 2009-05-05 19:02:27.765625 [SetupTv]: ---- SetupDatabaseForm: server = 192.168.1.2, local = False 2009-05-05 19:02:27.937500 [SetupTv]: ---- SetupTv v1.0.1.22244 is starting up on Windows XP (Service Pack 3) ---- 2009-05-05 19:02:27.937500 [SetupTv]: ---- check connection with database ---- 2009-05-05 19:02:33.312500 [SetupTv]: ---- check if database needs to be updated/created ---- 2009-05-05 19:02:38.359375 [SetupTv]: ---- create database ---- 2009-05-05 19:02:43.515625 [SetupTv]: Exec SQL: DROP DATABASE IF EXISTS MpTvDb;CREATE DATABASE IF NOT EXISTS MpTvDb;USE MpTvDb; 2009-05-05 19:02:43.515625 [SetupTv]: 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; 2009-05-05 19:02:43.609375 [SetupTv]: Exec SQL: CREATE TABLE `Card` (`idCard` int(11) NOT NULL auto_increment,`devicePath` varchar(2000) NOT NULL,`name` varchar(200) NOT NULL,`priority` int(11) NOT NULL,`grabEPG` bit(1) NOT NULL,`lastEpgGrab` datetime NOT NULL,`recordingFolder` varchar(256) NOT NULL,`idServer` int(11) NOT NULL,`enabled` bit(1) NOT NULL,`camType` int(11) NOT NULL,`timeshiftingFolder` varchar(256) NOT NULL,`recordingFormat` int(11) NOT NULL,`decryptLimit` int(11) NOT NULL,PRIMARY KEY (`idCard`),KEY `FK_Card_Server` (`idServer`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.625000 [SetupTv]: Exec SQL: CREATE TABLE `CardGroup` (`idCardGroup` int(11) NOT NULL auto_increment,`name` varchar(255) NOT NULL,PRIMARY KEY (`idCardGroup`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.625000 [SetupTv]: Exec SQL: CREATE TABLE `CardGroupMap` (`idMapping` int(11) NOT NULL auto_increment,`idCard` int(11) NOT NULL,`idCardGroup` int(11) NOT NULL,PRIMARY KEY (`idMapping`),KEY `FK_CardGroupMap_Card` (`idCard`),KEY `FK_CardGroupMap_CardGroup` (`idCardGroup`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.703125 [SetupTv]: Exec SQL: CREATE TABLE `Channel` (`idChannel` int(11) NOT NULL auto_increment,`name` varchar(200) NOT NULL,`isRadio` bit(1) NOT NULL,`isTv` bit(1) NOT NULL,`timesWatched` int(11) NOT NULL,`totalTimeWatched` datetime NOT NULL,`grabEpg` bit(1) NOT NULL,`lastGrabTime` datetime NOT NULL,`sortOrder` int(11) NOT NULL,`visibleInGuide` bit(1) NOT NULL,`externalId` varchar(200) NOT NULL,`freetoair` bit(1) NOT NULL,`displayName` varchar(200) NOT NULL,`epgHasGaps` bit(1) default NULL,PRIMARY KEY (`idChannel`),KEY `idxChannel` (`isTv`,`sortOrder`),KEY `idxChannelRadio` (`isRadio`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.703125 [SetupTv]: Exec SQL: update Channel set `epgHasGaps`=0;CREATE TABLE `ChannelGroup` (`idGroup` int(11) NOT NULL auto_increment,`groupName` varchar(200) NOT NULL,`sortOrder` int(11) NOT NULL,PRIMARY KEY (`idGroup`),KEY `IDX_ChannelGroup` (`sortOrder`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.718750 [SetupTv]: Exec SQL: CREATE TABLE `ChannelLinkageMap` (`idMapping` int(11) NOT NULL auto_increment,`idPortalChannel` int(11) NOT NULL,`idLinkedChannel` int(11) NOT NULL,PRIMARY KEY (`idMapping`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.718750 [SetupTv]: Exec SQL: CREATE TABLE `ChannelMap` (`idChannelMap` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`idCard` int(11) NOT NULL,`epgOnly` bit(1) default NULL,PRIMARY KEY (`idChannelMap`),KEY `FK_ChannelMap_Cards` (`idCard`),KEY `FK_ChannelMap_Channels` (`idChannel`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.734375 [SetupTv]: Exec SQL: update ChannelMap set `epgOnly`=0;CREATE TABLE `Conflict` (`idConflict` int(11) NOT NULL auto_increment,`idSchedule` int(11) NOT NULL,`idConflictingSchedule` int(11) NOT NULL,`idChannel` int(11) NOT NULL,`conflictDate` datetime NOT NULL,`idCard` int(11) default NULL,PRIMARY KEY (`idConflict`),KEY `FK_Conflict_Channel` (`idChannel`),KEY `FK_Conflict_Schedule` (`idSchedule`),KEY `FK_Conflict_Schedule1` (`idConflictingSchedule`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.750000 [SetupTv]: Exec SQL: CREATE TABLE `DiSEqCMotor` (`idDiSEqCMotor` int(11) NOT NULL auto_increment,`idCard` int(11) NOT NULL,`idSatellite` int(11) NOT NULL,`position` int(11) NOT NULL,PRIMARY KEY (`idDiSEqCMotor`),KEY `FK_DisEqcMotor_Satellite` (`idSatellite`),KEY `FK_DisEqcMotor_Card` (`idCard`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.750000 [SetupTv]: Exec SQL: CREATE TABLE `Favorite` (`idFavorite` int(11) NOT NULL auto_increment,`idProgram` int(11) NOT NULL,`priority` int(11) NOT NULL,`timesWatched` int(11) NOT NULL,PRIMARY KEY (`idFavorite`),KEY `FK_Favorites_Programs` (`idProgram`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.765625 [SetupTv]: Exec SQL: CREATE TABLE `GroupMap` (`idMap` int(11) NOT NULL auto_increment,`idGroup` int(11) NOT NULL,`idChannel` int(11) NOT NULL,`SortOrder` int(11) NOT NULL,PRIMARY KEY (`idMap`),KEY `FK_GroupMap_Channel` (`idChannel`),KEY `FK_GroupMap_ChannelGroup` (`idGroup`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.765625 [SetupTv]: Exec SQL: CREATE TABLE `History` (`idHistory` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`title` varchar(1000) NOT NULL,`description` text NOT NULL,`genre` varchar(1000) NOT NULL,`recorded` bit(1) NOT NULL,`watched` int(11) NOT NULL,PRIMARY KEY (`idHistory`),KEY `FK_History_Channel` (`idChannel`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.859375 [SetupTv]: Exec SQL: CREATE TABLE `Keyword` (`idKeyword` int(11) NOT NULL auto_increment,`keywordName` varchar(200) NOT NULL,`rating` int(11) NOT NULL,`autoRecord` bit(1) NOT NULL,`searchIn` int(11) NOT NULL,PRIMARY KEY (`idKeyword`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.875000 [SetupTv]: Exec SQL: CREATE TABLE `KeywordMap` (`idKeywordMap` int(11) NOT NULL auto_increment,`idKeyword` int(11) NOT NULL,`idChannelGroup` int(11) NOT NULL,PRIMARY KEY (`idKeywordMap`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.890625 [SetupTv]: Exec SQL: CREATE TABLE `PersonalTVGuideMap` (`idPersonalTVGuideMap` int(11) NOT NULL auto_increment,`idKeyword` int(11) NOT NULL,`idProgram` int(11) NOT NULL,PRIMARY KEY (`idPersonalTVGuideMap`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.890625 [SetupTv]: Exec SQL: CREATE TABLE `Program` (`idProgram` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`title` varchar(2000) NOT NULL,`description` text NOT NULL,`seriesNum` varchar(200) NOT NULL,`episodeNum` varchar(200) NOT NULL,`genre` varchar(200) NOT NULL,`originalAirDate` datetime NOT NULL,`classification` varchar(200) NOT NULL,`starRating` int(11) NOT NULL,`notify` bit(1) NOT NULL,`parentalRating` int(11) NOT NULL,PRIMARY KEY (`idProgram`),UNIQUE KEY `idProgramBeginEnd` (`idChannel`,`startTime`,`endTime`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.906250 [SetupTv]: Exec SQL: CREATE TABLE `RadioChannelGroup` (`idGroup` int(11) NOT NULL auto_increment,`groupName` varchar(200) NOT NULL,`sortOrder` int(11) NOT NULL,PRIMARY KEY (`idGroup`),KEY `IDX_RadioChannelGroup` (`sortOrder`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.906250 [SetupTv]: Exec SQL: CREATE TABLE `RadioGroupMap` (`idMap` int(11) NOT NULL auto_increment,`idGroup` int(11) NOT NULL,`idChannel` int(11) NOT NULL,`SortOrder` int(11) NOT NULL,PRIMARY KEY (`idMap`),KEY `FK_RadioGroupMap_Channel` (`idChannel`),KEY `FK_RadioGroupMap_ChannelGroup` (`idGroup`),KEY `IDX_RadioGroupMap_SortOrder` (`SortOrder`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.921875 [SetupTv]: Exec SQL: CREATE TABLE `Recording` (`idRecording` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`title` varchar(2000) NOT NULL,`description` varchar(8000) NOT NULL,`genre` varchar(200) NOT NULL,`fileName` varchar(1024) NOT NULL,`keepUntil` int(11) NOT NULL,`keepUntilDate` datetime NOT NULL,`timesWatched` int(11) NOT NULL,`idServer` int(11) NOT NULL,`stopTime` int(11) NOT NULL,PRIMARY KEY (`idRecording`),KEY `FK_Recording_Server` (`idServer`),KEY `FK_Recordings_Channels` (`idChannel`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.937500 [SetupTv]: Exec SQL: CREATE TABLE `Satellite` (`idSatellite` int(11) NOT NULL auto_increment,`satelliteName` varchar(200) NOT NULL,`transponderFileName` varchar(200) NOT NULL,PRIMARY KEY (`idSatellite`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.937500 [SetupTv]: Exec SQL: CREATE TABLE `Schedule` (`id_Schedule` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`scheduleType` int(11) NOT NULL,`programName` varchar(256) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`maxAirings` int(11) NOT NULL,`priority` int(11) NOT NULL,`directory` varchar(1024) NOT NULL,`quality` int(11) NOT NULL,`keepMethod` int(11) NOT NULL,`keepDate` datetime NOT NULL,`preRecordInterval` int(11) NOT NULL,`postRecordInterval` int(11) NOT NULL,`canceled` datetime NOT NULL,`recommendedCard` int(11) NOT NULL,PRIMARY KEY (`id_Schedule`),KEY `FK_Schedule_Channel` (`idChannel`),KEY `IDX_Schedule_ScheduleType` (`scheduleType`),KEY `IDX_Schedule_ProgramName` (`programName`),KEY `IDX_Schedule_StartTime` (`startTime`),KEY `IDX_Schedule_EndTime` (`endTime`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.953125 [SetupTv]: Exec SQL: CREATE TABLE `Server` (`idServer` int(11) NOT NULL auto_increment,`isMaster` bit(1) NOT NULL,`hostName` varchar(256) NOT NULL,PRIMARY KEY (`idServer`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.953125 [SetupTv]: Exec SQL: CREATE TABLE `Setting` (`idSetting` int(11) NOT NULL auto_increment,`tag` varchar(200) NOT NULL,`value` varchar(4096) NOT NULL,PRIMARY KEY (`idSetting`),KEY `IDX_Setting_Tag` (`tag`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:43.968750 [SetupTv]: Exec SQL: CREATE TABLE `Timespan` (`idTimespan` int(11) NOT NULL auto_increment,`idKeyword` int(11) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`dayOfWeek` int(11) NOT NULL,PRIMARY KEY (`idTimespan`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:44.000000 [SetupTv]: Exec SQL: CREATE TABLE `TuningDetail` (`idTuning` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`name` varchar(200) NOT NULL,`provider` varchar(200) NOT NULL,`channelType` int(11) NOT NULL,`channelNumber` int(11) NOT NULL,`frequency` int(11) NOT NULL,`countryId` int(11) NOT NULL,`isRadio` bit(1) NOT NULL,`isTv` bit(1) NOT NULL,`networkId` int(11) NOT NULL,`transportId` int(11) NOT NULL,`serviceId` int(11) NOT NULL,`pmtPid` int(11) NOT NULL,`freeToAir` bit(1) NOT NULL,`modulation` int(11) NOT NULL,`polarisation` int(11) NOT NULL,`symbolrate` int(11) NOT NULL,`diseqc` int(11) NOT NULL,`switchingFrequency` int(11) NOT NULL,`bandwidth` int(11) NOT NULL,`majorChannel` int(11) NOT NULL,`minorChannel` int(11) NOT NULL,`pcrPid` int(11) NOT NULL,`videoSource` int(11) NOT NULL,`tuningSource` int(11) NOT NULL,`videoPid` int(11) NOT NULL,`audioPid` int(11) NOT NULL,`band` int(11) NOT NULL,`satIndex` int(11) NOT NULL,`innerFecRate` int(11) NOT NULL,`pilot` int(11) NOT NULL,`rollOff` int(11) NOT NULL,`url` varchar(200) NOT NULL,`bitrate` int(11) NOT NULL,PRIMARY KEY (`idTuning`),KEY `IDX_TuningDetail1` (`idChannel`),KEY `IDX_TuningDetail_Edit` (`networkId`,`transportId`,`serviceId`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:44.031250 [SetupTv]: Exec SQL: CREATE TABLE `TvMovieMapping` (`idMapping` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`stationName` varchar(200) NOT NULL,`timeSharingStart` varchar(200) NOT NULL,`timeSharingEnd` varchar(200) NOT NULL,PRIMARY KEY (`idMapping`),KEY `FK_TvMovieMapping_Channel` (`idChannel`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:44.062500 [SetupTv]: Exec SQL: CREATE TABLE `Version` (`idVersion` int(11) NOT NULL auto_increment,`versionNumber` int(11) NOT NULL,PRIMARY KEY (`idVersion`)) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 2009-05-05 19:02:44.093750 [SetupTv]: Exec SQL: INSERT INTO `Version` (`idVersion`,`versionNumber`) VALUES(1,38); 2009-05-05 19:02:44.093750 [SetupTv]: - Database created. 2009-05-05 19:02:44.109375 [SetupTv]: ---- upgrade database schema ---- 2009-05-05 19:02:44.125000 [SetupTv]: Exec SQL: USE MpTvDb;ALTER TABLE `card`ADD COLUMN `preload` bit(1) NOT NULL;UPDATE `Version` SET `versionNumber`=39; 2009-05-05 19:02:44.125000 [SetupTv]: ********* SQL statement failed! ********* 2009-05-05 19:02:44.125000 [SetupTv]: ********* Error reason: Table 'MpTvDb.card' doesn't exist 2009-05-05 19:02:44.125000 [SetupTv]: ********* Error code: 1146 ********* 2009-05-05 19:04:48.484375 [SetupTv]: ---- SetupTv v1.0.1.22244 is starting up on Windows XP (Service Pack 3) ---- 2009-05-05 19:04:48.484375 [SetupTv]: ---- check connection with database ---- 2009-05-05 19:04:53.812500 [SetupTv]: ---- check if database needs to be updated/created ---- 2009-05-05 19:04:58.906250 [SetupTv]: ---- upgrade database schema ---- 2009-05-05 19:05:04.015625 [SetupTv]: Exec SQL: USE MpTvDb;ALTER TABLE `card`ADD COLUMN `preload` bit(1) NOT NULL;UPDATE `Version` SET `versionNumber`=39; 2009-05-05 19:05:04.015625 [SetupTv]: ********* SQL statement failed! ********* 2009-05-05 19:05:04.015625 [SetupTv]: ********* Error reason: Table 'MpTvDb.card' doesn't exist 2009-05-05 19:05:04.015625 [SetupTv]: ********* Error code: 1146 ********* [/CODE] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
[BUG] TVServer + MySQL error
Contact us
RSS
Top
Bottom
