cyrillsneer

Out of curiosity, why not just use the built in ability to keep a post stuck to the front page? Wouldn’t that accomplish the same thing?

Because we would like the posts to start cycling through the loop from the beginning again.

I’d love to know how to do this.

So the mediatemple forums have been really helpful, much more so than this place.

But incase any poor sod is having the same problems as me, this is where I am so far…

Ideally I would remove all the plugins, reboot the SQL container, wait 24 hours, run a new query and see where I am.

However I am running commerical blogs so that is not an option, so…

1) I have limited the number of reivisions allowed on each blog to 3.

You can do this by adding the following line to your wp-config.php file

define(‘WP_POST_REVISIONS’, 3);

2) Based on reading/advice/looking at the queries these are likely to be the slowest

1) subscribe to comments
2) simple tags
3) top commentators widget
4) get recent comments
5) wp-2.3 related posts

I have removed what I could;

1) get recent comments <- now core
2) Simple Tags <- nice but not reader affecting
3) Top commentator widget <- again not essential for us

Once done, I rebooted my container, repaired the tables, and rebooted again.

I will now wait 24 hours and re-run the analyzer and see where we are.

Can anyone suggest somewhere where I can get WordPress help?

I don’t seem to have much luck in this forum… ??

Any help would be really really appreciated!

Any news on this, all my writers are complaining like crazy, it is rendering my blog useless.

No one is using HTTP protection and it only occurs on say 50% of scheduled stories.

Mods – anyone – please?

I wouldn’t normally bump, but I really need some help, quickly.

Same thing happening for me as well, you would hope that “full size” would not have have image size tags added to it

Is it possible or should I just not worry about our URLS?

bump.

Is there are any other resources someone could point me in the direction of, our blog is basically crippled until I fix this.

I was looking around some forums and some suggested I “drop ” all the plugin tables.

I am thinking about backing up and repopulating the database but I have no idea if this will help.

I would say 85% of new posts now get this error.

——————————————————–
WordPress database error: [Duplicate entry ” for key 2]
INSERT INTO wp_terms (name, slug, term_group) VALUES (”, ”, ‘0’)

WordPress database error: [Duplicate entry ‘0-post_tag’ for key 2]

INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES (‘0’, ‘post_tag’, ”, ‘0’, ‘0’)

Warning: Cannot modify header information – headers already sent by (output started at /xxx/xxxx/xxxxxx/xxxxx/domains/xxxxxxx.com/html/wp-includes/wp-db.php:160) in/xxx/xxxx/xxxxxx/xxxxx/domains/xxxxxxx.com//html/wp-includes/pluggable.php on line 391

Thanks for the reply but to be honest I am not really sure what I am looking for or how to correct it, any chance of a link that could explain it, it is getting to the point where people cannot post new stories.

Sorry.

So I had my friend look at our wordpress install, he went into the database and managed to find all the deleted entries.

He said that each one that had disappeared had Null values in the date field/s, simply changing them back to what you want them to be fixed it.