I am receiving MySQL error 1265 when I try to insert records into a table and after googling this error I am no closer to understanding the problem.
Here is the error message that is returned:
Warning Code : 1265
Data truncated for column 'DATE_FIELD' at row 1

Here is the table definition:

CREATE TABLE  `test`.`TIME_TABLE` (
`RECORD_NUM` INT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT  'Number of Records',
`DATE_FIELD` DATE NOT NULL COMMENT  'Date of the event',
`DESCRIPTION` VARCHAR( 1000 ) NOT NULL COMMENT  'Detail of the event'
) ENGINE = MYISAM COMMENT =  'This day in history'

Here is a typical insert:
INSERT INTO TIME_TABLE ( DATE_FIELD, DESCRIPTION ) VALUES ('28, October    1971' , 'Great Britain launched Prospero, the first of four X-3 satellites.');

When inspecting the table the DATE-FIELD is set to ‘0000-00-00’

You can insert a datefield as '1971-10-28'. The data you are trying to insert does not fit in the date column.

OK and Thanks!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.