hi. i am getting an error when i am trying to install the contrib/import.module

here it is:

Error

SQL-query :

CREATE TABLE feed(
nid int( 10 ) unsigned NOT NULL default '0',
url varchar( 255 ) NOT NULL default '',
refresh int( 10 ) NOT NULL default '0',
link varchar( 255 ) NOT NULL default '',
DATA text,
expire int( 10 ) NOT NULL ,
default '0',
PRIMARY KEY ( nid ) ,
KEY link( link ) ,
KEY url( url )
) TYPE = MYISAM

MySQL said:

You have an error in your SQL syntax near 'default '0',
PRIMARY KEY (nid),
KEY link (link),
KEY url (url)
) TYPE' at line 7

how can i change the sql query so that it will work?

erik.

Comments

ax’s picture

between "expire int(10) NOT NULL" and "default '0'". FIXED this in CVS.