I received the following error after enabling pretty much all e-commerce modules on a fresh installation of Drupal 5.3. I am using MySQL 4.1.22.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT '+', operand DECIMAL(10,2) NOT NULL, created I' at line 3 query: CREATE TABLE ec_coupon ( coupon VARCHAR(20) PRIMARY KEY, operator VARCHAR(1) CHECK (operator IN ('+', '-', '%')) DEFAULT '+', operand DECIMAL(10,2) NOT NULL, created INTEGER NOT NULL, created_txnid INTEGER DEFAULT NULL, created_vid INTEGER DEFAULT NULL ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\htdocs\drupal\includes\database.mysql.inc on line 172.

user warning: Table 'drupal.ec_coupon' doesn't exist query: CREATE INDEX ec_coupon_created_txnid ON ec_coupon (created_txnid, created_vid) in C:\htdocs\drupal\includes\database.mysql.inc on line 172.

Cheers

Comments

kshahan’s picture

I've got the same issue., coupons don't seem to be creating tables. did you find a fix?