YAFLogo

bob@robertwjones.ca
2012-07-25T23:12:15Z
Installed ..9.6. I change table prefix to BNR_. Installed on a remote server with no problems.

http://24.207.43.210/BobsNewsRoom/ 

I can do anything I like in the trail category, add topics, messages, replies etc.

I added 3 new Categories, with several forms off each category. When I click on the form to add topics, I get an message yaf_topic object not found. Every thing looks the same under the trial category and the new category I set up.

Did I miss a Key or registration or something and I am being locked out of every thing but trial category?

If this is the case, could somebody add this to the install instructions?

Many Thanks

Bob

Server Error in '/BobsNewsRoom' Application.

--------------------------------------------------------------------------------

Invalid object name 'yaf_Topic'.

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.Data.SqlClient.SqlException: Invalid object name 'yaf_Topic'.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

[SqlException (0x80131904): Invalid object name 'yaf_Topic'.]

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2084358

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5096328

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234

System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2294

System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +215

System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162

System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +178

System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137

YAF.Classes.Data.MsSqlDbAccess.ExecuteNonQuery(IDbCommand cmd, Boolean transaction) +365

YAF.Types.Interfaces.IDbAccessExtensions.ExecuteNonQuery(IDbAccess dbAccess, IDbCommand cmd) in K:\inetpub\BobsNewsRoom\YAF.Types\Interfaces\Extensions\IDbAccessExtensions.cs:48

YAF.Classes.Data.LegacyDb.ReadForum_AddOrUpdate(Object userID, Object forumID) +275

YAF.Core.Services.YafReadTrackCurrentUser.SetForumRead(Int32 forumID) +176

YAF.Pages.topics.Topics_Unload(Object sender, EventArgs e) +133

System.EventHandler.Invoke(Object sender, EventArgs e) +0

System.Web.UI.Control.OnUnload(EventArgs e) +8998162

System.Web.UI.Control.UnloadRecursive(Boolean dispose) +241

System.Web.UI.Control.UnloadRecursive(Boolean dispose) +175

System.Web.UI.Control.UnloadRecursive(Boolean dispose) +175

System.Web.UI.Control.UnloadRecursive(Boolean dispose) +175

System.Web.UI.Page.UnloadRecursive(Boolean dispose) +23

System.Web.UI.Page.ProcessRequestCleanup() +43

System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +253

System.Web.UI.Page.ProcessRequest() +78

System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21

System.Web.UI.Page.ProcessRequest(HttpContext context) +49

ASP.default_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\bobsnewsroom\25c8c2e2\75133ae6\App_Web_p5ed4pmz.5.cs:0

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +100

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.0
2012-07-26T12:40:33Z
There is an issue with one stored Procedure where the Custom Table Prefix is not used.

Go to Admin -> Database - Run SQL Query and enter...

ALTER PROCEDURE [{databaseOwner}].[{objectQualifier}readforum_addorupdate] (
    @UserID INT
    ,@ForumID INT,
      @UTCTIMESTAMP datetime
    )
AS
BEGIN
    DECLARE @LastAccessDate DATETIME

    IF EXISTS (
            SELECT 1
            FROM [{databaseOwner}].[{objectQualifier}ForumReadTracking]
            WHERE UserID = @UserID
                AND ForumID = @ForumID
            )
    BEGIN
        SET @LastAccessDate = (
                SELECT LastAccessDate
                FROM [{databaseOwner}].[{objectQualifier}ForumReadTracking]
                WHERE (
                        UserID = @UserID
                        AND ForumID = @ForumID
                        )
                )

        UPDATE [{databaseOwner}].[{objectQualifier}ForumReadTracking]
        SET LastAccessDate = @UTCTIMESTAMP
        WHERE LastAccessDate = @LastAccessDate
            AND UserID = @UserID
            AND ForumID = @ForumID
    END
    ELSE
    BEGIN
        INSERT INTO [{databaseOwner}].[{objectQualifier}ForumReadTracking] (
            UserID
            ,ForumID
            ,LastAccessDate
            )
        VALUES (
            @UserID
            ,@ForumID
            ,@UTCTIMESTAMP
            )
    END

    -- Delete TopicReadTracking for forum...
    DELETE
    FROM [{databaseOwner}].[{objectQualifier}TopicReadTracking]
    WHERE UserID = @UserID
        AND TopicID IN (
            SELECT TopicID
            FROM [{databaseOwner}].[{objectQualifier}Topic]
            WHERE ForumID = @ForumID
            )
END

And Click on Run Query


UserPostedImage
bob@robertwjones.ca
2012-07-26T18:17:15Z
Bingo works like a charm!

I am extremely impressed with this product!

Many Thanks

Bob