YAFLogo

olops
  • olops
  • 57.8% (Neutral)
  • YAF Camper Topic Starter
6 years ago
Yep, I'm working on a copy of the database. Ta for efforts.
olops
  • olops
  • 57.8% (Neutral)
  • YAF Camper Topic Starter
6 years ago
https://github.com/YAFNET/YAFNET/wiki/Upgrade- (from-Version-1.9.5.5-or-above). I got a bit further - this time I entered the update process rather than install and it stated this completed successfully but then I received an 'unknown table yaf_Eventlog' error:

Server Error in '/' Application.

Invalid object name 'yaf_EventLog'.

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_EventLog'.

Stack Trace:

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

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2441634

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5736252

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +628

System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +3731

System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +58

System.Data.SqlClient.SqlDataReader.get_MetaData() +89

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

System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +2026

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +375

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

System.Data.SqlClient.SqlCommand.ExecuteScalar() +271

ServiceStack.OrmLite.OrmLiteDialectProviderBase`1.InsertAndGetLastInsertId(IDbCommand dbCmd) +101

YAF.Types.Interfaces.Data.IDbAccessExtensions.Insert(IDbAccess dbAccess, T insert, IDbTransaction transaction, Boolean selectIdentity) +556

YAF.Core.Extensions.IRepositoryExtensions.Insert(IRepository`1 repository, T entity, IDbTransaction transaction) +189

YAF.Core.Services.Logger.YafDbLogger.Log(String message, EventLogTypes eventType, String username, String source, Exception exception) +759

YAF.Core.Extensions.ILoggerExtensions.Log(ILogger logger, Nullable`1 userId, Object source, Exception exception, EventLogTypes eventType) +233

YAF.ForumPageBase.Page_Error(Object sender, EventArgs e) +319

System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51

System.Web.UI.TemplateControl.OnError(EventArgs e) +116

System.Web.UI.Page.HandleError(Exception e) +84

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +6202

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

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

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

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

ASP.default_aspx.ProcessRequest(HttpContext context) +4

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

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

yaf_EventLog is present in the database:

CREATE TABLE [hostinpro2241uk5167_SIRCForum].[yaf_EventLog](

[EventLogID] [int] IDENTITY(1,1) NOT NULL,

[EventTime] [datetime] NOT NULL CONSTRAINT [DF_yaf_EventLog_EventTime] DEFAULT (getutcdate()),

[UserID] [int] NULL,

[Source] [nvarchar](50) NOT NULL,

[Description] [ntext] NOT NULL,

[Type] [int] NOT NULL CONSTRAINT [DF_yaf_EventLog_Type] DEFAULT ((0)),

[UserName] [nvarchar](100) NULL,

CONSTRAINT [PK_yaf_EventLog] PRIMARY KEY CLUSTERED

(

[EventLogID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [hostinpro2241uk5167_SIRCForum].[yaf_EventLog] WITH CHECK ADD CONSTRAINT [FK_yaf_EventLog_yaf_User] FOREIGN KEY([UserID])

REFERENCES [hostinpro2241uk5167_SIRCForum].[yaf_User] ([UserID])

ON DELETE CASCADE

GO

ALTER TABLE [hostinpro2241uk5167_SIRCForum].[yaf_EventLog] CHECK CONSTRAINT [FK_yaf_EventLog_yaf_User]

GO

Any idea what is going on off the bat?