Review Rating/Moderation

Posted By metalmania Wed 24 Jun 2015
Add to Favorites0
Author Message
metalmania
 Posted Wed 24 Jun 2015
Supreme Being

Supreme Being - (11,700 reputation)Supreme Being - (11,700 reputation)Supreme Being - (11,700 reputation)Supreme Being - (11,700 reputation)Supreme Being - (11,700 reputation)Supreme Being - (11,700 reputation)Supreme Being - (11,700 reputation)Supreme Being - (11,700 reputation)Supreme Being - (11,700 reputation)

Group: Forum Members
Last Active: Tue 21 Jun 2016
Posts: 36, Visits: 165
After migrating customers and their related data using the Datatool from Cactushop v6 - I encountered a problem when accessing the review functionality in the admin area in order to moderate ("_Reviews.aspx?strModerate=y")...this page was throwing a "Oops!" error page.

I have tracked down the problem to be related to review entries where the Rating in Cactushop was 0 (Zero) - this seems to be migrated into tblKartrisReviews.Rev_Rating as NULL.

The review page obviously doesn't like the fact there are null values in the rating column (even though it is a nullable) and you get an "Oops!" error.


The simple fix I applied was to set the rating to 1 where the rating was null.
i.e.
update [dbname].[dbo].[tblKartrisReviews]
set rev_rating = 1
where rev_rating is null
Wed 24 Jun 2015 by metalmania

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top