There was an order placed in Hikashop (mails sent, paybox payment received), but we can no longer find it in the back-end.
Its order_id is missing in the tables hikashop_order, hikashop_order_product and hikashop_history.
Any other table to look at? Any logfile? My best guess is that the order was erased from back-end. If so, how to prove it?
For the next times, may playing with onAfterOrderDelete help in any way?
function onAfterOrderDelete($elements){
if(!is_array($elements)){
$elements = array($elements);
}
$database = JFactory::getDBO();
foreach($elements as $key => $val){
$elements[$key] = $database->Quote($val);
}
$query='DELETE FROM '.hikashop_table('history').' WHERE history_order_id IN ('.implode(',',$elements).')';
//add some log message here?
$database->setQuery($query);
$database->query();
return true;
}