Error message

[woffie]

Getting this error when trying to run impex. I have done the impex before and never had an issue. I am trying to import IPB 3.4.6

ImpEx Database error

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

mysql error:

Date: Friday 23rd 2014f May 2014 03:39:10 PM
Database: myprefix_ipbforum
MySQL error:

[Lynne]

That looks like it couldn't connect to mysql. Is the information in your impex config.php file correct? That database must be on the same server as vbulletin.

[woffie]

Yes, the database is on the same server and the info is correct.

[CaptainAwesome]

I'm having the same problem.

Originally, i got this message:
--------------------------------------------------------------------------------------------------------------------------------------------------------

There seems to have been a problem with the database.

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: Sunday 11th 2014f May 2014 05:54:28 AM
Database: bargainf_vb4
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

--------------------------------------------------------------------------------------------------------------------------------------------------------

Someone told me to
In the /upload/impex/ folder from the impex zip open the index.php file in notepad++ or similar and look at line 271:
PHP Code:
) TYPE=MyISAM";

Change to:
PHP Code:
) ENGINE=MyISAM";




After i did that, i got this message:

There seems to have been a problem with the database.

ImpEx Database error

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

mysql error:

Date: Sunday 18th 2014f May 2014 07:49:28 AM
Database: source
MySQL error:


I'm noticing now that the database is showing up differently now. I didn't set up the software, my host did.

Any suggestions?

Thanks

Oh, and if you tell me to look at XYZ, please keep in mind i'm a total newbie so i may not be able to navigate myself around and find files as easily as an experienced user. Sometimes i see posts saying to change X but i wouldn't know where to find X.

[Lynne]

In the /impex/index.php file, change this line:

                    ) TYPE=MyISAM"; 

to this line

                    ) ENGINE=MyISAM"; 

[woffie]

In the /impex/index.php file, change this line:

 ) TYPE=MyISAM"; 

to this line

 ) ENGINE=MyISAM"; 

Already did that and I am getting the same error as the poster before me. Obviously it is an issue with impex. Like I said, I have used impex several times in the past so I know what I am doing and it is not working.

[Lynne]

If you are now getting the message regarding "Link-ID" being false, then something is wrong with the credentials you have supplied in the impex config.php file - it can't connect to the impex database.

[woffie]

If you are now getting the message regarding "Link-ID" being false, then something is wrong with the credentials you have supplied in the impex config.php file - it can't connect to the impex database.

I checked a config file from when I was using 4.1. Nothing has changed in how you fill out the config file and what I have is correct. It either does not work with one of the following vB 4.2, mysql 5.4 or IPB 3.4.6

[Lynne]

It does work with 4.2, but I don't know about with PHP5.4 or IPB3.4.6 (it was last tested with IPB3.0.3 according to the manual).