New Coupons Always Inactive

[DivaVocals]

This issue is occurring in BOTH my live store and the development shop. Everytime I create a new coupon the "coupon_active" column is set to NULL. I have to go into the DB and manually set the "coupon_active" column to "Y". I realize this is the default value for this column, but I expect that when I create a new coupon that this value will be set to "Y".

CREATE TABLE `zen_coupons` (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_type` char(1) DEFAULT NULL,
  `coupon_code` varchar(32) DEFAULT NULL,
  `coupon_amount` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `coupon_minimum_order` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `coupon_start_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `coupon_expire_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `uses_per_coupon` int(5) NOT NULL DEFAULT '1',
  `uses_per_user` int(5) NOT NULL DEFAULT '0',
  `restrict_to_products` varchar(255) DEFAULT NULL,
  `restrict_to_categories` varchar(255) DEFAULT NULL,
  `restrict_to_customers` text,
  `coupon_active` char(1) DEFAULT NULL,
  `date_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `coupon_zone_restriction` int(11) NOT NULL DEFAULT '0',
  `manufacturer_ids` varchar(100) DEFAULT NULL,
  `sales_eligible` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`coupon_id`),
  KEY `idx_active_type_zen` (`coupon_active`,`coupon_type`),
  KEY `idx_coupon_code_zen` (`coupon_code`),
  KEY `idx_coupon_type_zen` (`coupon_type`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8

Any ideas???

[DivaVocals]

In the meantime I've modified the coupon table so the default value is "Y" for the "coupon_active" column.. Seems to solve the issue..

ALTER TABLE `coupons` CHANGE `coupon_active` `coupon_active` CHAR(1)DEFAULT 'Y' NULL;

Would like to know what the issue was in the first place.. It truly CAN'T be THIS simple..

[stevesh]

In my stock Zencart test site (custom Classic-clone template, no mods), when I create a coupon, it is set to Active in the DB, even if I specify a start date to a date in the future, and the DB default is Y. What's different on your sites ? Upgrade from an earlier version?

[DivaVocals]

In my stock Zencart test site (custom Classic-clone template, no mods), when I create a coupon, it is set to Active in the DB, even if I specify a start date to a date in the future, and the DB default is Y. What's different on your sites ? Upgrade from an earlier version?

Honestly NONE of the mods I've made to this site alter the coupon_admin.php file or any of the coupon tables.. so to answer your question.. I've NO CLUE what's different.. I can say that I've had a variety of strange issues since the host updated this client the PHP to 5.4.. I don't think this is related to that.. **shrugs** I do know that the DB change I've made has solved the issue for now..

I DID discover that the coupon_restrict.php files had an issue which rendered a blank page (and strangely NO error logs) which I resolved by replacing it with the v1.5.2 version of the file..