Nochex - 1054 Unknown column 'zen_order_id' Error

Hey all,

I'm running a new install of zen cart 1.38 with Nochex payments set up... I have a merchant nochex account, orders can be placed on the site, everything go's through smoothly, but when i try to view orders in admin i get the following error and i'm unable to update any orders:

1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from nochex_apc_transactions where zen_order_id = '2' 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.
Any help would be hugely appreciated as its driving me crazy...!

cheers

You're using an old version of the nochex module against a new version of the database structure.
Did you install any addons? such as the old nochex module?

Thanks Drbyte.

Yeah i think thats what i did...

I didn't realise there was a nochex module in 1.38 and installed the add on module from the downloads section... On realising i removed the add on module php files and replced them with the original files from a zen cart 1.38 install... I then re-intsalled the payment module through admin, but still getting the same error...

Is there anything you can suggest to get everything back to how it should be??

thanks again

If it's still giving you the same error, then I suspect you've missed putting back an original file.

Sometimes a full comparison helps: http://www.zen-cart.com/wiki/index.php/Troubleshoot_-_Diagnosing_Obscure_Issues

drByte...

That was it... I Just re-uploaded original files and works fine... You are a legend!!

Thanks again