I have a really strange problem with SQL Server 2008. We have an e-commerce cart ASPDOTNETSTOREFRONT and we set the product category to UNPUBLISHED(via the carts admin section), and in the database record is set as 0 which is correct.
We refresh the page and the category is gone from the webpage.
All day yesterday the category wasnt showing and then today the category is now showing in the page and in the admin section and database its set to un-published. It makes no logical sense whats so ever!
The server has a C:\ is 25GB and only has 100MB free space! and the OS is loaded onto it with SQL Server but the websites are hosted on the D:\ which has 500GB of free space.
What can i do to investigate this further? (Please migrate this if its in the wrong stack website but i think programmers would maybe experiance something similar so might have a solution)
The problem was because the XML package entity.grid.xml.config didnt contain the following:
<xsl:choose>
<xsl:when test="Published=1">
<xsl:call-template name="SubCatCell">
<xsl:with-param name="scName" select="$scName" />
</xsl:call-template>
</xsl:when>
The sub category is now checking if its published, if it IS, then show it.