Resource icon

vBulletin Big Board Importer [vBulletin 3 + vBulletin 4] [Paid] 1.5.0

No permission to buy ($150.00)
Overview Updates (9) Reviews (3) History Discussion
Heya @Slavik @Jake Bunce - I'm having a heck of a time trying to do this last final server import, after having had success doing my dev setup.

The only thing that's changed is, before, I made a complete copy of my live DB, and ran all imports off of "localhost" (since my live server and dev were separate).

The new attempt, I am looking to pull data from the live server (using: protected $slaveDbHost = 'ip.add.re.ss';).

I am running the 1-8 separate.
Posts seem to work fine (had to use the iconv-chunks method @arn recommended).

When I try to run users, I get:
user & user authenticateAn unexpected database error occurred. Please try again later.
<!-- Mysqli prepare error: Table '[myDBname].user' doesn't exist -->

This db and table do exist though? I searched this thread and didn't see anything that has helped me. Have you all run into this issue?

Log within XF:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table '[myDBname].user' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Click to expand...

I'm using latest Export/Import, and latest XF version.

EDIT:
When I try to export threads, I get:

exporting threads...
threads (882,690 records in 17.60s)...
watched threads (152,421 records in 0.47s)...
thread user post (3,888,487 records in 36.91s)...
pollsAn unexpected database error occurred. Please try again later.
<!-- Mysqli prepare error: Table '[myDBname].poll' doesn't exist -->

Attachments and avatars also generate the error, Misc, Forums, Private Messages did fine.
 
Last edited:
Is your source and destination databases on different servers?

For some tables, they require both to be on the same server to run some joins.
 
Yeah 2 different servers.

Do I need to pull the DB from my live, and put a copy on my new (what will be) final server?

If so, when I get it how I want (themes, add ons etc.) - will I be able to turn live forum off, run scripts again, and only get the new users/posts/threads? I'm going to have like a 2 day gap from initial export,>import>get themes in order etc. before I'm ready to go live.

Thanks!
 
CreationNation said:
Yeah 2 different servers.

Do I need to pull the DB from my live, and put a copy on my new (what will be) final server?

If so, when I get it how I want (themes, add ons etc.) - will I be able to turn live forum off, run scripts again, and only get the new users/posts/threads? I'm going to have like a 2 day gap from initial export,>import>get themes in order etc. before I'm ready to go live.

Thanks!
Click to expand...

Yes, both dbs need to be on the same server since this importer uses a single connection to access both dbs.

This import can be run multiple times against the same XF installation. It will blow away the content each time, but styles, settings, etc will persist.
 
Jake Bunce said:
This import can be run multiple times against the same XF installation. It will blow away the content each time, but styles, settings, etc will persist.
Click to expand...

That's exactly what I needed to hear. As long as settings, styles and such remain, I'm perfectly content. Thanks!
 
RoldanLT said:
Is this Importer Tested Working on XF 1.5.2?
As I have several errors.
Click to expand...

I also like to ask this question.

CreationNation said:
That's exactly what I needed to hear. As long as settings, styles and such remain, I'm perfectly content. Thanks!
Click to expand...

We have been not successful in our tests with reimporting after the first import. User group permissions and similar things have to be done again. You need to have a seperate test server with all settings applied to be able to copy it to your main server easily.
 
So looks like some query doesn't work with MariaDB 10.0.22.
Code: 
# php Import.php


Importing...
xf_conversation_masterERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_conversation_messageERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_conversation_recipientERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_conversation_userERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_deletion_logERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_edit_historyERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_forumERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_forum_readERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_liked_contentERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_link_forumERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_moderator_logERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.12s)...
xf_nodeERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_pollERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_poll_responseERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_poll_voteERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_post.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
.ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.17s)...
xf_profile_postERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_reportERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_report_commentERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_stats_dailyERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_threadERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_thread_readERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_thread_user_postERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_thread_watchERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_userERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_user_authenticateERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_user_banERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.12s)...
xf_user_external_authjamii_xf_final_db.xf_user_external_auth    repair    note    The storage engine for the table doesn't support repair
ERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.01s)...
xf_user_field_valueERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.12s)...
xf_user_followERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_user_ignoredERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_user_optionERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_user_privacyERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.12s)...
xf_user_profileERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...
xf_user_upgrade_activeERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_user_upgrade_expiredERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_user_upgrade_logERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_warningERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.11s)...
xf_warning_action_triggerERROR 1148 (42000) at line 1: The used command is not allowed with this MariaDB version
(0.10s)...

   Import Total Time: 4.92s)...

Cleaning Up...
   trim thread titles
   building import log

   import log done, total time: 0.72s)...

    updating post like cache
   like cache done, total time: 0.00s)...

    Updating Posts With Edit History...
   edit history done, total time: 0.00s)...

!! beware of auto-edit history pruning and auto-ip pruning in XenForo @ admin.php?options/list/logging !!

   Cleanup done.

Any advice please?
 
I'm following the unofficial guide (thanks for that!) and wanted to ask what is the best way to deal with usergroup persmissions for migration? I'm testing migration of a large board and I have 150 'private' forums - each has it's own dedicated "secondary" usergroup. I'm not sure what role Ghost could have in the process, but I guess this would only be helpful if I already had permission set up properly on a test board, right? Is it easy to migrate the grand permissions (have access/no access) between vbulletin and xenforo in a case like mine?
 
Jake Bunce said:
Yes, both dbs need to be on the same server since this importer uses a single connection to access both dbs.

This import can be run multiple times against the same XF installation. It will blow away the content each time, but styles, settings, etc will persist.
Click to expand...

Quick followup on this @Jake Bunce . If I add some stuff to the media gallery on the new server while testing, will re-running an import/export blow that out as well, or will it only kill the threads/posts/users coming over from VB?
 
After import and cache rebuild - should I see complete content listed when I click on a user's profile and select "postings" ?

I'm not seeing anything pre-xf (like past threads/posts).
 
CreationNation said:
Quick followup on this @Jake Bunce . If I add some stuff to the media gallery on the new server while testing, will re-running an import/export blow that out as well, or will it only kill the threads/posts/users coming over from VB?
Click to expand...

It won't delete the media pictures, but at the same time that's not going to work. The media gallery uses XF's attachment system. What will happen is your media pictures will occupy the same attachment ids as attachments in vB such that the importer will think those vB attachment ids were already imported. So your media images will replace some of your new vB attachments.
 
Jake Bunce said:
You would have to rebuild the search index before that tab will show anything
Click to expand...

I had done that. What I think happened (After now re-running it) is I installed the Elastic Search add on and switched settings to that. I assume it blew out the old index by doing that.

Jake Bunce said:
It won't delete the media pictures, but at the same time that's not going to work. The media gallery uses XF's attachment system. What will happen is your media pictures will occupy the same attachment ids as attachments in vB such that the importer will think those vB attachment ids were already imported. So your media images will replace some of your new vB attachments.
Click to expand...

Ok cool. I've added a few only for testing, and having a couple users test some stuff on what will be the final server once moved. Do you recommend I do anything in particular to account for those before I re-run things?
 
CreationNation said:
I had done that. What I think happened (After now re-running it) is I installed the Elastic Search add on and switched settings to that. I assume it blew out the old index by doing that.
Click to expand...

Yep. You would need to rebuild the index again for ES.

CreationNation said:
Ok cool. I've added a few only for testing, and having a couple users test some stuff on what will be the final server once moved. Do you recommend I do anything in particular to account for those before I re-run things?
Click to expand...

To keep things consistent you should remove those media attachments from the database. Or just truncate the attachment tables in XF and let the Export script reimport them all again. Then avoid adding attachments to the XF installation separately from the import.
 
I'm going to do my final import in a couple days. If I have rearranged the display order of some of my forums, all should still be good right? Export/Import I imagine is matching forums Ids not the order they appear in?
 
CreationNation said:
I'm going to do my final import in a couple days. If I have rearranged the display order of some of my forums, all should still be good right? Export/Import I imagine is matching forums Ids not the order they appear in?
Click to expand...

The Import script still reimports the forum and node records. You would need to comment out those lines to prevent this:

importTable('xf_forum');
importTable('xf_node');
 
I am doing my final import and it just finished.

I am comparing old stat vs. new stat and I have a difference, but I am not sure if it is chalked up to how XF determines what is a user/post/thread or not.

Old:
Threads: 879,370, Posts: 9,248,333, Members: 145,219

After import to XF:
Discussions: 878,876, Messages: 9,242,290, Members 142,090

I searched the thread to see if others have had this but can't find anything, unless I'm not searching the correct term.

Any insight appreciated.

EDIT:
Rebuilding the caches changed the numbers, but they still do not match. Correct me if I am wrong, but I think it is chalked up to how each system handles things and or classifies certain things, or how certain items ended up imported and recategorized or something.
 
Last edited:
You must log in or register to reply here.

Similar threads

M
  • Question Question
XF 2.2 XF2 CLI import vs vBulletin Big Board Importer
Replies
1
Views
527
Slavik
Slavik
Slavik
vBulletin Big Board Importer for XenForo 2 [vBulletin 3 & vBulletin 4] [Deleted]
Replies
1
Views
810
Slavik
Slavik
Steffen
vBulletin 3/4 Moderator Log Import Command
Replies
0
Views
964
Steffen
Steffen
Kier
  • Question Question
XF 2.0 vBulletin 4 with Blog importer - known issue
Replies
8
Views
17K
Universal4
U
Mr Lucky
  • Question Question
XF 1.5 Redirect from vBulletin 3 and vBulletin 4
Replies
1
Views
489
Mr Lucky
Mr Lucky
Back
Top Bottom