XF 1.4 xf_bb_code_parse_cache corrupted

[grantus]

I was checking the mysql logs and noticed I had tons of warnings that xf_bb_code_parse_cache was corrupted. Since the table is innodb, I couldn't just do a repair via phpmyadmin.

So a few questions:

1. How can I fix it?
2. How does it get corrupted?
3. Is it normal for that table to be 140 MB?

Thanks.

 

[Chris D]

Easiest way to fix it is just disable the bb code parse cache. There's actually quite little benefit unless you have a considerable amount of content with lots of complex bb code content.

It's actually disabled by default because it has limited benefit for most people.

That table will usually be roughly the same size as the xf_post table. It stores a copy of the parsed bb code tree for each post.

If any of these things concern you or don't apply I would definitely disable it.

 

[grantus]

I don't even remember enabling this feature. Where is it located? Is it related to bb code media sites?

 

[Chris D]

It's in Performance Options I think.

 

[grantus]

Yes, that's where it is. Thanks for the help!