submit for review issue

by

I have installed WordPress on my linode vps and it was running without a problem till today.

Today I realized I dont have admin rights to post a page in wp-admin. It doesn’t show me submit button, it shows me “submit for review” button instead. It is very odd because I am logged in with admin account and for example I can use theme editor, edit styles etc. I googled it and found something about “auto increment on primary keys are gone”.

What do you think?

4 Answers
4

Weird.. Have you checked the database on your own?

  1. Are you in the administrator group? Get your user id from the {tableprefix}_users table and search for the coresponding meta key {tableprefix}_user_level for your user id inside the {tableprefix}_usermeta table. The value should be set to 10.
  2. Do you have migrated the database from another wordpress installation? If it’s really an autoincrement problem, you could use a db tool (e.g. phpMyAdmin) to set the AUTO_INCREMENT attribute. I haven’t tested this, so please make a database backup before and use a testsystem. Open your database, select a table (e.g. {tableprefix}_posts), click the Structure tab and edit the ID column. There you can enable/disable the AUTO_INCREMENT attribute for this column. Another approach is to export the hole database with the Add AUTO_INCREMENT value selected, delete and re-import the database.

Leave a Comment