Hi all

When I checked the Products Expected in Admin I found around 2,700 books being listed when in fact there are only 5.

I've made the changes in the FAQ to change the display of US date format to UK date format in both the catalog english.php and the admin english.php and I have reset the products_date_available column to NULL for all records:

I then trialled adding a new record with no date expected date. In the MySQl database the products_date_available displays as:

0000:00:00 00:00:00

which from what I have read means that whatever date is being handled does not conform to the correct date format for the database and therefore is not set to NULL. The new record shows as a product in the Products Expected list even though it's not.

After I enter a record with an expected date (using the calendar selection - eg. 23 Mar 2016) when I edit the record that date shows in the Admin edit field as 2016-23-03 - so still in US format,

I am struggling to find where the column is populated with the zeroes instead of a NULL value.

Can anyone point me to where I should be looking please?

From the count in the database the first 8,000-odd records had a NULL value (v1.5.0) with the remainder being zeros (from v1.5.3 onwards).


Thanks