drofe

I am also looking for a way to search manufacturers in admin in my 2.3.1 shop.

Thank you Bryce. It worked like magic.

I've done some more research on this problem but I still don't know how to fix it.

In admin/orders.php, the orders list appears to be generated by this code around line 390:

	 if (tep_not_null($oInfo->last_modified)) $contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED . ' ' . tep_date_short($oInfo->last_modified));

I don't know enough sql to know what this is doing in detail, but I think it is excluding orders with null date_modified values from the list. This would explain why new orders are not appearing in the list because, when an order is created, the last_modified date is being left null (the default). I haven't been able to find the code that creates the orders . I'm also not sure if fixing this will fix the problem, because I tried commenting out the if clause and it made no difference. Then I tried manually adding the last_modified date through myphp and this didn't work either.

I can still process the orders through admin by entering the order number direct. By doing this I've found that the last_modified in the order is being updated when a new order_status_history is added. If null values are being excluded by the code, you would expect this to cause the orders to staty showing up in the list when orders are processed but they don't.

All the old, migrated, orders are there in the list. I've checked and rechecked, but can see nothing different between the old orders and the new ones. I've also looked at the table structures in my old shop, new shop and an empty 2.3.1 database and they seem to be identical.

I can get by without the orders showing in the list but they also don't show in the customer's order history, which is a bit more of a problem.

/catalog/ is the main shop directory when you download oscommerce 2.3.1. You may have renamed it but it will be the same as what you put in define('DIR_WS_CATALOG', '/catalog/');

I wish it would but it just points to this thread.