CONTENIDO Forum

Das Diskussionsforum zum Open Source Content Management System
https://forum.contenido.org/

upgrade 4.4.2 auf 4.4.4

https://forum.contenido.org/viewtopic.php?f=110&t=4917

Seite 1 von 1

upgrade 4.4.2 auf 4.4.4

Verfasst: Mo 5. Jul 2004, 19:47
von malsdgtac
Hallo zusammen,

ich habe ein Update von 4.4.2 auf 4.4.4 durchgeführt, und auch gedacht, dass alles problemlos gelaufen ist.
Wie ich gerade gemerkt habe, ist das nicht so.

Bei einem Kunden habe ich gerade alles deinstalliert und neu aufgesetzt und hoffe, dass nun alles läuft. Beim anderen war es nicht so dringen, sodaß ich hoffe, dass ihr mir noch eine andere Lösung mitteilen könnt.

Das Problem war bei beiden Kunden die Statistik, während mir bei dem einem (der ist noch nicht neu gemacht) die Statistik nicht archiviert wurde, zeigte der andere falsche Zugriffe an (z.B. Zugriffe 2 und Zugriffe in dieser Sprache 0 - obwohl es nur eine Sprache gibt)

Ich habe gerade erst fest gestellt, dass im UpgradeErroroLog ganz viel drinnen steht daher, poste ist das ganze hier mal.

Code: Alles auswählen

2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'idart') - Invalid SQL:   ALTER TABLE smac_art ADD COLUMN idart int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_art ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'idartlang') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN idartlang int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'idart') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN idart int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'title') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN title varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'pagetitle') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN pagetitle varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'summary') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN summary text NULL  <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN author varchar(32) NULL  <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'modifiedby') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN modifiedby varchar(32) NULL  <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'online') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN online tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'redirect') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN redirect int(6) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'redirect_url') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN redirect_url varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'artsort') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN artsort int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:07: error 1060 (Duplicate column name 'timemgmt') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN timemgmt tinyint(1) NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'datestart') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN datestart datetime NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'dateend') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN dateend datetime NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'status') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN status int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'free_use_01') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN free_use_01 mediumint(7) NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'free_use_02') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN free_use_02 mediumint(7) NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'free_use_03') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN free_use_03 mediumint(7) NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'time_move_cat') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN time_move_cat mediumint(7) NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'time_target_cat') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN time_target_cat mediumint(7) NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'time_online_move') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN time_online_move mediumint(7) NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'external_redirect') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN external_redirect char(1) NOT NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'locked') - Invalid SQL:   ALTER TABLE smac_art_lang ADD COLUMN locked int(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idcat') - Invalid SQL:   ALTER TABLE smac_cat ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_cat ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'parentid') - Invalid SQL:   ALTER TABLE smac_cat ADD COLUMN parentid int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'preid') - Invalid SQL:   ALTER TABLE smac_cat ADD COLUMN preid int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'postid') - Invalid SQL:   ALTER TABLE smac_cat ADD COLUMN postid int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'status') - Invalid SQL:   ALTER TABLE smac_cat ADD COLUMN status int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_cat ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_cat ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_cat ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idcatart') - Invalid SQL:   ALTER TABLE smac_cat_art ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idcat') - Invalid SQL:   ALTER TABLE smac_cat_art ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idart') - Invalid SQL:   ALTER TABLE smac_cat_art ADD COLUMN idart int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'is_start') - Invalid SQL:   ALTER TABLE smac_cat_art ADD COLUMN is_start tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'status') - Invalid SQL:   ALTER TABLE smac_cat_art ADD COLUMN status int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_cat_art ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_cat_art ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_cat_art ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'createcode') - Invalid SQL:   ALTER TABLE smac_cat_art ADD COLUMN createcode tinyint(1) NOT NULL DEFAULT '1' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idtree') - Invalid SQL:   ALTER TABLE smac_cat_tree ADD COLUMN idtree int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idcat') - Invalid SQL:   ALTER TABLE smac_cat_tree ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'level') - Invalid SQL:   ALTER TABLE smac_cat_tree ADD COLUMN level int(2) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idcatlang') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN idcatlang int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idcat') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN name varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'visible') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN visible tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'public') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN public tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'status') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN status int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_cat_lang ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_clients ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_clients ADD COLUMN name varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_clients ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_clients ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_clients ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'path') - Invalid SQL:   ALTER TABLE smac_clients ADD COLUMN path varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'frontendpath') - Invalid SQL:   ALTER TABLE smac_clients ADD COLUMN frontendpath varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'htmlpath') - Invalid SQL:   ALTER TABLE smac_clients ADD COLUMN htmlpath varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'errsite_cat') - Invalid SQL:   ALTER TABLE smac_clients ADD COLUMN errsite_cat int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'errsite_art') - Invalid SQL:   ALTER TABLE smac_clients ADD COLUMN errsite_art int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idclientslang') - Invalid SQL:   ALTER TABLE smac_clients_lang ADD COLUMN idclientslang int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_clients_lang ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_clients_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idcode') - Invalid SQL:   ALTER TABLE smac_code ADD COLUMN idcode int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idcatart') - Invalid SQL:   ALTER TABLE smac_code ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:08: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_code ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_code ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'code') - Invalid SQL:   ALTER TABLE smac_code ADD COLUMN code longtext NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idcontent') - Invalid SQL:   ALTER TABLE smac_content ADD COLUMN idcontent int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idartlang') - Invalid SQL:   ALTER TABLE smac_content ADD COLUMN idartlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idtype') - Invalid SQL:   ALTER TABLE smac_content ADD COLUMN idtype int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'typeid') - Invalid SQL:   ALTER TABLE smac_content ADD COLUMN typeid int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'value') - Invalid SQL:   ALTER TABLE smac_content ADD COLUMN value longtext NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'version') - Invalid SQL:   ALTER TABLE smac_content ADD COLUMN version varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_content ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_content ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_content ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_lang ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_lang ADD COLUMN name varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'active') - Invalid SQL:   ALTER TABLE smac_lang ADD COLUMN active tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_lang ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_lang ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_lang ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'encoding') - Invalid SQL:   ALTER TABLE smac_lang ADD COLUMN encoding varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idlay') - Invalid SQL:   ALTER TABLE smac_lay ADD COLUMN idlay int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_lay ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_lay ADD COLUMN name varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'description') - Invalid SQL:   ALTER TABLE smac_lay ADD COLUMN description text NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'deletable') - Invalid SQL:   ALTER TABLE smac_lay ADD COLUMN deletable tinyint(1) NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'code') - Invalid SQL:   ALTER TABLE smac_lay ADD COLUMN code text NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_lay ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_lay ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_lay ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idmod') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN idmod int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN name varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'description') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN description text NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'deletable') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN deletable tinyint(1) NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'input') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN input longtext NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'output') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN output longtext NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'template') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN template text NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'static') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN static tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_mod ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idnews') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN idnews int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idart') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN idart int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN name varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'subject') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN subject text NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'message') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN message text NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'newsfrom') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN newsfrom varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'newsdate') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN newsdate datetime NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_news ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idnewsrcp') - Invalid SQL:   ALTER TABLE smac_news_rcp ADD COLUMN idnewsrcp int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_news_rcp ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_news_rcp ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:09: error 1060 (Duplicate column name 'email') - Invalid SQL:   ALTER TABLE smac_news_rcp ADD COLUMN email varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_news_rcp ADD COLUMN name varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'deactivated') - Invalid SQL:   ALTER TABLE smac_news_rcp ADD COLUMN deactivated int(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_news_rcp ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_news_rcp ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_news_rcp ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idstat') - Invalid SQL:   ALTER TABLE smac_stat ADD COLUMN idstat int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idcatart') - Invalid SQL:   ALTER TABLE smac_stat ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_stat ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_stat ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'visited') - Invalid SQL:   ALTER TABLE smac_stat ADD COLUMN visited int(6) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'visitdate') - Invalid SQL:   ALTER TABLE smac_stat ADD COLUMN visitdate timestamp(14) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idstatarch') - Invalid SQL:   ALTER TABLE smac_stat_archive ADD COLUMN idstatarch int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'archived') - Invalid SQL:   ALTER TABLE smac_stat_archive ADD COLUMN archived varchar(6) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idcatart') - Invalid SQL:   ALTER TABLE smac_stat_archive ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_stat_archive ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_stat_archive ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'visited') - Invalid SQL:   ALTER TABLE smac_stat_archive ADD COLUMN visited int(6) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'visitdate') - Invalid SQL:   ALTER TABLE smac_stat_archive ADD COLUMN visitdate timestamp(14) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idstatus') - Invalid SQL:   ALTER TABLE smac_status ADD COLUMN idstatus int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'description') - Invalid SQL:   ALTER TABLE smac_status ADD COLUMN description varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_status ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_status ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_status ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idlay') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN idlay int(10) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idtpl') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN idtpl int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN idtplcfg int(10) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN name varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'description') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN description varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'deletable') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN deletable tinyint(1) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'status') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN status int(10) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN author varchar(32) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN created timestamp(14) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_template ADD COLUMN lastmodified timestamp(14) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL:   ALTER TABLE smac_template_conf ADD COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idtpl') - Invalid SQL:   ALTER TABLE smac_template_conf ADD COLUMN idtpl int(10) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'status') - Invalid SQL:   ALTER TABLE smac_template_conf ADD COLUMN status int(10) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_template_conf ADD COLUMN author varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_template_conf ADD COLUMN created timestamp(14) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_template_conf ADD COLUMN lastmodified timestamp(14) NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idtype') - Invalid SQL:   ALTER TABLE smac_type ADD COLUMN idtype int(6) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'type') - Invalid SQL:   ALTER TABLE smac_type ADD COLUMN type varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'code') - Invalid SQL:   ALTER TABLE smac_type ADD COLUMN code text NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'description') - Invalid SQL:   ALTER TABLE smac_type ADD COLUMN description varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'status') - Invalid SQL:   ALTER TABLE smac_type ADD COLUMN status int(11) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_type ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_type ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_type ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idupl') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN idupl int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'filename') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN filename varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'dirname') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN dirname varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'filetype') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN filetype varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'size') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN size varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'description') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN description text NOT NULL  <br><br>
2004-Jun-Fri 16:37:10: error 1060 (Duplicate column name 'status') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN status int(11) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'author') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN author varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'created') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'lastmodified') - Invalid SQL:   ALTER TABLE smac_upl ADD COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idkeyword') - Invalid SQL:   ALTER TABLE smac_keywords ADD COLUMN idkeyword int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'keyword') - Invalid SQL:   ALTER TABLE smac_keywords ADD COLUMN keyword varchar(50) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'exp') - Invalid SQL:   ALTER TABLE smac_keywords ADD COLUMN exp text NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'auto') - Invalid SQL:   ALTER TABLE smac_keywords ADD COLUMN auto text NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'self') - Invalid SQL:   ALTER TABLE smac_keywords ADD COLUMN self text NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_keywords ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idarea') - Invalid SQL:   ALTER TABLE smac_area ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'parent_id') - Invalid SQL:   ALTER TABLE smac_area ADD COLUMN parent_id varchar(255) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_area ADD COLUMN name varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'relevant') - Invalid SQL:   ALTER TABLE smac_area ADD COLUMN relevant tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'online') - Invalid SQL:   ALTER TABLE smac_area ADD COLUMN online tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idaction') - Invalid SQL:   ALTER TABLE smac_actions ADD COLUMN idaction int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idarea') - Invalid SQL:   ALTER TABLE smac_actions ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'alt_name') - Invalid SQL:   ALTER TABLE smac_actions ADD COLUMN alt_name varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_actions ADD COLUMN name varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'code') - Invalid SQL:   ALTER TABLE smac_actions ADD COLUMN code text NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'location') - Invalid SQL:   ALTER TABLE smac_actions ADD COLUMN location varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'relevant') - Invalid SQL:   ALTER TABLE smac_actions ADD COLUMN relevant tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idnavm') - Invalid SQL:   ALTER TABLE smac_nav_main ADD COLUMN idnavm int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'location') - Invalid SQL:   ALTER TABLE smac_nav_main ADD COLUMN location varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idnavs') - Invalid SQL:   ALTER TABLE smac_nav_sub ADD COLUMN idnavs int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idnavm') - Invalid SQL:   ALTER TABLE smac_nav_sub ADD COLUMN idnavm int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idarea') - Invalid SQL:   ALTER TABLE smac_nav_sub ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'level') - Invalid SQL:   ALTER TABLE smac_nav_sub ADD COLUMN level int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'location') - Invalid SQL:   ALTER TABLE smac_nav_sub ADD COLUMN location varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'online') - Invalid SQL:   ALTER TABLE smac_nav_sub ADD COLUMN online tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idright') - Invalid SQL:   ALTER TABLE smac_rights ADD COLUMN idright int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'user_id') - Invalid SQL:   ALTER TABLE smac_rights ADD COLUMN user_id varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idarea') - Invalid SQL:   ALTER TABLE smac_rights ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idaction') - Invalid SQL:   ALTER TABLE smac_rights ADD COLUMN idaction int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idcat') - Invalid SQL:   ALTER TABLE smac_rights ADD COLUMN idcat int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_rights ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_rights ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'type') - Invalid SQL:   ALTER TABLE smac_rights ADD COLUMN type tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idcontainer') - Invalid SQL:   ALTER TABLE smac_container ADD COLUMN idcontainer int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idtpl') - Invalid SQL:   ALTER TABLE smac_container ADD COLUMN idtpl int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'number') - Invalid SQL:   ALTER TABLE smac_container ADD COLUMN number int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idmod') - Invalid SQL:   ALTER TABLE smac_container ADD COLUMN idmod int(10) NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idcontainerc') - Invalid SQL:   ALTER TABLE smac_container_conf ADD COLUMN idcontainerc int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idtplcfg') - Invalid SQL:   ALTER TABLE smac_container_conf ADD COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'number') - Invalid SQL:   ALTER TABLE smac_container_conf ADD COLUMN number int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'container') - Invalid SQL:   ALTER TABLE smac_container_conf ADD COLUMN container text NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idfile') - Invalid SQL:   ALTER TABLE smac_files ADD COLUMN idfile int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idarea') - Invalid SQL:   ALTER TABLE smac_files ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'filename') - Invalid SQL:   ALTER TABLE smac_files ADD COLUMN filename varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'filetype') - Invalid SQL:   ALTER TABLE smac_files ADD COLUMN filetype varchar(4) NOT NULL DEFAULT 'main' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idframefile') - Invalid SQL:   ALTER TABLE smac_frame_files ADD COLUMN idframefile int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idarea') - Invalid SQL:   ALTER TABLE smac_frame_files ADD COLUMN idarea int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idframe') - Invalid SQL:   ALTER TABLE smac_frame_files ADD COLUMN idframe int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idfile') - Invalid SQL:   ALTER TABLE smac_frame_files ADD COLUMN idfile int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idplugin') - Invalid SQL:   ALTER TABLE smac_plugins ADD COLUMN idplugin int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_plugins ADD COLUMN idclient int(10) NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_plugins ADD COLUMN name varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'description') - Invalid SQL:   ALTER TABLE smac_plugins ADD COLUMN description text NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'path') - Invalid SQL:   ALTER TABLE smac_plugins ADD COLUMN path varchar(255) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'installed') - Invalid SQL:   ALTER TABLE smac_plugins ADD COLUMN installed tinyint(1) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'active') - Invalid SQL:   ALTER TABLE smac_plugins ADD COLUMN active tinyint(1) NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'sid') - Invalid SQL:   ALTER TABLE smac_phplib_active_sessions ADD COLUMN sid varchar(32) NOT NULL  PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_phplib_active_sessions ADD COLUMN name varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'val') - Invalid SQL:   ALTER TABLE smac_phplib_active_sessions ADD COLUMN val longblob NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'changed') - Invalid SQL:   ALTER TABLE smac_phplib_active_sessions ADD COLUMN changed varchar(14) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'user_id') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN user_id varchar(32) NOT NULL  PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'username') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN username varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'password') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN password varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'perms') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN perms varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'realname') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN realname varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'email') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN email varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:11: error 1060 (Duplicate column name 'telephone') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN telephone varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'address_street') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN address_street varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'address_zip') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN address_zip varchar(10) NOT NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'address_city') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN address_city varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'address_country') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN address_country varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'wysi') - Invalid SQL:   ALTER TABLE smac_phplib_auth_user_md5 ADD COLUMN wysi tinyint(2) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idlog') - Invalid SQL:   ALTER TABLE smac_actionlog ADD COLUMN idlog int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'user_id') - Invalid SQL:   ALTER TABLE smac_actionlog ADD COLUMN user_id varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idclient') - Invalid SQL:   ALTER TABLE smac_actionlog ADD COLUMN idclient int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idlang') - Invalid SQL:   ALTER TABLE smac_actionlog ADD COLUMN idlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idaction') - Invalid SQL:   ALTER TABLE smac_actionlog ADD COLUMN idaction int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idcatart') - Invalid SQL:   ALTER TABLE smac_actionlog ADD COLUMN idcatart int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'logtimestamp') - Invalid SQL:   ALTER TABLE smac_actionlog ADD COLUMN logtimestamp datetime NULL DEFAULT '0000-00-00 00:00:00' <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idlink') - Invalid SQL:   ALTER TABLE smac_link ADD COLUMN idlink int(6) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idartlang') - Invalid SQL:   ALTER TABLE smac_link ADD COLUMN idartlang int(10) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idcat') - Invalid SQL:   ALTER TABLE smac_link ADD COLUMN idcat int(10) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idart') - Invalid SQL:   ALTER TABLE smac_link ADD COLUMN idart int(10) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'linkpath') - Invalid SQL:   ALTER TABLE smac_link ADD COLUMN linkpath varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'internal') - Invalid SQL:   ALTER TABLE smac_link ADD COLUMN internal tinyint(1) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'active') - Invalid SQL:   ALTER TABLE smac_link ADD COLUMN active tinyint(1) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idmetatype') - Invalid SQL:   ALTER TABLE smac_meta_type ADD COLUMN idmetatype int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'metatype') - Invalid SQL:   ALTER TABLE smac_meta_type ADD COLUMN metatype varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'fieldtype') - Invalid SQL:   ALTER TABLE smac_meta_type ADD COLUMN fieldtype varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'maxlength') - Invalid SQL:   ALTER TABLE smac_meta_type ADD COLUMN maxlength int(11) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idmetatag') - Invalid SQL:   ALTER TABLE smac_meta_tag ADD COLUMN idmetatag int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idartlang') - Invalid SQL:   ALTER TABLE smac_meta_tag ADD COLUMN idartlang int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idmetatype') - Invalid SQL:   ALTER TABLE smac_meta_tag ADD COLUMN idmetatype int(10) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'metavalue') - Invalid SQL:   ALTER TABLE smac_meta_tag ADD COLUMN metavalue text NOT NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'group_id') - Invalid SQL:   ALTER TABLE smac_groups ADD COLUMN group_id varchar(32) NOT NULL  PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'groupname') - Invalid SQL:   ALTER TABLE smac_groups ADD COLUMN groupname varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'perms') - Invalid SQL:   ALTER TABLE smac_groups ADD COLUMN perms varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'description') - Invalid SQL:   ALTER TABLE smac_groups ADD COLUMN description varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idgroupprop') - Invalid SQL:   ALTER TABLE smac_group_prop ADD COLUMN idgroupprop int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'group_id') - Invalid SQL:   ALTER TABLE smac_group_prop ADD COLUMN group_id varchar(32) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'type') - Invalid SQL:   ALTER TABLE smac_group_prop ADD COLUMN type varchar(32) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'name') - Invalid SQL:   ALTER TABLE smac_group_prop ADD COLUMN name varchar(32) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'value') - Invalid SQL:   ALTER TABLE smac_group_prop ADD COLUMN value text NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idcatlang') - Invalid SQL:   ALTER TABLE smac_group_prop ADD COLUMN idcatlang int(11) NOT NULL DEFAULT '0' <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idgroupuser') - Invalid SQL:   ALTER TABLE smac_groupmembers ADD COLUMN idgroupuser int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'group_id') - Invalid SQL:   ALTER TABLE smac_groupmembers ADD COLUMN group_id varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'user_id') - Invalid SQL:   ALTER TABLE smac_groupmembers ADD COLUMN user_id varchar(32) NOT NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idconfig') - Invalid SQL:   ALTER TABLE smac_config ADD COLUMN idconfig int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'abs_path') - Invalid SQL:   ALTER TABLE smac_config ADD COLUMN abs_path varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'url_path') - Invalid SQL:   ALTER TABLE smac_config ADD COLUMN url_path varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'css_path') - Invalid SQL:   ALTER TABLE smac_config ADD COLUMN css_path varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'js_path') - Invalid SQL:   ALTER TABLE smac_config ADD COLUMN js_path varchar(255) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'filename') - Invalid SQL:   ALTER TABLE smac_config ADD COLUMN filename varchar(127) NULL  <br><br>
2004-Jun-Fri 16:37:12: error 1060 (Duplicate column name 'idconfc') - Invalid SQL:   ALTER TABLE smac_config_client ADD COLUMN idconfc int(10) NOT NULL DEFAU

Verfasst: Mo 5. Jul 2004, 22:26
von timo
die Meldungen kann man nach wie vor ignorieren...

Verfasst: Di 6. Jul 2004, 07:36
von malsdgtac
Warum wurde dann die Statistik des letzten Monats nicht archiviert? (Ich vewende 4.4.4) - es gibt dazu keine Fehlermeldungen.

Verfasst: Di 6. Jul 2004, 08:13
von timo
smac hat geschrieben:Warum wurde dann die Statistik des letzten Monats nicht archiviert? (Ich vewende 4.4.4) - es gibt dazu keine Fehlermeldungen.
Lief der Cronjob? Schau in das Verzeichnis cronjobs rein. Wenn du ein Upgrade auf die 4.4.4 erst in diesem Monat gemacht hast, kann es nicht funktionieren, da der Cronjob erst mit der 4.4.4 richtig funktioniert, du mußt dann bis zum nächsten Monat warten.

Verfasst: Di 6. Jul 2004, 12:23
von malsdgtac
Danke für die Info, ich habe nun nicht nur den Ordner cronjobs mit der 777 ausgestattet sondern auch die files darin. Mal sehen ob im nächsten Monat funktioniert.
Die 4.4.4 hatte ich schon seit letzem Monat
Alle Zeiten sind UTC+01:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de