API tools faq
paste
Advertisement
Guest User

Ido Diamant

a guest
Feb 23rd, 2010
172
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.08 KB | None | 0 0
raw download clone embed print report
  1. 2010-02-23 17:54:56.594216 [SetupTv(1)]: ---- SetupTv v1.0.5.25080 is starting up on Windows7 [6.1.7600.0] ----
  2. 2010-02-23 17:54:56.599216 [SetupTv(1)]: ---- check connection with database ----
  3. 2010-02-23 17:54:59.164220 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - MySQL
  4. 2010-02-23 17:54:59.164220 [SetupTv(1)]: ---- check if database needs to be updated/created ----
  5. 2010-02-23 17:55:01.419223 [SetupTv(1)]: ---- create database ----
  6. 2010-02-23 17:55:03.684226 [SetupTv(1)]: Exec SQL: DROP DATABASE IF EXISTS MpTvDb;CREATE DATABASE IF NOT EXISTS MpTvDb;USE MpTvDb;
  7. 2010-02-23 17:55:03.689226 [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;
  8. 2010-02-23 17:55:03.719226 [SetupTv(1)]: 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;
  9. 2010-02-23 17:55:03.754226 [SetupTv(1)]: 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;
  10. 2010-02-23 17:55:03.789226 [SetupTv(1)]: 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;
  11. 2010-02-23 17:55:03.819226 [SetupTv(1)]: 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;
  12. 2010-02-23 17:55:03.849226 [SetupTv(1)]: 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;
  13. 2010-02-23 17:55:03.879226 [SetupTv(1)]: 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;
  14. 2010-02-23 17:55:03.914226 [SetupTv(1)]: 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;
  15. 2010-02-23 17:55:03.959226 [SetupTv(1)]: 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;
  16. 2010-02-23 17:55:03.994226 [SetupTv(1)]: 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;
  17. 2010-02-23 17:55:04.024226 [SetupTv(1)]: 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;
  18. 2010-02-23 17:55:04.074227 [SetupTv(1)]: 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;
  19. 2010-02-23 17:55:04.109227 [SetupTv(1)]: 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;
  20. 2010-02-23 17:55:04.154227 [SetupTv(1)]: 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;
  21. 2010-02-23 17:55:04.184227 [SetupTv(1)]: 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;
  22. 2010-02-23 17:55:04.244227 [SetupTv(1)]: 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;
  23. 2010-02-23 17:55:04.314227 [SetupTv(1)]: 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;
  24. 2010-02-23 17:55:04.384227 [SetupTv(1)]: 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;
  25. 2010-02-23 17:55:04.444227 [SetupTv(1)]: 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;
  26. 2010-02-23 17:55:04.504227 [SetupTv(1)]: 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;
  27. 2010-02-23 17:55:04.569227 [SetupTv(1)]: 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;
  28. 2010-02-23 17:55:04.629227 [SetupTv(1)]: 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;
  29. 2010-02-23 17:55:04.629227 [SetupTv(1)]: ********* SQL statement failed! *********
  30. 2010-02-23 17:55:04.629227 [SetupTv(1)]: ********* Error reason: BLOB/TEXT column 'programName' used in key specification without a key length
  31. 2010-02-23 17:55:04.629227 [SetupTv(1)]: ********* Error code: 1170 *********
  32. 2010-02-23 17:55:04.629227 [SetupTv(1)]: 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;
  33. 2010-02-23 17:55:04.684227 [SetupTv(1)]: 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;
  34. 2010-02-23 17:55:04.754227 [SetupTv(1)]: 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;
  35. 2010-02-23 17:55:04.804228 [SetupTv(1)]: 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;
  36. 2010-02-23 17:55:04.884228 [SetupTv(1)]: 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;
  37. 2010-02-23 17:55:04.934228 [SetupTv(1)]: 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;
  38. 2010-02-23 17:55:04.989228 [SetupTv(1)]: Exec SQL: INSERT INTO `Version` (`idVersion`,`versionNumber`) VALUES(1,38);
  39.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!