Bring Your Business to Life › Support › Image Store › Image Store Broke WP, Can only "Submit for Review"
- AuthorPosts
- May 23, 2012 at 2:19 am #47259jammerParticipant
Hi,
I just found this plugin and am very interested in trying it. However, once it was installed I could no longer publish posts or pages.
Logged in as an administrator I could only “Submit for Review” which also failed to submit for review ironically.
Uninstalling Image Store restored this instance of WP to fully functioning version I can only assume it is related to the added field in the posts table to power the post expiration date …
Any information on this would be appreciated. I followed the installation proceedure exactly (I installed through WP UI)
May 23, 2012 at 9:59 am #47282Xpark MediaKeymasterI 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 #47302jammerParticipantYeah, 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 #47303jammerParticipantAhhh, 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 #47304jammerParticipantI’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 #47305jammerParticipantThe 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 #47306jammerParticipantAhhhhhh, 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 #47307jammerParticipantOK, 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 MediaKeymasterglad to hear that you were able to fix the problem
- AuthorPosts
- You must be logged in to reply to this topic.