Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 23 May 2017, 19:19
dchan dchan is offline
 
Join Date: May 2006
ImpEx and database issue

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.
Reply With Quote
  #2  
Old 23 May 2017, 19:28
Dave Dave is offline
 
Join Date: Jun 2010
Real name: 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)
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 23 May 2017, 19:43
dchan dchan is offline
 
Join Date: May 2006
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.
Reply With Quote
  #4  
Old 23 May 2017, 20:55
Dave Dave is offline
 
Join Date: Jun 2010
Real name: 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.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #5  
Old 23 May 2017, 21:25
dchan dchan is offline
 
Join Date: May 2006
DHHHH

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 23 May 2017 at 21:30 ---------------

Thanks for that. One step closer.

Very much appreciate it.

--------------- Added 23 May 2017 at 21:36 ---------------

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?
Reply With Quote
  #6  
Old 25 May 2017, 14:20
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
google is your friend

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

I've been supporting vBulletin and Wordpress for over a decade, contact me for any assistance.
Interested in DNA testing or drug testing information, look here.
Reply With Quote
  #7  
Old 26 May 2017, 01:44
dchan dchan is offline
 
Join Date: May 2006
Originally Posted by Brandon Sheley View Post
past that part. Now working on getting ImpEx to transfer the data.

DC
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 17:10.

Layout Options | Width: Wide Color: