I'm using MYSQL version 5.7 and this is the table giving me issues:

```
CREATE TABLE Tenencia(
  fechaInicio DATE,
  numero INT,
  nif CHAR(10),
  fechaFinal DATE,
  PRIMARY KEY (fechaInicio,numero,nif),
  FOREIGN KEY (numero) REFERENCES Animal (numero)
    ON UPDATE CASCADE,
  FOREIGN KEY (nif) REFERENCES Propietario (nif)
    ON UPDATE CASCADE
 );

```

I'm trying to do a simple insertion of data into this table, like so:

```
INSERT INTO Tenencia (fechaInicio,numero,nif,fechaFinal) 
VALUES ('2012-06-10', 2, '1B', '2012-09-11');

```

But it's returning this error:

```
ERROR 1241 (21000): Operand should contain 1 column(s)

```

I've seen this question asked before when SELECTs are used in the insertion, or when trying to insert multiple rows at a time, but I'm inserting them one by one (it's a class assignment and inserting them one by one is one of the requirements).

[Here's a link to the complete script](http://pastebin.com/AjyV0LwX), if that's necessary.
In the table definition there is a trigger as well.

Help please!