Datenbank voll - tl_content nimmt keine weiteren Felder an
Nun gut, der Thematitel ist etwas übertrieben. Denn bestimmte Felder sind durchaus noch möglich.
Ich habe heute eine eigene Erweiterung auf den Server kopiert und das Datenbank-Update in der Erweiterungsverwaltung aufgerufen. Contao verabschiedete sich und im error.log stand Folgendes:
Code:
[11-Sep-2014 10:29:41 Europe/Berlin] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs (ALTER TABLE `tl_content` ADD `adresse_zusatz` varchar(255) NOT NULL default '';)' thrown in /kunden/***/system/modules/core/library/Contao/Database/Statement.php on line 282
Was will er von mir fragte ich mich und ging im Browser eine Seite zurück. Von meinen 5 Feldern waren noch 3 in die tl_content einzutragen. Also wiederholt - selbe Fehlermeldung. Ich habe dann varchar auf 240 gesetzt - selber Fehler. Mit 128 klappte es dann. Den DCA meiner Erweiterung habe ich entsprechend angepaßt und dann erstmal gegoogelt. Nachdem ich zuvor versucht hatte das Feld direkt in phpMyAdmin einzutragen. Auch dort derselbe Fehler.
Ich hatte heute schon auf dem Berliner Stammtisch darüber gesprochen und keiner kannte bisher so eine Fehlermeldung. Neue Felder als VARCHAR(255) anlegen, geht nicht. Als Typ TEXT aber sehr wohl.
Hier mal die Tabellenstruktur:
Code:
CREATE TABLE `tl_content` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`ptable` varchar(64) NOT NULL DEFAULT '',
`sorting` int(10) unsigned NOT NULL DEFAULT '0',
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`type` varchar(32) NOT NULL DEFAULT '',
`headline` varchar(255) NOT NULL DEFAULT '',
`text` mediumtext,
`addImage` char(1) NOT NULL DEFAULT '',
`singleSRC` varchar(255) NOT NULL DEFAULT '',
`alt` varchar(255) NOT NULL DEFAULT '',
`title` varchar(255) NOT NULL DEFAULT '',
`size` varchar(64) NOT NULL DEFAULT '',
`imagemargin` varchar(128) NOT NULL DEFAULT '',
`imageUrl` varchar(255) NOT NULL DEFAULT '',
`fullsize` char(1) NOT NULL DEFAULT '',
`caption` varchar(255) NOT NULL DEFAULT '',
`floating` varchar(32) NOT NULL DEFAULT '',
`html` mediumtext,
`listtype` varchar(32) NOT NULL DEFAULT '',
`listitems` blob,
`tableitems` mediumblob,
`summary` varchar(255) NOT NULL DEFAULT '',
`thead` char(1) NOT NULL DEFAULT '',
`tfoot` char(1) NOT NULL DEFAULT '',
`tleft` char(1) NOT NULL DEFAULT '',
`sortable` char(1) NOT NULL DEFAULT '',
`sortIndex` smallint(5) unsigned NOT NULL DEFAULT '0',
`sortOrder` varchar(32) NOT NULL DEFAULT '',
`mooHeadline` varchar(255) NOT NULL DEFAULT '',
`mooStyle` varchar(255) NOT NULL DEFAULT '',
`mooClasses` varchar(255) NOT NULL DEFAULT '',
`highlight` varchar(32) NOT NULL DEFAULT '',
`shClass` varchar(255) NOT NULL DEFAULT '',
`code` text,
`url` varchar(255) NOT NULL DEFAULT '',
`target` char(1) NOT NULL DEFAULT '',
`titleText` varchar(255) NOT NULL DEFAULT '',
`linkTitle` varchar(255) NOT NULL DEFAULT '',
`embed` varchar(255) NOT NULL DEFAULT '',
`rel` varchar(64) NOT NULL DEFAULT '',
`useImage` char(1) NOT NULL DEFAULT '',
`multiSRC` blob,
`orderSRC` text,
`useHomeDir` char(1) NOT NULL DEFAULT '',
`perRow` smallint(5) unsigned NOT NULL DEFAULT '0',
`perPage` smallint(5) unsigned NOT NULL DEFAULT '0',
`numberOfItems` smallint(5) unsigned NOT NULL DEFAULT '0',
`sortBy` varchar(32) NOT NULL DEFAULT '',
`galleryTpl` varchar(64) NOT NULL DEFAULT '',
`playerSRC` blob,
`youtube` varchar(16) NOT NULL DEFAULT '',
`posterSRC` varchar(255) NOT NULL DEFAULT '',
`playerSize` varchar(64) NOT NULL DEFAULT '',
`autoplay` char(1) NOT NULL DEFAULT '',
`cteAlias` int(10) unsigned NOT NULL DEFAULT '0',
`articleAlias` int(10) unsigned NOT NULL DEFAULT '0',
`article` int(10) unsigned NOT NULL DEFAULT '0',
`form` int(10) unsigned NOT NULL DEFAULT '0',
`module` int(10) unsigned NOT NULL DEFAULT '0',
`protected` char(1) NOT NULL DEFAULT '',
`groups` blob,
`guests` char(1) NOT NULL DEFAULT '',
`cssID` varchar(255) NOT NULL DEFAULT '',
`space` varchar(64) NOT NULL DEFAULT '',
`invisible` char(1) NOT NULL DEFAULT '',
`start` varchar(10) NOT NULL DEFAULT '',
`stop` varchar(10) NOT NULL DEFAULT '',
`com_order` varchar(32) NOT NULL DEFAULT '',
`com_perPage` smallint(5) unsigned NOT NULL DEFAULT '0',
`com_moderate` char(1) NOT NULL DEFAULT '',
`com_bbcode` char(1) NOT NULL DEFAULT '',
`com_disableCaptcha` char(1) NOT NULL DEFAULT '',
`com_requireLogin` char(1) NOT NULL DEFAULT '',
`com_template` varchar(32) NOT NULL DEFAULT '',
`pgn_piecesize` int(10) unsigned NOT NULL DEFAULT '46',
`pgn_pieceset` varchar(255) NOT NULL DEFAULT '',
`pgn_file` varchar(255) NOT NULL DEFAULT '',
`pgn_pause` int(10) unsigned NOT NULL DEFAULT '800',
`pgn_moveformat` varchar(255) NOT NULL DEFAULT '',
`pgn_boardfirst` char(1) NOT NULL DEFAULT '',
`pgn_backlink` char(1) NOT NULL DEFAULT '',
`pgn_coordinates` char(1) NOT NULL DEFAULT '',
`pgn_autoscroll` char(1) NOT NULL DEFAULT '',
`pgn_gamestat` varchar(255) NOT NULL DEFAULT '',
`tagsonly` char(1) NOT NULL DEFAULT '',
`tags` char(1) NOT NULL DEFAULT '',
`fen_code` varchar(255) NOT NULL DEFAULT '',
`fen_figurensatz` varchar(255) NOT NULL DEFAULT '',
`fen_figurengroesse` int(10) unsigned NOT NULL DEFAULT '35',
`fen_untertitel` varchar(255) NOT NULL DEFAULT '',
`fen_koordinaten` char(1) NOT NULL DEFAULT '',
`fen_brettdrehen` char(1) NOT NULL DEFAULT '',
`fen_rand` char(1) NOT NULL DEFAULT '',
`fen_randbreite` int(1) unsigned NOT NULL DEFAULT '1',
`fen_randfarbe` varchar(6) NOT NULL DEFAULT '',
`fen_farbeweiss` varchar(6) NOT NULL DEFAULT '',
`fen_farbeschwarz` varchar(6) NOT NULL DEFAULT '',
`fen_text` text,
`fen_textfluss` varchar(255) NOT NULL DEFAULT '',
`chesstable_csv` text,
`chesstable_file` varchar(255) NOT NULL DEFAULT '',
`chesstable_namendrehen` char(1) NOT NULL DEFAULT '',
`chesstable_lightbox` char(1) NOT NULL DEFAULT '',
`chesstable_linktext` varchar(255) NOT NULL DEFAULT '',
`sliderDelay` int(10) unsigned NOT NULL DEFAULT '0',
`sliderSpeed` int(10) unsigned NOT NULL DEFAULT '300',
`sliderStartSlide` smallint(5) unsigned NOT NULL DEFAULT '0',
`sliderContinuous` char(1) NOT NULL DEFAULT '',
`pa2Album` int(10) unsigned NOT NULL DEFAULT '0',
`pa2ImageViewTemplate` varchar(64) NOT NULL DEFAULT '',
`pa2ImagesTemplate` varchar(64) NOT NULL DEFAULT '',
`pa2ImagesShowHeadline` char(1) NOT NULL DEFAULT '',
`pa2ImagesShowTitle` char(1) NOT NULL DEFAULT '',
`pa2ImagesShowTeaser` char(1) NOT NULL DEFAULT '',
`pa2ImagesImageSize` varchar(64) NOT NULL DEFAULT '',
`pa2ImagesImageMargin` varchar(128) NOT NULL DEFAULT '',
`pa2ImagesPerRow` smallint(5) unsigned NOT NULL DEFAULT '2',
`pa2ImagesPerPage` smallint(5) unsigned NOT NULL DEFAULT '24',
`pa2NumberOfImages` smallint(5) unsigned NOT NULL DEFAULT '0',
`pa2ImagesShowMetaDescriptions` char(1) NOT NULL DEFAULT '',
`pa2ImagesMetaFields` blob,
`pa2TimeFilter` char(1) NOT NULL DEFAULT '',
`pa2TimeFilterStart` varchar(64) NOT NULL DEFAULT '',
`pa2TimeFilterEnd` varchar(64) NOT NULL DEFAULT '',
`pa2Teaser` int(10) unsigned NOT NULL DEFAULT '0',
`usemap` varchar(64) NOT NULL DEFAULT '',
`pgn_download` char(1) NOT NULL DEFAULT '',
`pgn_titleText` varchar(255) NOT NULL DEFAULT '',
`pgn_linkTitle` varchar(255) NOT NULL DEFAULT '',
`tag_filter` varchar(255) NOT NULL DEFAULT '',
`tag_ignore` char(1) NOT NULL DEFAULT '',
`remark_icon` varchar(255) NOT NULL DEFAULT 'info',
`poll` int(10) unsigned NOT NULL DEFAULT '0',
`poll_current` char(1) NOT NULL DEFAULT '',
`dlh_googlemap` int(10) unsigned NOT NULL DEFAULT '0',
`dlh_googlemap_zoom` int(10) unsigned NOT NULL DEFAULT '0',
`dlh_googlemap_size` varchar(255) NOT NULL DEFAULT '',
`dlh_googlemap_static` char(1) NOT NULL DEFAULT '',
`dlh_googlemap_url` varchar(255) NOT NULL DEFAULT '',
`simple_columns` char(3) NOT NULL DEFAULT '',
`simple_columns_rowspan` int(10) unsigned NOT NULL DEFAULT '0',
`simple_columns_close` char(1) NOT NULL DEFAULT '',
`simple_columns_wrapper` char(1) NOT NULL DEFAULT '',
`simple_columns_autoheight` char(1) NOT NULL DEFAULT '',
`simple_columns_border` char(1) NOT NULL DEFAULT '',
`ical_calendar` blob,
`ical_prefix` varchar(128) NOT NULL DEFAULT '',
`ical_start` varchar(12) NOT NULL DEFAULT '',
`ical_end` varchar(12) NOT NULL DEFAULT '',
`movie_controls` char(1) NOT NULL DEFAULT '',
`movie_preload` char(1) NOT NULL DEFAULT '',
`movie_autoplay` char(1) NOT NULL DEFAULT '',
`movie_loop` char(1) NOT NULL DEFAULT '',
`movie_width` varchar(5) NOT NULL DEFAULT '',
`movie_height` varchar(5) NOT NULL DEFAULT '',
`movie_preview` varchar(255) NOT NULL DEFAULT '',
`movie_webm` varchar(255) NOT NULL DEFAULT '',
`movie_mp4` varchar(255) NOT NULL DEFAULT '',
`movie_ogg` varchar(255) NOT NULL DEFAULT '',
`audio_controls` char(1) NOT NULL DEFAULT '',
`audio_preload` char(1) NOT NULL DEFAULT '',
`audio_autoplay` char(1) NOT NULL DEFAULT '',
`audio_loop` char(1) NOT NULL DEFAULT '',
`audio_webm` varchar(255) NOT NULL DEFAULT '',
`audio_mp3` varchar(255) NOT NULL DEFAULT '',
`audio_ogg` varchar(255) NOT NULL DEFAULT '',
`audio_order` blob,
`movie_order` blob,
`tabType` varchar(32) NOT NULL DEFAULT '',
`tabClasses` varchar(255) NOT NULL DEFAULT '',
`tabBehaviour` varchar(64) NOT NULL DEFAULT '',
`tab_autoplay_autoSlide` char(1) NOT NULL DEFAULT '0',
`tab_autoplay_fade` char(1) NOT NULL DEFAULT '0',
`tab_autoplay_delay` int(10) NOT NULL DEFAULT '2500',
`tabControlCookies` varchar(128) NOT NULL DEFAULT '',
`tab_tabs` blob,
`tab_template` varchar(64) NOT NULL DEFAULT '',
`tab_template_start` varchar(64) NOT NULL DEFAULT '',
`tab_template_stop` varchar(64) NOT NULL DEFAULT '',
`tab_template_end` varchar(64) NOT NULL DEFAULT '',
`tabTitles` blob,
`metamodel_jumpTo` int(10) unsigned NOT NULL DEFAULT '0',
`metamodel` int(10) unsigned NOT NULL DEFAULT '0',
`metamodel_layout` varchar(64) NOT NULL DEFAULT '',
`metamodel_use_limit` char(1) NOT NULL DEFAULT '',
`metamodel_limit` smallint(5) NOT NULL DEFAULT '0',
`metamodel_offset` smallint(5) NOT NULL DEFAULT '0',
`metamodel_sortby` varchar(64) NOT NULL DEFAULT '',
`metamodel_sortby_direction` varchar(4) NOT NULL DEFAULT '',
`metamodel_filtering` int(10) NOT NULL DEFAULT '0',
`metamodel_rendersettings` int(10) NOT NULL DEFAULT '0',
`metamodel_noparsing` char(1) NOT NULL DEFAULT '',
`metamodel_donotindex` char(1) NOT NULL DEFAULT '',
`metamodel_available_values` char(1) NOT NULL DEFAULT '',
`metamodel_filterparams` longblob,
`metamodel_fef_params` blob,
`metamodel_fef_autosubmit` char(1) NOT NULL DEFAULT '',
`metamodel_fef_hideclearfilter` char(1) NOT NULL DEFAULT '',
`metamodel_fef_template` varchar(64) NOT NULL DEFAULT '',
`metamodel_meta_title` varchar(64) NOT NULL DEFAULT '',
`metamodel_meta_description` varchar(64) NOT NULL DEFAULT '',
`dma_eg_data` longtext,
`npsType` varchar(32) NOT NULL DEFAULT '',
`npsSizeMode` varchar(32) NOT NULL DEFAULT '',
`npsWidth` varchar(255) NOT NULL DEFAULT '',
`npsHeight` varchar(255) NOT NULL DEFAULT '',
`npsAdaptiveHeight` char(1) NOT NULL DEFAULT '',
`npsAdaptiveHeightSpeed` varchar(255) NOT NULL DEFAULT '',
`npsSlideMargin` varchar(255) NOT NULL DEFAULT '',
`npsMode` varchar(255) NOT NULL DEFAULT '',
`npsSpeed` varchar(255) NOT NULL DEFAULT '',
`npsInfiniteLoop` char(1) NOT NULL DEFAULT '',
`npsRandomStart` char(1) NOT NULL DEFAULT '',
`npsCaptions` char(1) NOT NULL DEFAULT '',
`npsHideControlOnEnd` char(1) NOT NULL DEFAULT '',
`npsStartSlide` varchar(255) NOT NULL DEFAULT '',
`npsPreloadImages` varchar(255) NOT NULL DEFAULT '',
`npsEnableEasing` char(1) NOT NULL DEFAULT '',
`npsEasingMode` varchar(255) NOT NULL DEFAULT '',
`npsEasing` varchar(255) NOT NULL DEFAULT '',
`npsControls` char(1) NOT NULL DEFAULT '',
`npsPrevText` varchar(255) NOT NULL DEFAULT '',
`npsNextText` varchar(255) NOT NULL DEFAULT '',
`npsPrevImage` varchar(255) NOT NULL DEFAULT '',
`npsNextImage` varchar(255) NOT NULL DEFAULT '',
`npsOwnNavContainer` char(1) NOT NULL DEFAULT '',
`npsPrevSelector` varchar(255) NOT NULL DEFAULT '',
`npsNextSelector` varchar(255) NOT NULL DEFAULT '',
`npsAutoControls` char(1) NOT NULL DEFAULT '',
`npsAutoControlsCombine` char(1) NOT NULL DEFAULT '',
`npsStartText` varchar(255) NOT NULL DEFAULT '',
`npsStopText` varchar(255) NOT NULL DEFAULT '',
`npsTicker` char(1) NOT NULL DEFAULT '',
`npsTickerHover` char(1) NOT NULL DEFAULT '',
`npsUseCSS` char(1) NOT NULL DEFAULT '',
`npsVideo` char(1) NOT NULL DEFAULT '',
`npsAuto` char(1) NOT NULL DEFAULT '',
`npsAutoHover` char(1) NOT NULL DEFAULT '',
`npsAutoStart` char(1) NOT NULL DEFAULT '',
`npsPause` varchar(5) NOT NULL DEFAULT '',
`npsAutoDelay` varchar(5) NOT NULL DEFAULT '',
`npsAutoDirection` varchar(255) NOT NULL DEFAULT '',
`npsDisplaySlide` char(1) NOT NULL DEFAULT '',
`npsMinSlides` char(4) NOT NULL DEFAULT '',
`npsMaxSlides` char(4) NOT NULL DEFAULT '',
`npsMoveSlides` char(4) NOT NULL DEFAULT '',
`npsSlideWidth` char(4) NOT NULL DEFAULT '',
`npsTouchEnabled` char(1) NOT NULL DEFAULT '',
`npsOneToOneTouch` char(1) NOT NULL DEFAULT '',
`npsSwipeThreshold` varchar(255) NOT NULL DEFAULT '',
`npsPreventDefaultSwipeX` char(1) NOT NULL DEFAULT '',
`npsPreventDefaultSwipeY` char(1) NOT NULL DEFAULT '',
`npsPager` char(1) NOT NULL DEFAULT '',
`npsPagerType` varchar(255) NOT NULL DEFAULT '',
`npsPagerShortSeparator` varchar(255) NOT NULL DEFAULT '',
`npsPagerSelector` varchar(255) NOT NULL DEFAULT '',
`npsPagerCustom` varchar(255) NOT NULL DEFAULT '',
`npsCallbacks` char(1) NOT NULL DEFAULT '',
`npsOnSliderLoad` mediumtext,
`npsOnSlideBefore` mediumtext,
`npsOnSlideAfter` mediumtext,
`npsOnSlideNext` mediumtext,
`npsOnSlidePrev` mediumtext,
`npsBuildPager` mediumtext,
`lightboxSocialVideoLink` varchar(255) NOT NULL DEFAULT '',
`lightboxopenonpageload` char(1) NOT NULL DEFAULT '',
`lightboxUseImage` char(1) NOT NULL DEFAULT '',
`lightboximageSRC` varchar(255) NOT NULL DEFAULT '',
`lightboxoverflow` char(1) NOT NULL DEFAULT '',
`lightboxmargin` varchar(128) NOT NULL DEFAULT '',
`lightboxfontcolor` varchar(6) NOT NULL DEFAULT '',
`lightboxbgcolor` varchar(6) NOT NULL DEFAULT '',
`lightboxsize` varchar(64) NOT NULL DEFAULT '',
`lightboxlabel` varchar(64) NOT NULL DEFAULT '',
`lightboxcaption` varchar(255) NOT NULL DEFAULT '',
`lightboxdescription` varchar(255) NOT NULL DEFAULT '',
`chesstable_aufsteiger` varchar(255) NOT NULL DEFAULT '',
`chesstable_absteiger` varchar(255) NOT NULL DEFAULT '',
`chesstable_markieren` varchar(255) NOT NULL DEFAULT '',
`chesstable_flaggen` char(1) NOT NULL DEFAULT '',
`zad_aplayer_capfile` binary(16) DEFAULT NULL,
`tab_remember` char(1) NOT NULL DEFAULT '',
`newslinklist` blob,
`newslinklist_stopdate` varchar(10) NOT NULL DEFAULT '',
`newslinklist_tpl` varchar(32) NOT NULL DEFAULT '',
`adresse_id` int(10) unsigned NOT NULL DEFAULT '0',
`adresse_zusatz` varchar(128) NOT NULL DEFAULT '',
`adresse_funktion` varchar(255) NOT NULL DEFAULT '',
`adresse_tpl` varchar(32) NOT NULL DEFAULT '',
`adresse_viewfoto` char(1) NOT NULL DEFAULT '',
`nitsche` text NOT NULL,
PRIMARY KEY (`id`),
KEY `pid` (`pid`),
KEY `ptable` (`ptable`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18118 ;