Trying to perform a clean install of the latest version as of 1/2/2008 produces the following errors:

    * 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 'NULL, ecid INTEGER CHECK (ecid >= 0) NOT NULL, type ' at line 3 query: CREATE TABLE ec_transaction ( txnid INT AUTO_INCREMENT PRIMARY KEY, uid INTEGER CHECK (uid >= 0) NOT NULL, ecid INTEGER CHECK (ecid >= 0) NOT NULL, type VARCHAR(16) NOT NULL, mail VARCHAR(64) NOT NULL, shipping_cost DECIMAL(10,2) NOT NULL, payment_method VARCHAR(32) NOT NULL, payment_status VARCHAR(32) NOT NULL, payment_date INTEGER NOT NULL, allocation INTEGER CHECK (allocation >= 0) NOT NULL, workflow INTEGER CHECK (workflow >= 0) NOT NULL, currency VARCHAR(3) NOT NULL, gross DECIMAL(10,2) NOT NULL, created INTEGER NOT NULL, changed INTEGER NOT NULL, duedate INTEGER NOT NULL, token VARCHAR(42) NOT NULL ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\Apache2\htdocs\drupal\includes\database.mysqli.inc on line 151.
    * user warning: Table 'oregonaero_com.ec_transaction' doesn't exist query: CREATE INDEX ec_transaction_uid ON ec_transaction (uid) in C:\Apache2\htdocs\drupal\includes\database.mysqli.inc on line 151.
    * user warning: Table 'oregonaero_com.ec_transaction' doesn't exist query: CREATE INDEX ec_transaction_ecid ON ec_transaction (ecid) in C:\Apache2\htdocs\drupal\includes\database.mysqli.inc on line 151.
    * 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 'NULL, type VARCHAR(16) NOT NULL, fullname' at line 2 query: CREATE TABLE ec_transaction_address ( txnid INTEGER CHECK (txnid >= 0) NOT NULL, type VARCHAR(16) NOT NULL, fullname VARCHAR(32) NOT NULL, firstname VARCHAR(32) NOT NULL, lastname VARCHAR(32) NOT NULL, street1 VARCHAR(64) NOT NULL, street2 VARCHAR(64) NOT NULL, zip VARCHAR(10) NOT NULL, city VARCHAR(32) NOT NULL, state VARCHAR(32) NOT NULL, country VARCHAR(2) NOT NULL, PRIMARY KEY (txnid, type) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\Apache2\htdocs\drupal\includes\database.mysqli.inc on line 151.
    * 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 'NULL, nid INTEGER CHECK (nid >= 0) NOT NULL, vid ' at line 2 query: CREATE TABLE ec_transaction_product ( txnid INTEGER CHECK (txnid >= 0) NOT NULL, nid INTEGER CHECK (nid >= 0) NOT NULL, vid INTEGER CHECK (vid >= 0) NOT NULL, title VARCHAR(128) DEFAULT NULL, price DECIMAL(10,2) NOT NULL, qty INTEGER CHECK (qty >= 0) NOT NULL, data text, UNIQUE (txnid,nid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\Apache2\htdocs\drupal\includes\database.mysqli.inc on line 151.
    * user warning: Table 'oregonaero_com.ec_transaction_product' doesn't exist query: CREATE INDEX ec_transaction_product_txnid_2 ON ec_transaction_product (txnid) in C:\Apache2\htdocs\drupal\includes\database.mysqli.inc on line 151.
    * 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 'NULL, weight INTEGER NOT NULL, PRIMARY ' at line 8 query: CREATE TABLE ec_transaction_misc ( txnid INTEGER NOT NULL, type VARCHAR(10) NOT NULL, vid INTEGER NOT NULL, description VARCHAR (255) NOT NULL, invisible INTEGER NOT NULL, price DECIMAL(10,2) NOT NULL, qty INTEGER CHECK (qty >= 0) NOT NULL, weight INTEGER NOT NULL, PRIMARY KEY (txnid,type,vid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\Apache2\htdocs\drupal\includes\database.mysqli.inc on line 151.
CommentFileSizeAuthor
#1 store.install29.8 KBjantoine

Comments

jantoine’s picture

Assigned: Unassigned » jantoine
Status: Active » Needs review
StatusFileSize
new29.8 KB

Hey e-commerce team,

I found that many of the queries in the store_install function had the CHECK keyword added in an incorrect place. I have made all necessary fixes to this function, but I am uncertain if any update queries need to be fixed as well. Please see the attached store.install file for fixes.

Thanks,

brmassa’s picture

Status: Needs review » Fixed

Guys,

despite the fact that these codes are SQL ANSI, MySQL complains. ok so, fixed!

regards,

massa

Designer Dude’s picture

Version: 5.x-4.x-dev » 5.x-4.0-alpha9

I got the same SQL errors when installing store (using the latest alpha). the patch posted by AntioneSolutions did the trick.

Designerdude

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.