database permissions are sufficient to alter schema

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
3/27/2008 5:31:40 AM
z1
Gravatar
Total Posts 15
View Posts

database permissions are sufficient to alter schema

Hello,

    I am using mojoportal on my server. When I give call to my site it shows me error of "database permissions are sufficient to alter schema". The whole error I mentioned below-

Error-

An Error Occurred:Unable to build the 'Tables' collection because execution of the SQL query failed. See the inner exception for details.
Source:System.Data
Stack Trace at System.Data.ProviderBase.DbMetaDataFactory.ExecuteCommand(DataRow requestedCollectionRow, String[] restrictions, DbConnection connection) at System.Data.ProviderBase.DbMetaDataFactory.GetSchema(DbConnection connection, String collectionName, String[] restrictions) at System.Data.ProviderBase.DbConnectionInternal.GetSchema(DbConnectionFactory factory, DbConnectionPoolGroup poolGroup, DbConnection outerConnection, String collectionName, String[] restrictions) at System.Data.SqlClient.SqlConnection.GetSchema(String collectionName, String[] restrictionValues) at mojoPortal.Data.dbPortal.DatabaseHelper_TableExists(String tableName) at mojoPortal.Data.dbPortal.DatabaseHelper_SitesTableExists() at mojoPortal.Business.DatabaseHelper.SchemaHasBeenCreated() at mojoPortal.Web.UI.Pages.SetupHome.ProbeSystem() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

So,what that error means?I not get any solution for this?

3/27/2008 6:57:56 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: database permissions are sufficient to alter schema

Hi,

Someone else posted this error before so you can read my previous response.

what version of mojoPortal, what operating system, what version of MS SQL.

Is the database on the same machine as the web server, is it your machine or hosted?

I would make sure you have all the service paks installed for MS SQL, other than that it seems like probably a slow connection or response from the database.

I would also review your log under Key Icon > System Log
or webroot/Data/currentlog.config file

Hope it helps,

Joe

 

You must sign in to post in the forums. This thread is closed to new posts.