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?

thanks.

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.

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue