MyBB Community Forums

MySQL error: 1062
Duplicate entry '0' for key 1
Query: INSERT INTO myvolkan_users(....

What's problem?

Moved to General Support

As for that you need to fix your mysql increment counter. You can contact your host on how to do that.

You can try this SQL query

ALTER TABLE `mybb_users` CHANGE `uid` `uid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT

If you get an error doing that, try running this query first:

ALTER TABLE `mybb_users` ADD PRIMARY KEY ( `uid` )