Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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?

share|improve this question
    
any idea ?i really need help –  boranb Nov 20 '11 at 0:27

2 Answers 2

up vote 0 down vote accepted

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.
share|improve this answer
    
Thank you Roman –  boranb Dec 1 '11 at 13:02

Got stuck with this problem with one of our websites after we used the tumblr import tool. The tool did not import the blog successfully and also introduced this problem.

I fixed this by removing the auto-draft posts post with a very large id something above 2billion in my case and reseting the auto-increment to something like 2000 depending on how many rows you had before in the wp-posts table.

That should do it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.