REDAXO 3.3 zu 4.3.2

[ReggaePanda]

Hi, ich würde gerne meine alte Redaxo version auf die neueste updaten.
Da aber keine Informationen zu einem Update von 3.3 auf eine höhere vorhanden sind und jeder versuch fehlschlug (es sind keine artikelslices mehr vorhanden) frag ich jetzt hier.



hier die datenbankstruktur der 3.3er Version:

Code: Alles auswählen

CREATE TABLE rex_62_params (
  field_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  title varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  prior int(10) unsigned NOT NULL,
  attributes varchar(255) NOT NULL,
  `type` int(10) unsigned DEFAULT NULL,
  `default` varchar(255) NOT NULL,
  params varchar(255) DEFAULT NULL,
  validate varchar(255) DEFAULT NULL,
  createuser varchar(255) NOT NULL,
  createdate int(11) NOT NULL,
  updateuser varchar(255) NOT NULL,
  updatedate int(11) NOT NULL,
  PRIMARY KEY (field_id),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_62_type'
-- 

CREATE TABLE rex_62_type (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  label varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  dbtype varchar(255) CHARACTER SET utf8 NOT NULL,
  dblength int(11) NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_105_news'
-- 

CREATE TABLE rex_105_news (
  id int(11) NOT NULL AUTO_INCREMENT,
  news_title varchar(255) CHARACTER SET utf8 NOT NULL,
  news_subtitle varchar(255) CHARACTER SET utf8 NOT NULL,
  news_online tinyint(1) NOT NULL DEFAULT '0',
  news_date varchar(10) CHARACTER SET utf8 NOT NULL,
  news_date2 varchar(10) CHARACTER SET utf8 NOT NULL,
  news_text text CHARACTER SET utf8 NOT NULL,
  news_pic varchar(255) CHARACTER SET utf8 NOT NULL,
  news_pic_alt varchar(255) CHARACTER SET utf8 NOT NULL,
  news_pic_title varchar(255) CHARACTER SET utf8 NOT NULL,
  news_pic_css varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_105_newscat'
-- 

CREATE TABLE rex_105_newscat (
  id int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  extras text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_105_n_c'
-- 

CREATE TABLE rex_105_n_c (
  id int(11) NOT NULL AUTO_INCREMENT,
  news_id int(11) NOT NULL,
  cat_id int(11) NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_108_news'
-- 

CREATE TABLE rex_108_news (
  id int(11) NOT NULL AUTO_INCREMENT,
  p_id int(100) NOT NULL DEFAULT '0',
  entry_id int(100) NOT NULL DEFAULT '0',
  clang tinyint(2) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL DEFAULT '0',
  online_from int(11) NOT NULL DEFAULT '0',
  online_to int(11) NOT NULL DEFAULT '0',
  `name` text CHARACTER SET utf8 NOT NULL,
  title text CHARACTER SET utf8 NOT NULL,
  link text CHARACTER SET utf8 NOT NULL,
  teaser text CHARACTER SET utf8 NOT NULL,
  content text CHARACTER SET utf8 NOT NULL,
  `file` text CHARACTER SET utf8 NOT NULL,
  file_description text CHARACTER SET utf8 NOT NULL,
  file_title text CHARACTER SET utf8 NOT NULL,
  location text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(4) NOT NULL,
  updateuser text CHARACTER SET utf8 NOT NULL,
  updatedate int(11) NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_action'
-- 

CREATE TABLE rex_action (
  id int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  preview text CHARACTER SET utf8 NOT NULL,
  presave text CHARACTER SET utf8 NOT NULL,
  postsave text CHARACTER SET utf8 NOT NULL,
  previewmode tinyint(4) NOT NULL,
  presavemode tinyint(4) NOT NULL,
  postsavemode tinyint(4) NOT NULL,
  createuser varchar(255) CHARACTER SET utf8 NOT NULL,
  createdate int(11) NOT NULL,
  updateuser varchar(255) CHARACTER SET utf8 NOT NULL,
  updatedate int(11) NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_article'
-- 

CREATE TABLE rex_article (
  pid int(11) NOT NULL AUTO_INCREMENT,
  id int(11) NOT NULL DEFAULT '0',
  re_id int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  catname varchar(255) CHARACTER SET utf8 NOT NULL,
  catprior int(11) NOT NULL DEFAULT '0',
  description text CHARACTER SET utf8 NOT NULL,
  attributes text CHARACTER SET utf8 NOT NULL,
  `file` text CHARACTER SET utf8 NOT NULL,
  startpage tinyint(1) NOT NULL DEFAULT '0',
  prior int(11) NOT NULL DEFAULT '0',
  path varchar(255) CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  createdate int(11) NOT NULL DEFAULT '0',
  updatedate int(11) NOT NULL DEFAULT '0',
  keywords text CHARACTER SET utf8 NOT NULL,
  template_id int(11) NOT NULL DEFAULT '0',
  clang int(11) NOT NULL DEFAULT '0',
  createuser varchar(255) CHARACTER SET utf8 NOT NULL,
  updateuser varchar(255) CHARACTER SET utf8 NOT NULL,
  label varchar(255) CHARACTER SET utf8 NOT NULL,
  url text CHARACTER SET utf8 NOT NULL,
  art_parameter varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  art_neuflag varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  art_english varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  art_layout varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  art_datum varchar(255) DEFAULT '',
  cat_routing varchar(255) DEFAULT '',
  PRIMARY KEY (pid)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_article_slice'
-- 

CREATE TABLE rex_article_slice (
  id int(11) NOT NULL AUTO_INCREMENT,
  clang int(11) NOT NULL DEFAULT '0',
  ctype int(11) NOT NULL DEFAULT '0',
  re_article_slice_id int(11) NOT NULL DEFAULT '0',
  value1 text CHARACTER SET utf8 NOT NULL,
  value2 text CHARACTER SET utf8 NOT NULL,
  value3 text CHARACTER SET utf8 NOT NULL,
  value4 text CHARACTER SET utf8 NOT NULL,
  value5 text CHARACTER SET utf8 NOT NULL,
  value6 text CHARACTER SET utf8 NOT NULL,
  value7 text CHARACTER SET utf8 NOT NULL,
  value8 text CHARACTER SET utf8 NOT NULL,
  value9 text CHARACTER SET utf8 NOT NULL,
  value10 text CHARACTER SET utf8 NOT NULL,
  value11 text CHARACTER SET utf8 NOT NULL,
  value12 text CHARACTER SET utf8 NOT NULL,
  value13 text CHARACTER SET utf8 NOT NULL,
  value14 text CHARACTER SET utf8 NOT NULL,
  value15 text CHARACTER SET utf8 NOT NULL,
  value16 text CHARACTER SET utf8 NOT NULL,
  value17 text CHARACTER SET utf8 NOT NULL,
  value18 text CHARACTER SET utf8 NOT NULL,
  value19 text CHARACTER SET utf8 NOT NULL,
  value20 text CHARACTER SET utf8 NOT NULL,
  file1 varchar(255) CHARACTER SET utf8 NOT NULL,
  file2 varchar(255) CHARACTER SET utf8 NOT NULL,
  file3 varchar(255) CHARACTER SET utf8 NOT NULL,
  file4 varchar(255) CHARACTER SET utf8 NOT NULL,
  file5 varchar(255) CHARACTER SET utf8 NOT NULL,
  file6 varchar(255) CHARACTER SET utf8 NOT NULL,
  file7 varchar(255) CHARACTER SET utf8 NOT NULL,
  file8 varchar(255) CHARACTER SET utf8 NOT NULL,
  file9 varchar(255) CHARACTER SET utf8 NOT NULL,
  file10 varchar(255) CHARACTER SET utf8 NOT NULL,
  filelist1 text CHARACTER SET utf8 NOT NULL,
  filelist2 text CHARACTER SET utf8 NOT NULL,
  filelist3 text CHARACTER SET utf8 NOT NULL,
  filelist4 text CHARACTER SET utf8 NOT NULL,
  filelist5 text CHARACTER SET utf8 NOT NULL,
  filelist6 text CHARACTER SET utf8 NOT NULL,
  filelist7 text CHARACTER SET utf8 NOT NULL,
  filelist8 text CHARACTER SET utf8 NOT NULL,
  filelist9 text CHARACTER SET utf8 NOT NULL,
  filelist10 text CHARACTER SET utf8 NOT NULL,
  link1 varchar(10) CHARACTER SET utf8 NOT NULL,
  link2 varchar(10) CHARACTER SET utf8 NOT NULL,
  link3 varchar(10) CHARACTER SET utf8 NOT NULL,
  link4 varchar(10) CHARACTER SET utf8 NOT NULL,
  link5 varchar(10) CHARACTER SET utf8 NOT NULL,
  link6 varchar(10) CHARACTER SET utf8 NOT NULL,
  link7 varchar(10) CHARACTER SET utf8 NOT NULL,
  link8 varchar(10) CHARACTER SET utf8 NOT NULL,
  link9 varchar(10) CHARACTER SET utf8 NOT NULL,
  link10 varchar(10) CHARACTER SET utf8 NOT NULL,
  linklist1 text CHARACTER SET utf8 NOT NULL,
  linklist2 text CHARACTER SET utf8 NOT NULL,
  linklist3 text CHARACTER SET utf8 NOT NULL,
  linklist4 text CHARACTER SET utf8 NOT NULL,
  linklist5 text CHARACTER SET utf8 NOT NULL,
  linklist6 text CHARACTER SET utf8 NOT NULL,
  linklist7 text CHARACTER SET utf8 NOT NULL,
  linklist8 text CHARACTER SET utf8 NOT NULL,
  linklist9 text CHARACTER SET utf8 NOT NULL,
  linklist10 text CHARACTER SET utf8 NOT NULL,
  php text CHARACTER SET utf8 NOT NULL,
  html text CHARACTER SET utf8 NOT NULL,
  article_id int(11) NOT NULL DEFAULT '0',
  modultyp_id int(11) NOT NULL DEFAULT '0',
  createdate int(11) NOT NULL DEFAULT '0',
  updatedate int(11) NOT NULL DEFAULT '0',
  createuser varchar(255) CHARACTER SET utf8 NOT NULL,
  updateuser varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (id,re_article_slice_id,article_id,modultyp_id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_clang'
-- 

CREATE TABLE rex_clang (
  id int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_file'
-- 

CREATE TABLE rex_file (
  file_id int(11) NOT NULL AUTO_INCREMENT,
  re_file_id int(11) NOT NULL DEFAULT '0',
  category_id int(11) NOT NULL DEFAULT '0',
  attributes text CHARACTER SET utf8 NOT NULL,
  filetype varchar(255) CHARACTER SET utf8 NOT NULL,
  filename varchar(255) CHARACTER SET utf8 NOT NULL,
  originalname varchar(255) CHARACTER SET utf8 NOT NULL,
  filesize varchar(255) CHARACTER SET utf8 NOT NULL,
  width int(11) NOT NULL DEFAULT '0',
  height int(11) NOT NULL DEFAULT '0',
  title varchar(255) CHARACTER SET utf8 NOT NULL,
  description text CHARACTER SET utf8 NOT NULL,
  copyright varchar(255) CHARACTER SET utf8 NOT NULL,
  createdate int(11) NOT NULL DEFAULT '0',
  updatedate int(11) NOT NULL DEFAULT '0',
  createuser varchar(255) CHARACTER SET utf8 NOT NULL,
  updateuser varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (file_id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_file_category'
-- 

CREATE TABLE rex_file_category (
  id int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  re_id int(11) NOT NULL DEFAULT '0',
  path varchar(255) CHARACTER SET utf8 NOT NULL,
  createdate int(11) NOT NULL DEFAULT '0',
  updatedate int(11) NOT NULL DEFAULT '0',
  createuser varchar(255) CHARACTER SET utf8 NOT NULL,
  updateuser varchar(255) CHARACTER SET utf8 NOT NULL,
  attributes text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (id,`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_module'
-- 

CREATE TABLE rex_module (
  id int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  category_id int(11) NOT NULL DEFAULT '0',
  ausgabe text CHARACTER SET utf8 NOT NULL,
  eingabe text CHARACTER SET utf8 NOT NULL,
  createuser varchar(255) CHARACTER SET utf8 NOT NULL,
  updateuser varchar(255) CHARACTER SET utf8 NOT NULL,
  createdate int(11) NOT NULL DEFAULT '0',
  updatedate int(11) NOT NULL DEFAULT '0',
  attributes text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (id,category_id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_module_action'
-- 

CREATE TABLE rex_module_action (
  id int(11) NOT NULL AUTO_INCREMENT,
  module_id int(11) NOT NULL DEFAULT '0',
  action_id int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_template'
-- 

CREATE TABLE rex_template (
  id int(11) NOT NULL AUTO_INCREMENT,
  label varchar(255) CHARACTER SET utf8 NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  content text CHARACTER SET utf8 NOT NULL,
  active tinyint(1) NOT NULL DEFAULT '0',
  createuser varchar(255) CHARACTER SET utf8 NOT NULL,
  updateuser varchar(255) CHARACTER SET utf8 NOT NULL,
  createdate int(11) NOT NULL DEFAULT '0',
  updatedate int(11) NOT NULL DEFAULT '0',
  attributes text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle 'rex_user'
-- 

CREATE TABLE rex_user (
  user_id int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  description text CHARACTER SET utf8 NOT NULL,
  login varchar(50) CHARACTER SET utf8 NOT NULL,
  psw varchar(50) CHARACTER SET utf8 NOT NULL,
  `status` varchar(5) CHARACTER SET utf8 NOT NULL,
  rights text CHARACTER SET utf8 NOT NULL,
  login_tries tinyint(4) NOT NULL DEFAULT '0',
  createuser varchar(255) CHARACTER SET utf8 NOT NULL,
  updateuser varchar(255) CHARACTER SET utf8 NOT NULL,
  createdate int(11) NOT NULL DEFAULT '0',
  updatedate int(11) NOT NULL DEFAULT '0',
  lasttrydate int(11) NOT NULL DEFAULT '0',
  session_id varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (user_id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

[jdlx]

Hi, ich würde gerne meine alte Redaxo version auf die neueste updaten.

Such mal im Forum.. war die Tage erst Thema gewesen.

lg,
Jan

[ReggaePanda]

Danke ich weiß
aber zwischen der version 3.2 und 3.3 gibt es ja schon wieder einige unterschiede was die datenbank angeht. Hab auch das gemacht was da empfohlen wird. aber es resultiert bei mir schon ein ganz anderes ergebnis.

Die NICHT funktionierenden befehle:

Code: Alles auswählen

    ALTER TABLE `rex_template` DROP `bcontent`;
    ALTER TABLE `rex_template` DROP `date`;
    ALTER TABLE `rex_template` ADD `attributes` TEXT NOT NULL;
    ALTER TABLE `rex_article` DROP `cattype`;
    ALTER TABLE `rex_article` ADD `label` VARCHAR(255) NOT NULL;
    ALTER TABLE `rex_article` ADD `url` TEXT NOT NULL;
    ALTER TABLE `rex_article` DROP `alias`;
    ALTER TABLE `rex_article` CHANGE `attribute` `attributes` TEXT NOT NULL;
    ALTER TABLE `rex_article` DROP `online_from`;
    ALTER TABLE `rex_article` DROP `online_to`;
    ALTER TABLE `rex_article` DROP `fe_user`;
    ALTER TABLE `rex_article` DROP `fe_group`;
    ALTER TABLE `rex_article` DROP `fe_ext`;
    ALTER TABLE `rex_article` DROP `teaser`;
    ALTER TABLE `rex_article` DROP `type_id`;
    ALTER TABLE `rex_modultyp` DROP `bausgabe`;
    ALTER TABLE `rex_modultyp` DROP `func`;
    ALTER TABLE `rex_modultyp` DROP `php_enable`;
    ALTER TABLE `rex_modultyp` DROP `html_enable`;
    ALTER TABLE `rex_modultyp` DROP `perm_category`;
    ALTER TABLE `rex_modultyp` DROP `label`;
    ALTER TABLE `rex_modultyp` ADD `attributes` TEXT NOT NULL;
    ALTER TABLE `rex_file_category` DROP `hide`;
    ALTER TABLE `rex_file_category` ADD `attributes` TEXT NOT NULL;
    ALTER TABLE `rex_file` ADD `attributes` TEXT NOT NULL AFTER `category_id`;
    ALTER TABLE `rex_action` ADD `preview` TEXT NOT NULL, ADD `presave` TEXT NOT NULL, ADD `postsave` TEXT NOT NULL, ADD `previewmode` TINYINT NOT NULL, ADD `presavemode` TINYINT NOT NULL, ADD `postsavemode` TINYINT NOT NULL;
    ALTER TABLE `rex_action` DROP `action`, DROP `prepost`, DROP `sadd`, DROP `sedit`, DROP `sdelete`;
    ALTER TABLE `rex_action` ADD `createuser` VARCHAR(255) NOT NULL, ADD `createdate` INT NOT NULL, ADD `updateuser` VARCHAR(255) NOT NULL, ADD `updatedate` INT NOT NULL;
    RENAME TABLE `rex_modultyp` TO `rex_module`;

Und die funktionierenden:

Code: Alles auswählen

    ALTER TABLE `rex_article` DROP `description`;
    ALTER TABLE `rex_article` DROP `keywords`;
    ALTER TABLE `rex_article` DROP `file`;
    ALTER TABLE `rex_article_slice` CHANGE `link1` `link1` VARCHAR(10) NOT NULL, CHANGE `link2` `link2` VARCHAR(10) NOT NULL, CHANGE `link3` `link3` VARCHAR(10) NOT NULL, CHANGE `link4` `link4` VARCHAR(10) NOT NULL, CHANGE `link5` `link5` VARCHAR(10) NOT NULL, CHANGE `link6` `link6` VARCHAR(10) NOT NULL, CHANGE `link7` `link7` VARCHAR(10) NOT NULL, CHANGE `link8` `link8` VARCHAR(10) NOT NULL, CHANGE `link9` `link9` VARCHAR(10) NOT NULL, CHANGE `link10` `link10` VARCHAR(10) NOT NULL;
    ALTER TABLE `rex_user` ADD `cookiekey` varchar(255);
    ALTER TABLE `rex_article_slice` ADD `next_article_slice_id` int(11);
    ALTER TABLE `rex_action` ADD `revision` int(11);
    ALTER TABLE `rex_article` ADD `revision` int(11);
    ALTER TABLE `rex_article_slice` ADD `revision` int(11);
    ALTER TABLE `rex_clang` ADD `revision` int(11);
    ALTER TABLE `rex_file` DROP `copyright`;
    ALTER TABLE `rex_file` DROP `description`;
    ALTER TABLE `rex_file` ADD `revision` int(11);
    ALTER TABLE `rex_file_category` ADD `revision` int(11);
    ALTER TABLE `rex_module_action` ADD `revision` int(11);
    ALTER TABLE `rex_template` ADD `revision` int(11);
    ALTER TABLE `rex_user` ADD `revision` int(11);
    UPDATE `rex_user` SET `status`=1;
    UPDATE `rex_article_slice` SET `ctype`=`ctype`+1;
    ALTER TABLE `rex_module` ADD `revision` int(11);

die befehle mit der tabelle rex_modultype habe ich schon angepasst, da die tabelle bei mir schon wie die neue heißt.

aber es fehlen in der 4.0 alle Artikel, wenn ich den medienpool öffne wird mir die strucktur angezeigt.

[jdlx]

..aber zwischen der version 3.2 und 3.3 gibt es ja schon wieder einige unterschiede was die datenbank angeht.

Ich hatte mir halt alle notwendigen queries aus den versch. setups zusammengeschrieben, und damit ne rex 3.2 site erfolgreich auf 4.3.1 upgedatet.. wie gesagt mit gelegnetlichen probs denen man händisch nachgehen muß, aber prinzipiell hats gepaßt.

Leider kann ich aber momentan nicht mehr/detailierter zu beitragen weil büschn im Streß..

hth,
j.

[ReggaePanda]

ok, jetzt klappt es einigermaßen.

habe die dateien der 4.3.2 hochgeladen und dann

von der 3.3er datenbank version aus, diese befehle erfolgreich ausgeführt:

Code: Alles auswählen

##4.0
    ALTER TABLE `rex_article` DROP `description`;
    ALTER TABLE `rex_article` DROP `keywords`;
    ALTER TABLE `rex_article` DROP `file`;
    ALTER TABLE `rex_article_slice` CHANGE `link1` `link1` VARCHAR(10) NOT NULL, CHANGE `link2` `link2` VARCHAR(10) NOT NULL, CHANGE `link3` `link3` VARCHAR(10) NOT NULL, CHANGE `link4` `link4` VARCHAR(10) NOT NULL, CHANGE `link5` `link5` VARCHAR(10) NOT NULL, CHANGE `link6` `link6` VARCHAR(10) NOT NULL, CHANGE `link7` `link7` VARCHAR(10) NOT NULL, CHANGE `link8` `link8` VARCHAR(10) NOT NULL, CHANGE `link9` `link9` VARCHAR(10) NOT NULL, CHANGE `link10` `link10` VARCHAR(10) NOT NULL;
    ALTER TABLE `rex_user` ADD `cookiekey` varchar(255);
    ALTER TABLE `rex_article_slice` ADD `next_article_slice_id` int(11);
    ALTER TABLE `rex_action` ADD `revision` int(11);
    ALTER TABLE `rex_article` ADD `revision` int(11);
    ALTER TABLE `rex_article_slice` ADD `revision` int(11);
    ALTER TABLE `rex_clang` ADD `revision` int(11);
    ALTER TABLE `rex_file` DROP `copyright`;
    ALTER TABLE `rex_file` DROP `description`;
    ALTER TABLE `rex_file` ADD `revision` int(11);
    ALTER TABLE `rex_file_category` ADD `revision` int(11);
    ALTER TABLE `rex_module_action` ADD `revision` int(11);
    ALTER TABLE `rex_template` ADD `revision` int(11);
    ALTER TABLE `rex_user` ADD `revision` int(11);
    UPDATE `rex_user` SET `status`=1;
    UPDATE `rex_article_slice` SET `ctype`=`ctype`+1;
    ALTER TABLE `rex_module` ADD `revision` int(11);

##4.1    
        ALTER TABLE `rex_article_slice` CHANGE `value1` `value1` text NULL, CHANGE `value2` `value2` text NULL, CHANGE `value3` `value3` text NULL, CHANGE `value4` `value4` text NULL, CHANGE `value5` `value5` text NULL, CHANGE `value6` `value6` text NULL, CHANGE `value7` `value7` text NULL, CHANGE `value8` `value8` text NULL, CHANGE `value9` `value9` text NULL, CHANGE `value10` `value10` text NULL, CHANGE `value11` `value11` text NULL, CHANGE `value12` `value12` text NULL, CHANGE `value13` `value13` text NULL, CHANGE `value14` `value14` text NULL, CHANGE `value15` `value15` text NULL, CHANGE `value16` `value16` text NULL, CHANGE `value17` `value17` text NULL, CHANGE `value18` `value18` text NULL, CHANGE `value19` `value19` text NULL, CHANGE `value20` `value20` text NULL, CHANGE `file1` `file1` varchar(255) NULL, CHANGE `file2` `file2` varchar(255) NULL, CHANGE `file3` `file3` varchar(255) NULL, CHANGE `file4` `file4` varchar(255) NULL, CHANGE `file5` `file5` varchar(255) NULL, CHANGE `file6` `file6` varchar(255) NULL, CHANGE `file7` `file7` varchar(255) NULL, CHANGE `file8` `file8` varchar(255) NULL, CHANGE `file9` `file9` varchar(255) NULL, CHANGE `file10` `file10` varchar(255) NULL, CHANGE `filelist1` `filelist1` text NULL, CHANGE `filelist2` `filelist2` text NULL, CHANGE `filelist3` `filelist3` text NULL, CHANGE `filelist4` `filelist4` text NULL, CHANGE `filelist5` `filelist5` text NULL, CHANGE `filelist6` `filelist6` text NULL, CHANGE `filelist7` `filelist7` text NULL, CHANGE `filelist8` `filelist8` text NULL, CHANGE `filelist9` `filelist9` text NULL, CHANGE `filelist10` `filelist10` text NULL, CHANGE `link1` `link1` varchar(10) NULL, CHANGE `link2` `link2` varchar(10) NULL, CHANGE `link3` `link3` varchar(10) NULL, CHANGE `link4` `link4` varchar(10) NULL, CHANGE `link5` `link5` varchar(10) NULL, CHANGE `link6` `link6` varchar(10) NULL, CHANGE `link7` `link7` varchar(10) NULL, CHANGE `link8` `link8` varchar(10) NULL, CHANGE `link9` `link9` varchar(10) NULL, CHANGE `link10` `link10` varchar(10) NULL, CHANGE `linklist1` `linklist1` text NULL, CHANGE `linklist2` `linklist2` text NULL, CHANGE `linklist3` `linklist3` text NULL, CHANGE `linklist4` `linklist4` text NULL, CHANGE `linklist5` `linklist5` text NULL, CHANGE `linklist6` `linklist6` text NULL, CHANGE `linklist7` `linklist7` text NULL, CHANGE `linklist8` `linklist8` text NULL, CHANGE `linklist9` `linklist9` text NULL, CHANGE `linklist10` `linklist10` text NULL, CHANGE `php` `php` text NULL, CHANGE `html` `html` text NULL;

##4.2
    ALTER TABLE `rex_action` CHANGE `revision` `revision` INT( 11 ) NOT NULL DEFAULT '0';
    ALTER TABLE `rex_article` CHANGE `revision` `revision` INT( 11 ) NOT NULL DEFAULT '0';
    ALTER TABLE `rex_article_slice` CHANGE `revision` `revision` INT( 11 ) NOT NULL DEFAULT '0';
    ALTER TABLE `rex_clang` CHANGE `revision` `revision` INT( 11 ) NOT NULL DEFAULT '0';
    ALTER TABLE `rex_file` CHANGE `revision` `revision` INT( 11 ) NOT NULL DEFAULT '0';
    ALTER TABLE `rex_file_category` CHANGE `revision` `revision` INT( 11 ) NOT NULL DEFAULT '0';
    ALTER TABLE `rex_module` CHANGE `revision` `revision` INT( 11 ) NOT NULL DEFAULT '0';
    ALTER TABLE `rex_module_action` CHANGE `revision` `revision` INT( 11 ) NOT NULL DEFAULT '0';
    ALTER TABLE `rex_user` CHANGE `revision` `revision` INT( 11 ) NOT NULL DEFAULT '0';
    UPDATE `rex_article` SET `revision` = 0;
    UPDATE `rex_article_slice` SET `revision` = 0;

und dann noch einen befehlnachschieben, da sonst die ctypes durcheinander sind

Code: Alles auswählen

UPDATE
 rex_article_slice
SET
 ctype = ctype - 1

Falls sonst nochmal jemand von der REDAXO 3.3 auf REDAXO 4.3.2 updaten muss ^^

(bin aber noch nicht ganz fertig... also weiß ich nicht, ob noch andere redaxorelevanten änderungen an der datenbank vorgenommen werden müssen.)