Error – 1293 – Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

QuestionsCategory: CakephpError – 1293 – Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Roboto asked 3 months ago

Showing ERROR 
ERROR 1293 – Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause 
 


CREATE TABLE `history` (
`id` int( 11 ) NOT NULL ,
`userid` int( 11 ) DEFAULT '0',
`created_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP ,
`modified_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`isdeleted` tinyint( 1 ) DEFAULT '0',
) ENGINE = InnoDB DEFAULT CHARSET = latin1;