Forum Replies Created
-
Posts
-
OK, LAST Message … SOLVED!!!!!
It was my local instance of MySQL configuration that was causing the issue …
I went over to the instance configuration and changed the following line in the my.ini file (using the UI)
from:
sql_mode = “STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
to:
sql_mode = “”
Bingo … all fixed …
Ahhhhhh, I think I’ve found the problem.
I put WP into debug mode and going to the Add New Page screen shows me this error … really not sure how to fix this one though as datetime in MySQL doesn’t have a default value …
WordPress database error: [Field ‘post_expire’ doesn’t have a default value]
INSERT INTO `wp_posts` (`post_author`,`post_date`,`post_date_gmt`,`post_content`, `post_content_filtered`,`post_title`,`post_excerpt`,`post_status`,`post_type`, `comment_status`,`ping_status`,`post_password`,`post_name`,`to_ping`, `pinged`,`post_modified`,`post_modified_gmt`,`post_parent`,`menu_order`,`guid`) VALUES (‘1′,’2012-05-24 14:07:18′,’0000-00-00 00:00:00′,”,”,’Auto Draft’,”,’auto-draft’,’page’,’closed’,’open’,”,”,”,”,’2012-05-24 14:07:18′,’0000-00-00 00:00:00′,’0′,’0′,”)The really odd issue is that it seems most people experiencing this are doing upgrades from 3.2.1 … mine was a completely fresh 3.3.2 install …
I’ve reinstalled the ImageStore plugin and rechecked the wp_capabilities setting and it’s still as you stated and it’s doing the same, I can only submit for review.
I’m stumped on this one now, I’ve tried removing the only security related plugin I have installed “Theme-My-Login” and that hasn’t made any difference at all.
This is really frustrating as this plugin is EXACTLY what I’ve been looking for and would love to use it but this problem is a major showstopper …
Any other ideas for a solution would be really appreciated.
Cheers,
Jammer
Ahhh, OK Found it in the wp_usermeta. I’ve checked the field contents for that entry on the system and it’s exactly as you stated …
a:1:{s:13:”administrator”;s:1:”1″;}
Yeah, I was looking for something permissions related. I did use the uninstall feature of the plugin rather than just deactivating.
I don’t have any permissions plugins installed, I do have Theme-My-Login installed though, would that be the issue? Where in the database is “wp_capabilities”?
Thanks,
Jammer
