"import post" on all message titles after import

[malich68]

After importing wowbb, all my posts are marked as 'imported posts". Can I just clear that out? Everything else worked fine.

What would be the mysql query to set that blank?

Thanks!

[Steve Machol]

Please read the Importing HOWTO thread:

http://www.vbulletin.com/forum/showthread.php?t=116398

Take special note of The End Game section. Following these steps should solve those issues

[malich68]

I have read over the posts twice and I have done everything like they said. I just need to know of a query to remove the message title "imported post" from all the imported message.

Can someone please give me a query? It would be a simple update command.

Thanks!

Mike

[Steve Machol]

I'll move this to the Import forum so Jerry will see it.

[Jerry]

SQL to do that will be :



UPDATE post SET title='' WHERE title LIKE 'imported post';


Or to just do them all :



UPDATE post SET title='';


You may need your table prefix on post, i.e. vb3_post.

[malich68]

Thank you, all is better now!

Mike