Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 23 Apr 2017, 18:23
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Question VB 3.8.9 import into 3.8.9

I have two VB 3.8.9 databases and I'm trying to import one into the other,. First I used the most recent Impex and when that didn't work I tried the old (last VB version) of Impex and that didn't work either.

In both cases on the very first step, the Database Check, I click to start it and the request just seems to freeze/time out the page. No data gets returned, Chrome displays it's "sad face" for a broken page.

No database error is generated and no PHP errors are logged.

After this anytime I reload the admincp and click on the Impex link it just times out in the same way.

I like to think at this point I have a pretty good idea what is going on but really at a loss right now- I'm thinking a server problem but I can't confirm that.
__________________
-Joe (@BirdOPrey5) Former Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
Comments
  #2  
Old 23 Apr 2017, 18:29
Dave Dave is online now
 
Join Date: Jun 2010
Real name: Dave
Is it causing an internal server error (500)? If so, I believe in some cases it's logged in the error logs of the webserver and not of PHP.
__________________
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 Apr 2017, 18:38
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Thanks, but not seeing any mention of any 500 level error messages in the log in the last couple hours (since playing with Impex.)
__________________
-Joe (@BirdOPrey5) Former Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
  #4  
Old 24 Apr 2017, 22:03
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
Depending on the size of the target DB you might just be running into a timeout as "Check and Update database" creates the importid fields, eg. alters tables like post and user.

If that is the case i'd just add the fields manually.
Reply With Quote
  #5  
Old 25 Apr 2017, 00:17
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Originally Posted by Andreas View Post
Depending on the size of the target DB you might just be running into a timeout as "Check and Update database" creates the importid fields, eg. alters tables like post and user.

If that is the case i'd just add the fields manually.
May well be, it was a slow machine and large db. Moved to a box with more resources and trying again.
__________________
-Joe (@BirdOPrey5) Former Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
  #6  
Old 25 Apr 2017, 16:05
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Well I finally got it. I believe server resources was part of it. Also despite the broken page Google returned, while I was looking up more info the page eventually loaded and got past step 1.

Then I had completely forgot, it is better to move Impex out of the admincp and run it directly. I moved the /impex/ directory from under the forum's directory to a dedicated /impex/ directory and was able to run the import. Importing 1.5 million posts into a 2 million post board took less than an hour.

The only slow step has been rebuilding the search index, I should have asked my host to run the console file, but I hope it completes today. I have to check and restart it every so often.

But the latest version of Zachery's Impex from github worked without issue on PHP 5.4.x going from 3.8.9 into 3.8.9. (I had to choose 3.7 as the import from system since 3.8 isn't an option.)

Also, all users need to have an email address or they won't import for some reason, despite the fact VB 3.x doesn't require email addresses. Once I gave them all dummy email accounts they imported fine.

I deleted the emails with a query after the import.

Thanks all.
__________________
-Joe (@BirdOPrey5) Former Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
  #7  
Old 22 May 2017, 15:54
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
I think emails are required as after the import, you need some way to reset your email (just thinking about how the system works, I haven't looked at the code in a bit.)
__________________
Looking for ImpEx?
Reply With Quote
  #8  
Old 23 May 2017, 11:21
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Makes sense. In my case the imported content was just for archiving purposes. None of the imported users were ever going to login. There is not going to be anyway to login as these users, they all have a random complex password (via mysql query) and no way to reset it.
__________________
-Joe (@BirdOPrey5) Former Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Miscellaneous Hacks 404 / 301 after import redirect on import ids Jerry vBulletin 3.6 Add-ons 84 30 Jun 2014 16:27



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
Forum Jump


New To Site? Need Help?

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

Layout Options | Width: Wide Color: