Hi David,
Hope all is well. Wondered if you might be able to help me resolve a problem with the alerts for missing featured products (detailed in node 5082). In summary, I implemented featured category sections as detailed in node 3243 some time ago. When I receive the (missing featured products) e-mails I just receive a list of the featured categories. Each category is listed the number a number of times which equals the number of featured products the featured category section holds (none of which are actually missing). There is no mention of the missing product in the e-mail. I'm guessing it's the addition of the categories which is causing the issue with the sql statement in the code? I wondered if you might already have a fix for this?
Thanks in advance.
Regards
Chris
Great, thanks David, I will give that a go.
Best regards
Chris
Hello Chris,
There was an error in the featuredcheck.php script that would not use the correct name where section/ prefixes are in place - it was this code beginning at line 9:
$parts = explode("/",$product["name"]);$name = $parts[0];
...should be:
$parts = explode("/",$product["name"]);$name = (isset($parts[1])?$parts[1]:$parts[0]);
Corrected in the original post.
Cheers,
David.
--
PriceTapestry.com