This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.
When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:
I encountered an error when you try to see the list of posts of any user. when you click on view post an error is generated. the error log is System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.mp_ForumThreads'. at System.Data.SqlClient.SqlConnection.OnError (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError (SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning () the installed version is 2.3.9.6 and runs on MS SQL
can someone help me
need to see a little more of the error to tell where it is happening.
Does the table exist [dbo].mp_ForumThreads?
Do the forums work otherwise?
hi joe
the forum works all correctly. the error is generated when you click to see all posts of any user, whether the forum is the member list. the table exists in the database and is correctly populated, the table is named MSSql37526.mp_ForumThreads as all other table prefix
carry the following log
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.mp_ForumThreads'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at mojoPortal.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) at mojoPortal.Data.SqlParameterHelper.ExecuteReader() at mojoPortal.Data.DBForums.GetThreadPageByUser(Int32 userId, Int32 pageNumber, Int32 pageSize, Int32& totalPages) at mojoPortal.Web.ForumUI.UserThreadList.PopulateControls() at mojoPortal.Web.ForumUI.UserThreadList.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
does the table have the dbo prefix?
you will have to alter the sql procedure mp_ForumThreads_SelectPageByUser and remove the dbo prefix from there
the procedure is named
MSSql37526.mp_ForumThreads_SelectPageByUser
as all other...
i continue to receive error when click on view all post under user avatar.. or member list in admin panel
You'll need to alter inside the procedure and remove the reference to dbo that is inside the procedure. I'm not talking about changing the name of the procedure, you must edit the procedure and remove the dbo prefix where it references the table.
thank you very much with all my might. now it works perfectly. I'll buy you a beer joe
Thanks for the beer!
Cheers,
Joe