Server Error in '/' Application.

Invalid column name 'pos_affect'.
Invalid column name 'pos_top'.
Invalid column name 'pos_bot'.
Invalid column name 'pos_alt'.
Invalid column name 'pos_fix'.
SELECT TOP 9 V_LeisureCentres.contactaddress1, V_LeisureCentres.contactaddress2, V_LeisureCentres.contactaddress3, V_LeisureCentres.contacttel, V_LeisureCentres.id, V_LeisureCentres.contactpostcode, V_LeisureCentres.reviewurl, V_LeisureCentres.moreinfourl AS url, V_LeisureCentres.contactcity, V_LeisureCentres.contactcounty, CASE WHEN LEN(V_LeisureCentres.contactpostcode)>3 THEN UPPER(RTRIM(LEFT(V_LeisureCentres.contactpostcode,LEN(V_LeisureCentres.contactpostcode) - 3))) ELSE '' END AS postcode, V_LeisureCentres.directorytypeid, V_LeisureCentres.pos_affect, V_LeisureCentres.pos_top, V_LeisureCentres.pos_bot, V_LeisureCentres.pos_alt, V_LeisureCentres.pos_fix, T_DirAds.active, T_DirAds.startdate, T_DirAds.enddate, T_DirectoryAdTypes.resultstotop, T_DirectoryAdTypes.newwindow, T_DirectoryAdTypes.moreinfo, T_DirectoryAdTypes.showwebsite, T_DirectoryAdTypes.showemail, T_DirectoryAdTypes.enquireform, T_DirectoryAdTypes.enquireredirect, T_DirectoryAdTypes.resultscolour, T_DirectoryAdTypes.active AS adactive, T_DirAds.price, T_Users.directorytop, T_Users.enquireurl, V_LeisureCentres.name, CASE WHEN V_LeisureCentres.fia=1 THEN 'FIA' ELSE NULL END AS FIA, T_DirAds.userid, T_DirAds.campaignid, T_DirAds.id AS diradid FROM T_Users INNER JOIN V_LeisureCentres ON T_Users.id=V_LeisureCentres.userid LEFT OUTER JOIN T_DirectoryAdTypes INNER JOIN T_DirAds ON T_DirectoryAdTypes.id=T_DirAds.diradtypeid ON V_LeisureCentres.id=T_DirAds.diritemid WHERE suspended=0 AND (V_LeisureCentres.f_x BETWEEN (325959-24140.16) AND (325959+24140.16)) AND (V_LeisureCentres.f_y BETWEEN (674057-24140.16) AND (674057+24140.16)) AND ((SQUARE(V_LeisureCentres.f_x - 325959) + SQUARE(V_LeisureCentres.f_y - 674057)) <= SQUARE(24140.16)) ORDER BY SQUARE(V_LeisureCentres.f_x-325959) + SQUARE(V_LeisureCentres.f_y-674057),T_DirAds.active DESC,T_DirAds.enddate DESC

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.Exception: Invalid column name 'pos_affect'.
Invalid column name 'pos_top'.
Invalid column name 'pos_bot'.
Invalid column name 'pos_alt'.
Invalid column name 'pos_fix'.
SELECT TOP 9 V_LeisureCentres.contactaddress1, V_LeisureCentres.contactaddress2, V_LeisureCentres.contactaddress3, V_LeisureCentres.contacttel, V_LeisureCentres.id, V_LeisureCentres.contactpostcode, V_LeisureCentres.reviewurl, V_LeisureCentres.moreinfourl AS url, V_LeisureCentres.contactcity, V_LeisureCentres.contactcounty, CASE WHEN LEN(V_LeisureCentres.contactpostcode)>3 THEN UPPER(RTRIM(LEFT(V_LeisureCentres.contactpostcode,LEN(V_LeisureCentres.contactpostcode) - 3))) ELSE '' END AS postcode, V_LeisureCentres.directorytypeid, V_LeisureCentres.pos_affect, V_LeisureCentres.pos_top, V_LeisureCentres.pos_bot, V_LeisureCentres.pos_alt, V_LeisureCentres.pos_fix, T_DirAds.active, T_DirAds.startdate, T_DirAds.enddate, T_DirectoryAdTypes.resultstotop, T_DirectoryAdTypes.newwindow, T_DirectoryAdTypes.moreinfo, T_DirectoryAdTypes.showwebsite, T_DirectoryAdTypes.showemail, T_DirectoryAdTypes.enquireform, T_DirectoryAdTypes.enquireredirect, T_DirectoryAdTypes.resultscolour, T_DirectoryAdTypes.active AS adactive, T_DirAds.price, T_Users.directorytop, T_Users.enquireurl, V_LeisureCentres.name, CASE WHEN V_LeisureCentres.fia=1 THEN 'FIA' ELSE NULL END AS FIA, T_DirAds.userid, T_DirAds.campaignid, T_DirAds.id AS diradid FROM T_Users INNER JOIN V_LeisureCentres ON T_Users.id=V_LeisureCentres.userid LEFT OUTER JOIN T_DirectoryAdTypes INNER JOIN T_DirAds ON T_DirectoryAdTypes.id=T_DirAds.diradtypeid ON V_LeisureCentres.id=T_DirAds.diritemid WHERE suspended=0 AND (V_LeisureCentres.f_x BETWEEN (325959-24140.16) AND (325959+24140.16)) AND (V_LeisureCentres.f_y BETWEEN (674057-24140.16) AND (674057+24140.16)) AND ((SQUARE(V_LeisureCentres.f_x - 325959) + SQUARE(V_LeisureCentres.f_y - 674057)) <= SQUARE(24140.16)) ORDER BY SQUARE(V_LeisureCentres.f_x-325959) + SQUARE(V_LeisureCentres.f_y-674057),T_DirAds.active DESC,T_DirAds.enddate DESC

Source Error:


Line 201:
Line 202:	Dim oRES As New OmniDirectory.Results
Line 203:	Dim aFinalRows() As DataRow = oRES.getDataRowArray(Me.iSite, oDT.ID, oLoc.ID, (iMaxReturn * iMaxPages), Me.bIgnoreAdv, sFeaturedUIDs)
Line 204:	Dim iTotalRows As Integer = 0
Line 205:

Source File: C:\THF\SYSSITES\www.omnicrm.co.uk\public\aspx\dirresults.aspx Line: 203

Stack Trace:


[Exception: Invalid column name 'pos_affect'.
Invalid column name 'pos_top'.
Invalid column name 'pos_bot'.
Invalid column name 'pos_alt'.
Invalid column name 'pos_fix'.
SELECT TOP 9  V_LeisureCentres.contactaddress1, V_LeisureCentres.contactaddress2, V_LeisureCentres.contactaddress3, V_LeisureCentres.contacttel, V_LeisureCentres.id, V_LeisureCentres.contactpostcode, V_LeisureCentres.reviewurl, V_LeisureCentres.moreinfourl AS url, V_LeisureCentres.contactcity, V_LeisureCentres.contactcounty, CASE WHEN LEN(V_LeisureCentres.contactpostcode)>3 THEN UPPER(RTRIM(LEFT(V_LeisureCentres.contactpostcode,LEN(V_LeisureCentres.contactpostcode) - 3))) ELSE '' END AS postcode, V_LeisureCentres.directorytypeid, V_LeisureCentres.pos_affect, V_LeisureCentres.pos_top, V_LeisureCentres.pos_bot, V_LeisureCentres.pos_alt, V_LeisureCentres.pos_fix, T_DirAds.active, T_DirAds.startdate, T_DirAds.enddate, T_DirectoryAdTypes.resultstotop, T_DirectoryAdTypes.newwindow, T_DirectoryAdTypes.moreinfo, T_DirectoryAdTypes.showwebsite, T_DirectoryAdTypes.showemail, T_DirectoryAdTypes.enquireform, T_DirectoryAdTypes.enquireredirect, T_DirectoryAdTypes.resultscolour, T_DirectoryAdTypes.active AS adactive, T_DirAds.price, T_Users.directorytop, T_Users.enquireurl, V_LeisureCentres.name, CASE WHEN V_LeisureCentres.fia=1 THEN 'FIA' ELSE NULL END AS FIA, T_DirAds.userid, T_DirAds.campaignid, T_DirAds.id AS diradid    FROM T_Users  INNER JOIN V_LeisureCentres ON T_Users.id=V_LeisureCentres.userid  LEFT OUTER JOIN T_DirectoryAdTypes   INNER JOIN T_DirAds ON T_DirectoryAdTypes.id=T_DirAds.diradtypeid ON V_LeisureCentres.id=T_DirAds.diritemid    WHERE suspended=0 AND     (V_LeisureCentres.f_x BETWEEN (325959-24140.16) AND (325959+24140.16)) AND (V_LeisureCentres.f_y BETWEEN (674057-24140.16) AND (674057+24140.16)) AND  ((SQUARE(V_LeisureCentres.f_x - 325959) + SQUARE(V_LeisureCentres.f_y - 674057)) <= SQUARE(24140.16)) ORDER BY SQUARE(V_LeisureCentres.f_x-325959) + SQUARE(V_LeisureCentres.f_y-674057),T_DirAds.active DESC,T_DirAds.enddate DESC]
   OmniCLS.ops.db.DataSet(String sqlquery) +321
   OmniCLS.ops.db.DataView(String sqlquery) +39
   OmniDirectory.Results.getForcedResultsDV(Int32 iSITE, Int32 iDIR, Int64 iLOC, Int32 iTop, Boolean bIgnoreAdv, String sUserIDsToHide) +275
   OmniDirectory.Results.getDataRowArray(Int32 iSITE, Int32 iDIR, Int64 iLOC, Int32 iTop, Boolean bIgnoreAdv, String sUserIDsToHide, Boolean bForceUTTM) +243
   ASP._aspx_dirresults_aspx.getDirResults(Double x, Double y, Double rad) in C:\THF\SYSSITES\www.omnicrm.co.uk\public\aspx\dirresults.aspx:203
   ASP._aspx_dirresults_aspx.checkLocation() in C:\THF\SYSSITES\www.omnicrm.co.uk\public\aspx\dirresults.aspx:165
   ASP._aspx_dirresults_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in C:\THF\SYSSITES\www.omnicrm.co.uk\public\aspx\dirresults.aspx:10
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +98
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
   System.Web.UI.Page.Render(HtmlTextWriter writer) +26
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2558

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433