Order status update Error on pre upgrade orders

[e5m1r]

I am now on 1.6.14 i have imported orders from oscommerce and i can not change order status on those orders

new orders received in 1.6.14 work just fine

when googling around i found some other users having issues with orders created before update to 1.6.14 so i do not think the problem has to do with my oscommerce import

 

i get following error message

 

 

[PrestaShopException]

Property Order->module is not valid
at line 872 in file classes/ObjectModel.php

867.
868.             $message = $this->validateField($field, $this->$field);
869.             if ($message !== true)
870.             {
871.                 if ($die)
872.                     throw new PrestaShopException($message);
873.                 return $error_return ? $message : false;
874.             }
875.         }
876.
877.         return true;

• ObjectModelCore->validateFields - [line 278 - classes/ObjectModel.php]
• ObjectModelCore->getFields - [line 299 - classes/order/Order.php]
• OrderCore->getFields - [line 631 - classes/ObjectModel.php]
• ObjectModelCore->update - [line 289 - classes/order/OrderHistory.php]
• OrderHistoryCore->changeIdOrderState - [line 520 - controllers/admin/AdminOrdersController.php] - [3 Arguments]
• AdminOrdersControllerCore->postProcess - [line 171 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

 

Any and all help is appreciated

tnx

 

[e5m1r]

Solwed

the issue is in the database and payment module name

i had spaces in the name and that is not allowed so that is the reason for error

so if anyone else has same issue edit payment_module field from ps_orders tables to valid values (no spaces, no special characters, no numbers) after this you can change order status again

[d147]

Thanks! This helped a lot!

 

Also want to add that you must use all lowercase letters for it to work. In P.S. 1.6.14 it's the field under Table "ps_orders" column "module".

[-iD-]

Great ! Thanks ! Helped me a lot !