'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)