Error On Order Status Change

[omine]

PrestaShop displays this error when try to change the order status:

You can't specify target table 'ps_order_invoice' for update in FROM clause

UPDATE `ps_order_invoice` SET number =(SELECT new_number FROM (SELECT (MAX(`number`) + 1) AS new_number
            FROM `ps_order_invoice`) AS result) WHERE `id_order_invoice` = 1

PS 1.6.1.3

MySQL 5.7

 

I think is the same problem described on this topic: https://www.prestashop.com/forums/topic/493398-mysql-57-causes-error-when-ps-try-to-insert-date-as-0000-00-00-000000/

[omine]

Besides of this error, the order status was changed correctly.

 

So, i noticed my configuration was running on debug mode.

 

I changed back to define('_PS_MODE_DEV_', false); and the error do not displays.

Edited December 25, 2015 by omine (see edit history)

[joseantgv]

Check this commit:

 

https://github.com/PrestaShop/PrestaShop/commit/34ad2f5f45e8b02ce7c3174d94644d6114399746