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

[Jake Bunce]

If I run into a database error running Export.php in the middle of attachments should I just run Export.php and choose All again?

What is the error? It might be logged:

Admin CP -> Tools -> Server Error Log

 

[Jake Bunce]

Well that's just it - when setting up the select options I had to use underscores since spaces weren't allowed for values. Some of the imported data is going to have spaces for that field, since spaces were allowed in vB. So will I need to modify the script so that it replaces spaces with underscores when it imports that data? Any suggestions on the code to use for that?

MySQL has a REPLACE() function.

REPLACE(value, ' ', '_')

That will replace spaces with underscores in value.

 

[Ludachris]

What is the error? It might be logged:

Admin CP -> Tools -> Server Error Log

This is what my admincp looks like (attached). This same thing happened the last time I did a test import using this importer. I can't access the logs, let alone much else. And yes, I'm set as a superadmin in config.php. I also cannot log in to the front end. It just keeps looping saying I need to log in.

 

[Ludachris]

I just ran Export.php again and noticed it only exported 198 posts... not the 3.89 million. Something's wrong here. I checked the db to confirm and only see 198 records in the xf_post table.

Can I send my Export.php and Import.php files to someone to take a look. I really don't understand why nothing is working right.

 

[Ludachris]

198 records for a lot of things... forums, nodes, conversation master, and others.

 

[Ludachris]

I confirmed that the source db has nearly 4 million records in the post table. The Export.php script is not exporting them. And as I posted above, the admincp is displaying strangely so I can't view any logs. I logged into phpmyadmin and checked the server log table. When I load the admincp this error info shows up:

Fatal Error: Class name must be a valid object or a string
library/XenForo/Model/Node.php
#0 [internal function]: XenForo_Application::handleFatalError()
#1 {main}

 

[Ludachris]

hold on.... might have something here. Looks like I deleted the -u and -p in front of the source db user info. I am running Export.php again and it's taking quite a bit longer than it has been in the past. I had a feeling it was something simple like that which I screwed up, though the errors sure were strange. Hopefully it goes smooth from here!

 

[Adam Bloch]

I'm having a problem with the Avatars.... We have tried expoting from folders, we have even stuck it all back into the database and tried again but we only seem to get a few of the avatars coming over
I had a look a the errors and this error seems to be filling up the log (pages and pages of them).

Is this the problem and if so what is it?

Many thanks

Adam

ErrorException: Undefined offset: 8 - Export.php:375
Generated By: Unknown Account, Yesterday at 4:11 PM
Stack Trace
#0 /home/xxx/xxxx.net/public_html/xf/Export.php(375): XenForo_Application::handlePhpError(8, 'Undefined offse...', '/home/xxx/xxx...', 375, Array)
#1 /home/xxx/xxxx.net/public_html/xf/Export.php(1896): DigitalPointExporter->users()
#2 {main}
Request State
array(3) {
["url"] => string(7) "http://"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[Adam Bloch]

89308 89330 89343 89345 89347 89349 89366 89376 89403 89409 89427 89443 89456 8 9465 89470 89485 89488 89491 89503 89506 89523 89525 89539 89568 89575 89580 895 86 89608 89629 89664 89678 89679 89685 89732 89739 89762 89771 89777 89780 89796 89799 89809 89832 89860 89862 89885 89893 89910 89943 89948 89951 89953 89969 8 9995 90019 90021 90033 90039 90056 90058 90062 90065 90085 90086 90093 90103 901 04 90112 90115 90125 90127 90133 90140 90141 90146 90148 90205 90237 90239 90302 90309 90366 90374 90376 90402 90433 90439 90464 <pre>
chmod: cannot access `data/avatars/s/0/*.*': No such file or directory
<pre>
chmod: cannot access `data/avatars/m/0/*.*': No such file or directory
<pre>
data/avatars/l/0/116.jpg => No move
data/avatars/l/0/198.jpg => No move
data/avatars/l/0/31.jpg => No move

Total time for avatars: 67.35s

 

[Slavik]

ErrorException: Undefined offset: 8 - Export.php:375

You havent mapped the usergroups.

 

[Adam Bloch]

yep we did

1 => 1,
2 => 2,
3 => 1,
5 => 4,
6 => 3,
7 => 4,
27 => 4,
35 => 5,
42 => 5,
45 => 4,
50 => 6,

 

[Slavik]

Undefined offset: 8

This means you have a user with a usergroup as 8 set somewhere, which, you havent mapped.

 

[Adam Bloch]

Queried the VB database for usergroupids which weren't any of those in our map (and VB settings); found 99 and dirty-SQL'd them all to usergroupid = 2. Running the script again now (with group ID 4 (banned users) back in the map - we'd removed in post above while we were fiddling with stuff).

Still having trouble with avatars - it chunks through a load of user ID numbers, but doesn't seem to be able to do anything with them. In the temp folder after our last run, everything seemed about right - nice large files for posts, etc. - but there's one file 'avatar_temp' [no xf_ prefix or file extension?] which is only 3074 bytes long.

Is there any connection between this and the 'no such file or directory' stuff in the post above?

Thanks

A

 

[Slavik]

Those are fine, theyre part of a sorting script.

 

[Adam Bloch]

Good to know; thanks.

Any ideas regarding avatars?

Just cleared the temp and /data/avatars folders and ran the script again; the exporter reports 7600+ new avatars, but after completing the import the contents of /data/avatars/ is:

/data/avatars/
           l/
               0/
                   116.jpg
                   198.jpg
                   31.jpg
                   index.html
              10/
                   10593.jpg
                   index.html
               2/
                   2721.jpg
                   index.html
               4/
                   4410.jpg
                   index.html
               6/
                   6845.jpg
                   index.html
               8/
                   8610.jpg
                   index.html
               index.html

Those files correspond correctly with VB users IDs & avatars, and they seem to match XF user numbers, but even those few don't show in XF - there's just a broken image placeholder (not even a 'blank' avatar) in the users' profiles.

Any ideas why only a tiny fraction of the avatars might come over, and still not show correctly?

Thanks,

A

 

[Adam Bloch]

Any thoughts or suggestion on this one?.......

 

[Slavik]

Hard to tell, it can happen if theres missing data in the vbulletin avatars tables

 

[Brent W]

I have had a ticket open about an error I got when a user logged in. @Jake Bunce said that the users password was corrupted. This did not occur for all passwords as I did the import months ago and this is the first time running into the issue.

Error Info
ErrorException: unserialize(): Error at offset 69 of 74 bytes - library/XenForo/Authentication/vBulletin.php:29
Generated By: Unknown Account, 1 minute ago
Stack Trace
#0 [internal function]: XenForo_Application::handlePhpError(8, 'unserialize(): ...', '/home/nginx/dom...', 29, Array)
#1 /home/nginx/domains/v6mustang.com/public/library/XenForo/Authentication/vBulletin.php(29): unserialize('a:2:{s:4:"hash"...')
#2 /home/nginx/domains/v6mustang.com/public/library/XenForo/Model/User.php(1257): XenForo_Authentication_vBulletin->setData('a:2:{s:4:"hash"...')
#3 /home/nginx/domains/v6mustang.com/public/library/XenForo/Model/User.php(1279): XenForo_Model_User->getUserAuthenticationObjectByUserId(8854)
#4 /home/nginx/domains/v6mustang.com/public/library/XenForo/ControllerPublic/Login.php(107): XenForo_Model_User->validateAuthentication('<redacted>@gmail.c...', 'portland', NULL)
#5 /home/nginx/domains/v6mustang.com/public/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Login->actionLogin()
#6 /home/nginx/domains/v6mustang.com/public/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /home/nginx/domains/v6mustang.com/public/index.php(13): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
["url"] => string(37) "https://www.v6mustang.com/login/login"
["_GET"] => array(1) {
["/login/login"] => string(0) ""
}
["_POST"] => array(7) {
["login"] => string(17) "<redacted>@gmail.com"
["register"] => string(1) "0"
["password"] => string(8) "********"
["remember"] => string(1) "1"
["cookie_check"] => string(1) "1"
["_xfToken"] => string(8) "********"
["redirect"] => string(24) "/account/contact-details"
}
}

 

[Slavik]

Do you still have the original VB database to look up the users password hash there and check it?

 

[Brent W]

Do you still have the original VB database to look up the users password hash there and check it?

I can reimport it and check. Will do that tomorrow.