"auto increment" issue

i have installed a wordpress on my linode and it was running without a problem till today. but today i realized i dont have admin rights to post a page in wp-admin. i googled it and found it is because "auto increment" on primary keys are gone on my wp table. so how will i fix this and why my "auto increment" on primary keys are gone by their self? :x

thanks.

2 Replies

@bboran:

my "auto increment" on primary keys are gone by their self?
I doubt it. Though maybe someone proficient with wordpress might give you some pointers.

If indeed the problem is because there is no 'auto increment', correcting the database scheme/structure should resolve that problem. If nothing else, you can backup/dump the database data and import it with the correct database structure/schema.

Travis

I agree with travis, backup your database, reinstall it from the wordpress installer, then load all the data back into the new database, remember to skip create table statements when dumping the database and to truncate the tables before you load the backup. Missing auto increment is a bit weird not sure why it would happen.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct