David Rodriguez Hernandez wrote:
Hi David,
I had just the same error as you describe. No errors viewing the host posts but the same error with all the other users. Your investigation is very interesting, I've the same incoherencies in view dnn_Forum_vs_ForumUsers, but modifying it does not resolve it.
In my case the solution was very simple. I had deleted the Country from the user's profile because I didn't need it -the host had that profile property. So when I added the Country again, all the problems were resolved. As a workaround, I've put invisible that field in the profile, so I've the same behaviour for the users.
I suppose that this information will help to the Dev Team in order to reproduce the bug.
Hope this helps,
David Rodríguez
David - you got me on the right track.
When I went into my portal profile definitions, there actually was profiles at all. Very strange.
I wrote a short sql query to identify which profile properties were mismatched between host and portal, seeing as I couldn't see it on the page.
The query was this:
select host.PortalId, host.PropertyCategory, host.PropertyName
, portal.PortalId, portal.PropertyCategory, portal.propertyName
from dnn_ProfilePropertyDefinition host
left join dnn_ProfilePropertyDefinition portal
on host.propertyName = portal.PropertyName
and host.PortalId is null
and portal.portalId = 0
where host.portalId is null
You may have to remove the dnn_ if you don't use the prefix and possibly change the portalid
The results from the query will show which profile property is missing because it will show up as a 'NULL' in the 4th, 5th and 6th columns for the missing property
In my case, it was the Photo property, which I then added back in via the portal profile page
Once I did this, my forum errors were fixed and it started working again
Note my dnn_Forum_vw_ForumUsers view is still broken due to EnableDisplayInMemberList - not sure what that is about