Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: "The multi-part identifier "a.TopicID" could not be bound."

  1. #1
    John.Kauffman is offline Junior Member
    Join Date
    Mar 2011
    Posts
    2

    Default "The multi-part identifier "a.TopicID" could not be bound."

    Showing up in my ML Multistore. Non-mobile browsers work fine
    (we are encountering multiple other issues, but not related to this error)
    http://parts.maaxspas.com/default.aspx


    The multi-part identifier "a.TopicID" could not be bound.
    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: The multi-part identifier "a.TopicID" could not be bound.

    Source Error:


    Line 98: <td align="center" style="vertical-align:top;padding-top:5px;">
    Line 99: <ul class="tameHoriz">
    Line 100: <li><a id="A1" runat="server" href='<%$ Tokens:TopicLink, About %>'><asp:Literal ID="ltAbout" runat="server" Text='<%$ Tokens:TopicTitle, About %>' /></a></li>&nbsp;|
    Line 101: <li><a id="A2" runat="server" href="~/contactus.aspx"><asp:Literal ID="ltContact" runat="server" Text='<%$ Tokens:StringResource, ContactUs.PageTitle %>' /></a></li>
    Line 102: </ul>

    Source File: e:\SITES\AspDotNetStorefrontMS\Web\App_Templates\M obileSkin_1\mobile_template.master Line: 100

    Stack Trace:
    [SqlException (0x80131904): The multi-part identifier "a.TopicID" could not be bound.]
    System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) +1950890
    System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +4846875
    System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +194
    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
    System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a() +33
    System.Data.SqlClient.SqlDataReader.get_MetaData() +83
    System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
    System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
    System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
    System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
    System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method) +141
    System.Data.SqlClient.SqlCommand.ExecuteReader() +89
    AspDotNetStorefrontCore.DB.GetRS(String Sql, SqlConnection dbconn) +140
    AspDotNetStorefrontCore.Topic.GetTitle(Int32 TopicID, String LocaleSetting) +196
    AspDotNetStorefrontCore.Topic.GetTitle(String TopicName, String LocaleSetting, Int32 StoreID) +25
    AspDotNetStorefrontCore.Tokens.GetEvalData(String expression, Type target, String entry) +1003
    ASP.app_templates_mobileskin_1_mobile_template_mas ter.__BuildControlltAbout() in e:\SITES\AspDotNetStorefrontMS\Web\App_Templates\M obileSkin_1\mobile_template.master:100
    ASP.app_templates_mobileskin_1_mobile_template_mas ter.__BuildControlA1() in e:\SITES\AspDotNetStorefrontMS\Web\App_Templates\M obileSkin_1\mobile_template.master:100
    ASP.app_templates_mobileskin_1_mobile_template_mas ter.__BuildControlform1() in e:\SITES\AspDotNetStorefrontMS\Web\App_Templates\M obileSkin_1\mobile_template.master:34
    ASP.app_templates_mobileskin_1_mobile_template_mas ter.__BuildControlTree(app_templates_mobileskin_1_ mobile_template_master __ctrl) in e:\SITES\AspDotNetStorefrontMS\Web\App_Templates\M obileSkin_1\mobile_template.master:1
    ASP.app_templates_mobileskin_1_mobile_template_mas ter.FrameworkInitialize() in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\root\c5d97a1f\a5633d7c\App_Web_btsvbg02.0.cs :0
    System.Web.UI.UserControl.InitializeAsUserControlI nternal() +35
    System.Web.UI.MasterPage.CreateMaster(TemplateCont rol owner, HttpContext context, VirtualPath masterPageFile, IDictionary contentTemplateCollection) +8671615
    System.Web.UI.Page.get_Master() +51
    System.Web.UI.Page.ApplyMasterPage() +15
    System.Web.UI.Page.PerformPreInit() +45
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +282

  2. #2
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    That's a known issue in 9.0.1.3 SP1. You can either contact support for an update, or upgrade to 9.1.0.0, which has the fix built in.