luk3thomas

I was having the same problem, I was getting the ‘Submit for Review’ error when I tried to publish a post.

Summary of problem:

1. Problem occured after an import
2. Auto-drafts and newly created users were saving to the database with an ID == 0

Solution:

1. Delete all entries from the database with a primary key == 0 (posts, users, etc)
2. Reset the primary key fields for all the tables to AUTO_INCREMENT

Here is the sql code (you’ll want to check any tables created by your plugins and re AUTO_INCREMENT those as well) (Here is a text file with the code – pretty formatting ):
ALTER TABLEsswp_commentmetaCHANGEmeta_idmeta_id` BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE sswp_comments CHANGE comment_ID comment_ID BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE sswp_links CHANGE link_id link_id BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE sswp_options CHANGE option_id option_id BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE sswp_postmeta CHANGE meta_id meta_id BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE sswp_posts CHANGE ID ID BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE sswp_terms CHANGE term_id term_id BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE sswp_term_taxonomy CHANGE term_taxonomy_id term_taxonomy_id BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE sswp_usermeta CHANGE umeta_id umeta_id BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE sswp_users CHANGE ID ID BIGINT ( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT;
~

`

I’m having the same problem. Subscribing to post – will post back if I find a solution