Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 7 of 7

Thread: featuredproducts.xml.config displaying unpublished products

  1. 06-03-2010, 12:59 PM #1
    ceriwholesale is offline Member
    Join Date
    Jan 2009
    Posts
    32

    Default featuredproducts.xml.config displaying unpublished products

    hi, i am using featuredproducts.xml.config to display the featured products on my homepage. It is basically linked to the new arrivals category ID. What's strange is that on the featuredproducts.xml.config it will display unpublished products from that category. I have checked the admin and the product is indeed unpublished. I went in to the new arrivals category page and it won't display products that are unpublished. This behavior only happens on featuredproducts.xml.config. Any idea will be appreciated. thanks.

    best regards,
    edwin
  2. 06-04-2010, 06:50 AM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    This is just a simple fix. If you have access to sql server management studio, open the aspdnsf_GetFeaturedProducts stored proc, and add "published = 1" in the whereclause. Execute the sproc against your DB to take effect.

    e.g.
    Code:
    where pc.CategoryID=@FeaturedCategoryID and p.Deleted=0 and published = 1
order by newid()
    *Make a full backup of your DB first, just in case.
  3. 06-12-2011, 12:34 PM #3
    mikemurphy is offline Senior Member
    Join Date
    Mar 2006
    Location
    United Kingdom
    Posts
    207

    Default

    When i execute this i get an error

    Msg 209, Level 16, State 1, Procedure aspdnsf_GetFeaturedProducts, Line 50
    Ambiguous column name 'published'.
    8.0.1.4 W2008R2 64-bit MSSQL2005
  4. 06-13-2011, 12:58 AM #4
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    Should probably be p.published=1
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!
  5. 06-13-2011, 04:58 AM #5
    mikemurphy is offline Senior Member
    Join Date
    Mar 2006
    Location
    United Kingdom
    Posts
    207

    Default

    perfect...thank you !
    8.0.1.4 W2008R2 64-bit MSSQL2005
  6. 09-19-2011, 01:13 PM #6
    slicklocrian is offline Member
    Join Date
    Jan 2009
    Posts
    46

    Default Where do you find featuredproducts.xml.config???

    Where do you find featuredproducts.xml.config??? I've been searching for it since I need to change it to "gridwithprices". It's driving me crazy.
  7. 09-24-2011, 07:53 AM #7
    fsantos is offline Senior Member
    Join Date
    Feb 2007
    Posts
    244

    Default

    slicklocrian,

    What do you mean "where do you find featuredproducts.xml.config"? The file is in the xmlpackages folder and should be easy to locate.

    However, if you're looking for where it is called from, you will find it at page.default.xml.config.

    I hope this helps!

    fsantos