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

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

Postby admin » Sun Mar 12, 2017 7: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 you wish to add visual documentation (screenshots), make a donation and we'll let you know when the post has been updated

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.- Our account had recently a hacking problem on FB and we were forced to create a new one. We lost all our posts & likes. :(
  2. Send us a testimonial.- Testimonials thanking for our good team work can be valuable to us and may encourage others to seek our support.
  3. Post a review.- Posting a good review about this site could also compel others to seek our advice & support.

Thank You!
User avatar
Site Admin
Posts: 452
Joined: Mon Jan 13, 2014 3:18 am
Location: New York City

Return to WordPress

Who is online

Users browsing this forum: No registered users and 0 guests