php - 在 WAMP 服务器中安装 Magento 时出错

Question

处理您的请求时出错

Error in file: "C:\wamp\www\magento\app\code\core\Mage\SalesRule\sql\salesrule_setup\upgrade-1.6.0.0-1.6.0.1.php" - SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'period', 

查询是:

  CREATE TABLE `coupon_aggregated_updated` (
  `id` int UNSIGNED NOT NULL auto_increment COMMENT 'Id' ,
  `period` date NOT NULL default '' COMMENT 'Period' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `order_status` varchar(50) NULL COMMENT 'Order Status' ,
  `coupon_code` varchar(50) NULL COMMENT 'Coupon Code' ,
  `coupon_uses` int NOT NULL default '0' COMMENT 'Coupon Uses' ,
  `subtotal_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Subtotal Amount' ,
  `discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Discount Amount' ,
  `total_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Amount' ,
  `subtotal_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Subtotal Amount Actual' 

Answer 1

使用CURDATE()或“0000-00-00”。查看wiki

...

`period` date NOT NULL default CURDATE() COMMENT 'Period' ,

...