Urgent Help needed with Secure Hosting Payment module

[snellc]

Hi

Im using Zencart 1.3.8 and have just installed and configured the SecureHosting V3 module, and upon confirmation of an order i am getting the following error message.

The website url is w w w . o m n i j e t . u k . c o m

I have seen other posts that relate to this erro, but i have no other payment modules installed or cinfigured, yet for some reason it seems to be trying to do something with paypal!

This is the error:
1054 Unknown column 'zen_order_id' in 'field list'
in:
[INSERT INTO omni_paypal (zen_order_id,txn_id,payment_date,payer_id,reason_code) VALUES ('7','28884635','2009-05-06 17:00:08','','Success')]

This is really frustrating and having talked to support at SecureHosting the have no idea either.
I do have one other Zencart store running which is using paypal, however from the error msg i see that it is trying at least to use the table prefix that i have set. What i dont understand is why its trying to do an sql insert statement into a table called omni_paypal at all.

Please help.

Many Thanks

Chris

[longstockings]

In securehosting.php find where zen_order_id and change to where order_id

It is a conflict with an old column name