What is post_parsed for
 

I have just added a new bbcode tag and want it to be applied to all old posts that have used it. I believe that running the command below will fix it:

truncate post_parsed

However, I'm not entirely up to speed as to what this post_parsed table does? Is it like a post cache whereby no processing has to be run to parse bbcode on the fly? If i truncate it will it affect performance? Can I then rebuild the cache?

Actually its 'postparsed' table. Try this [link] for some words on what the postparsed table is for.

Ah okay. So if i truncate that table, how do I rebuild the cache?

I'm guessing its done when the posts are parsed to be displayed, I've never really looked into actually. :D

*Goes to look in vBulletin Files*

You rebuild it in the ACP - "Rebuild Post Cache" is part of the rebuild counters area.

Or just wait until it gets populated again

Yep.

There's no harm in truncating that table it will just force bbcode to be parsed again on first views. Unless your site is insanely active, you can do it without fear.


You have users that use bbcodes that don't yet exist? How very strange. :)

We've just upgraded from vB2 (with a custom bbcode hacked in), and it needed porting over to vB3 :)