1054 Unknown column 'order_id' in 'where clause' using nochex payment module

25 Mar 2008, 9:54 PM

Zen Follower

Join Date:: Jun 2007
Posts:: 198
Plugin Contributions:: 0

1054 Unknown column 'order_id' in 'where clause' using nochex payment module

I'm having a problem with the Nochex apc module -

1054 Unknown column 'order_id' in 'where clause'
in:
[select * from nochex_apc_transactions where order_id = '47' order by nochex_apc_id DESC LIMIT 1]

This is a new installation of 1.3.8a. I have overwritten the database from my older 1.3.7 version, and then applied the 1.3.8 database upgrade patch.

26 Mar 2008, 4:40 AM

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: 1054 Unknown column 'order_id' in 'where clause' using nochex payment module

Try running this via the SQL patch tool in the admin:

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

26 Mar 2008, 7:39 AM

pglad

Zen Follower

Join Date:: Jun 2007
Posts:: 198
Plugin Contributions:: 0

Re: 1054 Unknown column 'order_id' in 'where clause' using nochex payment module

Thanks DrByte that did the trick!

Patrick