Portal Engine Questions on portal engine and web parts.
Version 5.x > Portal Engine > Cannot create new field for Document Type View modes: 
User avatar
Member
Member
desi24-abv - 4/17/2013 9:55:43 AM
   
Cannot create new field for Document Type
[DataConnection.ExecuteQuery]: Query: CREATE VIEW View_CONTENT_MenuItem_Joined AS SELECT View_CMS_Tree_Joined.*, CONTENT_MenuItem.* FROM View_CMS_Tree_Joined INNER JOIN CONTENT_MenuItem ON View_CMS_Tree_Joined.DocumentForeignKeyValue = CONTENT_MenuItem.[MenuItemID] WHERE (ClassName = 'CMS.MenuItem') : caused exception: CREATE VIEW permission denied in database 'GTCM'.

User avatar
Kentico Support
Kentico Support
kentico_filipl - 4/17/2013 10:06:43 AM
   
RE:Cannot create new field for Document Type
Hello,

It seems like you do not have sufficient privileges to create a new field for document type. Please check your access permissions for the database and add write permissions in case current user does not have them.

Additionally, did this error occur when you tried to create it the standard way through Site Manager -> Development -> Document types -> <your document type> -> Fields -> New attribute?

Best regards,
Filip Ligac

User avatar
Member
Member
desi24-abv - 4/17/2013 10:23:00 AM
   
RE:Cannot create new field for Document Type
Yes this error did occurred when I tried to create new Fields for the Document type Page(Menu Item).

User avatar
Kentico Support
Kentico Support
kentico_filipl - 4/17/2013 10:28:31 AM
   
RE:Cannot create new field for Document Type
Hello,

Have you also checked the permissions for the user account you use? If you are using Windows authentication, could you try to use super admin's account instead as it is suggested in this forum thread - CREATE DATABASE permission denied in database 'master'.?

Best regards,
Filip Ligac