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 :-/

[Ajeh]

Backup your database ...

Then run the Upgrade Database again ...

You should see checkbox(es) for each upgrade that needs to be done ...

It is best to do these one at a time so if you have more than one checked, leave the first one checked alone and uncheck any below it and Upgrade ... then repeat until all are displayed unchecked ...

[dctarbuck]

but i see loads of check boxes... all unchecked but lots of them.......... Dont know what to do?

[Ajeh]

What PayPal Payment method are you using?

[dctarbuck]

Thats part of the problem i am not using paypal at all?! Only using a service called SecureHosting....? If that helps?!