| Buenas...
casualmente tengo el mismo error, pero no es por tener un campo mas chico:
DROP TABLE IF EXISTS `tb_registrocompramateriales`;
CREATE TABLE `tb_registrocompramateriales` (
`id` int(11) NOT NULL auto_increment,
`idProveedor` int(11) NOT NULL,
`idMaterial` int(11) NOT NULL,
`fecha` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`precio` float(11,0) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `tb_registrocompramateriales` (`id`, `idProveedor`, `idMaterial`, `fecha`, `precio`) VALUES
(1,0,2,'2006-06-20 10:58:13',2),
(2,0,3,'2006-06-20 10:58:13',1),
(3,0,4,'2006-06-20 10:58:13',1),
(4,1,5,'2006-06-20 10:58:13',60),
(5,1,6,'2006-06-20 10:58:13',30),
(6,0,2,'2006-06-20 11:44:54',2),
(7,0,3,'2006-06-20 11:44:54',1),
(8,0,2,'2006-06-22 15:47:03',2),
(9,0,3,'2006-06-22 15:47:03',1),
(10,0,4,'2006-06-22 15:47:03',1),
(11,1,5,'2006-06-22 15:47:03',60),
(12,1,6,'2006-06-22 15:47:03',30);
COMMIT;
saludos |