Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...DNN 7.2.2 -> 7.4.0 upgrade cause problems with edit modeDNN 7.2.2 -> 7.4.0 upgrade cause problems with edit mode
Previous
 
Next
New Post
5/15/2015 8:40 AM
 

Hello again!

We're facing problems while executing script mentioned. We firstly ran "TurboDNN740.sql" (Everything OK), now we are trying to run "TurboSchema740" as you suggested in last post. Here is complete error log: TurboScriptErrors.txt

I firstly thought this is a common problem related to SQL DB permissions. Then i logged in as sysadmin and error remains the same. Is there something i'm not doing right? Thank you for you kind help!

 
New Post
5/15/2015 10:48 AM
 
Kivi,
your link to the error file is a local link, which cannot be accessed via web.
best location to post issues with TurboDNN would http://dnnscript.codeplex.com/workite... or http://dnnscript.codeplex.com/discuss...

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/18/2015 7:08 AM
 
Hello, i hope you can asnwer my question on dnnsoftware.com too. I would appreciate it.

Msg 3701, Level 11, State 5, Line 3
Cannot drop the function 'dbo.FitsExtendedPropertyPermission', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the view 'dbo.vw_Lists', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the view 'dbo.vw_TabSettings', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the view 'dbo.vw_TabModuleSettings', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the view 'dbo.vw_ModuleSettings', because it does not exist or you do not have permission.
Msg 208, Level 16, State 1, Procedure dbo.GetFileFolderFunc, Line 12
Invalid object name 'dbo.Folders'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'FolderID'.
Msg 208, Level 16, State 1, Procedure dbo.AdministratorRoleId, Line 12
Invalid object name 'dbo.Portals'.
Msg 102, Level 15, State 1, Procedure dbo.GetListParentKey, Line 45
Incorrect syntax near '@ParentID'.
Msg 208, Level 16, State 1, Procedure dbo.GetProfilePropertyDefinitionID, Line 14
Invalid object name 'dbo.ProfilePropertyDefinition'.
Msg 208, Level 16, State 1, Procedure dbo.GetProfileFieldSql, Line 15
Invalid object name 'dbo.ProfilePropertyDefinition'.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 208, Level 16, State 1, Procedure dbo.Journal_ValidJournalTypesForModule, Line 12
Invalid object name 'dbo.Journal_Types'.
Msg 208, Level 16, State 1, Procedure dbo.vw_FilePaths, Line 11
Invalid object name 'dbo.Files'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.FilePath, Line 15
Invalid object name 'dbo.vw_FilePaths'.
Msg 208, Level 16, State 1, Procedure dbo.FileSize, Line 17
Invalid object name 'dbo.vw_FilePaths'.
Msg 208, Level 16, State 1, Procedure dbo.vw_Banners, Line 24
Invalid object name 'dbo.Banners'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_Banners" because it does not exist or you do not have permissions.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 49
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 4145, Level 15, State 1, Line 4
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 52
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 6
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 53
Incorrect syntax near the keyword 'ELSE'.
Msg 208, Level 16, State 1, Procedure dbo.vw_MasterPortals, Line 10
Invalid object name 'dbo.Portals'.
Msg 208, Level 16, State 1, Procedure dbo.vw_Users, Line 28
Invalid object name 'dbo.Users'.
Msg 208, Level 16, State 1, Procedure dbo.vw_Files, Line 36
Invalid object name 'dbo.Files'.
Msg 1088, Level 16, State 12, Line 3
Cannot find the object "dbo.vw_Files" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_Files" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_Files" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_PublishedFiles, Line 36
Invalid object name 'dbo.vw_Files'.
Msg 208, Level 16, State 1, Procedure dbo.vw_FileVersions, Line 20
Invalid object name 'dbo.FileVersions'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_FileVersions" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_PortalFileSpace, Line 8
Invalid object name 'dbo.Files'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_PortalFileSpace" because it does not exist or you do not have permissions.
Msg 2714, Level 16, State 3, Procedure vw_ModuleBase, Line 6
There is already an object named 'vw_ModuleBase' in the database.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 2714, Level 16, State 3, Procedure vw_ModuleTabs, Line 6
There is already an object named 'vw_ModuleTabs' in the database.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 8171, Level 16, State 2, Procedure vw_Modules, Line 63
Hint 'noexpand' on object 'dbo.vw_ModuleBase' is invalid.
Msg 2714, Level 16, State 3, Procedure vw_ModulesOnTabs, Line 6
There is already an object named 'vw_ModulesOnTabs' in the database.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 53
Incorrect syntax near the keyword 'ELSE'.
Msg 8171, Level 16, State 2, Procedure vw_TabModules, Line 62
Hint 'noexpand' on object 'dbo.vw_ModuleBase' is invalid.
Msg 208, Level 16, State 1, Procedure dbo.vw_PortalDesktopModules, Line 18
Invalid object name 'dbo.DesktopModules'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ProfileDataTypes, Line 9
Invalid object name 'dbo.Lists'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ProfileBase, Line 29
Invalid object name 'dbo.UserProfile'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_ProfileBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_ProfileBase" because it does not exist or you do not have permissions.
Msg 4145, Level 15, State 1, Line 4
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 28
Incorrect syntax near the keyword 'ELSE'.
Msg 208, Level 16, State 1, Procedure dbo.vw_UserProfileLookup, Line 8
Invalid object name 'dbo.UserProfile'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_UserProfileLookup" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_RoleUserCount, Line 7
Invalid object name 'dbo.Roles'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_RoleUserCount" because it does not exist or you do not have permissions.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 208, Level 16, State 1, Procedure dbo.vw_DesktopModulePermissionBase, Line 22
Invalid object name 'dbo.DesktopModulePermission'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_DesktopModulePermissions, Line 24
Invalid object name 'dbo.vw_DesktopModulePermissionBase'.
Msg 208, Level 16, State 1, Procedure dbo.vw_FolderRolePermissions, Line 26
Invalid object name 'dbo.FolderPermission'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_FolderRolePermissions" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_FolderUserPermissions, Line 25
Invalid object name 'dbo.FolderPermission'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_FolderUserPermissions" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_FolderPermissions, Line 25
Invalid object name 'dbo.vw_FolderRolePermissions'.
Msg 208, Level 16, State 1, Procedure dbo.vw_TabPermissionBase, Line 23
Invalid object name 'dbo.TabPermission'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_TabPermissions, Line 25
Invalid object name 'dbo.vw_TabPermissionBase'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ModulePermissionBase, Line 21
Invalid object name 'dbo.ModulePermission'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ModulePermissions, Line 26
Invalid object name 'dbo.vw_ModulePermissionBase'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ModulePermissionTabs, Line 22
Invalid object name 'dbo.Tabs'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ModuleSettings, Line 11
Invalid object name 'dbo.TabModules'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_ModuleSettings" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_TabModuleSettings, Line 11
Invalid object name 'dbo.TabModules'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_TabModuleSettings" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_TabSettings, Line 11
Invalid object name 'dbo.Tabs'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_TabSettings" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_RelationBase, Line 21
Invalid object name 'dbo.Relationships'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_RelationBase" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_RelatedUsers, Line 21
Invalid object name 'dbo.vw_RelationBase'.
Msg 102, Level 15, State 1, Procedure dbo.vw_Lists, Line 17
Incorrect syntax near '('.
Msg 156, Level 15, State 1, Procedure dbo.vw_Lists, Line 22
Incorrect syntax near the keyword 'THEN'.
Msg 102, Level 15, State 1, Procedure dbo.vw_Lists, Line 29
Incorrect syntax near 'S'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '('.
Msg 156, Level 15, State 1, Line 35
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near '('.
Msg 156, Level 15, State 1, Line 36
Incorrect syntax near the keyword 'ELSE'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_CoreMessaging_Recipients" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_CoreMessaging_Recipients" because it does not exist or you do not have permissions.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 208, Level 16, State 1, Procedure dbo.vw_JournalBase, Line 26
Invalid object name 'dbo.Journal'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_JournalItems, Line 27
Invalid object name 'dbo.vw_JournalBase'.
Msg 208, Level 16, State 1, Procedure dbo.vw_JournalSecurity, Line 16
Invalid object name 'dbo.Journal'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalSecurity" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalSecurity" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalSecurity" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalSecurity" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_JournalTypeFilters, Line 11
Invalid object name 'dbo.Journal_Types'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalTypeFilters" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_JournalComments, Line 26
Invalid object name 'dbo.Journal_Comments'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalComments" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalComments" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalComments" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.FitsExtendedPropertyPermission, Line 33
Invalid object name 'dbo.UserRoles'.
Msg 208, Level 16, State 1, Procedure dbo.FitsExtendedPropertyPermission, Line 37
Invalid object name 'dbo.vw_RelatedUsers'.
Msg 208, Level 16, State 1, Procedure dbo.MasterPortalId, Line 14
Invalid object name 'dbo.vw_MasterPortals'.
Msg 208, Level 16, State 1, Procedure dbo.GetUsersByPropertyName, Line 22
Invalid object name 'dbo.vw_Profile'.
Msg 4145, Level 15, State 1, Procedure dbo.UserProfileBaseGranted, Line 24
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 102, Level 15, State 1, Procedure dbo.UserProfileBaseGranted, Line 26
Incorrect syntax near 'PropertyValue'.
Msg 319, Level 15, State 1, Procedure dbo.UserProfileBaseGranted, Line 27
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Msg 4145, Level 15, State 1, Line 10
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 81
Incorrect syntax near the keyword 'ELSE'.
Msg 208, Level 16, State 1, Procedure dbo.Journal_PermittedJournalIDs, Line 19
Invalid object name 'dbo.vw_JournalSecurity'.
Msg 102, Level 15, State 1, Procedure dbo.FindBanners, Line 16
Incorrect syntax near '('.
Msg 319, Level 15, State 1, Procedure dbo.FindBanners, Line 32
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 75
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 72
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 73
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure dbo.GetModules, Line 8
Incorrect syntax near 'V'.
Msg 319, Level 15, State 1, Procedure dbo.GetModules, Line 14
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 18
Incorrect syntax near the keyword 'ELSE'.
Msg 8171, Level 16, State 2, Procedure dbo.GetExtensionUrlProviders, Line 32
Hint 'noexpand' on object 'dbo.vw_ModulesOnTabs' is invalid.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '('.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 80
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 80
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 156
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 61
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 59
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 56
Incorrect syntax near the keyword 'ELSE'.
Msg 208, Level 16, State 1, Line 10
Invalid object name 'dbo.HostSettings'.

 
New Post
5/18/2015 12:43 PM
 
I'll need to check on my test site and will reply later tonight or tomorrow

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/21/2015 12:21 AM
 
Hello again!

We hope you will answer, so we would be able to fix our problems (we haven't found any useful solution so far). Thank you
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...DNN 7.2.2 -> 7.4.0 upgrade cause problems with edit modeDNN 7.2.2 -> 7.4.0 upgrade cause problems with edit mode


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out