Transfirst Epay Mod problem

[Scarlet]

When I install this in the admin, I get the following error:

1064 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 ''`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT', '`customer_id`
in:
[CREATE TABLE zen_transfirst_epay ('`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT', '`customer_id` INT(11) DEFAULT \'0\' NOT NULL', '`order_id` INT(11) DEFAULT \'0\' NOT NULL', '`trans_code` INT(2) DEFAULT \'0\' NOT NULL', '`seq_num` INT(8) DEFAULT \'0\' NOT NULL', '`trans_status` VARCHAR(2) NOT NULL', '`ref_num` VARCHAR(14) NOT NULL', '`auth_resp_code` VARCHAR(6) NOT NULL', '`auth_source_code` INT(1) DEFAULT \'0\' NOT NULL', '`auth_char_ind` INT(1) DEFAULT \'0\' NOT NULL', '`trans_id` VARCHAR(15) NOT NULL', '`valid_code` VARCHAR(4) NOT NULL', '`avs_resp_code` VARCHAR(1) NOT NULL', '`sent` LONGTEXT NOT NULL', '`received` LONGTEXT NOT NULL', '`time` VARCHAR(50) NOT NULL', '`session_id` VARCHAR(255) NOT NULL', 'UNIQUE (`id`)') TYPE = myisam]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[jerbroo]

Same problem here...

I resorted to creating the table manually:

CREATE TABLE zen_transfirst_epay (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT
, customer_id INT(11) DEFAULT 0 NOT NULL
, order_id INT(11) DEFAULT 0 NOT NULL
, trans_code INT(2) DEFAULT 0 NOT NULL
, seq_num INT(8) DEFAULT 0 NOT NULL
, trans_status VARCHAR(2) NOT NULL
, ref_num VARCHAR(14) NOT NULL
, auth_resp_code VARCHAR(6) NOT NULL
, auth_source_code INT(1) DEFAULT 0 NOT NULL
, auth_char_ind INT(1) DEFAULT 0 NOT NULL
, trans_id VARCHAR(15) NOT NULL
, valid_code VARCHAR(4) NOT NULL
, avs_resp_code VARCHAR(1) NOT NULL
, sent LONGTEXT NOT NULL
, received LONGTEXT NOT NULL
, time VARCHAR(50) NOT NULL
, session_id VARCHAR(255) NOT NULL
, UNIQUE (id)) TYPE = myisam;

[jerbroo]

After installing this module and looking at the code I would not use it. In fact, I'd recommend against it. The credit card data is stored in the session and then published in the page source on the order confirmation screen. The CC isn't processed until then.

TransFirst has their own in-house developed module for ZC but you'll have to contact them to get it.


HTH,
Jeremy