I've tried to install this module on a virgin Commerce Kickstart (Drupal 7.14) and received the following error:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'pf_transaction_id' doesn't exist in table: CREATE TABLE {commerce_payfast_itn} ( `itn_id` INT unsigned NOT NULL auto_increment COMMENT 'Serial numeric ID of the ITN in the local database.', `pf_payment_id` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The PayFast payment ID.', `merchant_id` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The merchant_id of the payment receiever.', `email_address` VARCHAR(255) DEFAULT '' COMMENT 'The e-mail of the payer.', `order_id` INT unsigned NOT NULL DEFAULT 0 COMMENT 'The order ID the payment belongs to.', `transaction_id` INT unsigned NOT NULL DEFAULT 0 COMMENT 'The payment transaction ID the payment belongs to.', `amount_gross` DECIMAL(10, 2) NOT NULL DEFAULT 0 COMMENT 'The gross payment amount.', `amount_fee` DECIMAL(10, 2) NOT NULL DEFAULT 0 COMMENT 'The amount of fees collected by PayFast for this payment.', `payment_status` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The status of the payment at PayFast.', `server` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The server used to process the payment.', `created` INT NOT NULL DEFAULT 0 COMMENT 'The Unix timestamp when the ITN was received.', `changed` INT NOT NULL DEFAULT 0 COMMENT 'The Unix timestamp when the ITN was last updated.', PRIMARY KEY (`itn_id`), INDEX `pf_transaction_id` (`pf_transaction_id`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'Stores processed ITNs.'; Array ( ) in db_create_table() (line 2685 of /var/www/commerce_kickstart/includes/database/database.inc).

An index (pf_transaction_id) is beign set for a non-existing column. Is pf_transactoin_id mistyped (should be pf_payment_id?)
or is there a missing column in the DDL?

I'd really like to take this module for a spin since there's not many options here in South Africa and the only payment modules available (given limited gateway options) is for Drupal 6.x.

Thanks for checking it out.

Comments

hadsie’s picture

Status: Active » Fixed

Thanks @ninjav! This should be fixed now. See http://drupalcode.org/project/commerce_payfast.git/commit/60fa191 for details.

Status: Fixed » Closed (fixed)

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