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]

Originally Posted by ozzy47

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]

Originally Posted by ozzy47

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 [DATE]1384442750[/DATE] at [TIME]1384442750[/TIME] ---------------

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 !