Moneris 2006 - mysql server has gone away error - FIX

[greasemonkey]

For any Canadian retails out there processing with Moneris Eselect Plus - if you have been receiving timeout errors like below lately - caused by your server timing out prior to a reply from Moneris;

 

2006 - mysql server has gone away insert into orders (moneris_order_id, gateway_url, osc_order_id, osc_session, ref_num, f4l4, iso_code, resp_code, auth_code, trans_date, trans_time, trans_type, message, card_type, txn_num, avs_code, cvd_code, crypt_type, veres, pares )

values ('OSC_ORDER-0000000000************', 'www3.moneris.com', '', '7b8ca0501e508480994ffebebccbcd47', 'null', '4242***4242', 'null', 'null', 'null', 'null', 'null', 'null', 'null', 'null', 'null', '', '', '7', '', '')

 

Open /includes/modules/payment/moneriscampg.php

 

At or around line 261;

 

Change FROM

$this->host=(MODULE_PAYMENT_MONERISCAMPG_ENV == "Production Server" ? "www3.moneris.com" : "esqa.moneris.com");[/size][/font][/color]
[color=#222222][font="helvetica neue","serif"][size=2]

 

TO;

 

$this->host=(MODULE_PAYMENT_MONERISCAMPG_ENV == "Production Server" ? "www3dr.moneris.com" : "esqa.moneris.com");[/size][/font][/color]
[color=#222222][font="helvetica neue","serif"][size=2]

 

This server change (From www3 to www3dr) as a temporary fix... I presume it will change back at some point.