SQL error: #1062 - Duplicate entry '0' for key 'PRIMARY'

SQL error: #1062 - Duplicate entry '0' for key 'PRIMARY'

Postby admin » Sun Mar 12, 2017 3:05 pm

Symptom: When attempting to import a WordPress website in phpMyAdmin, the following error is shown in pink background:
SQL query:

-- Indexes for table `wp_options`
ALTER TABLE `wp_options`
ADD PRIMARY KEY (`option_id`), ADD UNIQUE KEY `option_name` (`option_name`);

MySQL said: Documentation
#1062 - Duplicate entry '0' for key 'PRIMARY'

Solution: Re-try a few times. Sometimes is the result of a bad connection between your computer and your host.

For more info on this type of error :
http://stackoverflow.com/questions/1217 ... ey-primary
The AVNW Support Team

If there is a false accusation made against you, then remove this fake report.

Shopping for a new website? See our design deals.

How much is your website worth? Get a free estimate.

And, if our post has provided you with great information, there are a few ways you can show your appreciation:
  1. Like us on Facebook
  2. Post a review.- Posting a good review about this site could help us provide improved support.

Thank You!
User avatar
Site Admin
Posts: 497
Joined: Sun Jan 12, 2014 11:18 pm
Location: New York City

Return to WordPress

Who is online

Users browsing this forum: No registered users and 1 guest