[BUG] TVServer + MySQL error (1 Viewer)

mkoonstra · May 5, 2009

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 *********

rtv · May 6, 2009

Sorry - even with that glitch fixed you won't be able to use the TV-Server using an improperly configured MySQL server.

mkoonstra · May 6, 2009

Am I right when I draw the conclusion that MP says: "It won't work anyway, so we won't fix it anyway"? If this is true, then I am very disappointed in the MP developers.

Thus, describe what "an improperly configured MySQL server" actually means.

rtv · May 6, 2009

Actually the scripts are already fixed...

Your my.cnf's mysqld section should have this line:

lower_case_table_names=1

if you want to host the tvdb on a unix mysql server (which is working nicely here).

[BUG] TVServer + MySQL error (1 Viewer)

mkoonstra

Portal Member

rtv

Retired Team Member

mkoonstra

Portal Member

rtv

Retired Team Member

Users who are viewing this thread