Skip navigation links

MySQL Forums :: Spanish :: #1067 - Invalid default value for 'date'


Advanced Search

#1067 - Invalid default value for 'date'
Posted by: Eric FM ()
Date: April 22, 2007 08:22AM

Buenas! Estoy intentando importar un archivo sql a MySQL, concretamente al de iespana.es, que corre en la versión 5.0.26. El problema es que al ejecutar las siguientes órdenes

CREATE TABLE `smf_calendar` (
`ID_EVENT` smallint(5) unsigned NOT NULL auto_increment,
`startDate` date NOT NULL default '0001-01-01',
`endDate` date NOT NULL default '0001-01-01',
`ID_BOARD` smallint(5) unsigned NOT NULL default '0',
`ID_TOPIC` mediumint(8) unsigned NOT NULL default '0',
`title` varchar(48) NOT NULL default '',
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_EVENT`),
KEY `startDate` (`startDate`),
KEY `endDate` (`endDate`),
KEY `topic` (`ID_TOPIC`,`ID_MEMBER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

me da el error #1067 - Invalid default value for 'date'.

He estado buscando solución para este error, he probado diferentes formatos de fecha, pero no consigo que me cree la tabla. Me podéis decir como remediarlo? Gracias!

Options: ReplyQuote


Subject Views Written By Posted
#1067 - Invalid default value for 'date' 8820 Eric FM 04/22/2007 08:22AM
Re: #1067 - Invalid default value for 'date' 4846 Miguel Perez 04/27/2007 02:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.