Please Help SQL error ... Repair in process after Hack! NO

[dctarbuck]

Hi Guys i am using 1.3.8a after upgrading from 1.3.7 after being hacked.. I am now having a few issues though.. Most of which i have sorted.

The main one is that when i look at the orders page in admin. I cannot update the order status? and i get an error message at the top of the page that says...

1054 Unknown column 'zen_order_id' in 'where clause'
[select * from zen_paypal where zen_order_id = '624' LIMIT 1]

Any help to sort this out would be gratefully recieved!

KR

Dan

[dctarbuck]

To add insult to injury we are not using paypal as our processing service??? I really dont know whats going on!

[dctarbuck]

I can make it pull of a result when i change the code to..

select * from zen_paypal where order_id = '624' LIMIT 1

should this code not read

select * from zen_orders where orders_id ='624' LIMIT 1?

That was it would be from the orders list not the paypal one? if so how do i change it? Or even better just fix it!

[Ajeh]

This sounds like your database is not upgraded ... the field:
zen_order_id

is renamed in the Upgrade of the database ...

[dctarbuck]

You think it will be best to run through the database upgrade part of the ruitine again?

[dctarbuck]

Or is someone able to help me with the needed sql to change the column?

Everything alse seems fine :-/