Column count doesn’t match value count at row 1

The error means that you are providing not as much data as the table wp_posts does contain columns. And now the DB engine does not know in which columns to put your data.

To overcome this you must provide the names of the columns you want to fill. Example:

insert into wp_posts (column_name1, column_name2)
values (1, 3)

Look up the table definition and see which columns you want to fill.

And insert means you are inserting a new record. You are not modifying an existing one. Use update for that.

Related Posts:

  1. Access denied for user ‘root@localhost’ (using password:NO)
  2. Access denied for user ‘root@localhost’ (using password:NO)
  3. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  4. Data is not constantly loading from custom wordpress table
  5. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  6. MySQL string replace
  7. Which MySQL data type to use for storing boolean values
  8. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  9. Cannot delete or update a parent row: a foreign key constraint fails
  10. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  11. Your password does not satisfy the current policy requirements
  12. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  13. What is the definition of cardinality in SQL
  14. How to restart remote MySQL server running on Ubuntu linux?
  15. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  16. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  17. Selecting data from two different tables without using joins
  18. Difference between VARCHAR and TEXT in MySQL
  19. MySQL: Invalid use of group function
  20. How can I loop through all rows of a table? (MySQL)
  21. Simple Random Samples from a Sql database
  22. What does SQL clause “GROUP BY 1” mean?
  23. LAST_INSERT_ID() MySQL
  24. SQL select only rows with max value on a column
  25. Trying to perform MINUS operation in MySQL
  26. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  27. mysql count duplicates
  28. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  29. MySQL config file location – redhat linux server
  30. Create boolean column in MySQL with false as default value?
  31. Is there a naming convention for MySQL?
  32. How to get the max of two values in MySQL?
  33. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  34. MySql – HAVING vs WHERE 
  35. How to stop mysqld
  36. How to remove index.php from WordPress site URL
  37. Is merge statement available in MySQL
  38. GROUP_CONCAT comma separator – MySQL
  39. WordPress site migration – icons missing
  40. Set page template for all pages?
  41. How to log mysql errors from wordpress core?
  42. Optimize Multiple Taxonomy Term MySQL Query?
  43. WordPress MySQL & PHP Performance
  44. What specific database privileges does WordPress need?
  45. Using source control with WordPress
  46. My WordPress site always displays a cached version of its homepage
  47. wpdb Custom Meta Data with 2 conditions
  48. Updating User Meta with SQL Query
  49. wpdb prepare syntax
  50. How to run this SQL query of wp_terms database
  51. Proper way to work with wpdb to get user’s firstname
  52. How to change post format from Aside to Image for all posts?
  53. Inserting Hundreds of Thousands of Posts at Once
  54. wp_admin edit.php slow with lots of queries
  55. How to add and SQL query of posts only published
  56. Slow Mysql Queries
  57. can database and media folder be moved to a different drive?
  58. Find duplicate posts with same slug and author
  59. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  60. writing inner join in wpdb
  61. How to get data from WordPress site sql file
  62. Unknown collation when I import a dump from an existing site into a development database?
  63. PHP script can’t connect to Database on port 3307
  64. WordPress with php5-fpm and nginx
  65. Migrating from Existing MySQL Setup to WordPress
  66. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  67. How to translate this mySQL query to $wpdb query
  68. $wpdb to insert html form information
  69. Proper usage of $wpdb->update()?
  70. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  71. Separate DB by yearly archive of WordPress
  72. What should a WordPress developer know about MySQL? [closed]
  73. Copyright: Get first and last date of post type
  74. Update MySQL query so that it functions again
  75. Is there a page length limit?
  76. Query posts by custom taxonomy and sort by post_modified
  77. WordPress $wpdb get posts from category and sort by custom meta
  78. Array Formation Issue
  79. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  80. WordPress $wpdb no result
  81. How can I view my site directly from WordPress dashboard?
  82. Word Press and database from another server sync
  83. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  84. When I add metadata, metavalue length is added in to the value in some cases
  85. edit_user_created_user hook – using to update Groups
  86. Mysql Error in querying form entries in Gravity Form plugin
  87. WordPress database error Duplicate entry for key ‘slug’
  88. Improving performance of SQL sub-queries in WordPress
  89. Saving custom term value to the database in new table
  90. Stop my loop to register data twice
  91. MySQL errors after a WordPress clone
  92. How to restore: Database intact but folders deleted
  93. XML RPC post produces immediate revision with odd post_date_gmt
  94. MYSQL Join on meta key value?
  95. Complicated MySQL Query
  96. problem with quotes on new post
  97. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  98. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  99. How do I load a sql.gz file to my database? (importing)
  100. Batch Replace URLs in WordPress Database

Leave a Comment