mysql列与行的计数不匹配_PHP，MySQL错误：列计数与第1行的值计数不匹配

我收到这个错误：

Column count doesn't match value count at row 1

从以下代码中：

$name = $_GET['name'];

$description = $_GET['description'];

$shortDescription = $_GET['shortDescription'];

$ingredients = $_GET['ingredients'];

$method = $_GET['method'];

//$image = $_GET['image'];

$username = $_GET['username'];

$length = $_GET['length'];

$dateAdded = uk_date();

$conn = mysql_connect('localhost', 'dbname', 'pass');

mysql_select_db('dbname');

$query = sprintf("INSERT INTO dbname (id, Name, Description, shortDescription, Ingredients, Method, Length, dateAdded, Username) VALUES ('', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",

mysql_real_escape_string($name),

mysql_real_escape_string($description),

mysql_real_escape_string($shortDescription),

mysql_real_escape_string($ingredients),

//mysql_real_escape_string($image),

mysql_real_escape_string($length),

mysql_real_escape_string($dateAdded),

mysql_real_escape_string($username));

$result = mysql_query($query) or die(mysql_error());错误是什么意思？