Issues with Scripts and [vw_Profile]

[Joezyz]

Tried to run DNN TurboUnSchema Version 0.9.9 (2018-09-23) and having issues.
There are problems with the [vw_Profile] script. I changed the script to fix the errors.

CREATE VIEW [dbo].[vw_Profile]

AS
SELECT
P.UserID,
P.PortalID,
P.PropertyName,
CASE
WHEN P.TypeName = N'List' THEN IsNull(L.[Text], P.PropertyValue)
WHEN P.TypeName IN (N'Region', N'Country') THEN IsNull(M.[Text], M.[Value])
WHEN IsNull(P.PropertyText, N'') = N'' THEN IsNull(P.PropertyText, P.PropertyValue)
ELSE P.PropertyText
END AS PropertyValue,
P.Visibility,
P.ExtendedVisibility,
P.Deleted,
P.DataType,
P.TypeName,
P.LastUpdatedDate,
P.PropertyDefinitionID
FROM dbo.[vw_ProfileBase] AS P
LEFT JOIN dbo.[Lists] AS L ON P.PropertyName = L.ListName AND P.PropertyValue = L.Value
LEFT JOIN dbo.[Lists] AS M ON P.PropertyValue = CAST(M.EntryID as varchar)

GO

The original was
LEFT JOIN {databaseOwner}[{objectQualifier}Lists] AS M ON Cast(P.PropertyValue AS Int) = M.EntryID

The
Cast(P.PropertyValue AS Int) was causing the problem.

[sleupold]

Thank you for reporting it, I will fix it in next release (using the calculated column instead)

[Joezyz]

Sebastian, I'm having issues with the CNN site export in version 9.1.1. I'm trying to reverse all the turbo scripts, but after running your latest un script, I get a ton of errors. Can we email directly? It appears that your deprecated code is causing errors. It does not reverse the changes to the views. I just want to make sure my site export is not related to your scripts. The error is a *Message:*Invalid object name 'dbo. TabModules'. I've heard that a lot of issues were fixed in 9.2, but I've successfully exported before I applied the scripts. I'm just trying to rule out everything first. Thanks Joe

…

On Sat, Oct 27, 2018, 5:39 AM Sebastian Leupold ***@***.***> wrote: Thank you for reporting it, I will fix it in next release (using the calculated column instead) — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#8 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AUUDXbyN1FKDDEiLklqzGO7woThwatxDks5upCnWgaJpZM4X9FOP> .

[sleupold]

Joe,
Yyou may contact me via support (at) dnnwerk.de, response may be a bit slower atm, because I am not in the office atm. are you using default values for databaseOwner and objectQualifier placeholders ("dbo." and "" - empty string)?

[Joezyz]

If you are in Germany, sorry if this woke you up. I have run the scripts without removing the qualifiers Inside the CNN SQL window. And removing them and running the script in SQL management studio. Joe

…

On Sat, Oct 27, 2018, 8:43 PM Sebastian Leupold ***@***.***> wrote: Joe, Yyou may contact me via ***@***.***, response may be a bit slower atm, because I am not in the office atm. are you using default values for databaseOwner and objectQualifier placeholders ("dbo." and "" - empty string)? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#8 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AUUDXeKecxe0XuTUSijWYdozpLqDuBO0ks5upP2dgaJpZM4X9FOP> .

[sleupold]

@Joezyz
You should run latest TurboDNN followed by TurboSchema sxript, this should solve all your problems.