4.4.5 und php 5

Gesperrt
general2000plus
Beiträge: 53
Registriert: Mi 5. Jan 2005, 13:58
Wohnort: Coellefornia
Kontaktdaten:

4.4.5 und php 5

Beitrag von general2000plus »

ich habe php 5 und mysql 4.0.22 auf meinem webserver installiert. nach dem ich die 4.4.5 version installiert hatte bekam ich folgende fehlermeldung in der contenido upgrade error log:

Code: Alles auswählen

2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_art CHANGE COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN idart int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN title varchar(255) NOT NULL  
2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN pagetitle varchar(255) NOT NULL  
2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN summary text NULL  
2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN author varchar(32) NULL  
2005-Apr-Sun 20:39:46: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN modifiedby varchar(32) NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN online tinyint(1) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN redirect int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN redirect_url varchar(255) NOT NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN artsort int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN timemgmt tinyint(1) NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN datestart datetime NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN dateend datetime NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN status int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN free_use_01 mediumint(7) NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN free_use_02 mediumint(7) NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN free_use_03 mediumint(7) NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN time_move_cat mediumint(7) NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN time_target_cat mediumint(7) NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediumint(7) NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN time_online_move mediumint(7) NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'char(1) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'char(1) NOT NULL' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN external_redirect char(1) NOT NULL  
2005-Apr-Sun 20:39:47: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(1) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(1) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_art_lang CHANGE COLUMN locked int(1) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat CHANGE COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat CHANGE COLUMN parentid int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat CHANGE COLUMN preid int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat CHANGE COLUMN postid int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat CHANGE COLUMN status int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NOT NULL' at line 1
  ALTER TABLE con_cat CHANGE COLUMN author varchar(32) NOT NULL  
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1
  ALTER TABLE con_cat CHANGE COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1
  ALTER TABLE con_cat CHANGE COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_art CHANGE COLUMN idcat int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_art CHANGE COLUMN idart int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_art CHANGE COLUMN is_start tinyint(1) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_art CHANGE COLUMN status int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NOT NULL' at line 1
  ALTER TABLE con_cat_art CHANGE COLUMN author varchar(32) NOT NULL  
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1
  ALTER TABLE con_cat_art CHANGE COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1
  ALTER TABLE con_cat_art CHANGE COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2005-Apr-Sun 20:39:48: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '1'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '1'' at line 1
  ALTER TABLE con_cat_art CHANGE COLUMN createcode tinyint(1) NOT NULL DEFAULT '1' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_tree CHANGE COLUMN idcat int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(2) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(2) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_tree CHANGE COLUMN level int(2) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_lang CHANGE COLUMN idcat int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_lang CHANGE COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_lang CHANGE COLUMN idtplcfg int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1
  ALTER TABLE con_cat_lang CHANGE COLUMN name varchar(255) NOT NULL  
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_lang CHANGE COLUMN visible tinyint(1) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'tinyint(1) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_lang CHANGE COLUMN public tinyint(1) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_cat_lang CHANGE COLUMN status int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NOT NULL' at line 1
  ALTER TABLE con_cat_lang CHANGE COLUMN author varchar(32) NOT NULL  
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1
  ALTER TABLE con_cat_lang CHANGE COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1
  ALTER TABLE con_cat_lang CHANGE COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1
  ALTER TABLE con_clients CHANGE COLUMN name varchar(255) NOT NULL  
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(32) NOT NULL' at line 1
  ALTER TABLE con_clients CHANGE COLUMN author varchar(32) NOT NULL  
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1
  ALTER TABLE con_clients CHANGE COLUMN created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '0000-00-00 00:00:00'' at line 1
  ALTER TABLE con_clients CHANGE COLUMN lastmodified datetime NOT NULL DEFAULT '0000-00-00 00:00:00' 
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1
  ALTER TABLE con_clients CHANGE COLUMN path varchar(255) NOT NULL  
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1
  ALTER TABLE con_clients CHANGE COLUMN frontendpath varchar(255) NOT NULL  
2005-Apr-Sun 20:39:49: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255) NOT NULL' at line 1
  ALTER TABLE con_clients CHANGE COLUMN htmlpath varchar(255) NOT NULL  
2005-Apr-Sun 20:39:50: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_clients CHANGE COLUMN errsite_cat int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:50: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_clients CHANGE COLUMN errsite_art int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:50: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_clients_lang CHANGE COLUMN idclient int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:50: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_clients_lang CHANGE COLUMN idlang int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:50: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_code CHANGE COLUMN idcatart int(10) NOT NULL DEFAULT '0' 
2005-Apr-Sun 20:39:50: error 1064 (You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1) - MySQL error 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) NOT NULL DEFAULT '0'' at line 1
  ALTER TABLE con_code CHANGE COLUMN idlang int(10) NOT NULL DEFAULT '0' 
kann mir einer von euch helfen und mir sagen was da schief gelaufen ist?

danke für eure hilfe.

gruss
kai
emergence
Beiträge: 10653
Registriert: Mo 28. Jul 2003, 12:49
Wohnort: Austria
Kontaktdaten:

Beitrag von emergence »

ist ein bug,
der sich jedoch bei einem upgrade innerhalb der 4.4.x serie nicht auswirkt.
kannst du ignorieren...
*** make your own tools (wishlist :: thx)
Gesperrt