Couldn’t save draft posts - solved for now

Posted on December 28, 2005 No Comments

Ah, the joys of stampeding into software upgrades! As noted a few days ago, I recently not only upgraded Wordpress to the new version 2, but I also updated to a current version of MySQL. And then� promptly found issues, as detailed in my support ticket, “Dude, where’s my Draft?“.

One of the responses to my post mentioned that saving drafts just doesn’t work with wp2 and mysql being in Strict Mode. Ah ha. So tonight I finally took the time to search the wp bug tracking system to see if anyone had logged a similar issue. Didn’t see any, so I created one. Perhaps overly vague, but hopefully it’ll help.

Then I decided to see if I could take mysql out of strict mode. Found that my NT service for it loads up an .ini file full of parms. Mine was cleverly called “my.ini”. In there, I found the following 2 lines:

# Set the SQL mode to strict sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

So, I commented out that sql-mode line and restarted my service. And like magic, I can save drafts again!

So, that’ll hold me for now. I’m happy.

OH. and now that that works, I can enjoy a new feature of Wordpress 2.0. While composing a post, I can click “Save and Continue Editing”. Doing so, gives me a preview of what my post will look like in a little framed section. Nothing real new there from 1.5, but it that framed section includes my theme and css styles. Awesome, now I can see exactly what it’ll look like.