XF 1.4 post titles from import of vBulletin

[Majora]

Hello,
i have post titles from vBulletin in my threads: http://lager-jobs.de/xenforo/threads/wir-suchen-einen-handytester.73527/

how can i delete that? Should i empty the xf_post table and import the threads and post again with this solution: https://xenforo.com/community/threa...when-importring-from-vb3-8.45427/#post-487662

Is there any alternative?

 

[Chris D]

You may have some success with the Post Content Find and Replace add-on by Kier in the Resource Manager.

Quick Find:

[/b]

Regular Expression:

/^\[b\](.*)\[\/b\]\n\n/i

Replacement String (should be blank)

Ensure you back up before performing such operations as they are unreversible unless you restore from a back up.

 

[Majora]

That plugin doesn't work with xenForo 1.4.8 :/
Is there a sql query to replace the content?

 

[Chris D]

That plugin doesn't work with xenForo 1.4.8 :/

Yes, it does.

Can you describe the issue you're having with it?

 

[Majora]

i get a blank page when i click on admin_navigation_post_replace in the left menu.

I have uploaded the file PostReplace to library with the 3 files inside it...

Thank you for your answer!

 

[Chris D]

It looks like the rebuild process didn't finish properly.

Try uninstalling / reinstalling.

It definitely works for me.

 

[Majora]

I uploaded the PostReplace file with the 4 files and addon to library. After that i install the addon in the admincp.
Is that right? Did not work for me...

 

[Majora]

anyone?

 

[Chris D]

The add on isn't installing properly, you need to try and get it to do so.

Is there a notice on the Admin CP home page about manual processes haven't yet been completed or server errors?

 

[Majora]

Now it works! I have installed the addon now. The addon found all posts (33.079 matching posts.) but when i click on "start" i get an 500 error:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@xxx.de and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

 

[Chris D]

I feared that would happen.

That may make it an unviable approach.

This may mean you have to start the process again after all.

 

[Majora]

Okay, what's the solution. I tried it all the time and get everytime the 500 error message..

 

[Chris D]

Hello,
i have post titles from vBulletin in my threads: http://lager-jobs.de/xenforo/threads/wir-suchen-einen-handytester.73527/

how can i delete that? Should i empty the xf_post table and import the threads and post again with this solution: https://xenforo.com/community/threa...when-importring-from-vb3-8.45427/#post-487662

Is there any alternative?

This is likely the only solution, now.