Problem/Motivation

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens: SELECT base_table.payment_id AS payment_id, base_table.payment_id AS base_table_payment_id FROM {commerce_payment} base_table INNER JOIN {commerce_payment} commerce_payment ON commerce_payment.payment_id = base_table.payment_id WHERE (commerce_payment.state = :db_condition_placeholder_0) AND (commerce_payment.remote_id = :db_condition_placeholder_1:db_condition_placeholder_2:db_condition_placeholder_3:db_condition_placeholder_4:db_condition_placeholder_5:db_condition_placeholder_6:db_condition_placeholder_7); Array ( [:db_condition_placeholder_0] => pending [:db_condition_placeholder_1] => xxx [:db_condition_placeholder_2] => xxx [:db_condition_placeholder_3] => xxx [:db_condition_placeholder_4] => xxx [:db_condition_placeholder_5] => xxx [:db_condition_placeholder_6] => xxx [:db_condition_placeholder_7] => xxx ) in Drupal\commerce_authnet\Plugin\Commerce\PaymentGateway\Echeck->getSettledTransactions() (line 238 of /var/www/html/docroot/modules/contrib/commerce_authnet/src/Plugin/Commerce/PaymentGateway/Echeck.php).

Steps to reproduce

Execute Cron after making payments via E-check

Proposed resolution

Provide a patch.

CommentFileSizeAuthor
#8 commerce_authnet-echeck-error-3178739-8.patch714 bytesnathaniel
#7 commerce_authnet-echeck-error-3178739-7.patch714 bytesleewbutler
#4 commerce_authnet-echeck-error-3178739-4.patch714 bytesleewbutler
#2 commerce_authnet-echeck-error-3178739-2.patch714 bytesjohn.oltman

Issue fork commerce_authnet-3178739

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

john.oltman created an issue. See original summary.

john.oltman’s picture

john.oltman commented
StatusFileSize
new commerce_authnet-echeck-error-3178739-2.patch714 bytes

See attached patch

john.oltman’s picture

john.oltman commented
Status: Active » Needs review
leewbutler’s picture

leewbutler commented
StatusFileSize
new commerce_authnet-echeck-error-3178739-4.patch714 bytes

Thank you John. Your patch was the fix for me when receiving the same error, I just had to update it to apply the code to line numbers that correspond with the release 8.x-1.3. Updated patch attached.

Status: Needs review » Needs work

The last submitted patch, 4: commerce_authnet-echeck-error-3178739-4.patch, failed testing. View results

philltran made their first commit to this issue’s fork.

leewbutler’s picture

leewbutler commented
StatusFileSize
new commerce_authnet-echeck-error-3178739-7.patch714 bytes

Updated patch for the 8.x-1.x branch attached.

nathaniel’s picture

nathaniel commented
Assigned: john.oltman » Unassigned
Status: Needs work » Needs review
StatusFileSize
new commerce_authnet-echeck-error-3178739-8.patch714 bytes

re-roll

  • jsacksick committed aa53fc2 on 8.x-1.x authored by john.oltman 
    Issue #3178739 by leewbutler, john.oltman, philltran, Nathaniel: ECheck...
jsacksick’s picture

jsacksick commented
Status: Needs review » Fixed

Committed.

  • jsacksick committed 09075a7 on 8.x-1.x 
    Revert "Issue #3178739 by leewbutler, john.oltman, philltran, Nathaniel...

  • jsacksick committed 76d1480 on 8.x-1.x 
    Revert "Revert "Issue #3178739 by leewbutler, john.oltman, philltran,...

Status: Fixed » Closed (fixed)

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