liquidrice

Hi Alex,

Thanks for responding. After a day of live testing I’m still running into the problem of only a few select posts using shortlinks and others using the default shortlink, not even the “pretty url”. I’ve set up Bit.ly pro user data in the wp-config file have the plugin installed.

Most tweets uses the default url:
https://twitter.com/sneakernews/status/215248094508486656

And maybe one out of every 10 tweets gets a bit.ly shortened link:

Air Jordan X "Hanes" By @ReviveCustoms https://t.co/NvPFwHyY

— Sneaker News (@SneakerNews) June 20, 2012

May or may not have been the theme.

Acting on a hunch, there was one plugin we used which flipped the time in wp-admin for us “Restore Exact Time”. I turned this off and some of the scheduled posts started to automatically publish again. Not all but most. So if you have this plugin installed, consider uninstalling it to see what happens. I’ve had 10 straight posts publish automatically, fingers crossed this will continue to work out.

Early on I did test with all plugins off but it was too quick of a test since the site doesn’t really function with out a lot of the plugins.

I’m having this issue as well. I’m on WP 3.3.1, plugin was initially working but after trying to make a change in diggdigg all functionality broke. Doing a full reset of the plugin broke the entire plugin. Hope the developer updates soon…

So I tried a few things.

1) I reset the plugins folder and while plugins were all off. I tested scheduling. I still saw missed scheduled posts. Plugins aren’t the problem.

2) I left all plugins active and I changed to the default theme twenty eleven. I scheduled about 10 posts back to back. Each post missed the schedule and noted that in the time. BUT one minute later, all of those posts which missed the scheduled published.

So I have a feeling it might have something to do with my theme. We’ve never had this problem until the 3.3.1 update. Any one have any ideas on old theme code that doesn’t work with wp 3.3.1?

My schedule is usually at least one post per hour and during peak times of the day, one every 30 mins.

My hosting company discovered this:
“I don’t see the same number of scheduled posts in the wp_cron database as on the schedule posts page in wp-admin. And when I create a new post and set a scheduled time, I don’t always see it in the wp_cron.”

Any WP experts out there? please weigh in.

Richard,

I tried turning off all plugins 5 minutes before the scheduled post was going publish but that didn’t work either. What plugins are you using? here’s my list:
https://dl.dropbox.com/u/19472631/plugins.gif

I also tried clearing my htaccess and rebuilding it via a resave of permalinks settings.

Of the 12 scheduled yesterday, 3 didn’t publish on their own.

Still have the problem but a little better now. I’m having my hosting company check the cron jobs which seem to the the problem.

One other thing I had was sticked posts which i’ve taken off. Not sure if this helped anything yet. We have a whole new batch of scheduled posts today so we’ll see.

I have the same issue with the little image, here’s an article with a bunch of them:
https://sneakernews.com/2011/05/16/celebrity-feet-fabolous-air-jordan-v-quai54/

Screen shot
https://dl.dropbox.com/u/19472631/sn-image-next-to-tag.jpg

fyankai! Thanks so much!! That was exactly what it the problem was. luckily, its just my personal blog and i had only a month of posts. So I had no clue how to go from PHP4 to PHP5, I ended up just building a new db with PHP5 and imported from the old files.

Just thought I’d add what the problem was and the resolution.

Problem started with WordPress 2.3. Every time we edit or post new ‘page’, the server load with shoot up and force it to crash and at times lock us out.

It seems the wp-options table was the main cause of the problem, this table fills up with junk and increases from 2mb to 50 to 180mb at times.

This time, the crash locked us out and we couldn’t get the site back up at all and we finally did after a few hours, the entire site was a blank page. can’t access anything.

We fixed this by going into phpmyadmin and ‘browse’ the wp-options table and deleted the last ‘junk’ row (lots of rewrite rules). This got the site back up again but the wp-options table was still over 150mb so back to deleting junk rows. we got it back down to 3mb.

this obviously doesn’t fully solve our problem of not being able to create or edit ‘pages’.

We couldn’t really upgrade to WP2.7 yet since our theme didn’t really support it so we just upgraded to wp2.5 for the time being and everything so far editing and creating pages seem fine. We are looking forward to upgrading to wp2.7.

hope this helps some of you guys out with a big/huge wp-options table.

Im still unable to resolve this problem. I recently upgraded to a quadcore server and just left the wp-options at over 40mbs and my site seems to run smoothly. It seems that the problem occurs when you create or edit a “page” or upload images to that old or new page. Hopefully a upgrade to wp 2.7 will solve this. will update.

doesn’t work on 2.7.1 anymore unfortunately.

Hello,

I’ve been following this thread for a little while with the same problem.

My wp-options was about 34MBs and one day my site just refused to load.

I recently fixed it and got the same problem again today and I think I just fixed it for a second time (fingers crossed). Here’s what I did:

1st Fix:
In phpmyadmin, i exported the wp-options table (excel). Found about 15 rows of “rewrite_rules” which turned out to be exactly the same in each row. Each of those rows were about 2mb each. Looking at it, i discovered that it was one of my ‘posts’ that caused the problem. I noticed this when i saw the same post name repeated over and over. I went in to wp manage and drafted that one post. Problem fixed. 3 days later, problem came back.

2nd Fix:
My wp-options is now 7mb. Again in phpmyadmin, i exported the wp-options table (excel). Again i discover that there is still traces of that one post that caused problem. Although i got rid of the post that caused the problem, there were images still associated with that post. I looked thru my wp uploads in wp admin and found those images and deleted them in wp-admin. If you have the same problem, delete the files in wp and not ftp. Since deleting in ftp will leave traces of those files in wp.

Hope this helps someone.

oops sorry.

yuming at liquidrice dot com

Thank you.