Duplicate Hung up on importing PMs

[steven s]

Anyone get hung up when importing private messages?

Error


The requested page could not be found

 

[Mr_Bob]

I get that there is a server error; good catch was just about to report .

 

[steven s]

I get that there is a server error; good catch was just about to report .

Did you get the same error when importing forums? I do.

 

[Mr_Bob]

Not when importing forums, just PMs.

 

[steven s]

I can import visitor messages. Just not forums and PMs so far.

 

[Rob]

mine hangs with same error while importing threads / posts

 

[steven s]

mine hangs with same error while importing threads / posts

I haven't got that far yet.
I wonder has anyone imported their v3.8 board yet?
Wonder if it's a mod/hack that is causing the problem.

 

[Rob]

I would doubt that steven since it is working on the database independent of your vbulletin instance. I dont think it will even go anywhere near the plugin tables

 

[mlx]

Same problem here. I think it's related to special characters.

Possibly adding something like

$pmText['touserarray'] = $this->_convertToUtf8($pmText['touserarray']);

might help. Just guessing here though as I cannot test this right now as I just went ahead with importing threads and posts and this step is not finished yet.

P.S. you might want to check XenForo AdminCP -> Tools -> Server Error Log for details. What I posted above is related to the error on line 1058 while importing PMs: library/XenForo/Importer/vBulletin.php(1058)

 

[steven s]

Same problem here. I think it's related to special characters.

Possibly adding something like

$pmText['touserarray'] = $this->_convertToUtf8($pmText['touserarray']);

might help. Just guessing here though as I cannot test this right now as I just went ahead with importing threads and posts and this step is not finished yet.

P.S. you might want to check XenForo AdminCP -> Tools -> Server Error Log for details. What I posted above is related to the error on line 1058 while importing PMs: library/XenForo/Importer/vBulletin.php(1058)

I have nothing in the server log. I'm going to import from a backup rather than my live database.

Added: My db is 700mb.

 

[Rob]

Kier / Mike..... I am almost certain this is caused by rogue characters in the source database. When i import threads and posts this string is choking your code:- \xF4\x80\x80\x97

Looks like unicode but wtf do I know, just guessing. More detailed error report here:- http://xenforo.com/community/threads/import-errors-post-yours-here.4969/#post-80801

 

[Rob]

Help!!!

I need to know what exact post mine is failing on but cant seem to get any more data from debug. If I could figure that out and I can tell you the character or string it is failing on more accuratly.

Does anyone know how to get a little more output such as the sql command or the postid it is working on?

 

[CFodder]

Did a test import from VB 3.8.6, didn't get that error message, all seemed to work okay.

 

[mlx]

The code I've posted above doesn't seem to make a difference. It errors out once there is a special character like German umlauts öäü in the username within touserarray. Not sure if our vBulletin source database being in utf8_general_ci is another important detail?

 

[steven s]

WHOA!
Last night I tried to install my forum names and the page was redirected to an error page.
Today I viewed my forum and the forums were there!

 

[Rob]

related thread: http://xenforo.com/community/threads/import-errors-post-yours-here.4969/

 

[steven s]

related thread: http://xenforo.com/community/threads/import-errors-post-yours-here.4969/

I did. I think it's going to get very confusing with multiple people trying to solve multiple problem in one thread.

 

[Rob]

yeah, like I said, it's related.