DISCLAIMER:
As Will correctly states below: Executing SQL Statements directly to the database will nullify any support or maintenance contract. Please contact your HCC Partner! The problem above affects Hotcakes Category Viewer when using DrillDown-View.
It will stop working with a nasty error message
If you run into this problem you can fix it using this the statement below:
1)
Create a DB Backup2) Make sure DB Backup is correctly created
3) Make sure you followed step 1) and 2)
4) This is tested with HCC 3.1.0 on DNN 8.0.4
SELECT ppv.id
FROM hcc_ProductPropertyValue ppv
LEFT JOIN hcc_ProductPropertyChoice ppc
ON ppv.PropertyValue = ppc.Id
WHERE ppv.PropertyId IN
(
SELECT ID
FROM hcc_ProductProperty
WHERE TypeCode = 2
)
AND ppc.Id IS NULL
if this returns one or more rows you can execute the following statement to delete the orphan references:
DELETE FROM
hcc_ProductPropertyValue
WHERE id IN
(
SELECT ppv.id
FROM hcc_ProductPropertyValue ppv
LEFT JOIN hcc_ProductPropertyChoice ppc
ON ppv.PropertyValue = ppc.Id
WHERE ppv.PropertyId IN
(
SELECT ID
FROM hcc_ProductProperty
WHERE TypeCode = 2
)
AND ppc.Id IS NULL
)
Now DrillDown View should work again.
Hope that helps.
Reto
Edited by user
2019-02-11T06:33:39Z
|
Reason: Not specified