phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’

From what I can see, you are inserting data in table wp_commentmeta. However the column meta_id has a Primary Key restriction. You can see the table definition at http://codex.wordpress.org/Database_Description#Table:_wp_commentmeta

As meta_id has a Primary Key restriction, this column may only hold unique values. The insert statements you have posted show only unique values for meta_id, therefore my guess is that your current wp_commentmeta table already holds data. Value ‘1’ is already in table and therefore you cannot insert ‘1’ again.

Related Posts:

  1. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  2. Import 10,000 Users into WordPress WITH a specific ID for each user
  3. phpMyAdmin displays error when importing database
  4. Error establishing a database connection (Set-up locally)
  5. How to create a foreign key in phpmyadmin
  6. How to return number of found rows from SELECT query
  7. Check if post of title already exists
  8. $wpdb->delete column values IN ARRAY()?
  9. How To Make Connection To WordPress Data Base In A Plugin?
  10. Changing user_nicename
  11. Does WordPress cache get_user_meta() results?
  12. WordPress will not operate correctly
  13. How to Join two tables from separate databases within WordPress
  14. error importing localhost export file to server
  15. How to sort results from a custom database table
  16. How can I call a row of user specific data from a custom table added to the WP Database
  17. Insert post without actions/hooks
  18. How to merge local and live databases?
  19. How to track a users progress through pages by inserting data into WordPress Database?
  20. WP database error for comments_popup_link()
  21. if statement on database query
  22. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  23. No wp-config.php file on local install of wordpress – site still displays
  24. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  25. #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  26. Different database query in function.php using mysqli
  27. How to create and work with custom data / tables (i.e., for arbitrary data)?
  28. Create WP_Query to search for posts by their categories or their parent/child categories
  29. WordPress database import: Row size too large
  30. WordPress not reflecting changed of the database
  31. How to display data from custom table in wordpress phpmyadmin
  32. How can I save unique user data on my site? [closed]
  33. Is it possible to create a wordpress database with php code?
  34. Update results, Before deleting the related category [closed]
  35. database sent to a JSON file
  36. inserting a post from an extern php file but post content doesn’t show on wp site
  37. Using custom tables for old posts
  38. Not connecting to database in file with multiple MySQL connections
  39. WordPress Block developer from exporting Database via PHP
  40. wpdb prepare insert table doesn’t work
  41. Should I use WordPress to skin a database website?
  42. How do I display offsite database info on my wordpress site?
  43. Creating Database Table vs. Adding MetaData to Post & User
  44. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  45. Most commented posts by time period (last 12h, last 24h and etc)
  46. I can’t update my data through $wpdb
  47. Why when I create a new post I found 2 record related to this post into the posts database table?
  48. Adding data to custom wordpress database table
  49. Add row to custom database Table and delete all rows older than 1 day
  50. select a single val though a table in wordpress
  51. SQL error with custom query
  52. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  53. Please help! I have a problem with getting wordpress databas
  54. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  55. Unable to insert two value in two different columns (WordPress database)
  56. Using wpdb to connect to a different database is not working
  57. why not selecting multiple rows of same standard_id using SQL query from database?
  58. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  59. Insert data from form to database
  60. can’t delete a row from post_meta table
  61. How to set max users to 17.000
  62. two wordpress sites, two themes, one database, same content
  63. Insert double entry in DB
  64. How to connect database table to each registered wordpress user.
  65. Let users register weight each day and save it in DB
  66. MySQL database migration to WordPress
  67. Custom query_posts() parameter
  68. How to pass username into form that sends data to database
  69. How to edit the default database of WordPress [closed]
  70. Display total count of products in orders of a specific order status
  71. Getting invalid user ID error when creating a new user with wp_insert_user
  72. Execute multiple PHP Snippets causes error?
  73. Custom form that stores data in mysql database
  74. Putting form result in my database
  75. Can’t insert into a database wordpress
  76. Undefined function mysql_connect()
  77. MySQL column count doesn’t match value count at row 1 [closed]
  78. Inserting dynamic content into a page
  79. Export User Info to CSV from Front End
  80. WordPress admin never finishes saving page on site with large page count
  81. Update some database fields when post is saved
  82. sql query to put quotes around numbers in img tag
  83. Strange wordpress slowness
  84. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  85. Accessing the database from a plugin outside of action hooks
  86. Databases – Submitting data from inputs to database [closed]
  87. WordPress Custom SQL Table with UserID Filter for results
  88. How to get image from url from the database?
  89. Use variable in SQL statement
  90. How to track who has deleted files
  91. How to display results from a data table with an encrypted user id?
  92. How to WP_Query posts order by parent title?
  93. how to get data from two different table from wordpress database
  94. Passing Current User ID into SQL statement
  95. Processing forms with php to wordpress database
  96. How to fetch results from database
  97. Using the same shortcode to show any table from the database
  98. Create an unique ID number after submit form
  99. How to send push notification in android using php? [closed]
  100. running an existing WordPress site from Visual Studio Code?