asodha

Hey Marius,

Thanks for the reply. I don’t think it’s so much an issue that keeps, happening, rather than an issue that has been there for a while already, and occasionally causes the table to crash; or at least that’s what I believe.

I have a ticket open with them to see if there’s anything they can do. I’m also looking at options to find a database expert who might be able to fix it.

A friend of mind suggested that I create a new table, import all the data, delete the original ‘posts’ table, and then rename the new table.

Has anyone tried anything like that – do you know if it will work?

As always, any assistance appreciated,

Amit

Update:

so using PHP MY Admin, if I do a check on the wp_post table this is what comes up…

wp_posts check warning Size of indexfile is: 2822144 Should be: 2821120
wp_posts check error Key in wrong position at page 243712
wp_posts check error Corrupt

I can repair and the status says OK, but everytime I run a check afterwards, I still get this same error.

Any help greatly appreciated.

Thanks

Thanks James, I’ll set the topic to resolved but try later once I fix my DB issue.

Cheers.

Amit

Sorry, here is the full DB repair report…

The wp_users table is okay.

The wp_usermeta table is okay.

The wp_posts table is not okay. It is reporting the following error: Size of indexfile is: 2822144 Should be: 2821120. WordPress will attempt to repair this table…
Failed to repair the wp_posts table. Error: Size of indexfile is: 2822144 Should be: 2821120

The wp_comments table is okay.

The wp_links table is okay.

The wp_options table is okay.

The wp_postmeta table is okay.

The wp_terms table is okay.

The wp_term_taxonomy table is okay.

The wp_term_relationships table is okay.

The wp_commentmeta table is okay.

Thanks James, I will give that a go.

By the way – going back to the original point.

If it wasn’t the feedsmith plugin that caused the problem, should I disable it, my feed would automatically become revert to default e.g. https://www.unlimitedchoice.org/blog/feed

Much obliged,

Amit

Hey James,

Yes, but it looks like it might not have been the plugin at all.

I’ve just logged into my blog and the same thing has occurred even though I’ve not done anything.

If you visit the blog now you will see what I mean.

Once I get this problem fixed, I’ll see if I can disable the plugin and hope that it doesn’t cause any issues.

Amit

Did a repair on my database and that has restore.

I’ll log a separate thread to find a way to safely move away from feedburner without killing my blog!

Hey Tim,

It seems to have sorted itself out. I had created that account at some point in the past, so I deleted it and it has since stopped.

Thanks for the advice – Setting to resolved.

Amit

Yes sorry, I was quoting you lee…

cool, I’ve never used a security plugin but I’ve just installed one now so hopefully a little extra peace of mind.

Thanks for your help.

Amit

@ Lee Joeseph –

Please take a moment to see this all from my point of view, as the customer, and not your point of view as the hosting company.

Place yourself in my shoes if you were in exactly the same shoes and how you would like all this handled if you were me?
– What do you mean?

@bd – I think it’s all fixed now with the help from the hosting company.

How do I get this thread deleted ?

Hey Hector..

I’m sadly not a web developer so I wouldn’t even have a clue where to start…

Thanks for the heads up though – I’ve removed a whole load of plugins today, made sure everything is up-to date, including my thesis theme.

I’ll speak to my hosting company to see if I can get any help.

By the way – where do you see this 500 error? They might ask me to explain where I’m seeing the 500 error?

Thanks,

PS marking topic as resolved. Thanks

Hey Hector,

I found the problematic plugin – it was a plugin I had installed wp-tweet button.

It’s now deactivated.

I’ve also installed jetpack and go rid of WP.com stats

Thanks for all your help! :-)))

Amit

Thanks Hector – I’m going to try and do that shortly and I’ll reply back and let you know how that goes ??

Thanks for all your help so far! ??

Amit

Cheers for that! ??