AVeryNiceWeb

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
http://www.AVeryNiceWeb.com

We also have great domain names for your next website. Go through the list and make an offer now!

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
admin
Site Admin
 
Posts: 459
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

cron