Issue Bug Closed

#66929Cannot parse default date

Xavier Perseguers 05/13/15, 10:21 updated 10/19/17, 21:59

Description

#1310027793: ERROR: Query could not be parsed: “SQL engine parse ERROR: Field type unknown in parseFieldDef()!: near "date default ’0000-00-00’ "”. Query: “ALTER TABLE fe_users ADD birthday date default ’0000-00-00’;”

When installing an extension having ext_tables.sql:

#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
    birthday date DEFAULT '0000-00-00',
    subscribed_courses int(11) unsigned DEFAULT '0' NOT NULL,
    tx_extbase_type varchar(255) DEFAULT '' NOT NULL,
);

Reviews 1