[TYPO3-german] tt_address und Update auf TYPO3 4.2.6

[Gaspers]

Hallo,

beim Update auf TYPO3 4.2.6 wird Compare für tt_address nicht ausgeführt.
Es sind Daten in der Tabelle.


Lösung:
Tabelle gesichert
Create geandert (  `uid` int(11) NOT NULL auto_increment, und   PRIMARY KEY 
(`uid`), eingefügt)
Create ausgeführt
Daten zurück geschrieben

Gibt es einen besseren Weg, muss leider ein paar Server Updaten.

Gruß
Bernd


INSERT DELAYED INTO `tt_address` (`tx_cal_controller_isorganizer`, 
`tx_cal_controller_islocation`, `tx_cal_controller_latitude`, 
`tx_cal_controller_longitude`, `pid`, `tstamp`, `hidden`, `name`, 
`first_name`, `middle_name`, `last_name`, `title`, `email`, `phone`, 
`mobile`, `www`, `address`, `company`, `city`, `zip`, `region`, `country`, 
`image`, `fax`, `deleted`, `description`, `addressgroup`, 
`module_sys_dmail_category`, `module_sys_dmail_html`, 
`tx_dfdirectmailsubscription_gender`) VALUES
(0, 0, '', '', 0, 0, 0, 'Nachname', 'Vorname', '', '', '', 'E-Mail', 
'Telefonnummer', 'Mobilfunknummer', '', 'Straße', '', 'Ort', 'PLZ', '', '', 
'', '', 0, '', 0, 0, 0, 0),



CREATE TABLE IF NOT EXISTS `tt_address` (
  `uid` int(11) NOT NULL auto_increment,
  `tx_cal_controller_isorganizer` tinyint(4) NOT NULL default '0',
  `tx_cal_controller_islocation` tinyint(4) NOT NULL default '0',
  `tx_cal_controller_latitude` tinytext NOT NULL,
  `tx_cal_controller_longitude` tinytext NOT NULL,
  `pid` int(11) unsigned NOT NULL default '0',
  `tstamp` int(11) unsigned NOT NULL default '0',
  `hidden` tinyint(4) unsigned NOT NULL default '0',
  `name` tinytext NOT NULL,
  `first_name` tinytext NOT NULL,
  `middle_name` tinytext NOT NULL,
  `last_name` tinytext NOT NULL,
  `title` varchar(40) NOT NULL default '',
  `email` varchar(80) NOT NULL default '',
  `phone` varchar(30) NOT NULL default '',
  `mobile` varchar(30) NOT NULL default '',
  `www` varchar(80) NOT NULL default '',
  `address` tinytext NOT NULL,
  `company` varchar(80) NOT NULL default '',
  `city` varchar(80) NOT NULL default '',
  `zip` varchar(20) NOT NULL default '',
  `region` varchar(100) NOT NULL default '',
  `country` varchar(100) NOT NULL default '',
  `image` tinyblob NOT NULL,
  `fax` varchar(30) NOT NULL default '',
  `deleted` tinyint(3) unsigned NOT NULL default '0',
  `description` text NOT NULL,
  `addressgroup` int(11) NOT NULL default '0',
  `module_sys_dmail_category` int(10) unsigned NOT NULL default '0',
  `module_sys_dmail_html` tinyint(3) unsigned NOT NULL default '0',
  `tx_dfdirectmailsubscription_gender` int(11) NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  KEY `parent` (`pid`),
  KEY `pid` (`pid`,`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;