ImpEx and database issue [Archive]

View Full Version : ImpEx and database issue

dchan

05-23-2017, 04:19 PM

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

05-23-2017, 04:28 PM

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

05-23-2017, 04:43 PM

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

05-23-2017, 05:55 PM

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

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

dchan

05-23-2017, 06:25 PM

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 1495571410 at 1495571410 ---------------

Thanks for that. One step closer.

Very much appreciate it.

--------------- Added 1495571803 at 1495571803 ---------------

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

05-25-2017, 11:20 AM

google is your friend ;)

https://www.vbulletin.com/forum/forum/vbulletin-legacy-versions-products/legacy-vbulletin-versions/vbulletin-3-0-how-do-i-and-troubleshooting-forum/148650-error-link-id-false-connect-failed

dchan

05-25-2017, 10:44 PM