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
Slavik said:
You may need to grant usage also.
Click to expand...
If you mean this: grant all privileges on *.* to gamerz_vb@localhost; for the vbulletin database, I just tried that, and then ran the Export.php again, and still got the same problem:

Make Selection [1-9]: 2

exporting users...
user & user authenticateroot@server [~]#
 
First, I'd just like to say thanks again to all of you who made this plugin possible. I'm so thankful this is out there and I am proud to support your efforts which benefit the XenForo community.

I'm finally doing my first test run, and have a few questions regarding usergroups in Export.php:
  • What should I do with my vB3 users who are in the "Users Awaiting Email Confirmation"? Should they really be imported to the "Unregistered/Unconfirmed" user group? How does this differ from the "User State (Awaiting email confirmation)" attribute for a normal user in the XenForo "Registered" email group?
  • To which XenForo usergroup should I send "banned" users from my vB3 board?
 
DeltaHF said:
First, I'd just like to say thanks again to all of you who made this plugin possible. I'm so thankful this is out there and I am proud to support your efforts which benefit the XenForo community.

I'm finally doing my first test run, and have a few questions regarding usergroups in Export.php:
  • What should I do with my vB3 users who are in the "Users Awaiting Email Confirmation"? Should they really be imported to the "Unregistered/Unconfirmed" user group? How does this differ from the "User State (Awaiting email confirmation)" attribute for a normal user in the XenForo "Registered" email group?
  • To which XenForo usergroup should I send "banned" users from my vB3 board?
Click to expand...

There is no separate group for pending registrations. Rather there is a user_state field that is part of their profile. The user_state is what defines pending registrations. And when a registration is pending they will have guest permissions (the Unregistered / Unconfirmed group) despite being in the Registered group.
 
Ok, thanks for the clarification. Is it the same with banned users? Do I just send them into XenForo's Registered user group as well?
 
DeltaHF said:
Ok, thanks for the clarification. Is it the same with banned users? Do I just send them into XenForo's Registered user group as well?
Click to expand...

Yes you can. There is a separate is_banned flag.

Though a separate banned group isn't necessarily wrong. It's optional.
 
Hornstar said:
If you mean this: grant all privileges on *.* to gamerz_vb@localhost; for the vbulletin database, I just tried that, and then ran the Export.php again, and still got the same problem:

Make Selection [1-9]: 2

exporting users...
user & user authenticateroot@server [~]#
Click to expand...

What does the output file have?
 
I am getting the same error that some of the above guys are getting, unable to export data.

You can check my server configuration here.
www.chinesedefence.com/info.php

That Turkey guy solved this but didn't tell how.

@ehd @router

Code: 
!!!WARNING!!! - set charset to 'binary' in XenForo_Application:loadDb()

#################################################
### Digital Point A.R.F.I. vB4 -> XF Importer ###
### Modified by Slavik at www.XenForo.com    ###
### with assistance from Mike, Jake and Shawn ###
#################################################
### Notes:                                    ###
### None of the user feilds will be imported  ###
### by default. If you want to keep your user ###
### fields these need to be configured in    ###
### XenForo first and then mapped at lines    ###
### 380-396.                                  ###
#################################################

1 - Posts
2 - Users
3 - Threads
4 - Private Messages
5 - Avatars
6 - Attachments
7 - Forums
8 - Miscellaneous
9 - Everything

Make Selection [1-9]: 9

exporting posts...
          [forking process for posts]
          post IPs (198 records in 0.01s)...
        vbseo likesrm: cannot remove `/home/chinese/public_html/xen/importData2/xf_post_*': No su                      ch file or directory
(198 records in 0.01s)...
          reported posts (198 records in 0.01s)...
          reported post comments (198 records in 0.01s)...
          reported profile posts (396 records in 0.01s)...
          reported profile post comments (396 records in 0.01s)...
          reported private messages (594 records in 0.01s)...
          reported private message comments (594 records in 0.01s)...
          post edit history (198 records in 0.01s)...
Total time for posts: 0.08s

exporting users...
          [forking process for users & user authenticate]
          user external auth (198 records in 0.01s)...
          user follow (198 records in 0.01s)...
          user ignored (198 records in 0.01s)...
          user options (198 records in 0.01s)...
          user profile (198 records in 0.01s)...
          user privacy (198 records in 0.01s)...
          user warnings (198 records in 0.00s)...
          user bans (198 records in 0.00s)...
          warning action triggers (198 records in 0.00s)...
          skipping user fields          user registration IPs (396 records in 0.01s)...
          user account confirmation IPs (594 records in 0.01s)...
          user change log IPs (792 records in 0.01s)...
          profile posts (198 records in 0.01s)...
          profile post IPs (990 records in 0.01s)...
          user upgrades active (198 records in 0.01s)...
          user upgrades expired (198 records in 0.01s)...
          user upgrades log (198 records in 0.01s)...
Total time for users: 0.11s
*** Don't forget to rebuild user cache ***


exporting threads...
          [forking process for threads]
          watched threads (198 records in 0.01s)...
          thread user post (198 records in 0.00s)...
          polls (88 records in 0.02s)...
          thread read (198 records in 0.00s)...
Total time for threads: 0.04s
*** Don't forget to rebuild poll cache ***


exporting private messages...
          [forking process for conversation master]
          conversation message (198 records in 0.01s)...
          conversation recipient (396 records in 0.01s)...
          conversation user (396 records in 0.01s)...
          skipping private conversation IPs
Total time for private messages: 0.02s

performing avatar diff...
        180 users with new avatars
<pre>
data/avatars/s/0/1.jpg => No move

Total time for avatars: 5.46s

        1 new attachments
348
        updating attachment view count
Total time for attachments: 0.09s

exporting forums...
          nodes (198 records in 0.01s)...
          forums (198 records in 0.01s)...
          link forums (198 records in 0.01s)...
          forum read (198 records in 0.01s)...
Total time for forums: 0.03s

exporting micellaneous stuff...
          deletion log (198 records in 0.01s)...
          moderator log (198 records in 0.01s)...
          daily stats (1,584 records in 0.03s)...
Total time for micellaneous stuff: 0.05s

          [waiting on process for users & user authenticate] DONE.
          [waiting on process for conversation master] DONE.
          [waiting on process for threads] DONE.
          [waiting on process for posts] DONE.

    Grand Total For Everything: 0 minutes, 5 seconds (11,866 records)

I definitely want this to get it working... wouldn't want to be stuck with vbulletin...
 
Slavik said:
The PHP warnings are wothing to worry about, theyre just notices. You should however take note of the
!!!WARNING!!! - set charset to 'binary' in XenForo_Application:loadDb()

This is in /library/XenForo/Application.php
Click to expand...
Where do i need to change to binary to avoid this warning?
 
Hornstar said:
Make sure you leave -u and -p before your username and password.
Click to expand...

so that was the problem!

Thanks a lot. Now another problem is that my imported admin account doessn't have much access or to clear the cache, and the account i created to install Xenforo no longer exist.
 
Any idea how to pull the posts which are in chinese characters? or some other language? Currently they are being converted into this.

&#25105;&#24863;&#35273;&#36825;&#37324;&#26377;&#22909;&#22810;&#22269;&#20869;&#30340;&#31570;&#23376;&#22312;&#28508;&#27700;&#12290;&#12290;&#12290;&#26152;&#22825;users&#31361;&#30772;75&#20102;&#65281;
Click to expand...
 
eagle eyes said:
so that was the problem!

Thanks a lot. Now another problem is that my imported admin account doessn't have much access or to clear the cache, and the account i created to install Xenforo no longer exist.
Click to expand...

Check the user ID of the admin account and ensure its set as superadmin in the config.php for xenforo.
 
eagle eyes said:
Any idea how to pull the posts which are in chinese characters? or some other language? Currently they are being converted into this.
Click to expand...

Your Chinese characters are apparently being stored as HTML entities in vB? Check the posts in the vB database to confirm this.

You may be able to modify the $extraOutCommand line:

Code: 
	// USE THIS SETTING TO SPECIFY AN EXTRA PIPE FOR ALL OUTPUT RECORDS
	// EXAMPLE IS TO PIPE OUTPUT THROUGH iconv IF CHARACTER ENCODING CHANGES ARE NEEDED
	// '| iconv -f LATIN1 -t UTF8'
	public static $extraOutCommand = '| iconv -f LATIN1 -t UTF8';

But off hand I don't know if iconv has an option to convert from entities.
 
Jake Bunce said:
Your Chinese characters are apparently being stored as HTML entities in vB? Check the posts in the vB database to confirm this.

You may be able to modify the $extraOutCommand line:

Code: 
    // USE THIS SETTING TO SPECIFY AN EXTRA PIPE FOR ALL OUTPUT RECORDS
    // EXAMPLE IS TO PIPE OUTPUT THROUGH iconv IF CHARACTER ENCODING CHANGES ARE NEEDED
    // '| iconv -f LATIN1 -t UTF8'
    public static $extraOutCommand = '| iconv -f LATIN1 -t UTF8';

But off hand I don't know if iconv has an option to convert from entities.
Click to expand...

Not sure how to check in the database for a particular thread exactly.

Currently you can see this thread in vBulletin.
http://www.chinesedefence.com/forums/cdf-members-room/661-chinese-chatroom-3.html

And when imported it goes acting like this... for the chinese characters.

Code: 
&#25105;&#24863;&#35273;&#36825;&#37324;&#26377;&#22909;&#22810;&#22269;&#20869;&#30340;&#31570;&#23376;&#22312;&#28508;&#27700;&#12290;&#12290;&#12290;&#26152;&#22825;users&#31361;&#30772;75&#20102;&#65281;

I did change charset to binary when i was getting the warning error in Application.php file. As someone suggested above. You think that caused this?

What do i need to change in the export/import file to have proper transfer?
 
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