Authorizenet error On Order Done Page..

[hotrod]

On my Upgraded test site to J4.. I just placed a test order  and it went through fine..  but this error showed at the top of the page?

Error

vmError: vmTable store updateObject Data too long for column 'authorizenet_response_account_number' at row 1 UPDATE `wwdai_virtuemart_payment_plg_authorizenet` SET `virtuemart_order_id`='11021',`order_number`='0',`virtuemart_paymentmethod_id`='0',`payment_name`='0',`payment_order_total`='0',`payment_currency`='0',`return_context`='0',`cost_per_transaction`='0',`cost_percent_total`='0',`tax_id`='0',`authorizenet_response_authorization_code`='151795',`authorizenet_response_transaction_id`='64562974037',`authorizenet_response_response_code`='1',`authorizenet_response_response_subcode`='1',`authorizenet_response_response_reason_code`='1',`authorizenet_response_response_reason_text`='This transaction has been approved.',`authorizenet_response_transaction_type`='auth_capture',`authorizenet_response_account_number`='XXXX7424',`authorizenet_response_card_type`='Visa',`authorizenet_response_card_code_response`='M',`authorizenet_response_cavv_response`='',`authorizeresponse_raw`='1|1|1|This transaction has been approved.|151795|Y|64562974037|FQG208697||55.39|CC|auth_capture||Rod|Houck||42 Mae Dr|Yardville|New Jersey|08620|United States of America (the)|6099549108||rod@njswf.com|Rod|Houck||42 Mae Dr|Yardville|New Jersey|08620|United States of America (the)|||||||M||||||||||||XXXX7424|Visa|||||||463237476252161KN27W 01||||||||||3.1|,|TRUE|FALSE|||',`modified_on`='2023-08-25 13:13:44',`modified_by`='945' WHERE `id` = '10948'

Thought maybe it had something to do with my account on the new site...   When I checked out as Guest..   i only got this error..

Error

vmTable store updateObject


But everything goes through fine.

[GJC Web Design]

increase the size of the field 'authorizenet_response_account_number' in the table wwdai_virtuemart_payment_plg_authorizenet via your cPanel phpmyadmin

[hotrod]

That's like Chinese to me : )  I got to here..  can you help me a tad more. : 0  I see  XXXX


What should I change the 4 to?

[hotrod]

I took a shot and chaged to 8..  and that worked!!  thank you!!.. can you tell me why this would have changed from my active shop?

[GJC Web Design]

yes .. 8  - authorizenet_response_account_number`='XXXX7424

the Xs look like padding though?

[hotrod]

Yeah, I don’t know what the exes represented but I got into where you can see. I took a screenshot changed it to eighth because of that account number and it works. I’m just wondering why it changed on the new site I’m developing.  And again, thank you I would’ve never figured that one out.

[Milbo]

Changed in plugin for next update.

Code: [Select]

'authorizenet_response_account_number' => 'char(8)',