Issue processing payments on stripe after upgrade to 7.7.1

[sbd]

Spoiler

Hi

After updating to 7.7.1 we are unable to process cards via stripe.  Any help would be gratefully accepted.

Sam

Something went wrong and we couldn't process your request.

Please go back to the previous page and try again.

If the problem persists, please contact us.

« Back to Homepage

For additional assistance, please reference the WHMCS TroubleShooting Guide »

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'currency_id' cannot be null in /var/www/html/toolbox/vendor/illuminate/database/Connection.php:441
Stack trace:
#0 /var/www/html/toolbox/vendor/illuminate/database/Connection.php(441): PDOStatement->execute(Array)
#1 /var/www/html/toolbox/vendor/illuminate/database/Connection.php(706): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'insert into `tb...', Array)
#2 /var/www/html/toolbox/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('insert into `tb...', Array, Object(Closure))
#3 /var/www/html/toolbox/vendor/illuminate/database/Connection.php(442): Illuminate\Database\Connection->run('insert into `tb...', Array, Object(Closure))
#4 /var/www/html/toolbox/vendor/illuminate/database/Connection.php(398): Illuminate\Database\Connection->statement('insert into `tb...', Array)
#5 /var/www/html/toolbox/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `tb...', Array)
#6 /var/www/html/toolbox/vendor/illuminate/database/Query/Builder.php(2055): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `tb...', Array, 'id')
#7 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 /var/www/html/toolbox/vendor/illuminate/database/Eloquent/Builder.php(1370): call_user_func_array(Array, Array)
#9 /var/www/html/toolbox/vendor/illuminate/database/Eloquent/Model.php(1617): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#10 /var/www/html/toolbox/vendor/illuminate/database/Eloquent/Model.php(1586): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#11 /var/www/html/toolbox/vendor/illuminate/database/Eloquent/Model.php(1477): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array)
#12 /var/www/html/toolbox/includes/ccfunctions.php(0): Illuminate\Database\Eloquent\Model->save()
#13 /var/www/html/toolbox/myadmin/invoices.php(0): captureCCPayment(2780)
#14 {main}
Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'currency_id' cannot be null (SQL: insert into `tbltransaction_history` (`invoice_id`, `transaction_id`, `gateway`, `description`, `amount`, `currency_id`, `remote_status`, `updated_at`, `created_at`) values (2780, N/A, Credit Card (Visa-Master), Automatic Payment Attempt, 13.47, , Error, 2019-04-02 17:01:26, 2019-04-02 17:01:26)) in /var/www/html/toolbox/vendor/illuminate/database/Connection.php:713
Stack trace:
#0 /var/www/html/toolbox/vendor/illuminate/database/Connection.php(669): Illuminate\Database\Connection->runQueryCallback('insert into `tb...', Array, Object(Closure))
#1 /var/www/html/toolbox/vendor/illuminate/database/Connection.php(442): Illuminate\Database\Connection->run('insert into `tb...', Array, Object(Closure))
#2 /var/www/html/toolbox/vendor/illuminate/database/Connection.php(398): Illuminate\Database\Connection->statement('insert into `tb...', Array)
#3 /var/www/html/toolbox/vendor/illuminate/database/Query/Processors/Processor.php(32): Illuminate\Database\Connection->insert('insert into `tb...', Array)
#4 /var/www/html/toolbox/vendor/illuminate/database/Query/Builder.php(2055): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `tb...', Array, 'id')
#5 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 /var/www/html/toolbox/vendor/illuminate/database/Eloquent/Builder.php(1370): call_user_func_array(Array, Array)
#7 /var/www/html/toolbox/vendor/illuminate/database/Eloquent/Model.php(1617): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#8 /var/www/html/toolbox/vendor/illuminate/database/Eloquent/Model.php(1586): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#9 /var/www/html/toolbox/vendor/illuminate/database/Eloquent/Model.php(1477): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 /var/www/html/toolbox/includes/ccfunctions.php(0): Illuminate\Database\Eloquent\Model->save()
#11 /var/www/html/toolbox/myadmin/invoices.php(0): captureCCPayment(2780)
#12 {main}

[steven99]

Under the client's profile, do you have a currency set?  If not, try setting one and see if that resolves the issue . 

[sbd]

Hi steve 

It was done but i went looking and found it not set in the stripe payment gateway where previously it had been  i think from memory.  Thanks for the siggedtion it is noe wirking again. 

 

Sam