vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   ImpEx and database issue (https://vborg.vbsupport.ru/showthread.php?t=325128)

dchan 05-23-2017 04:19 PM

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.

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...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 [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 05-25-2017 11:20 AM

google is your friend ;)

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

dchan 05-25-2017 10:44 PM

Quote:

Originally Posted by Brandon Sheley (Post 2586938)

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

DC


All times are GMT. The time now is 04:49 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00999 seconds
  • Memory Usage 1,725KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete