1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / Column 'p6' does not belong to table MetaDataQuery.

Column 'p6' does not belong to table MetaDataQuery.

4 posts, 0 answered
  1. gopalraman gopal
    gopalraman gopal avatar
    52 posts
    Registered:
    03 Dec 2009
    03 Jun 2010
    Link to this post
    Hi

    while trying to retrieve news/event from stefinity some times i am getting this kind of error.
    "Column 'p6' does not belong to table MetaDataQuery."
    What is the reason?

    Thanks
    G.GopalRaman
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    03 Jun 2010
    Link to this post
    Hi gopalraman gopal,

    Thank you for using our services.

    Could you please let us know exactly which version of Sitefinity you are using? You can use this article as a reference. Also please describe how you are trying to pull the news item - through code or from the built in controls/functionality. You will also need to check if you have more than one Sitefinity websites using the same database, and if those websites are having different versions of the CMS.

    Kind regards,
    Radoslav Georgiev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. gopalraman gopal
    gopalraman gopal avatar
    52 posts
    Registered:
    03 Dec 2009
    03 Jun 2010
    Link to this post

    Hi

    here is my code

     

    NewsManager objNews = new NewsManager("News");

     

     

     IMetaSearchInfo[] filters = new IMetaSearchInfo[2];
            filters[0] = new MetaSearchInfo(MetaValueTypes.DateTime, "Expiration_Date", DateTime.Now, SearchCondition.GreaterOrEqual);
            filters[1] = new MetaSearchInfo(MetaValueTypes.ShortText, "Title", "", SearchCondition.NotNull);

            IList lstListOfNewsItems = objNews.Content.GetContent("Publication_Date DESC", filters);

    in local it is running properly.

    Thanks
    G.GopalRaman

  4. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    03 Jun 2010
    Link to this post
    Hello gopalraman gopal,

    I am sending you a blank project set up using the built in SQLEXPRESS DB. Could you please try to reproduce the problem there and then send us back the project with its DB. The code you are using looks correct and we are not able to reproduce the issue with it. Username and password for the administrator account are both admin.

    Greetings,
    Radoslav Georgiev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Register for webinar
4 posts, 0 answered