I still think the product creation times aren't being saved into the database properly. Run the following queries on your BitShop database to make sure the necessary triggers are created:
Code: Select all
DROP TRIGGER IF EXISTS Products_OnInsert;
CREATE TRIGGER Products_OnInsert BEFORE INSERT ON `Products`
FOR EACH ROW SET NEW.Created = IFNULL(NEW.Created, UTC_TIMESTAMP());
DROP TRIGGER IF EXISTS Orders_OnInsert;
CREATE TRIGGER Orders_OnInsert BEFORE INSERT ON `Orders`
FOR EACH ROW SET NEW.Created = IFNULL(NEW.Created, UTC_TIMESTAMP());
DROP TRIGGER IF EXISTS Codes_OnInsert;
CREATE TRIGGER Codes_OnInsert BEFORE INSERT ON `Codes`
FOR EACH ROW SET NEW.Created = IFNULL(NEW.Created, UTC_TIMESTAMP());
DROP TRIGGER IF EXISTS Reviews_OnInsert;
CREATE TRIGGER Reviews_OnInsert BEFORE INSERT ON `Reviews`
FOR EACH ROW SET NEW.Created = IFNULL(NEW.Created, UTC_TIMESTAMP());
DROP TRIGGER IF EXISTS Accounts_OnInsert;
CREATE TRIGGER Accounts_OnInsert BEFORE INSERT ON `Accounts`
FOR EACH ROW SET NEW.Created = IFNULL(NEW.Created, UTC_TIMESTAMP());
If that doesn't work the reason could be that your installed version of MySQL is too old and it doesn't support triggers, although that shouldn't be the case because I believe they have been supported since MySQL 5.0.2, which is really old. Another reason could be that the time on your MySQL server was wrong and it was recording incorrect product creation times. So even if the time was fixed, some of the products you created may have dates set far in the future, preventing other products which are truly newer from showing up. If all else fails try deleting all the products you created, then make sure your MySQL server time is correct, and recreate all your products. You will know if it's working after adding just a few products because the most recent always show first.