Server Error in '/' Application.

Invalid column name "Author1".

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.InvalidOperationException: Invalid column name "Author1".

Source Error:


Line 8:  
Line 9:      var data = db.QuerySingle("SELECT * FROM Other WHERE Category='2' AND title like '%'+@0+'%'", reviewname);
Line 10:     var author = db.QuerySingle("SELECT fname, ID, Image, ShortProfile, Profile FROM Admin WHERE ID =@0", data.Author1);
Line 11:     var list = db.Query("SELECT TOP 8 ID, Title, Image, Date, Author1 FROM Other WHERE Category='2' AND ID <> @0 ORDER BY Date Desc", data.ID);
Line 12: 

Source File: d:\Websites\ukanimenet\www\AnimeFigures.cshtml    Line: 10

Stack Trace:


[InvalidOperationException: Invalid column name "Author1".]
   WebMatrix.Data.DynamicRecord.VerifyColumn(String name) +172
   WebMatrix.Data.DynamicRecord.get_Item(String name) +23
   WebMatrix.Data.DynamicRecord.TryGetMember(GetMemberBinder binder, Object& result) +17
   CallSite.Target(Closure , CallSite , Object ) +172
   ASP._Page_AnimeFigures_cshtml.Execute() in d:\Websites\ukanimenet\www\AnimeFigures.cshtml:10
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +252
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +99
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +182
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +107
   System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContextBase httpContext) +142


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