bsmither Posted November 4, 2013 Share Posted November 4, 2013 In the database table CC_inventory, the 'updated' column holds a Date/Time data type. Under certain circumstances, this column holds 0000-00-00 00:00:00. (I don't know how it got that way.) Queried by products.index.inc.php near line 1216, where later $updated_time is set to the column value, then used as a looks-like boolean. Since the string contains characters other than zero/decimal, this results in a true result and the Product Inventory list displays that string. The expected display is a phrase that says: Unknown. Suggest: ... = ($updated_time !== "0000-00-00 00:00:00") ? ... (Just mentioning it here until there is a publicly accessible bug tracker put online.) Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted November 4, 2013 Share Posted November 4, 2013 Thanks Brian. This issue has been added to GitHub. Please send a sales ticket if you come across a bug. We have no plansto have a public bug tracker any time soon. Quote Link to comment Share on other sites More sharing options...
Robsta Posted November 5, 2013 Share Posted November 5, 2013 This issue may have occurred from an upgrade from v3 or v4. The field didn't exist prior to v5 so it's default value is zero. This may be a different bug to what is being reported here, but it's an issue I have come across before. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.