B benFF Dec 5, 2021 #1 Every Sunday without fail, all the classifed items change their status to "expired" and are removed from view! In the package, the length is set as "Permanent" and viewing the database records directly "expiration_date" is set as 0. Yet still it keeps happening
Every Sunday without fail, all the classifed items change their status to "expired" and are removed from view! In the package, the length is set as "Permanent" and viewing the database records directly "expiration_date" is set as 0. Yet still it keeps happening
B benFF Jan 23, 2022 #2 This is due to the function expireListingsPastExpiration. In its selection query: Code: $listings = $this->finder('Z61\Classifieds:Listing') ->with('Category') ->where('expiration_date', '<', $cutOff) ->where('listing_open', 1)->fetch(); There also needs to be a "where expiration_date > 0".
This is due to the function expireListingsPastExpiration. In its selection query: Code: $listings = $this->finder('Z61\Classifieds:Listing') ->with('Category') ->where('expiration_date', '<', $cutOff) ->where('listing_open', 1)->fetch(); There also needs to be a "where expiration_date > 0".
