DB-Sicherung

helmut · Beitrag von **helmut** » So 26. Okt 2003, 18:29

Hallo,

ich möchte gerne von Version 4.3.2 auf 4.4 upgraden. Vorher wollte ich die DB sichern. Ging zwar (mit phpadmin, Version 2.3.0), aber bei der probeweisen Rückspielung des Dump hagelte es Fehlermeldungen, z.B. bei der Tabelle con_actionlog: "logtimestamp datetimeDEFAULT '0000-00-00 00:00:00' syntax-Fehler. Habe ich mittlerweile behoben (hat nur ein Leerzeichen gefehlt), aber bei con_area gings dann gleich weiter: key idarea doppelt vorhanden ...
Frage: haben andere da auch Schwierigkeiten oder tritt der Fehler nur bei mir auf?
Was kann ich machen, um trotzdem den Dump wieder einspielen zu können?

Jede Hilfe herzlich willkommen!!!

Helmut

timo · Beitrag von **timo** » Mo 27. Okt 2003, 18:13

Hallo Helmut,

hast du versucht, das Backup über eine existierende Datenbank zurückzuspielen? Wenn ja, würde ich die DB sichern, komplett droppen und das vorherige Backup einspielen.

Grüße,
Timo

helmut · Beitrag von **helmut** » Mo 27. Okt 2003, 19:43

danke für Deine Antwort. Ich verstehe sie nicht ganz - aber vielleicht waren meine Angaben auch zu dürftig.
Also: ich habe eine Contenido-Website (Entwurf) bei puretec laufen (mysql-Datenbank). Diese Entwurfsseite lief bisher mit Version 4.3.2. Ich möchte sie nun auf 4.4. upgraden, vorher aber die DB-Tabellen der bestehenden Installation auf jeden Fall sichern. Ich habe also einen dump aller Contenido-Tabellen gemacht. Dann wollte ich probieren, ob ich die Tabellen auch reibungslos zurück spielen kann. Habe deshalb die Tabellen der Entwurfs-Website in der puretec-mysql-DB umbenannt (Prefix geändert) und dann versucht den Dump zurückzuspielen. Dabei traten dann die genannten Fehlermeldungen (alles mysql-syntax-Fehler) auf.
Bei dieser Entwurfsseite ist das alles zwar nicht so dramatisch, aber wenn diese Fehler immer immer auftreten, gibt es bei "echten" Websites dicke Probleme mit einem Backup. Auch die Vorgehensweise, alle Syntax-Fehler zu finden und zu korregieren, dürfte problematisch werden, da dadurch die Tabellenstruktur gegenüber den Original-Contenido-Tabellen verändert wird und Contenido dann vielleicht Schwierigkeiten mit der Datenabfrage macht.
Ich finde Contenido einfach super und Euere Version 4.4 ist wirklich im Großen und Ganzen sehr gut gelungen. Es wird mein System für die Zukunft sein. Aber ggf. kein funktionierendes DB-Backup machen zu können, stellt für mich ein Riesenproblem dar.
Fragen:
Stimmt die Syntax bei den Contenido-Original-Tabellen nicht?
Ist dieses Problem bei Euch bekannt und gibt es Lösungen dafür?
Oder stimmt da etwas mit meinen System nicht?

Bin für jede Antwort dankbar ...

helmut · Beitrag von **helmut** » Mo 27. Okt 2003, 19:53

Habe jetzt die Entwurfswebsite auch ohne Sicherung der DB-Tabellen upgedatet (schreckliches Wort ...!). Lief auch alles Bestens, Website ist weiterhin reibungslos zu nutzen.
Allerdings habe ich in der contenido-upgrade-error-log jede Menge Error-Meldungen, die auf die fehlerhafte mysql-Syntax (wie oben beschrieben) hinweisen.
Hier die Fehlermeldungen:

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

timo · Beitrag von **timo** » Di 28. Okt 2003, 10:17

Hallo helmut,

ich denke, es gibt da einfach ein Verständnisproblem. Du solltest, wenn du ein Backup zurückspielst, die Tabellen vorher alle löschen. Die SQL-Statements sind an sich nicht falsch, nur zeigen sie, daß dort Dinge doppelt gemacht werden (z.b. einen Key auf eine Tabelle gelegt werden, wo es schon einen Key gibt).

helmut hat geschrieben:Habe deshalb die Tabellen der Entwurfs-Website in der puretec-mysql-DB umbenannt (Prefix geändert) und dann versucht den Dump zurückzuspielen. Dabei traten dann die genannten Fehlermeldungen (alles mysql-syntax-Fehler) auf.

War der Dump auch fehlerfrei?

Auch die Vorgehensweise, alle Syntax-Fehler zu finden und zu korregieren, dürfte problematisch werden, da dadurch die Tabellenstruktur gegenüber den Original-Contenido-Tabellen verändert wird und Contenido dann vielleicht Schwierigkeiten mit der Datenabfrage macht.

Es sei dir versichert, daß dies nicht an Contenido liegt (bzw liegen kann).

Stimmt die Syntax bei den Contenido-Original-Tabellen nicht?

Nein, sofern du den Dump mit den richtigen Optionen gemacht hast, sollte es da kein Problem geben.

Hoffe, daß es geholfen hat

Grüße,
Timo

CONTENIDO Forum

DB-Sicherung

DB-Sicherung

Hallo timo

Ergänzung ...

Re: Hallo timo