Results 1 to 2 of 2

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

  1. #1
    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
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •