Error when entering information into the database

Column count doesn’t match value count at row 1

Please explain what this error is and how to fix it.


Answer 1, authority 100%

This means that you specified more or less fields than values in the INSERT query. This error will equally cause

INSERT INTO table (field1, field2) VALUES ('1');

and

INSERT INTO table (field1) VALUES ('1', '2');