[TYPO3-english] Problem with Typo3 4.2.6

[Tapio Markula]

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.