DELETE doesn't work.

[Matteo De Martino]

Hi everybody
I have a table "prenotazione":

DROP TABLE IF EXISTS `progetto_bd`.`prenotazione`;
CREATE TABLE `progetto_bd`.`prenotazione` (
`ID` int(10) unsigned NOT NULL auto_increment,
`ID_spettacolo` int(10) unsigned NOT NULL,
`ID_user` int(10) unsigned NOT NULL,
`n_posti_prenotati` int(10) unsigned NOT NULL,
PRIMARY KEY (`ID`),
KEY `FK_prenotazione_spett` (`ID_spettacolo`),
KEY `FK_prenotazione_user` (`ID_user`),
CONSTRAINT `FK_prenotazione_spett` FOREIGN KEY (`ID_spettacolo`) REFERENCES `spettacolo` (`ID`) ON DELETE CASCADE,
CONSTRAINT `FK_prenotazione_user` FOREIGN KEY (`ID_user`) REFERENCES `utente` (`ID`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

my problem is that, when for example i try something like:
DELETE FROM prenotazione;
the answer is: "Error 1326: Cursor is not open"....
Can someone explain how to solve it or at least where beginning??
thank you very much