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
Sorry for not posting exact errors....
MISSING DATA!!61062 !!MISSING DATA!!61063 !!MISSING DATA!!61064 !!MISSING DATA!!61065 !!MISSING DATA!!61066 !!MISSING DATA!!61067 !!MISSING DATA!!61068 !!MISSING DATA!!61069 !!MISSING DATA!!61070 !!MISSING DATA!!61071 !!MISSING DATA!!61072 !!MISSING DATA!!61073 !!MISSING DATA!!61074 !!MISSING DATA!!61075 !!MISSING DATA!!61076 !!MISSING DATA!!61077 !!MISSING DATA!!61078 !!MISSING DATA!!61079 !!MISSING DATA!!61080 !!MISSING DATA!!61081 !!MISSING DATA!!61082 !!MISSING DATA!!61083 !!MISSING DATA!!61084 !!MISSING DATA!!61085 !!MISSING DATA!!61086 !!MISSING DATA!!61087 !!MISSING DATA!!61088 !!MISSING DATA!!61089 !!MISSING DATA!!61090 !!MISSING DATA!!61091 !!MISSING DATA!!61092 !!MISSING DATA!!61093 !!MISSING DATA!!61094 !!MISSING DATA!!61095 !!MISSING DATA!!61096 !!MISSING DATA!!61097 !!MISSING DATA!!61098 !!MISSING DATA!!61099 !!MISSING DATA!!61100 !!MISSING DATA!!61101 !!MISSING DATA!!61102 !!MISSING DATA!!61103 !!MISSING DATA!!61104 !!MISSING DATA!!61105 !!MISSING DATA!!61106 !!MISSING DATA!!61107 !!MISSING DATA!!61108 !!MISSING DATA!!61109 !!MISSING DATA!!61110 !!MISSING DATA!!61111 !!MISSING DATA!!61112 !!MISSING DATA!!61113 !!MISSING DATA!!61114 !!MISSING DATA!!61115 !!MISSING DATA!!61116 !!MISSING DATA!!61117 !!MISSING DATA!!61118 !!MISSING DATA!!61119 !!MISSING DATA!!61120 !!MISSING DATA!!61121 !!MISSING DATA!!61122 !!MISSING DATA!!61125 !!MISSING DATA!!61126 !!MISSING DATA!!61127 !!MISSING DATA!!61128 !!MISSING DATA!!61129 !!MISSING DATA!!61130 !!MISSING DATA!!61131 !!MISSING DATA!!61132 !!MISSING DATA!!61133 !!MISSING DATA!!61134 !!MISSING DATA!!61135 !!MISSING DATA!!61136 !!MISSING DATA!!61137 !!MISSING DATA!!61138 !!MISSING DATA!!61139 !!MISSING DATA!!61141 !!MISSING DATA!!61142 !!MISSING DATA!!61143 !!MISSING DATA!!61144 !!MISSING DATA!!61145 !!MISSING DATA!!61146 !!MISSING DATA!!61147 !!MISSING DATA!!61148 !!MISSING DATA!!61149 !!MISSING DATA!!61150 !!MISSING DATA!!61151 !!MISSING DATA!!61152 !!MISSING DATA!!61153 !!MISSING DATA!!61154 !!MISSING DATA!!61155 !!MISSING DATA!!61156 !!MISSING DATA!!61157 !!MISSING DATA!!61158 !!MISSING DATA!!61159 !!MISSING DATA!!61160 !!MISSING DATA!!61161 !!MISSING DATA!!61162 !!MISSING DATA!!61163 !!MISSING DATA!!61164 !!MISSING DATA!!61165 !!MISSING DATA!!61166 !!MISSING DATA!!61167 !!MISSING DATA!!61168 !!MISSING DATA!!61169 !!MISSING DATA!!61170 !!MISSING DATA!!61171 !!MISSING DATA!!61172 !!MISSING DATA!!61174 !!MISSING DATA!!61175 !!MISSING DATA!!61176 !!MISSING DATA!!
updating attachment view count
Total time for attachments: 41.92s
Click to expand...

Also I can login after the import of users. My original user I installed xF with no longer works. I try my username on the admin of the vBulletin...and that doesn't work either. So I reset the password, and it seems like the password field is completely gone after importing. Posts don't get imported, and I get this
exporting threads...
threads (198 records in 0.00s)...
watched threads (198 records in 0.00s)...
thread user post (198 records in 0.00s)...
polls (42,309 records in 0.56s)...
thread read (198 records in 0.01s)...
Total time for threads: 0.57s
*** Don't forget to rebuild poll cache ***
Click to expand...

Please keep in mind, I'm choosing option 9 when I run it.
 
TheComputerGuy said:
MISSING DATA!!61062 !!MISSING DATA!!61063 !!MISSING DATA!!61064 !!MISSING DATA!!61065 .....
Click to expand...

That means the file data for those attachments is missing. Is vB using the db or file system to store attachments? Make sure you set the attachment path in the Export file. That setting must specify the correct server path in the case of file system attachments, or be left empty ('') in the case of db attachments.

TheComputerGuy said:
Also I can login after the import of users. My original user I installed xF with no longer works. I try my username on the admin of the vBulletin...and that doesn't work either. So I reset the password, and it seems like the password field is completely gone after importing.
Click to expand...

The XF admin account (user_id 1) can be overwritten during the import if vB also has a user_id 1. You need to check that and possibly use one of the imported user logins after the import.

TheComputerGuy said:
Posts don't get imported, and I get this

exporting threads...
threads (198 records in 0.00s)...
watched threads (198 records in 0.00s)...
thread user post (198 records in 0.00s)...
polls (42,309 records in 0.56s)...
thread read (198 records in 0.01s)...
Total time for threads: 0.57s
*** Don't forget to rebuild poll cache ***
Click to expand...
Click to expand...

That is the thread module which is separate from the post module. You are looking at the wrong export output if you are checking for posts. Posts are step 1. Threads are step 3.
 
So you are saying I should run each modules...instead of picking the Everything option?

Also I thought I had the file system in the attachment path correct, as it was using the full pathway similar to the way it is setup. I'll try to verify it once more.
 
Ok Slavik, now that I have this thing working flawlessly , including custom user fields and post reports/comments :D, how about building in an itrader -> xentrader import ;) That would just be the icing on the cake. I see a bunch of iTrader references commented out at line 496..... :notworthy: I can pay for your time, if you have time. I really would rather not have to generate an import log with the web importer during the actual conversion. I'll have enough to think about....
 
What happens when such a user comes up during the import? We've got several with commas in usernames.
 
Gladius said:
What happens when such a user comes up during the import? We've got several with commas in usernames.
Click to expand...

Nothing. The user is imported. No errors.

I suspect this comma problem will only manifest when doing any kind of username search or match on the front end, such as sending PMs to the user or searching for posts by a user.
 
I get an error when rebuilding the user cache after import is complete.

Code: 
Error Info Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'ignored' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: paul, Yesterday at 1:56 PM

#0 /home/talkbass/html/xenforo2/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/talkbass/html/xenforo2/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/talkbass/html/xenforo2/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_user...', Array)
#3 /home/talkbass/html/xenforo2/library/XenForo/DataWriter/User.php(997): Zend_Db_Adapter_Abstract->update('xf_user_profile', Array, 'user_id = 15985')
#4 /home/talkbass/html/xenforo2/library/XenForo/CacheRebuilder/User.php(65): XenForo_DataWriter_User->rebuildIgnoreCache()
#5 /home/talkbass/html/xenforo2/library/XenForo/ControllerHelper/CacheRebuild.php(26): XenForo_CacheRebuilder_User->rebuild(15846, Array, NULL)
#6 /home/talkbass/html/xenforo2/library/XenForo/ControllerAdmin/Tools.php(78): XenForo_ControllerHelper_CacheRebuild->rebuildCache(Array, 'http://xxx.xx.xx...', 'admin.php?tools...', true)
#7 /home/talkbass/html/xenforo2/library/XenForo/FrontController.php(313): XenForo_ControllerAdmin_Tools->actionCacheRebuild()
#8 /home/talkbass/html/xenforo2/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/talkbass/html/xenforo2/admin.php(13): XenForo_FrontController->run()
#10 {main}

Request State
array(3) {
  ["url"] => string(60) "http://xxx.xxx.xxx.xxx/xenforo2/admin.php?tools/cache-rebuild"
  ["_GET"] => array(1) {
    ["tools/cache-rebuild"] => string(0) ""
  }
  ["_POST"] => array(5) {
    ["process"] => string(1) "1"
    ["caches"] => string(26) "[["User",{"batch":"100"}]]"
    ["position"] => string(5) "15846"
    ["redirect"] => string(54) "http://xxx.xx.xxx.xx/xenforo2/admin.php?tools/rebuild"
    ["_xfToken"] => string(8) "********"
  }
}

The user with ID 15985 has 436 people in his ignore list... Is this the cause of the problem?
 
kontrabass said:
I get an error when rebuilding the user cache after import is complete.


The user with ID 15985 has 436 people in his ignore list... Is this the cause of the problem?
Click to expand...

Potentially yes, try removing all the ignored people from his list and try again.
 
Slavik said:
Potentially yes, try removing all the ignored people from his list and try again.
Click to expand...

Ok, that worked, but now it's error'ing on the next user with more than 90 on the ignore list, and the next, etc. Is there an easy way to fix this? A setting in mysql maybe? If not don't worry about it. It appears out of 200k+ users only about 5 or 6 hit the max and error out. They can just re-add people to their ignore lists.
 
Last edited:
kontrabass said:
Ok, that worked, but now it's error'ing on the next user with more than 90 on the ignore list, and the next, etc. Is there an easy way to fix this? A setting in mysql maybe? If not don't worry about it. It appears out of 200k+ users only about 5 or 6 hit the max and error out. They can just re-add people to their ignore lists.
Click to expand...

Not off the top of my head no, the easiest is just to remove the ignores of people who have huge ignore lists...
 
kontrabass said:
I get an error when rebuilding the user cache after import is complete.

Code: 
Error Info Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'ignored' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: paul, Yesterday at 1:56 PM

#0 /home/talkbass/html/xenforo2/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/talkbass/html/xenforo2/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/talkbass/html/xenforo2/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_user...', Array)
#3 /home/talkbass/html/xenforo2/library/XenForo/DataWriter/User.php(997): Zend_Db_Adapter_Abstract->update('xf_user_profile', Array, 'user_id = 15985')
#4 /home/talkbass/html/xenforo2/library/XenForo/CacheRebuilder/User.php(65): XenForo_DataWriter_User->rebuildIgnoreCache()
#5 /home/talkbass/html/xenforo2/library/XenForo/ControllerHelper/CacheRebuild.php(26): XenForo_CacheRebuilder_User->rebuild(15846, Array, NULL)
#6 /home/talkbass/html/xenforo2/library/XenForo/ControllerAdmin/Tools.php(78): XenForo_ControllerHelper_CacheRebuild->rebuildCache(Array, 'http://xxx.xx.xx...', 'admin.php?tools...', true)
#7 /home/talkbass/html/xenforo2/library/XenForo/FrontController.php(313): XenForo_ControllerAdmin_Tools->actionCacheRebuild()
#8 /home/talkbass/html/xenforo2/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/talkbass/html/xenforo2/admin.php(13): XenForo_FrontController->run()
#10 {main}

Request State
array(3) {
  ["url"] => string(60) "http://xxx.xxx.xxx.xxx/xenforo2/admin.php?tools/cache-rebuild"
  ["_GET"] => array(1) {
    ["tools/cache-rebuild"] => string(0) ""
  }
  ["_POST"] => array(5) {
    ["process"] => string(1) "1"
    ["caches"] => string(26) "[["User",{"batch":"100"}]]"
    ["position"] => string(5) "15846"
    ["redirect"] => string(54) "http://xxx.xx.xxx.xx/xenforo2/admin.php?tools/rebuild"
    ["_xfToken"] => string(8) "********"
  }
}

The user with ID 15985 has 436 people in his ignore list... Is this the cause of the problem?
Click to expand...

XenForo bug:

http://xenforo.com/community/threads/xf_user_profile-ignored-inconsistency.52051/

This should be fixed in the current version if Mike included it. Or you can increase the length of that field in the database to avoid the error.
 
Thanks guys.

On another note, after closer inspection of my imported board, it appears that many avatars do not make it through the conversion. With the old S.A.F.A.R.I. version of this importer all avatars came through fine. Hmm... All the missing avatars exist in the source file directory, and I can't find any rhyme or reason to why some files aren't copied.

Code: 
Make Selection [1-9]: 5

performing avatar diff...
        9,507 users with new avatars
Not a JPEG file: starts with 0x4a 0x47
Not a JPEG file: starts with 0x4a 0x47
libpng warning: Ignoring attempt to set cHRM RGB triangle with zero area
libpng warning: Ignoring attempt to set cHRM RGB triangle with zero area
libpng warning: Ignoring attempt to set cHRM RGB triangle with zero area
<pre>
data/avatars/s/0/1.jpg => No move
data/avatars/s/0/11.jpg => No move
data/avatars/s/0/164.jpg => No move
data/avatars/s/0/230.jpg => No move
data/avatars/s/0/270.jpg => No move
data/avatars/s/0/337.jpg => No move
data/avatars/s/0/34.jpg => No move
data/avatars/s/0/374.jpg => No move
data/avatars/s/0/377.jpg => No move
data/avatars/s/0/391.jpg => No move
data/avatars/s/0/402.jpg => No move
data/avatars/s/0/41.jpg => No move
data/avatars/s/0/416.jpg => No move
data/avatars/s/0/42.jpg => No move
data/avatars/s/0/45.jpg => No move
data/avatars/s/0/475.jpg => No move
data/avatars/s/0/50.jpg => No move
data/avatars/s/0/502.jpg => No move
data/avatars/s/0/514.jpg => No move
data/avatars/s/0/529.jpg => No move
data/avatars/s/0/53.jpg => No move
data/avatars/s/0/618.jpg => No move
data/avatars/s/0/629.jpg => No move
data/avatars/s/0/654.jpg => No move
data/avatars/s/0/692.jpg => No move
data/avatars/s/0/751.jpg => No move
data/avatars/s/0/781.jpg => No move
data/avatars/s/0/81.jpg => No move
data/avatars/s/0/825.jpg => No move
data/avatars/s/0/830.jpg => No move
data/avatars/s/0/842.jpg => No move
data/avatars/s/0/846.jpg => No move
data/avatars/s/0/884.jpg => No move
data/avatars/s/0/9.jpg => No move
data/avatars/s/0/932.jpg => No move
<pre>
data/avatars/m/0/1.jpg => No move
data/avatars/m/0/11.jpg => No move
data/avatars/m/0/164.jpg => No move
data/avatars/m/0/230.jpg => No move
data/avatars/m/0/270.jpg => No move
data/avatars/m/0/337.jpg => No move
data/avatars/m/0/34.jpg => No move
data/avatars/m/0/374.jpg => No move
data/avatars/m/0/377.jpg => No move
data/avatars/m/0/391.jpg => No move
data/avatars/m/0/402.jpg => No move
data/avatars/m/0/41.jpg => No move
data/avatars/m/0/416.jpg => No move
data/avatars/m/0/42.jpg => No move
data/avatars/m/0/45.jpg => No move
data/avatars/m/0/475.jpg => No move
data/avatars/m/0/50.jpg => No move
data/avatars/m/0/502.jpg => No move
data/avatars/m/0/514.jpg => No move
data/avatars/m/0/529.jpg => No move
data/avatars/m/0/53.jpg => No move
data/avatars/m/0/618.jpg => No move
data/avatars/m/0/629.jpg => No move
data/avatars/m/0/654.jpg => No move
data/avatars/m/0/692.jpg => No move
data/avatars/m/0/751.jpg => No move
data/avatars/m/0/781.jpg => No move
data/avatars/m/0/81.jpg => No move
data/avatars/m/0/825.jpg => No move
data/avatars/m/0/830.jpg => No move
data/avatars/m/0/842.jpg => No move
data/avatars/m/0/846.jpg => No move
data/avatars/m/0/884.jpg => No move
data/avatars/m/0/9.jpg => No move
data/avatars/m/0/932.jpg => No move
<pre>
data/avatars/l/0/1.jpg => No move
data/avatars/l/0/11.jpg => No move
data/avatars/l/0/164.jpg => No move
data/avatars/l/0/230.jpg => No move
data/avatars/l/0/270.jpg => No move
data/avatars/l/0/337.jpg => No move
data/avatars/l/0/34.jpg => No move
data/avatars/l/0/374.jpg => No move
data/avatars/l/0/377.jpg => No move
data/avatars/l/0/391.jpg => No move
data/avatars/l/0/402.jpg => No move
data/avatars/l/0/41.jpg => No move
data/avatars/l/0/416.jpg => No move
data/avatars/l/0/42.jpg => No move
data/avatars/l/0/45.jpg => No move
data/avatars/l/0/475.jpg => No move
data/avatars/l/0/50.jpg => No move
data/avatars/l/0/502.jpg => No move
data/avatars/l/0/514.jpg => No move
data/avatars/l/0/529.jpg => No move
data/avatars/l/0/53.jpg => No move
data/avatars/l/0/618.jpg => No move
data/avatars/l/0/629.jpg => No move
data/avatars/l/0/654.jpg => No move
data/avatars/l/0/692.jpg => No move
data/avatars/l/0/751.jpg => No move
data/avatars/l/0/781.jpg => No move
data/avatars/l/0/81.jpg => No move
data/avatars/l/0/825.jpg => No move
data/avatars/l/0/830.jpg => No move
data/avatars/l/0/842.jpg => No move
data/avatars/l/0/846.jpg => No move
data/avatars/l/0/884.jpg => No move
data/avatars/l/0/9.jpg => No move
data/avatars/l/0/932.jpg => No move
Total time for avatars: 79.42s

Not sure what all these "No move" lines mean, but it doesn't seem to have anything to do with the missing avatars.
 
@kontrabass

Ignore the "No move" messages.

If avatars are missing then presumably there would be some relevant errors in the Export output for avatars. Otherwise just confirm the storage directory and check some specific cases to ensure the data files exist. Note that the exporter has code to fall back to using profile pics if the user doesn't have an avatar in vB.
 
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
516
Slavik
Slavik
Slavik
vBulletin Big Board Importer for XenForo 2 [vBulletin 3 & vBulletin 4] [Deleted]
Replies
1
Views
803
Slavik
Slavik
Steffen
vBulletin 3/4 Moderator Log Import Command
Replies
0
Views
960
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
486
Mr Lucky
Mr Lucky
Top Bottom