Single post causing DB errors - How to fix?

[Gadget_Guy]

I put this on the vbulletin.com forums but have yet to get a response.

Thought maybe someone here could help.

I have a site running 3.8.7 and in only one particular thread users are getting a DB crash when trying to load a particular page.

I have my userCP settings to show 30 posts per page.

I have narrowed down the post to Page 25 of 26 pages (I can load Page 24, and I can load Page 26)

When I try to load Page 25 I get a DB crash.


How can I manually go in and see which specific post is causing the issue and delete it?

Here is the URL: https://www.toronto-subaru-club.com/...cycles-25.html

Reading through other solutions I saw that running the "Rebuild Post Cache" sometimes will fix things.... I ran it.

After a while it also crashes.

I suspect it is hitting that post and crashing.


What can I do? I really don't want to delete that thread as it has some great content in it.


Thanks,


D.

[Zachery]

We need to know what the database error is.

[Gadget_Guy]

Originally Posted by Zachery

We need to know what the database error is.

I am working on it.

Trying to run the post cache process again to try and capture it.

D.

[ForceHSS]

https://www.toronto-subaru-club.com/...cycles-25.html

You sure this is the correct url ...cycles-25.html

[Gadget_Guy]

Here is a new development.

In IE that URL loads fine (albet slow)

That same URL crashes in Chrome.

I am trying to run the Post Cache function in IE to see if it makes a difference.

D.

[Gadget_Guy]

Here is the contents of the DB error when running the Post Cache Funtion.

It seems to be from something else than the thread that my users are complaining about.

Is there something I can run on the DB to fix all errors?

D.

[Gadget_Guy]

Update.

I rebuilt all my attachment thumbnails as when I looked in that error from before it seems to point to a post with an attachment.

I am trying the rebuild cache again.

However, in chrome, that page still throws an error if you try to load it.

D.

[Gadget_Guy]

Here is what I get:

[Zachery]

That's a browser crash, not a db error.

[Gadget_Guy]

It is a browser crash based on a DB issue.

I am still unable to complete a Rebuild Post Cache due to errors.

As they come up, should I delete the posts that cause the crash?

For example this is where that post cache rebuild process crashes everytime right now:

Invalid SQL:

REPLACE INTO postparsed
(postid, dateline, hasimages, pagetext_html , styleid, languageid)
VALUES
(1556695,
1403612046,
1,
'<div style=\"margin:20px; margin-top:5px; \">\r\n <div class=\"smallfont\" style=\"margin-bottom:2px\">Quote:</div>\r\n

How would I go about deleting that one post (1556695) and then retrying the rebuild post cache and deleting each post that errors till I can get it to successfully run all the way through?

OR

Is there something I can just run that will fix all errors in the DB?

The DB is over 10 years old at this point and probably could use some sort of cleaning or reindexing I would think....

Or am I wrong?

D.