Update auf 4.4.4

Little · Beitrag von **Little** » So 11. Jul 2004, 14:45

Hallo zusammen,

zuerst muß ich mal sagen, dass ich absoluter Anfänger bin, also bitte nicht den Kopf abreißen, ich lerne fleißig und heute ist erst mein zweiter...hmm, oder dritter Tag mit contenido

Anfangs habe ich mit der 4.4.0 Version begonnen und dann ein Newsletter-Modul eingebaut. Da ich offensichtlich blind war, habe ich leider nicht darauf geachtet, dass dieses Modul nicht mit dieser Version kompatibel ist. Also habe ich jetzt die Version 4.4.4 drauf. Bei der Installation habe ich die folgenden Einträge in der Errorlog erhalten:

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'idart') - Invalid SQL: ALTER TABLE con_art ADD COLUMN idart int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_art ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'idartlang') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN idartlang int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'idart') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN idart int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'title') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN title varchar(255) NOT NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'pagetitle') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN pagetitle varchar(255) NOT NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'summary') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN summary text NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN author varchar(32) NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'online') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN online tinyint(1) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'redirect') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN redirect int(6) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'redirect_url') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN redirect_url varchar(255) NOT NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'artsort') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN artsort int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'timemgmt') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN timemgmt tinyint(1) NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'datestart') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN datestart datetime NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'dateend') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN dateend datetime NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN status int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'free_use_01') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN free_use_01 mediumint(7) NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'free_use_02') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN free_use_02 mediumint(7) NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'free_use_03') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN free_use_03 mediumint(7) NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'time_move_cat') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN time_move_cat mediumint(7) NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'time_target_cat') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN time_target_cat mediumint(7) NULL 

2004-Jul-Sun 14:39:20: error 1060 (Duplicate column name 'time_online_move') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN time_online_move mediumint(7) NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'external_redirect') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN external_redirect char(1) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'locked') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN locked int(1) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idcat') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'parentid') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN parentid int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'preid') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN preid int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'postid') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN postid int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN status int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idcatart') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idcat') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idart') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN idart int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'is_start') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN is_start tinyint(1) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN status int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'createcode') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN createcode tinyint(1) NOT NULL DEFAULT '1' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idtree') - Invalid SQL: ALTER TABLE con_cat_tree ADD COLUMN idtree int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idcat') - Invalid SQL: ALTER TABLE con_cat_tree ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'level') - Invalid SQL: ALTER TABLE con_cat_tree ADD COLUMN level int(2) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idcatlang') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN idcatlang int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idcat') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN name varchar(255) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'visible') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN visible tinyint(1) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'public') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN public tinyint(1) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN status int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN name varchar(255) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'path') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN path varchar(255) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'frontendpath') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN frontendpath varchar(255) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'htmlpath') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN htmlpath varchar(255) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'errsite_cat') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN errsite_cat int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'errsite_art') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN errsite_art int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idclientslang') - Invalid SQL: ALTER TABLE con_clients_lang ADD COLUMN idclientslang int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_clients_lang ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_clients_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idcode') - Invalid SQL: ALTER TABLE con_code ADD COLUMN idcode int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idcatart') - Invalid SQL: ALTER TABLE con_code ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_code ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_code ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'code') - Invalid SQL: ALTER TABLE con_code ADD COLUMN code text NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idcontent') - Invalid SQL: ALTER TABLE con_content ADD COLUMN idcontent int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idartlang') - Invalid SQL: ALTER TABLE con_content ADD COLUMN idartlang int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idtype') - Invalid SQL: ALTER TABLE con_content ADD COLUMN idtype int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'typeid') - Invalid SQL: ALTER TABLE con_content ADD COLUMN typeid int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'value') - Invalid SQL: ALTER TABLE con_content ADD COLUMN value text NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'version') - Invalid SQL: ALTER TABLE con_content ADD COLUMN version varchar(32) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_content ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_content ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_content ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN name varchar(255) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'active') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN active tinyint(1) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'encoding') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN encoding varchar(32) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idlay') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN idlay int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN name varchar(255) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN description text NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'deletable') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN deletable tinyint(1) NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'code') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN code text NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idmod') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN idmod int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN name varchar(255) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN description text NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'deletable') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN deletable tinyint(1) NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'input') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN input longtext NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'output') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN output longtext NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'template') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN template text NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'static') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN static tinyint(1) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idnews') - Invalid SQL: ALTER TABLE con_news ADD COLUMN idnews int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idart') - Invalid SQL: ALTER TABLE con_news ADD COLUMN idart int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_news ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_news ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_news ADD COLUMN name varchar(255) NOT NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'subject') - Invalid SQL: ALTER TABLE con_news ADD COLUMN subject text NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'message') - Invalid SQL: ALTER TABLE con_news ADD COLUMN message text NULL 

2004-Jul-Sun 14:39:21: error 1060 (Duplicate column name 'newsfrom') - Invalid SQL: ALTER TABLE con_news ADD COLUMN newsfrom varchar(255) NOT NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'newsdate') - Invalid SQL: ALTER TABLE con_news ADD COLUMN newsdate datetime NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_news ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_news ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column
name 'lastmodified') - Invalid SQL: ALTER TABLE con_news ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idnewsrcp') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN idnewsrcp int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'email') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN email varchar(255) NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN name varchar(255) NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'deactivated') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN deactivated int(1) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idstat') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN idstat int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idcatart') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'visited') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN visited int(6) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'visitdate') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN visitdate timestamp(14) NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idstatarch') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN idstatarch int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'archived') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN archived varchar(6) NOT NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idcatart') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'visited') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN visited int(6) NOT NULL DEFAULT '0' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'visitdate') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN visitdate timestamp(14) NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idstatus') - Invalid SQL: ALTER TABLE con_status ADD COLUMN idstatus int(10) NOT NULL DEFAULT '0' PRIMARY KEY 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_status ADD COLUMN description varchar(255) NOT NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_status ADD COLUMN author varchar(32) NOT NULL 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_status ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_status ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 

2004-Jul-Sun 14:39:22: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_template ADD COLUMN idclient int(10) NOT NULL DEFAULT '0'

Die restlichen Einträge spare ich mir jetzt mal, da die sich im Prinzip nicht unterscheiden und wohl überall was zu meckern haben.

Jetzt meine Verständnisfrage: Kann ich das so verstehen, dass in der Datenbank verschiedene Einträge in den Tabellen nicht durchgeführt wurden, beim Update, und ich jetzt im Prinzip diese Einträge nur manuell nachholen muß? Im Prinzip würde ja alles, was ich eingeben muß, im Fehlertext drinstehen, oder sehe ich das ganz falsch und man muß irgendwas anderes machen?

Ein kleiner Tipp oder Hinweis wäre nett

Vielen Dank schonmal

timo · Beitrag von **timo** » So 11. Jul 2004, 14:49

Das upgrade errorlog kannst du ignorieren. Eine Forumssuche hätte dich aber schon nach dem 4. Resultat auf das hier http://www.contenido.de/forum/viewtopic ... lter+table verwiesen...

Little · Beitrag von **Little** » So 11. Jul 2004, 14:52

Ja, das hatte ich schon gefunden und auch gelesen. Aber mir stellt sich dann die Frage, warum das Newsletter-Modul weiterhin nicht funktioniert und nicht alle Tabellen in der Datenbank geupdated wurden?

So fehlt z.B. in der con_news_rcp der Eintrag confirmed und hash...(bin ich auch nur draufgekommen, weil ich in nem anderen Thread Fragen zum Newsletter-Modul gestellt hatte)

Little · Beitrag von **Little** » So 11. Jul 2004, 15:29

Ok, habe den Fehler gefunden und behoben, trotzdem danke