Completion of transaction failing (attempting to post to absent table?)

[ventilator]

josephharley.co.uk
recently upgraded from 1.3 something (by transferring to temp domain/space, upgrading, then transfer back)
Server OS: Linux 4.19.44
Server: ApachePHP Version: 7.2.11
Database Engine: MySQL 5.5.5-10.2.22-MariaDB-log

Hello! Using the (fairly ancient) securehosting_V3.php payment module. Payments now seem to be processing OK, but I hit a

"WARNING: An Error occurred, please refresh the page and try again."

error on (what I think is) completion.

Logs tell me:

[26-Nov-2019 16:17:55 Europe/London] Request URI: /index.php?main_page=checkout_process&transactionreference=128347351&transactiond ate=2019-11-26&transactiontime=16:17:39&cv2avsresult=ALL%20MATCH, IP address: 89.34.99.134
#1 trigger_error() called at [/var/sites/j/josephharley.co.uk/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/var/sites/j/josephharley.co.uk/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/var/sites/j/josephharley.co.uk/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/var/sites/j/josephharley.co.uk/public_html/includes/modules/payment/securehosting.php:157]
#5 securehosting->after_process() called at [/var/sites/j/josephharley.co.uk/public_html/includes/classes/payment.php:254]
#6 payment->after_process() called at [/var/sites/j/josephharley.co.uk/public_html/includes/modules/pages/checkout_process/header_php.php:17]
#7 require(/var/sites/j/josephharley.co.uk/public_html/includes/modules/pages/checkout_process/header_php.php) called at [/var/sites/j/josephharley.co.uk/public_html/index.php:36]
--> PHP Fatal error: 1054:Unknown column 'zen_order_id' in 'field list' :: INSERT INTO paypal (zen_order_id,txn_id,payment_date,payer_id,reason_code) VALUES ('184','128347351','2019-11-26 16:17:39','ALL MATCH','Success') ==> (as called by) /var/sites/j/josephharley.co.uk/public_html/includes/modules/payment/securehosting.php on line 157 <== in /var/sites/j/josephharley.co.uk/public_html/includes/classes/db/mysql/query_factory.php on line 171.

I'm no database expert, but it looks as if the php is trying to write to a column ('zen_order_id') that no longer exists in the DB. Can someone who's familiar with old and new ZC database architecture tell me if I'm right - and even better, if I can afford to strip anything out from the payment side to prevent the error?

Many thanks

Ventilator

[lat9]

As you surmised, there's no field in the paypal table named zen_order_id. You'll need to edit /var/sites/j/josephharley.co.uk/public_html/includes/modules/payment/securehosting.php, line 157, changing zen_order_id to order_id.

[ventilator]

Yep, great - got it. Thanks!