Invalid object name graffiti_RolePermissions

Last post 08-04-2008 4:51 PM by BelayTekalign. 2 replies.
Page 1 of 1 (3 items)
  • Invalid object name graffiti_RolePermissions

    07-21-2008 6:45 AM

    Hi,

    I'm testing the Express version of Graffiticms on my local machine (IIS 6.0 + SQL Express).

    It works fine except one thing - If I am not logged in as an administrator I get the following error, when accessing the site.
    Also I get the same error when I am logged in as Admin and try to Access "Users" and "Roles and Permissions" in the control panel.

    Server Error in '/test' Application.

    Invalid object name 'graffiti_RolePermissions'.

    Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'graffiti_RolePermissions'.

     

    Any idea if this is a bug or a wrong setting on my own behalf?

    Thanks.

  • Re: Invalid object name graffiti_RolePermissions

    07-21-2008 2:34 PM

    The Stack Trace says:

    [SqlException (0x80131904): Invalid object name 'graffiti_RolePermissions'.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
       System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
       System.Data.SqlClient.SqlDataReader.get_MetaData() +62
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
       System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
       System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +7
       DataBuddy.DataProvider.ExecuteReader(QueryCommand cmd) +168
       DataBuddy.Query.ExecuteReader() +46
       Graffiti.Core.RolePermissionManager.GetRolePermissions() +92
       ASP.global_asax.Application_Start(Object sender, EventArgs e) +258

    I have no problems when connecting to a VistaDB, however I would prefer to get Graffiti to work with SQL Express. 

  • Re: Invalid object name graffiti_RolePermissions

    08-04-2008 4:51 PM

    Can someone reply to the invalid object question above? I have the same issue when clicking Roles & Permissions on User management. Perhaps the answer to the above could help me resolve my issue.. Database SQL Server 2000, Graffiti cms version 1.1, licensed.

    Object reference not set to an instance of an object.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

    Stack Trace:

    [NullReferenceException: Object reference not set to an instance of an object.]
       ASP.graffiti_admin_user_management_roles_default_aspx.__DataBind__control14(Object sender, EventArgs e) +92
       System.Web.UI.Control.OnDataBinding(EventArgs e) +99
       System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +206
       System.Web.UI.Control.DataBind() +12
       System.Web.UI.Control.DataBindChildren() +204
       System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
       System.Web.UI.Control.DataBind() +12
       System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +130
       System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +454
       System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53
       Graffiti.Core.Repeater.OnDataBinding(EventArgs e) +11
       System.Web.UI.WebControls.Repeater.DataBind() +72
       graffiti_admin_roles_Default.Page_Load(Object sender, EventArgs e) +1296
       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
       System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
       System.Web.UI.Control.OnLoad(EventArgs e) +99
       System.Web.UI.Control.LoadRecursive() +47
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
    

Page 1 of 1 (3 items)