Nochex - 1054 Unknown column 'zen_order_id' Error

[hutton89]

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

[DrByte]

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?

[hutton89]

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

[DrByte]

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.p...Obscure_Issues

[hutton89]

drByte...

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

Thanks again