openstore-ecommerce
USERDATA userid not correct for user.
When the USERDATA record is created it seems to attach the incorrect userid. In this case it was a user that had been deleted and no longer existed in the "users" DB table.
Not seen this before and was created with an upgraded DB. But maybe it's simply not been seen before.
Here is a sql select statement to help admins see if this is affecting an install.
SELECT TOP (1000) [ItemId], nb1.[UserId], portalid, [XMLData].value('(genxml/address/genxml/textbox/firstname)[1]','nvarchar(max)') [FirstName1], u.FirstName [FirstName2] FROM [NBrightBuy] nb1 join users u on u.UserID = nb1.UserId where typecode ='USERDATA' and u.FirstName <> [XMLData].value('(genxml/address/genxml/textbox/firstname)[1]','nvarchar(max)') order by userid
