[1.6.1.4][Order-list] Orders not displayed

[batZpk]

Hy community !

 

I'm Baptiste, web developer in France. I have a little problem on my Orders Controller and i need your help to resolve it. 

 

Since a few days I encountered a problem in the display of commands in Prestashop. I noticed two orders that are not present in the back office > Orders. I switch from order 50000 to 50002. But, the 50001 still present in the database, the customer's view, etc.

 

Somebody encountred the same problem ?

 

Thanks

 

Baptiste

 

Version : 1.6.1.4

Host: OVH

 

 

[Scully]

This kind of problem isn't known to me. If would try to enable DEV mode and SQL Debug mode.

 

define('_PS_MODE_DEV_', true);

define('_PS_DEBUG_SQL_', true);

 

in defines.inc.php. Then copy the query which is triggered from the order list and run it against the database. The result should be 0 records. I would then strip down the query step by step with WHERE clauses and JOINS. At some point, the order mus pop up and you know which WHERE clause or JOIN does cause the not found condition.