Reply to thread

Message: <blockquote data-quote="Scrounger" data-source="post: 862247" data-attributes="member: 87610">Hi, i have a strange behaviour in my plugins. I use the following manual SQL string to create a table in Tv Server Database. I tested it with standard MP MySql Server. But some people from the community has problems using MsSql2008. The strang thing is, that it works for a tvserver plugin, for a MP plugin not ?! Call[CODE]Broker.Execute(SQLstring)[/CODE] Tv Movie EPG Import++ (TvServer plugin) - works both (MySql, MsSql2008)[CODE]CREATE  TABLE `mptvdb`.`TVMovieProgram` ( `idTVMovieProgram` INT NOT NULL AUTO_INCREMENT , `idProgram` INT NOT NULL DEFAULT 0 , `TVMovieBewertung` INT NOT NULL DEFAULT 0 , `FanArt` VARCHAR(255) , `idSeries` INT NOT NULL DEFAULT 0 , `SeriesPosterImage` VARCHAR(255) , `idEpisode` VARCHAR(15) , `EpisodeImage` VARCHAR(255) , `local` BIT(1) NOT NULL DEFAULT 0 , `idMovingPictures` INT NOT NULL DEFAULT 0 , `idVideo` INT NOT NULL DEFAULT 0 , `KurzKritik` VARCHAR(255) , `BildDateiname` VARCHAR(32) , `Cover` VARCHAR(512) , `Fun` INT NOT NULL DEFAULT 0 , `Action` INT NOT NULL DEFAULT 0 , `Feelings` INT NOT NULL DEFAULT 0 , `Erotic` INT NOT NULL DEFAULT 0 , `Tension` INT NOT NULL DEFAULT 0 , `Requirement` INT NOT NULL DEFAULT 0 , `Actors` TEXT , `needsUpdate` BIT(1) NOT NULL DEFAULT 1 , `Dolby` BIT(1) NOT NULL DEFAULT 0 , `HDTV` BIT(1) NOT NULL DEFAULT 0 , `Country` VARCHAR(50) , `Regie` VARCHAR(50) , `Year` DATETIME NOT NULL , `Describtion` TEXT , `ShortDescribtion` TEXT , PRIMARY KEY (`idTVMovieProgram`) )[/CODE] Clickfinder ProgramGuide (MP plugin) - works not for MsSql2008[CODE]CREATE TABLE mptvdb.ClickfinderCategories ( idClickfinderCategories INT NOT NULL AUTO_INCREMENT , Name VARCHAR(255) , Beschreibung VARCHAR(255) , isVisible BIT(1) NOT NULL DEFAULT 0 , Image VARCHAR(255) , SqlString TEXT , sortOrder INT NOT NULL DEFAULT 0 , MinRunTime INT NOT NULL DEFAULT 0 , NowOffset INT NOT NULL DEFAULT 0 , sortedBy VARCHAR(100) , groupName VARCHAR(100) , PRIMARY KEY (idClickfinderCategories) )[/CODE] Anyone has an idea what could be the reason for this? Or is there a way to use directly the gentle.framwork class to create tables. An example would be very useful <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile    :)" loading="lazy" data-shortname=":)" />Thx.</blockquote>

Verification