Bring Your Business to Life › Support › Image Store › Image Store Broke WP, Can only "Submit for Review"
- AuthorPosts
- May 23, 2012 at 9:59 am #47282
Xpark Media
KeymasterI think is more of a permission issue, do you have a permissions plugin installed?
Also don’t just deactivate the plugin do a full uninstall, activate the plugin and got to settings > reset > uninstall
if that doesn’t work, look for the wp_capabilities and your user ID and change the meta_value with the following code and backup your database first:
a:1:{s:13:"administrator";s:1:"1";}
May 24, 2012 at 5:44 am #47302jammer
ParticipantYeah, 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
May 24, 2012 at 5:52 am #47303jammer
ParticipantAhhh, 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″;}
May 24, 2012 at 6:11 am #47304jammer
ParticipantI’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
May 24, 2012 at 6:39 am #47305jammer
ParticipantThe 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 …
May 24, 2012 at 7:11 am #47306jammer
ParticipantAhhhhhh, 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′,”)May 24, 2012 at 7:21 am #47307jammer
ParticipantOK, 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 …
May 24, 2012 at 9:56 am #47310Xpark Media
Keymasterglad to hear that you were able to fix the problem
- AuthorPosts
- You must be logged in to reply to this topic.