Server Error in '/' Application.

Invalid column name 'HITS'.

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 column name 'HITS'.

Source Error:


Line 73:         If MainClass.OPENCN(CN2) Then
Line 74:             SQLCM = New SqlCommand("UPDATE OXVIDEO SET HITS=HITS+1 WHERE VIDEOCODE=" & VCODE, CN2)
Line 75:             SQLCM.ExecuteNonQuery()
Line 76:             SQLCM.Dispose()
Line 77:             DR.Close()

Source File: G:\PleskVhosts\himdarshan.com\httpdocs\video-gallery\details.aspx.vb    Line: 75

Stack Trace:


[SqlException (0x80131904): Invalid column name 'HITS'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2586154
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6039978
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4477
   System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) +997
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +314
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +297
   category_details.GETHITS() in G:\PleskVhosts\himdarshan.com\httpdocs\video-gallery\details.aspx.vb:75
   category_details.Page_Load(Object sender, EventArgs e) in G:\PleskVhosts\himdarshan.com\httpdocs\video-gallery\details.aspx.vb:26
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


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