Installation failure

[Randomized]

Environment: Hostgator, Linux Centos, Apache 2.2.19, PHP 5.3.6, MySQL 5.1.56, Prestashop 1.4.4.0.

 

PS always fail creating the database at the same table (ps_order_detail). All previous tables are created ok, all following tables are not created. Installation was ok when tried at home with Windows 7 environment.

 

I suspect PS query syntax is having some problem at that table with MySQL version 5.1.56 (at home MySQL version is older), but I don't know how to correct the syntax.

 

Detailed error:

 

Error while inserting data in the database:

'CREATE TABLE `ps_order_detail` ( `id_order_detail` int(10) unsigned NOT NULL auto_increment, `id_order` int(10) unsigned NOT NULL, `product_id` int(10) unsigned NOT NULL, `product_attribute_id` int(10) unsigned default NULL, `product_name` varchar(255) NOT NULL, `product_quantity` int(10) unsigned NOT NULL default \'0\', `product_quantity_in_stock` int(10) NOT NULL default 0, `product_quantity_refunded` int(10) unsigned NOT NULL default \'0\', `product_quantity_return` int(10) unsigned NOT NULL default \'0\', `product_quantity_reinjected` int(10) unsigned NOT NULL default 0, `product_price` decimal(20,6) NOT NULL default \'0.000000\', `reduction_percent` DECIMAL(10, 2) NOT NULL default \'0.00\', `reduction_amount` DECIMAL(20, 6) NOT NULL default \'0.000000\', `group_reduction` DECIMAL(10, 2) NOT NULL default \'0.000000\', `product_quantity_discount` decimal(20,6) NOT NULL default \'0.000000\', `product_ean13` varchar(13) default NULL, `product_upc` varchar(12) default NULL, `product_reference` varchar(32) default NULL, `product_supplier_reference` varchar(32) default NULL, `product_weight` float NOT NULL, `tax_name` varchar(16) NOT NULL, `tax_rate` DECIMAL(10, 3) NOT NULL DEFAULT \'0.000\', `ecotax` decimal(21,6) NOT NULL default \'0.00\', `ecotax_tax_rate` DECIMAL(5,3) NOT NULL DEFAULT \'0.000\', `discount_quantity_applied` TINYINT(1) NOT NULL DEFAULT 0, `download_hash` varchar(255) default NULL, `download_nb` int(10) unsigned default \'0\', `download_deadline` datetime default \'0000-00-00 00:00:00\', PRIMARY KEY (`id_order_detail`), KEY `order_detail_order` (`id_order`), KEY `product_id` (`product_id`), KEY `product_attribute_id` (`product_attribute_id`), KEY `id_order_id_order_detail` (`id_order`, `id_order_detail`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8'

Invalid default value for \'download_deadline\'(Error: : 1067)

Any help would be appreciated. Thanks.

[Randomized]

Additional information:

 

When I tried to change the script at install/sql/db.sql I obtain a new error: Bad subdomain sql query.

 

I would be grateful if somebody gives an idea of what to try even if it is not a solution. Thanks.