Change the shipping status from PROCESSING to DELIVERED

[kannasai]

Hi,

I was tend to change the shipping status from PROCESSING to DELIVERED in this page,
mywebsite/admin/orders.php
but when i click on "EDIT" i found unknow error in the page as below

1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from paypal where zen_order_id = '4' order by paypal_ipn_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.

How do i solve the problem please advise? Do you know which file had problem that need to fix?

[colemanpa]

I am not sure I know what you are taking about, but if you edited your orders.php then you need to put it back the way it was, or replace the file with one that is not edited, to change what you what there is a place in the admin console to do that!

admin-localization-order status

pete

[kannasai]

i already replace by new ORDER.php and ORDER_STATUS.php
file but the problem remaining same.

any others related file you know which i could try to replace?

[colemanpa]

Is this a new site that you are just setting up, or a live site?

[kannasai]

Problem solved while i replace the v1.38 paypal.php to include/module/payment/paypal.php

Thanks

[colemanpa]

Good to hear, there is also a place to change status in PayPal IPN config under admin-modules-payment-paypal IPN.

pete