Single post causing DB errors - How to fix?

[Gadget_Guy]

Can I do this via the "Execute SQL Query" in the AdminCP ?

I hate to ask... but I am not SQL savy....

What specifically do I do in phpMyAdmin ?


I suppose what you are saying is to "soft delete" the post in the DB then delete it in the forums itself.

Then run the Post Cache rebuild till I find the next post issue and do the process again.


My question is this:

How can I load that specific post in the forums to hard delete it?


D.

--------------- Added [DATE]1403719057[/DATE] at [TIME]1403719057[/TIME] ---------------

Should I try the IMPEX cleaner.php tool?

D.

[ForceHSS]

There are a few places html are turned on group permissions and Forums & Moderators/Forum Manager then edit each forum you have and under Enable / Disable Features
Allow HTML = No
There might also be a setting in the options somewhere, but can't remember so check. It's not a good idea to allow members to use HTML as they can insert code

[TheLastSuperman]

Having HTML enabled per forum is a security issue IF you cannot trust 100% of your members and not may site owners can so don't think you're one of the few - instead disable the ability to post HTML in ANY forum.

Now that it's disabled rebuild your posts, if html is now disabled all their code is null and void i.e. it will show the exact code used in the post not a flash player or music player it will be the actual code i.e. <object type="code blah blah><more code param etc etc></object> so in other words - once you disable the html it should not affect the site nor produce a database error anymore so no need to delete that thread now, as you were back to business!

*Remember to disable the ability to post html in ALL forums UNLESS its a admin-only forum where only admins can post, if guests or members can view that's fine but do not allow them to post or edit posts in a html postable forum.

[Gadget_Guy]

Originally Posted by TheLastSuperman

Having HTML enabled per forum is a security issue IF you cannot trust 100% of your members and not may site owners can so don't think you're one of the few - instead disable the ability to post HTML in ANY forum.

Now that it's disabled rebuild your posts, if html is now disabled all their code is null and void i.e. it will show the exact code used in the post not a flash player or music player it will be the actual code i.e. <object type="code blah blah><more code param etc etc></object> so in other words - once you disable the html it should not affect the site nor produce a database error anymore so no need to delete that thread now, as you were back to business!

*Remember to disable the ability to post html in ALL forums UNLESS its a admin-only forum where only admins can post, if guests or members can view that's fine but do not allow them to post or edit posts in a html postable forum.

What am I running?

Rebuild Post Cache or something else?

D.

[ForceHSS]

Originally Posted by Gadget_Guy

What am I running?

Rebuild Post Cache or something else?

D.

Maintenance/General Update Tools

[Gadget_Guy]

Tried... still erroring when running rebuilding cache

D.

[Zachery]

Did you ever get the MySQL max_packet_size adjusted?

[Gadget_Guy]

Originally Posted by Zachery

Did you ever get the MySQL max_packet_size adjusted?

According to the AdminCP it is set to 16MB



D.

[ForceHSS]

Have it at 16 myself but try putting it to 32 and test it to rule that out as the problem if its not u can always put it back

[Gadget_Guy]

I will ask my host to make the change.

Anything else I can try in the meantime?

Is it worth me trying the IMPEX tools?

D.