I
ilker
Guest
Hoi
Ich habe 2 versch. Server versucht aber glieche fehler bekommen.
MySql version: 4.0.18 und 4.0.23a
==================
ERROR
SQL-query:
--
-- Dumping data for table `dp_confirms`
--
--
-- Table structure for table `dp_emails`
--
CREATE TABLE dp_emails(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
KEY varchar( 64 ) NOT NULL DEFAULT '',
name varchar( 255 ) NOT NULL default '',
value longtext,
name_tr varchar( 255 ) NOT NULL default '',
value_tr longtext NOT NULL ,
name_de varchar( 255 ) NOT NULL default '',
value_de longtext NOT NULL ,
name_fr varchar( 255 ) NOT NULL default '',
value_fr longtext NOT NULL ,
name_it varchar( 255 ) NOT NULL default '',
value_it longtext NOT NULL ,
name_sp varchar( 255 ) NOT NULL default '',
value_sp longtext NOT NULL ,
PRIMARY KEY ( id ) ,
UNIQUE KEY keyword( KEY ) ,
FULLTEXT KEY name( name )
) TYPE = MYISAM COMMENT = 'E-Mail Templates'
MySQL said:
#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(64) NOT NULL DEFAULT'',
name varchar(255) NOT NULL d
========================================
danke
Ich habe 2 versch. Server versucht aber glieche fehler bekommen.
MySql version: 4.0.18 und 4.0.23a
==================
ERROR
SQL-query:
--
-- Dumping data for table `dp_confirms`
--
--
-- Table structure for table `dp_emails`
--
CREATE TABLE dp_emails(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
KEY varchar( 64 ) NOT NULL DEFAULT '',
name varchar( 255 ) NOT NULL default '',
value longtext,
name_tr varchar( 255 ) NOT NULL default '',
value_tr longtext NOT NULL ,
name_de varchar( 255 ) NOT NULL default '',
value_de longtext NOT NULL ,
name_fr varchar( 255 ) NOT NULL default '',
value_fr longtext NOT NULL ,
name_it varchar( 255 ) NOT NULL default '',
value_it longtext NOT NULL ,
name_sp varchar( 255 ) NOT NULL default '',
value_sp longtext NOT NULL ,
PRIMARY KEY ( id ) ,
UNIQUE KEY keyword( KEY ) ,
FULLTEXT KEY name( name )
) TYPE = MYISAM COMMENT = 'E-Mail Templates'
MySQL said:
#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(64) NOT NULL DEFAULT'',
name varchar(255) NOT NULL d
========================================
danke