Nochex: 1054 Unknown column 'order_id' in 'where clause'

[fergusmacdonald]

Hi there,

I've just upgraded to 1.3.8 and am having problems with the Nochex module. In 1.3.7.1 i had the Nochex module installed and working OK, however, after upgrade, i get the following error message when i try to view an order prior to the upgrade that was paid for via Nochex:

1054 Unknown column 'order_id' in 'where clause'
in:
[select * from nochex_apc_transactions where order_id = '90140' order by nochex_apc_id DESC LIMIT 1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I believe that the problem has to do with the difference in the Nochex module code and the integrated Nochex module in 1.3.8 and the way they create tables.

I am moving from Nochex to Paypal Website Payments Pro but will need to be able to access older orders paid for via Nochex on the new site. All of these changes have been done on a beta site.

Any help on how to solve this problem would be much appreciated.

Thanks,
Fergus

[DrByte]

Go to Admin->Tools->Install SQL Patch
and paste this into the query field, and click Send:

ALTER TABLE nochex_apc_transactions CHANGE COLUMN zen_order_id order_id int(11) NOT NULL default '0';

[fergusmacdonald]

That is absolutely FANTASTIC.

Thank you very much indeed, your help is greatly appreciated.

Fergus