Update 4.4.0 auf 4.4.1 incl. Bugfix fehlgeschlagen ...

Pitscheneder · Beitrag von **Pitscheneder** » Sa 22. Nov 2003, 18:32

Hallo,

ich habe mir, nachdem ich das Problem mit dem Reload und der PEAR.php auch hatte, die Ver 4.4.1 incl. Bugfix runtergeladen, auf den Server gespielt und setup mit der Option Update ausgeführt. Was passierte:

Inhalt der install.log.txt:

2003-Nov-Sat 18:17:18: error 1060 (Duplicate column name 'idart') - Invalid SQL: ALTER TABLE con_art ADD COLUMN idart int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:18: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_art ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:18: error 1060 (Duplicate column name 'idartlang') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN idartlang int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:18: error 1060 (Duplicate column name 'idart') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN idart int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:18: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'title') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN title varchar(255) NOT NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'pagetitle') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN pagetitle varchar(255) NOT NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'summary') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN summary text NULL 
2003-Nov-Sat 18:17:19: 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' 
2003-Nov-Sat 18:17:19: 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' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN author varchar(32) NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'online') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN online tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'redirect') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN redirect int(6) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'redirect_url') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN redirect_url varchar(255) NOT NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'artsort') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN artsort int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'timemgmt') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN timemgmt tinyint(1) NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'datestart') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN datestart datetime NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'dateend') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN dateend datetime NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN status int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'free_use_01') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN free_use_01 mediumint(7) NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'free_use_02') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN free_use_02 mediumint(7) NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'free_use_03') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN free_use_03 mediumint(7) NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'time_move_cat') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN time_move_cat mediumint(7) NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'time_target_cat') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN time_target_cat mediumint(7) NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'time_online_move') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN time_online_move mediumint(7) NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'external_redirect') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN external_redirect char(1) NOT NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'locked') - Invalid SQL: ALTER TABLE con_art_lang ADD COLUMN locked int(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idcat') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'parentid') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN parentid int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'preid') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN preid int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'postid') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN postid int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN status int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_cat ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:19: 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' 
2003-Nov-Sat 18:17:19: 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' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idcatart') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idcat') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idart') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN idart int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'is_start') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN is_start tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN status int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:19: 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' 
2003-Nov-Sat 18:17:19: 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' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'createcode') - Invalid SQL: ALTER TABLE con_cat_art ADD COLUMN createcode tinyint(1) NOT NULL DEFAULT '1' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idtree') - Invalid SQL: ALTER TABLE con_cat_tree ADD COLUMN idtree int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idcat') - Invalid SQL: ALTER TABLE con_cat_tree ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'level') - Invalid SQL: ALTER TABLE con_cat_tree ADD COLUMN level int(2) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idcatlang') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN idcatlang int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idcat') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN name varchar(255) NOT NULL 
2003-Nov-Sat 18:17:19: error 1060 (Duplicate column name 'visible') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN visible tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'public') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN public tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN status int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_cat_lang ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN name varchar(255) NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'path') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN path varchar(255) NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'frontendpath') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN frontendpath varchar(255) NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'htmlpath') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN htmlpath varchar(255) NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'errsite_cat') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN errsite_cat int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'errsite_art') - Invalid SQL: ALTER TABLE con_clients ADD COLUMN errsite_art int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idclientslang') - Invalid SQL: ALTER TABLE con_clients_lang ADD COLUMN idclientslang int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_clients_lang ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_clients_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idcode') - Invalid SQL: ALTER TABLE con_code ADD COLUMN idcode int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idcatart') - Invalid SQL: ALTER TABLE con_code ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_code ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_code ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'code') - Invalid SQL: ALTER TABLE con_code ADD COLUMN code text NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idcontent') - Invalid SQL: ALTER TABLE con_content ADD COLUMN idcontent int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idartlang') - Invalid SQL: ALTER TABLE con_content ADD COLUMN idartlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idtype') - Invalid SQL: ALTER TABLE con_content ADD COLUMN idtype int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'typeid') - Invalid SQL: ALTER TABLE con_content ADD COLUMN typeid int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'value') - Invalid SQL: ALTER TABLE con_content ADD COLUMN value text NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'version') - Invalid SQL: ALTER TABLE con_content ADD COLUMN version varchar(32) NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_content ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN name varchar(255) NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'active') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN active tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'encoding') - Invalid SQL: ALTER TABLE con_lang ADD COLUMN encoding varchar(32) NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idlay') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN idlay int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN name varchar(255) NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN description text NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'deletable') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN deletable tinyint(1) NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'code') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN code text NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_lay ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idmod') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN idmod int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN name varchar(255) NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN description text NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'deletable') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN deletable tinyint(1) NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'input') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN input longtext NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'output') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN output longtext NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'template') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN template text NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'static') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN static tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_mod ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: 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' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idnews') - Invalid SQL: ALTER TABLE con_news ADD COLUMN idnews int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idart') - Invalid SQL: ALTER TABLE con_news ADD COLUMN idart int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_news ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_news ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_news ADD COLUMN name varchar(255) NOT NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'subject') - Invalid SQL: ALTER TABLE con_news ADD COLUMN subject text NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'message') - Invalid SQL: ALTER TABLE con_news ADD COLUMN message text NULL 
2003-Nov-Sat 18:17:20: error 1060 (Duplicate column name 'newsfrom') - Invalid SQL: ALTER TABLE con_news ADD COLUMN newsfrom varchar(255) NOT NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'newsdate') - Invalid SQL: ALTER TABLE con_news ADD COLUMN newsdate datetime NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_news ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:21: 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' 
2003-Nov-Sat 18:17:21: 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' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idnewsrcp') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN idnewsrcp int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'email') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN email varchar(255) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN name varchar(255) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'deactivated') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN deactivated int(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_news_rcp ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:21: 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' 
2003-Nov-Sat 18:17:21: 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' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idstat') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN idstat int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idcatart') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'visited') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN visited int(6) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'visitdate') - Invalid SQL: ALTER TABLE con_stat ADD COLUMN visitdate timestamp(14) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idstatarch') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN idstatarch int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'archived') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN archived varchar(6) NOT NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idcatart') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'visited') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN visited int(6) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'visitdate') - Invalid SQL: ALTER TABLE con_stat_archive ADD COLUMN visitdate timestamp(14) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idstatus') - Invalid SQL: ALTER TABLE con_status ADD COLUMN idstatus int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_status ADD COLUMN description varchar(255) NOT NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_status ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:21: 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' 
2003-Nov-Sat 18:17:21: 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' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_template ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idlay') - Invalid SQL: ALTER TABLE con_template ADD COLUMN idlay int(10) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idtpl') - Invalid SQL: ALTER TABLE con_template ADD COLUMN idtpl int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL: ALTER TABLE con_template ADD COLUMN idtplcfg int(10) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_template ADD COLUMN name varchar(255) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_template ADD COLUMN description varchar(255) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'deletable') - Invalid SQL: ALTER TABLE con_template ADD COLUMN deletable tinyint(1) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_template ADD COLUMN status int(10) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_template ADD COLUMN author varchar(32) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_template ADD COLUMN created timestamp(14) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_template ADD COLUMN lastmodified timestamp(14) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL: ALTER TABLE con_template_conf ADD COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idtpl') - Invalid SQL: ALTER TABLE con_template_conf ADD COLUMN idtpl int(10) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_template_conf ADD COLUMN status int(10) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_template_conf ADD COLUMN author varchar(255) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_template_conf ADD COLUMN created timestamp(14) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_template_conf ADD COLUMN lastmodified timestamp(14) NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idtype') - Invalid SQL: ALTER TABLE con_type ADD COLUMN idtype int(6) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'type') - Invalid SQL: ALTER TABLE con_type ADD COLUMN type varchar(255) NOT NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'code') - Invalid SQL: ALTER TABLE con_type ADD COLUMN code text NOT NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_type ADD COLUMN description varchar(255) NOT NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_type ADD COLUMN status int(11) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_type ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_type ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_type ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idupl') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN idupl int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:21: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'filename') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN filename varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'dirname') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN dirname varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'filetype') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN filetype varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'size') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN size varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN description text NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'status') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN status int(11) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'author') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN author varchar(32) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'created') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL: ALTER TABLE con_upl ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idkeyword') - Invalid SQL: ALTER TABLE con_keywords ADD COLUMN idkeyword int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'keyword') - Invalid SQL: ALTER TABLE con_keywords ADD COLUMN keyword varchar(50) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'exp') - Invalid SQL: ALTER TABLE con_keywords ADD COLUMN exp text NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'auto') - Invalid SQL: ALTER TABLE con_keywords ADD COLUMN auto text NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'self') - Invalid SQL: ALTER TABLE con_keywords ADD COLUMN self text NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_keywords ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idarea') - Invalid SQL: ALTER TABLE con_area ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'parent_id') - Invalid SQL: ALTER TABLE con_area ADD COLUMN parent_id varchar(255) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_area ADD COLUMN name varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'relevant') - Invalid SQL: ALTER TABLE con_area ADD COLUMN relevant tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'online') - Invalid SQL: ALTER TABLE con_area ADD COLUMN online tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idaction') - Invalid SQL: ALTER TABLE con_actions ADD COLUMN idaction int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idarea') - Invalid SQL: ALTER TABLE con_actions ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'alt_name') - Invalid SQL: ALTER TABLE con_actions ADD COLUMN alt_name varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_actions ADD COLUMN name varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'code') - Invalid SQL: ALTER TABLE con_actions ADD COLUMN code text NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'location') - Invalid SQL: ALTER TABLE con_actions ADD COLUMN location varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'relevant') - Invalid SQL: ALTER TABLE con_actions ADD COLUMN relevant tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idnavm') - Invalid SQL: ALTER TABLE con_nav_main ADD COLUMN idnavm int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'location') - Invalid SQL: ALTER TABLE con_nav_main ADD COLUMN location varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idnavs') - Invalid SQL: ALTER TABLE con_nav_sub ADD COLUMN idnavs int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idnavm') - Invalid SQL: ALTER TABLE con_nav_sub ADD COLUMN idnavm int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idarea') - Invalid SQL: ALTER TABLE con_nav_sub ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'level') - Invalid SQL: ALTER TABLE con_nav_sub ADD COLUMN level int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'location') - Invalid SQL: ALTER TABLE con_nav_sub ADD COLUMN location varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'online') - Invalid SQL: ALTER TABLE con_nav_sub ADD COLUMN online tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idright') - Invalid SQL: ALTER TABLE con_rights ADD COLUMN idright int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'user_id') - Invalid SQL: ALTER TABLE con_rights ADD COLUMN user_id varchar(32) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idarea') - Invalid SQL: ALTER TABLE con_rights ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idaction') - Invalid SQL: ALTER TABLE con_rights ADD COLUMN idaction int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idcat') - Invalid SQL: ALTER TABLE con_rights ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_rights ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_rights ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'type') - Invalid SQL: ALTER TABLE con_rights ADD COLUMN type tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idcontainer') - Invalid SQL: ALTER TABLE con_container ADD COLUMN idcontainer int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idtpl') - Invalid SQL: ALTER TABLE con_container ADD COLUMN idtpl int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'number') - Invalid SQL: ALTER TABLE con_container ADD COLUMN number int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idmod') - Invalid SQL: ALTER TABLE con_container ADD COLUMN idmod int(10) NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idcontainerc') - Invalid SQL: ALTER TABLE con_container_conf ADD COLUMN idcontainerc int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL: ALTER TABLE con_container_conf ADD COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'number') - Invalid SQL: ALTER TABLE con_container_conf ADD COLUMN number int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'container') - Invalid SQL: ALTER TABLE con_container_conf ADD COLUMN container text NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idfile') - Invalid SQL: ALTER TABLE con_files ADD COLUMN idfile int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idarea') - Invalid SQL: ALTER TABLE con_files ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'filename') - Invalid SQL: ALTER TABLE con_files ADD COLUMN filename varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'filetype') - Invalid SQL: ALTER TABLE con_files ADD COLUMN filetype varchar(4) NOT NULL DEFAULT 'main' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idframefile') - Invalid SQL: ALTER TABLE con_frame_files ADD COLUMN idframefile int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idarea') - Invalid SQL: ALTER TABLE con_frame_files ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idframe') - Invalid SQL: ALTER TABLE con_frame_files ADD COLUMN idframe int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idfile') - Invalid SQL: ALTER TABLE con_frame_files ADD COLUMN idfile int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idplugin') - Invalid SQL: ALTER TABLE con_plugins ADD COLUMN idplugin int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_plugins ADD COLUMN idclient int(10) NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_plugins ADD COLUMN name varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_plugins ADD COLUMN description text NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'path') - Invalid SQL: ALTER TABLE con_plugins ADD COLUMN path varchar(255) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'installed') - Invalid SQL: ALTER TABLE con_plugins ADD COLUMN installed tinyint(1) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'active') - Invalid SQL: ALTER TABLE con_plugins ADD COLUMN active tinyint(1) NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'sid') - Invalid SQL: ALTER TABLE con_phplib_active_sessions ADD COLUMN sid varchar(32) NOT NULL PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_phplib_active_sessions ADD COLUMN name varchar(32) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'val') - Invalid SQL: ALTER TABLE con_phplib_active_sessions ADD COLUMN val longblob NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'changed') - Invalid SQL: ALTER TABLE con_phplib_active_sessions ADD COLUMN changed varchar(14) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'user_id') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN user_id varchar(32) NOT NULL PRIMARY KEY 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'username') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN username varchar(32) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'password') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN password varchar(32) NOT NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'perms') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN perms varchar(255) NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'realname') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN realname varchar(255) NULL 
2003-Nov-Sat 18:17:22: error 1060 (Duplicate column name 'email') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN email varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'telephone') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN telephone varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'address_street') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN address_street varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'address_zip') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN address_zip varchar(10) NOT NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'address_city') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN address_city varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'address_country') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN address_country varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'wysi') - Invalid SQL: ALTER TABLE con_phplib_auth_user_md5 ADD COLUMN wysi tinyint(2) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idlog') - Invalid SQL: ALTER TABLE con_actionlog ADD COLUMN idlog int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'user_id') - Invalid SQL: ALTER TABLE con_actionlog ADD COLUMN user_id varchar(32) NOT NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_actionlog ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_actionlog ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idaction') - Invalid SQL: ALTER TABLE con_actionlog ADD COLUMN idaction int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idcatart') - Invalid SQL: ALTER TABLE con_actionlog ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'logtimestamp') - Invalid SQL: ALTER TABLE con_actionlog ADD COLUMN logtimestamp datetime NULL DEFAULT '0000-00-00 00:00:00' 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idlink') - Invalid SQL: ALTER TABLE con_link ADD COLUMN idlink int(6) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idartlang') - Invalid SQL: ALTER TABLE con_link ADD COLUMN idartlang int(10) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idcat') - Invalid SQL: ALTER TABLE con_link ADD COLUMN idcat int(10) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idart') - Invalid SQL: ALTER TABLE con_link ADD COLUMN idart int(10) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'linkpath') - Invalid SQL: ALTER TABLE con_link ADD COLUMN linkpath varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'internal') - Invalid SQL: ALTER TABLE con_link ADD COLUMN internal tinyint(1) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'active') - Invalid SQL: ALTER TABLE con_link ADD COLUMN active tinyint(1) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idmetatype') - Invalid SQL: ALTER TABLE con_meta_type ADD COLUMN idmetatype int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'metatype') - Invalid SQL: ALTER TABLE con_meta_type ADD COLUMN metatype varchar(32) NOT NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'fieldtype') - Invalid SQL: ALTER TABLE con_meta_type ADD COLUMN fieldtype varchar(32) NOT NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'maxlength') - Invalid SQL: ALTER TABLE con_meta_type ADD COLUMN maxlength int(11) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idmetatag') - Invalid SQL: ALTER TABLE con_meta_tag ADD COLUMN idmetatag int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idartlang') - Invalid SQL: ALTER TABLE con_meta_tag ADD COLUMN idartlang int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idmetatype') - Invalid SQL: ALTER TABLE con_meta_tag ADD COLUMN idmetatype int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'metavalue') - Invalid SQL: ALTER TABLE con_meta_tag ADD COLUMN metavalue text NOT NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'group_id') - Invalid SQL: ALTER TABLE con_groups ADD COLUMN group_id varchar(32) NOT NULL PRIMARY KEY 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'groupname') - Invalid SQL: ALTER TABLE con_groups ADD COLUMN groupname varchar(32) NOT NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'perms') - Invalid SQL: ALTER TABLE con_groups ADD COLUMN perms varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'description') - Invalid SQL: ALTER TABLE con_groups ADD COLUMN description varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idgroupprop') - Invalid SQL: ALTER TABLE con_group_prop ADD COLUMN idgroupprop int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'group_id') - Invalid SQL: ALTER TABLE con_group_prop ADD COLUMN group_id varchar(32) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'type') - Invalid SQL: ALTER TABLE con_group_prop ADD COLUMN type varchar(32) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_group_prop ADD COLUMN name varchar(32) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'value') - Invalid SQL: ALTER TABLE con_group_prop ADD COLUMN value varchar(32) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idcatlang') - Invalid SQL: ALTER TABLE con_group_prop ADD COLUMN idcatlang int(11) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idgroupuser') - Invalid SQL: ALTER TABLE con_groupmembers ADD COLUMN idgroupuser int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'group_id') - Invalid SQL: ALTER TABLE con_groupmembers ADD COLUMN group_id varchar(32) NOT NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'user_id') - Invalid SQL: ALTER TABLE con_groupmembers ADD COLUMN user_id varchar(32) NOT NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idconfig') - Invalid SQL: ALTER TABLE con_config ADD COLUMN idconfig int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'abs_path') - Invalid SQL: ALTER TABLE con_config ADD COLUMN abs_path varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'url_path') - Invalid SQL: ALTER TABLE con_config ADD COLUMN url_path varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'css_path') - Invalid SQL: ALTER TABLE con_config ADD COLUMN css_path varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'js_path') - Invalid SQL: ALTER TABLE con_config ADD COLUMN js_path varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'filename') - Invalid SQL: ALTER TABLE con_config ADD COLUMN filename varchar(127) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idconfc') - Invalid SQL: ALTER TABLE con_config_client ADD COLUMN idconfc int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_config_client ADD COLUMN idclient int(10) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'abs_path') - Invalid SQL: ALTER TABLE con_config_client ADD COLUMN abs_path varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'url_path') - Invalid SQL: ALTER TABLE con_config_client ADD COLUMN url_path varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'css_path') - Invalid SQL: ALTER TABLE con_config_client ADD COLUMN css_path varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'js_path') - Invalid SQL: ALTER TABLE con_config_client ADD COLUMN js_path varchar(255) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'filename') - Invalid SQL: ALTER TABLE con_config_client ADD COLUMN filename varchar(127) NULL 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'iddata') - Invalid SQL: ALTER TABLE con_data ADD COLUMN iddata int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:23: error 1060 (Duplicate column name 'idclient') - Invalid SQL: ALTER TABLE con_data ADD COLUMN idclient int(10) NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'abs_path') - Invalid SQL: ALTER TABLE con_data ADD COLUMN abs_path varchar(255) NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'url_path') - Invalid SQL: ALTER TABLE con_data ADD COLUMN url_path varchar(255) NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'dir_hide') - Invalid SQL: ALTER TABLE con_data ADD COLUMN dir_hide varchar(255) NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'dir_not') - Invalid SQL: ALTER TABLE con_data ADD COLUMN dir_not varchar(255) NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'ext_not') - Invalid SQL: ALTER TABLE con_data ADD COLUMN ext_not varchar(255) NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'idbereich') - Invalid SQL: ALTER TABLE con_lang_bereich ADD COLUMN idbereich int(4) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'brvalue') - Invalid SQL: ALTER TABLE con_lang_bereich ADD COLUMN brvalue char(40) NOT NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'expanded') - Invalid SQL: ALTER TABLE con_lang_bereich ADD COLUMN expanded int(1) NOT NULL DEFAULT '1' 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'client') - Invalid SQL: ALTER TABLE con_lang_bereich ADD COLUMN client int(4) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'idkey') - Invalid SQL: ALTER TABLE con_lang_key ADD COLUMN idkey int(4) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'valuekey') - Invalid SQL: ALTER TABLE con_lang_key ADD COLUMN valuekey text NOT NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'idbereich') - Invalid SQL: ALTER TABLE con_lang_key ADD COLUMN idbereich int(4) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'idlangvalue') - Invalid SQL: ALTER TABLE con_lang_value ADD COLUMN idlangvalue int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'idlangfile') - Invalid SQL: ALTER TABLE con_lang_value ADD COLUMN idlangfile int(4) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'value') - Invalid SQL: ALTER TABLE con_lang_value ADD COLUMN value text NOT NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'idkey') - Invalid SQL: ALTER TABLE con_lang_value ADD COLUMN idkey int(4) unsigned NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'idlang') - Invalid SQL: ALTER TABLE con_lang_value ADD COLUMN idlang int(4) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'idbereich') - Invalid SQL: ALTER TABLE con_lang_value ADD COLUMN idbereich int(4) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'seq_name') - Invalid SQL: ALTER TABLE con_sequence ADD COLUMN seq_name varchar(127) NOT NULL PRIMARY KEY 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'nextid') - Invalid SQL: ALTER TABLE con_sequence ADD COLUMN nextid int(10) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'iduserprop') - Invalid SQL: ALTER TABLE con_user_prop ADD COLUMN iduserprop int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'user_id') - Invalid SQL: ALTER TABLE con_user_prop ADD COLUMN user_id varchar(32) NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'type') - Invalid SQL: ALTER TABLE con_user_prop ADD COLUMN type varchar(32) NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'name') - Invalid SQL: ALTER TABLE con_user_prop ADD COLUMN name varchar(32) NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'value') - Invalid SQL: ALTER TABLE con_user_prop ADD COLUMN value varchar(32) NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'idcatlang') - Invalid SQL: ALTER TABLE con_user_prop ADD COLUMN idcatlang int(11) NOT NULL DEFAULT '0' 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'idinuse') - Invalid SQL: ALTER TABLE con_inuse ADD COLUMN idinuse int(10) NOT NULL DEFAULT '0' PRIMARY KEY 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'type') - Invalid SQL: ALTER TABLE con_inuse ADD COLUMN type varchar(32) NOT NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'objectid') - Invalid SQL: ALTER TABLE con_inuse ADD COLUMN objectid varchar(32) NOT NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'session') - Invalid SQL: ALTER TABLE con_inuse ADD COLUMN session varchar(32) NOT NULL 
2003-Nov-Sat 18:17:24: error 1060 (Duplicate column name 'userid') - Invalid SQL: ALTER TABLE con_inuse ADD COLUMN userid varchar(32) NOT NULL 

Kann mir irgend jemand sagen, was ich falsch mache ????

Danke !
Ralf

timo · Beitrag von **timo** » Sa 22. Nov 2003, 18:34

hast du mal geschaut, ob Contenido funktioniert?

Pitscheneder · Beitrag von **Pitscheneder** » Sa 22. Nov 2003, 18:44

timo hat geschrieben:hast du mal geschaut, ob Contenido funktioniert?

Hi,

danke für die schnelle Antwort.

Ja, es funzt, genauso gut (oder eben schlecht) wie vorher. Unter INFO wird auch immer noch die Version 4.4.0 angezeigt.
Es scheint sich also rein gar nichts getan zu haben, ausser dass ich die neuen Files auf den Server geschoben habe ..
Gruß
Ralf

timo · Beitrag von **timo** » Sa 22. Nov 2003, 18:48

Hast du auch die bestehenden Dateien überschrieben? Daß dort 4.4.0 steht, wundert mich dann doch ein wenig.

Welche Version steht in der Login-Box?

Pitscheneder · Beitrag von **Pitscheneder** » Sa 22. Nov 2003, 18:58

timo hat geschrieben:Hast du auch die bestehenden Dateien überschrieben? Daß dort 4.4.0 steht, wundert mich dann doch ein wenig.

Welche Version steht in der Login-Box?

4.4.0

Ich werde, da ich noch nicht viel an den templates geändert habe, alles mal killen und neu aufsetzen.

vielen Dank derweil für die Hilfe.

Gruß
Ralf

timo · Beitrag von **timo** » Sa 22. Nov 2003, 19:16

Wenn dort noch 4.4.0 steht, mußt du etwas falsch gemacht haben

Wichtig: Die neuen Dateien der 4.4.1 müssen die alten überschreiben, und dann nochmals das Setup mit der Upgrade-Option ausführen (config speichern nicht vergessen).

Grüße,
Timo

ttb · Beitrag von **ttb** » Sa 22. Nov 2003, 23:55

... oder du probierst es gleich mit Contenido 4.4.2.
http://sourceforge.net/project/showfile ... p_id=35885

Pitscheneder · Beitrag von **Pitscheneder** » Mo 24. Nov 2003, 17:52

ttb hat geschrieben:... oder du probierst es gleich mit Contenido 4.4.2.
http://sourceforge.net/project/showfile ... p_id=35885

... dann geht es ebenfalls nicht fehlerfrei.
Ich habe alles rausgeworfen, DB gelöscht, und 4.4.2 aufgesetzt.
Schon beim Klick innerhalb der mitgelieferten Beispielseite kommt folgender Fehler in die Errorlog:

[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('impressum','&18=2',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('vergessen','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('sie','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('nicht','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('ein','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('auch','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('anzugeben','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('www','&18=8',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('upload','&18=4',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('polarlichtinfo','&18=8',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('logos','&18=3',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('logo','&18=3',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('jpg','&18=2',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('http','&18=8',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('de','&18=8',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('contenido','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('cms','&18=8',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('itprof','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('gif','&18=2',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('bilder','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('banner','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_keywords (keyword,auto,idlang, idkeyword) VALUES ('fb','&18=1',1,0) 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_code (idcode, idcatart, code, idlang, idclient) VALUES ('0', '30', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
<title>Contenido</title>
<link rel="stylesheet" type="text/css" href="css/format.css">
<meta name="generator" content="CMS Contenido 4.4.2">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="white" style="margin:0px">
<table width="100%" height="100%" cellspacing="0" cellpadding="0" border="0">
<tr><td height="5"></td></tr>
<tr><td align="center">
<table width="800" border="0" height="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="200" align="center"><?php

if ("http://www.polarlichtinfo.de/cms/upload ... o_logo.jpg" != "") {

$img = \'<img src="http://www.polarlichtinfo.de/cms/upload ... o_logo.jpg" border="0">\';

if ("http://www.polarlichtinfo.de/cms/" != "http://") {
$img = sprintf(\'<a href="%s" target="%s">%s</a>\',"http://www.polarlichtinfo.de/cms/", "", $img);

}

echo $img;

}

echo " ";
echo "";
echo " ";
echo "";
echo " ";

?>
</td>
<td align="center" height="80" with="400">
<table width="400" border="0" height="80" cellspacing="0" cellpadding="0" background="images/background.jpg" style="border: 1px;border-color: #F7C473; border-style: dashed; background-color: #FCF2D5">
<tr><td>
<table border="0" cellspacing="0" cellpadding="0" width="400" height="80">
<tr><td> </td></tr><tr><td align="right" valign="bottom">


<?php

include_once($cfg["path"]["contenido"].$cfg["path"]["includes"]."functions.con.php");

$catStart = "2";

if ($catStart != "") {
$catIds = conDeeperCategoriesArray($catStart);

echo \'<table cellpadding="0" cellspacing="0" border="0"><tr>\';
echo \'<td><img src="images/wuerfel.gif"></td>\';

if ( is_array($catIds) ) {

foreach($catIds as $key=>$val) {
// Ersten Eintrag ueberspringen, weil das der Menupunkt selbst ist
// und nicht angezeigt werden soll.
if ($key != 0) {

$sql = "SELECT CAT.idcat AS idcat, name FROM ".
$cfg["tab"]["cat"]." AS CAT, ".
$cfg["tab"]["cat_lang"]." AS CATLANG
WHERE CAT.idcat = ".$val."
AND CAT.idcat = CATLANG.idcat
AND CATLANG.idlang = \'$lang\'
AND CATLANG.visible = \'1\'";

$db->query($sql);

while ( $db->next_record() ) {
echo \'<td height="21" class=".navigation" style="border: 0px; border-top:1px; border-color: #F7C473; border-style: dashed; background-color: #FFFFFF; padding-left:7px; padding-right:7px;">
<a class="klein" href="front_content.php?idcat=\'.$db->f("idcat").\'">\'.$db->f("name").\'</a></td>\';
} // end while
} // if
} // end foreach
} // end if (is_array)

echo \'</tr></table>\';

}
?>



</td></tr>
</table>
</td></tr>
</table>

</td>
<td width="200" align="center"><?php

if ("http://www.polarlichtinfo.de/cms/upload ... f_logo.gif" != "") {

$img = \'<img src="http://www.polarlichtinfo.de/cms/upload ... f_logo.gif" border="0">\';

if ("http://www.polarlichtinfo.de/cms/" != "http://") {
$img = sprintf(\'<a href="%s" target="%s">%s</a>\',"http://www.polarlichtinfo.de/cms/", "", $img);

}

echo $img;

}

echo " ";
echo "";
echo " ";
echo "";
echo " ";

?>
</td>
</tr>

<tr><td colspan="3" height="5"></td></tr>

<tr>
<td align="right" valign="top">

<?php

/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* Modulname : Navigation 1.1
* Author : Jan Lengowski
* Copyright : Contenido - four for business
* Created : 15-05-2003
* Modified : 26-05-2003
************************************************/

if ( !is_object($db2) ) {
$db2 = new DB_Contenido;
}

/**
* Check if a category is child
* of another category
*
* @return boolean true/false
* @author Jan Lengowski <Jan.Lengowski@4fb.de>
* @copyright four for business AG 2003
*/
function catIsChildOf($id, $idparent) {

global $cfg, $client, $lang;

$db = new DB_Contenido;

$parent = $id;

while ( $parent != 0 ) {

$sql = "SELECT
a.parentid
FROM
".$cfg["tab"]["cat"]." AS a,
".$cfg["tab"]["cat_lang"]." AS b
WHERE
a.idclient = \'".$client."\' AND
b.idlang = \'".$lang."\' AND
a.idcat = b.idcat AND
a.idcat = \'".$parent."\'";

$db->query($sql);
$db->next_record();

$parent = $db->f("parentid");

if ($parent == $idparent) {
return true;
}

}

return false;

}

if ( catIsChildOf($idcat, 1) ) {
$sel_idcat = $idcat;
} else {
$sel_idcat = 1;
}

/* Include Template Class */
include_once($cfg["path"]["contenido"] . \'classes/class.template.php\');

/**
* Array storing alle the
* navigation data
*/
$navitems = array();

/* Template Instance */
$tpl = new Template;

/**
* Recursive function for creating
* the navigation array
* @param Int $idcat Category id
*/
function nav($idcat) {

global $navitems, $client, $lang, $cfg;

$db = new DB_Contenido;
$db2 = new DB_Contenido;

$sql = "SELECT parentid FROM ".$cfg["tab"]["cat"]." WHERE idcat = \'$idcat\'";

$db->query($sql);
$db->next_record();

$parentid = $db->f("parentid");

if ( $parentid == 0 ) {

if ( $idcat != 1 ){

$navitems = array();

$sql = "SELECT
A.idcat,
C.name
FROM
".$cfg["tab"]["cat_tree"]." AS A,
".$cfg["tab"]["cat"]." AS B,
".$cfg["tab"]["cat_lang"]." AS C
WHERE
A.idcat = B.idcat AND
B.idcat = C.idcat AND
B.idclient = \'$client\' AND
C.idlang = \'$lang\' AND
C.visible = \'1\' AND
B.parentid = \'1\'
ORDER
BY A.idtree";

$db->query($sql);

while ($db->next_record()) {

/* Check for external redirects... */
$sql = "SELECT
a.external_redirect AS ext
FROM
".$cfg["tab"]["art_lang"]." AS a,
".$cfg["tab"]["cat_art"]." AS b,
".$cfg["tab"]["cat"]." AS c
WHERE
b.idcat = \'".$db->f("idcat")."\' AND
b.is_start = \'1\' AND
c.idclient = \'".$client."\' AND
c.idcat = b.idcat AND
a.idart = b.idart AND
a.idlang = \'".$lang."\'";

$db2->query($sql);
$db2->next_record();

$target = ( $db2->f("ext") == 0 ) ? \'_self\' : \'_blank\';

$navitems[$db->f("idcat")] = array("idcat" => $db->f("idcat"),
"name" => $db->f("name"),
"target" => $target);
}

}

return true;
}

$sql = "SELECT
A.idcat,
C.name
FROM
".$cfg["tab"]["cat_tree"]." AS A,
".$cfg["tab"]["cat"]." AS B,
".$cfg["tab"]["cat_lang"]." AS C
WHERE
A.idcat = B.idcat AND
B.idcat = C.idcat AND
B.idclient = \'$client\' AND
C.idlang = \'$lang\' AND
C.visible = \'1\' AND
B.parentid = \'$parentid\'
ORDER BY
A.idtree";

$db->query($sql);

while ($db->next_record()) {

/* Check for external redirects... */
$sql = "SELECT
a.external_redirect AS ext
FROM
".$cfg["tab"]["art_lang"]." AS a,
".$cfg["tab"]["cat_art"]." AS b,
".$cfg["tab"]["cat"]." AS c
WHERE
b.idcat = \'".$db->f("idcat")."\' AND
b.is_start = \'1\' AND
c.idclient = \'".$client."\' AND
c.idcat = b.idcat AND
a.idart = b.idart AND
a.idlang = \'".$lang."\'";

$db2->query($sql);
$db2->next_record();

$target = ( $db2->f("ext") == 0 ) ? \'_self\' : \'_blank\';

$tmp_nav[$db->f("idcat")] = array("idcat" => $db->f("idcat"),
"name" => $db->f("name"),
"target" => $target);
}

$tmp_nav[$idcat]["sub"] = $navitems;
$navitems = $tmp_nav;

/* Function call */
nav($parentid);

} // end function

$sql = "SELECT
A.idcat,
C.name
FROM
".$cfg["tab"]["cat_tree"]." AS A,
".$cfg["tab"]["cat"]." AS B,
".$cfg["tab"]["cat_lang"]." AS C
WHERE
A.idcat = B.idcat AND
B.idcat = C.idcat AND
B.idclient = \'$client\' AND
C.idlang = \'$lang\' AND
C.visible = \'1\' AND
B.parentid = \'$sel_idcat\'
ORDER BY
A.idtree";

$db->query($sql);

while ( $db->next_record() ) {

/* Check for external redirects... */
$sql = "SELECT
a.external_redirect AS ext
FROM
".$cfg["tab"]["art_lang"]." AS a,
".$cfg["tab"]["cat_art"]." AS b,
".$cfg["tab"]["cat"]." AS c
WHERE
b.idcat = \'".$db->f("idcat")."\' AND
b.is_start = \'1\' AND
c.idclient = \'".$client."\' AND
c.idcat = b.idcat AND
a.idart = b.idart AND
a.idlang = \'".$lang."\'";

$db2->query($sql);
$db2->next_record();

$target = ( $db2->f("ext") == 0 ) ? \'_self\' : \'_blank\';

$navitems[$db->f("idcat")] = array("idcat" => $db->f("idcat"),
"name" => $db->f("name"),
"target" => $target);
}

/* Create Navigation Array */
nav($sel_idcat);

/* Start Output buffer */
ob_start();

echo \'<table cellspacing="0" cellpadding="0" border="0">\';

foreach ($navitems as $key => $data) {

/* 1. Navigations Ebene */
$tpl->reset();
$tpl->set(\'d\', \'NAME\', $data[\'name\']);
$tpl->set(\'d\', \'TARGET\', $data[\'target\']);
$tpl->set(\'d\', \'HREF\', $sess->url(\'front_content.php?idcat=\'.$data[\'idcat\']));
$tpl->next();

if ($idcat == $data[\'idcat\'] || is_array($data[\'sub\'])) {
$tpl->generate(\'templates/navfirst_on.html\');
} else {
$tpl->generate(\'templates/navfirst_off.html\');
}

if (is_array($data[\'sub\'])) {

foreach ($data[\'sub\'] as $key => $data) {

/* 2. Navigations Ebene */
$tpl->reset();
$tpl->set(\'d\', \'NAME\', $data[\'name\']);
$tpl->set(\'d\', \'TARGET\', $data[\'target\']);
$tpl->set(\'d\', \'HREF\', $sess->url(\'front_content.php?idcat=\'.$data[\'idcat\']));
$tpl->next();

if ($idcat == $data[\'idcat\'] || is_array($data[\'sub\'])) {
$tpl->generate(\'templates/navsecond_on.html\');
} else {
$tpl->generate(\'templates/navsecond_off.html\');
}

if (is_array($data[\'sub\'])) {

foreach ($data[\'sub\'] as $key => $data) {

/* 3. Navigations Ebene */
$tpl->reset();
$tpl->set(\'d\', \'NAME\', $data[\'name\']);
$tpl->set(\'d\', \'TARGET\', $data[\'target\']);
$tpl->set(\'d\', \'HREF\', $sess->url(\'front_content.php?idcat=\'.$data[\'idcat\']));
$tpl->next();

if ($idcat == $data[\'idcat\']) {
$tpl->generate(\'templates/navthird_on.html\');
} else {
$tpl->generate(\'templates/navthird_off.html\');
}

} // end foreach

} // end if

} // end foreach

} // end if

} // end foreach

echo \'</table>\';

/* Read out buffer */
$html = ob_get_contents();

/* Clean buffer */
ob_end_clean();

/* Output buffer-contents */
echo $html;

?>



</td>
<td valign="top">

<table width="400" height="50%" border="0" cellspacing="0" cellpadding="0" style="border: 1px;border-color: #F7C473; border-style: dashed; background-color: #FCF2D5">
<tr><td height="20" colspan="2"> </td></tr>
<tr><td rowspan="3" width="25"> </td>
<td valign="top" height="30" class="headline"><?php echo "Impressum"; ?>
</td></tr>
<tr><td valign="top" height="30" class="subheadline"><?php echo ""; ?>
</td></tr>
<tr><td valign="top" height="100%" class="text"><?php echo "Vergessen Sie nicht, auch ein Impressum anzugeben."; ?>
</td></tr>
</table>

</td>

<td align="center" valign="top">

<table cellspacing="0" cellpadding="0" border="0">

<tr>
<td><?php
/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* REFERENZ MODUL / ARTIKELLISTE
*
* Artikelliste mit Img 1, Head 1, Head 2
*
* Erstellt eine Liste mit allen Artikel bis
* auf den Startartikel.
*
* Author : Jan Lengowski
* Copyright : four for business AG
* Created : 15-08-2002
* Modified : 16-08-2002
************************************************/

// second db class instance
$db2 = new DB_Contenido;

// selected category
$selcat = "12";

if($selcat!="0" && $selcat!=""){

// select all articles in category widthout start article
$query = "SELECT ARTLANG.idart, ARTLANG.idartlang FROM ".$cfg["tab"]["cat_art"]." AS CATART, ".
$cfg["tab"]["art_lang"]." AS ARTLANG ".
"WHERE CATART.idcat = \'$selcat\' AND ARTLANG.idart = CATART.idart AND ARTLANG.idlang = \'$lang\' AND ".
"ARTLANG.online = \'1\' ORDER BY CATART.idart DESC";

// execute query
$db->query($query);

unset($articleID);
unset($linkID);

// get id\'s of sub articles
while ($db->next_record()) {
$articleID[] = $db->f("idartlang");
$linkID[] = $db->f("idart");
} // end while

// loop through subarticles

echo \'
<table width="165" border="0" cellspacing="0" cellpadding="0">
<tr><td height="30" colspan="2" ></td></tr>
<tr><td height="21" width="22" style="border: 0px; border-top:1px; border-bottom:1px; border-color: #F7C473; border-style: solid; background-color: #FCF2D5"><img src="images/wuerfel.gif" width="22" height="21" border="0"></td>
<td width="143" style="border: 1px; border-left:0px; border-color: #F7C473; border-style: dashed; background-color: #FCF2D5; padding-left:10px" class="punkte">News</td></tr>
\';

if (is_array($articleID)) {

foreach ($articleID as $key => $value) {

// select all CMS variables of the article
$sql = "SELECT * FROM ".$cfg["tab"]["content"]." WHERE idartlang = \'$value\' AND idtype = \'1\' AND typeid = \'1\'";
$db->query($sql);
$db->next_record();
$head = $db->f("value");

if ( strlen($head) > "50") {
$head = substr($head, 0, "50");
$head .= \'..\';
}

// link
$link = $sess->url("front_content.php?client=$client&lang=$lang&idcat=$selcat&idart=$linkID[$key]&m=$m&s=$s");

echo \'<tr><td colspan="2" class="text" height="22" style="border: 1px; border-top:0px; border-color: #F7C473; border-style: dashed; background-color: #FCF2D5; padding-left:10px"><a href="\'.$link.\'">\'.urldecode($db->f("value")).\'</a></td></tr>\';

} // end while

unset($headline);
unset($text);

} // end foreach

} // end if (is_array)

echo \'</table> \';

?>

</td>
</tr>

<tr>
<td><?php

if ("http://www.polarlichtinfo.de/cms/upload ... banner.jpg" != "") {

$img = \'<img src="http://www.polarlichtinfo.de/cms/upload ... banner.jpg" border="0">\';

if ("http://www.polarlichtinfo.de/cms/" != "http://") {
$img = sprintf(\'<a href="%s" target="%s">%s</a>\',"http://www.polarlichtinfo.de/cms/", "", $img);

}

echo $img;

}

echo " ";
echo "";
echo " ";
echo "";
echo " ";

?>
</td>
</tr>

<tr>
<td><?php

if ("http://www.polarlichtinfo.de/cms/upload ... b_logo.gif" != "") {

$img = \'<img src="http://www.polarlichtinfo.de/cms/upload ... b_logo.gif" border="0">\';

if ("http://www.polarlichtinfo.de/cms/" != "http://") {
$img = sprintf(\'<a href="%s" target="%s">%s</a>\',"http://www.polarlichtinfo.de/cms/", "", $img);

}

echo $img;

}

echo " ";
echo "";
echo " ";
echo "";
echo " ";

?>
</td>
</tr>

</table>

</td></tr></table>

</td></tr></table>
</body>
</html>', '1', '1') 
[24-Nov-2003 17:46:46] Invalid SQL: lock tables con_sequence write 
[24-Nov-2003 17:46:46] lock() failed.
[24-Nov-2003 17:46:46] cannot lock con_sequence - has it been created?
[24-Nov-2003 17:46:46] Invalid SQL: INSERT INTO con_stat (visited, idcatart, idlang, idstat, idclient) VALUES ('1', '30', '1', '0', '1') 
[24-Nov-2003 17:46:46] PHP Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /var/www/web371/html/cms/front_content.php(546) : eval()'d code on line 21
[24-Nov-2003 17:46:46] PHP Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /var/www/web371/html/cms/front_content.php(546) : eval()'d code on line 51

Alles in allem scheint es aber besser zu laufen als vorher ...

Gruß
Ralf

ttb · Beitrag von **ttb** » Mo 24. Nov 2003, 18:02

Es kann eigentlich nicht laufen, da du das Lock-Recht für die DB nicht besitzt. - Sag mal deinem Provider, dass er es dir geben soll - dann funktioniert Contenido auch.