[Vinyljunky]

Hello,

Im in the process of restoring my DB to another host but I keep getting the error below

Error
SQL query:

--
-- Dumping data for table `holiday`
--
--
-- Table structure for table `icash_donations`
--
CREATE TABLE icash_donations(

id int( 11 ) NOT NULL AUTO_INCREMENT ,
FROM text NOT NULL ,
TO text NOT NULL , I get an error icon on this line
amount int( 11 ) NOT NULL default '0',
time text NOT NULL ,
PRIMARY KEY ( id )
) TYPE = MYISAM ;



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 'from text NOT NULL,
to text NOT NULL,
amount int(11) NOT NULL default '0',
' at line 3

The import works fine if I remove the icash bits from the .sql file

CREATE TABLE icash_donations (
  id int(11) NOT NULL auto_increment,
  from text NOT NULL,
  to text NOT NULL,
  amount int(11) NOT NULL default '0',
  time text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `icash_donations`
--

INSERT INTO icash_donations VALUES (1,'TheGuru','kazthorn',5,'{time()}');

I therefore guess that the error is in the code above. (Created by the icash mod)

What is wrong, how can I fix it

Many Thanks

VJ ...