Peter Russ kirjoitti: > --- Original Nachricht --- > Absender: Tapio Markula > Datum: 06.04.2009 21:13: >> Hi >> >> I can't create new pages >> >> As default this is 0 and I have defined a new valid value with a >> constant. >> >> 2: SQL error: 'Incorrect integer value: '' for column 'storage_pid' at >> row 1' (pages:NEW49da544b6bea4) > > <joke> > I can't fly. Everytime I try I see a blue screen with lot of stars and > then sudden black. > </joke> > > Sorry. Tapio. Isn't there more information available on this as you know > that there are so many factors... But you should know.
I just tried to create new pages - all trials failed. I used compare tool and made some dump from another Typo3 4.2.6 installation as comparison. Except order the data structure was the same for the table 'pages. CREATE TABLE `pages` ( `uid` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) DEFAULT '0', `tstamp` int(11) unsigned NOT NULL DEFAULT '0', `sorting` int(11) unsigned NOT NULL DEFAULT '0', `deleted` tinyint(1) unsigned DEFAULT '0', `perms_userid` int(11) unsigned NOT NULL DEFAULT '0', `perms_groupid` int(11) unsigned NOT NULL DEFAULT '0', `perms_user` tinyint(4) unsigned NOT NULL DEFAULT '0', `perms_group` tinyint(4) unsigned NOT NULL DEFAULT '0', `perms_everybody` tinyint(4) unsigned NOT NULL DEFAULT '0', `crdate` int(11) unsigned NOT NULL DEFAULT '0', `cruser_id` int(11) unsigned NOT NULL DEFAULT '0', `title` varchar(255) DEFAULT '', `doktype` tinyint(3) unsigned NOT NULL DEFAULT '0', `TSconfig` text, `storage_pid` int(11) NOT NULL DEFAULT '0', `is_siteroot` tinyint(4) NOT NULL DEFAULT '0', `php_tree_stop` tinyint(4) NOT NULL DEFAULT '0', `tx_impexp_origuid` int(11) NOT NULL DEFAULT '0', `url` varchar(255) DEFAULT '', `hidden` tinyint(4) unsigned NOT NULL DEFAULT '0', `starttime` int(11) unsigned NOT NULL DEFAULT '0', `endtime` int(11) unsigned NOT NULL DEFAULT '0', `urltype` tinyint(4) unsigned NOT NULL DEFAULT '0', `shortcut` int(10) unsigned NOT NULL DEFAULT '0', `shortcut_mode` int(10) unsigned NOT NULL DEFAULT '0', `no_cache` int(10) unsigned NOT NULL DEFAULT '0', `fe_group` varchar(100) DEFAULT '0', `subtitle` varchar(255) DEFAULT '', `layout` tinyint(3) unsigned NOT NULL DEFAULT '0', `target` varchar(20) NOT NULL DEFAULT '', `media` text, `lastUpdated` int(10) unsigned NOT NULL DEFAULT '0', `keywords` varchar(256) NOT NULL DEFAULT ' ', `cache_timeout` int(10) unsigned NOT NULL DEFAULT '0', `newUntil` int(10) unsigned NOT NULL DEFAULT '0', `description` text NOT NULL, `no_search` tinyint(3) unsigned NOT NULL DEFAULT '0', `SYS_LASTCHANGED` int(10) unsigned NOT NULL DEFAULT '0', `abstract` text NOT NULL, `module` varchar(10) NOT NULL DEFAULT '', `extendToSubpages` tinyint(3) unsigned NOT NULL DEFAULT '0', `author` varchar(255) DEFAULT '', `author_email` varchar(80) NOT NULL DEFAULT '', `nav_title` varchar(255) DEFAULT '', `content_from_pid` int(10) unsigned NOT NULL DEFAULT '0', `mount_pid` int(10) unsigned NOT NULL DEFAULT '0', `alias` varchar(32) DEFAULT '', `nav_hide` tinyint(4) NOT NULL DEFAULT '0', `mount_pid_ol` tinyint(4) NOT NULL DEFAULT '0', `t3ver_oid` int(11) DEFAULT '0', `t3ver_id` int(11) DEFAULT '0', `t3ver_label` varchar(30) NOT NULL DEFAULT '', `editlock` tinyint(4) unsigned NOT NULL DEFAULT '0', `l18n_cfg` tinyint(4) NOT NULL DEFAULT '0', `fe_login_mode` tinyint(4) NOT NULL DEFAULT '0', `t3ver_wsid` int(11) NOT NULL DEFAULT '0', `t3ver_state` tinyint(4) NOT NULL DEFAULT '0', `t3ver_stage` tinyint(4) NOT NULL DEFAULT '0', `t3ver_count` int(11) NOT NULL DEFAULT '0', `t3ver_tstamp` int(11) NOT NULL DEFAULT '0', `t3ver_swapmode` tinyint(4) NOT NULL DEFAULT '0', `t3ver_move_id` int(11) NOT NULL DEFAULT '0', `t3_origuid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `alias` (`alias`), KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`), KEY `parent` (`pid`,`sorting`,`deleted`,`hidden`) ) ENGINE=MyISAM AUTO_INCREMENT=1157 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1157 ; `storage_pid` int(11) NOT NULL DEFAULT '0', is ok I changed the field 'keyword' - got complained about missing default value first. _______________________________________________ TYPO3-english mailing list [email protected] http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
