Impex problem

[Spangle]

I submitted this to support last night, but as yet haven't had a reply, the question has also been asked on the official forum with no definitive reply

when using Impex I get the following :

ImpEx Database error

mysql error: Invalid SQL: CREATE TABLE impexerror (
errorid bigint(20) unsigned NOT NULL auto_increment,
errortype varchar(10) NOT NULL default '',
classnumber varchar(3) NOT NULL default '',
importid bigint(20) NOT NULL default 0,
error varchar(250) default 'NULL',
remedy varchar(250) default 'NULL',
PRIMARY KEY (errorid)
) TYPE=MyISAM

mysql error: 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 'TYPE=MyISAM' at line 9

mysql error number: 1064

Date: Wednesday 13th 2013f November 2013 11:03:22 AM
Database: footbal9_football
MySQL error: 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 'TYPE=MyISAM' at line 9

[ozzy47]

What ever you are importing from, change TYPE=MyISAM to ENGINE=MyISAM

[Spangle]

What ever you are importing from, change TYPE=MyISAM to ENGINE=MyISAM

I don't have that line in Inpexconfig.php

[ozzy47]

Where are you importing from/to?

[Spangle]

Where are you importing from/to?

I've cured that issue, now I have another problem that Impex says it cannot connect to the source database, despite me giving it the IP in the config file

--------------- Added 1384442750 at 1384442750 ---------------

This is error I'm getting now as posted on the official site

ImpEx Database error

mysql error: Link-ID == false, connect failed

mysql error:

Date: Thursday 14th 2013f November 2013 04:16:04 PM
Database: talkofth_vb
MySQL error:

I've checked the IP with the hosts and that is correct !