ImpEx and database issue

[dchan]

Hi

I do understand ImpEx is no longer a supported plugin but I am still looking for a little help.

I am attempting to import some data from a postgreSql database (huddler).

I have set up a new vbulletin server to do this test.

Windows 2012
PHP 5.6.3
mysql 5.7
vbulletin 4.2.5

Everything seemed to install properly.

I downloaded the latest ImpEx from github, and modified the Impexconfig.php as recommended, put each of the files in the directories that are suggested

I open the admincp and installed the Impex xml.

I now have the import tab on the left. I click through to the import, it asks me for the passcode. I enter it and get a "success" and "redirecting"

And then I get a dialog box that says

mysql error: link-id == false, connect failed.

and here I'm stuck.

I have gone around several directions trying to get past this connect error and I must be missing something somewhere.

I have enabled the Mysql extension even though it's not supported.
I've tried modifying the Impexconfig to try to use mysqli even though that's not supported.

All seem to result in the same error.

can anyone give me some guidance on this. What to try?

Thanks.

[Dave]

I checked the code of Impex and it seems that it will show that error when it can't connect to the MySQL server.

You might be able to see more detailed information if you modify db_mysql.php and replace @mysql_connect with mysql_connect. (remove the @ symbol)

[dchan]

Thanks. not seeing anywhere showing "@mysql_connect"
It looks like the whole db_mysql.php has @mysqli_
as it's settings.

BTW, Thanks for the very fast suggestion.

Will continue to look.

[Dave]

You don't see this?
https://github.com/vBZachery/vbimpex...mysql.php#L137


Regardless, the @ symbol suppresses errors so removing that will show a more detailed error.

[dchan]

after going round and round, I must be looking at one of the changed files.

Luckily I did save the original download. Checking

Thanks

--------------- Added [DATE]1495571410[/DATE] at [TIME]1495571410[/TIME] ---------------

Thanks for that. One step closer.

Very much appreciate it.

--------------- Added [DATE]1495571803[/DATE] at [TIME]1495571803[/TIME] ---------------

Now that I have the importer working, If I want to build my own script, I would try to find one that closely matches the tables of the database I currently have, (was a postgresql from huddler) and work out what tables to search and cross reference the tables to the mysql database in vbulletin?

[Brandon Sheley]

google is your friend

https://www.vbulletin.com/forum/foru...connect-failed

[dchan]

Originally Posted by Brandon Sheley

google is your friend

https://www.vbulletin.com/forum/foru...connect-failed

past that part. Now working on getting ImpEx to transfer the data.

DC