B2C Servicepublic

Customer Portal

Get Involved. Join the Conversation.

This is a public Forum  public

Topic

    JustRhianna
    Pre-populated answer page displaying no results
    Topic posted March 10, 2009 by JustRhiannaSilver Crown: 22,500+ Points, last edited September 25, 2018 by Just Rhianna 
    2716 Views, 20 Comments
    Title:
    Pre-populated answer page displaying no results
    Content:

    Yesterday I changed the report that is used for answers to remove the updated/new column because of a bug with agedatabase decay.

     

    Today all my pre-populated answer pages and even the regular answer page frequently shows no results found until you type something in the search box. Any thoughts on how to fix this?

     

    http://support.nikontech.com/app/answers/list/p/19

     

    http://support.nikontech.com/app/answers/list/p/1

     

    http://support.nikontech.com/app/answers/list

    Comment

    • monique perkins

      Did you verify you changed the report_id in all places?

       

      Also - you might want to keep the column and just leave it blank.  You can remove the column but the format of the answer listing might look different (since the multiline widget has particular formatting for the first few columns)

    • JustRhianna
      I updated the report id in details and list.php
    • monique perkins
      Your report doesn't seem to be returning data back when the product filter is used.  Your post data to the server looks ok as far as I can tell.  Does your report work correctly if you run it in the console?
    • JustRhianna

      Yes it does. I have attached the definition

      11888Answers CP 116678.xml (28KB)
    • monique perkins

      The report looks fine and I can run it with all products on my development site. 

       

      I can hit

      http://support.nikontech.com/app/answers/list/p/97

      and get results, but when I hit

      http://support.nikontech.com/app/answers/list/p/1 I don't get anything returned.  I also still don't get anything if I add keywords to that search.

       

      I'm wondering if you have something incorrect between your answers and your product / categories that nothing is returned?  If the same product searches are fine in the console then they product associations are probably ok but the search is not returning any data so I don't *think* it's due to a customization on the page.

       

      Have you tried it again with the standard CP answers report with the same urls / searches to verify if it is report specific?  

    • JustRhianna
      It is definately report specific because it worked before I made the changes. However as you can see I only removed the updated column and exceptions.
    • monique perkins

      I'm stuck on this one.  It looks like all of your data going to the server is correct - some of the products chosen just aren't returning answers.  I can't tell of its because of a customization from looking at the webpage.

       

      You  might want to copy the report again and just make that field blank (but don't remove it).  Right click on the New or Updated column -> Column Definition -> remove the part that is inthe expression field. Save it and chage your report_ids to that and see if it helps. 

    • JustRhianna

      I cannot blank out the column? I removed the exceptions saved it and the prepoulated are working fine. But I still see the updated label. Maybe I can make the label within the expression blank?

       

      Here is the current expression:

      if (date_diff(sysdate(), answers.created) / 86400 < $new, msg_lookup('NEW_LBL'), if(date_diff(sysdate(), answers.updated) / 86400 < $updated, msg_lookup('UPDATED_LBL')))

    • monique perkins

      Yes you can just put '' instead of msg_lookup('NEW_LBL');

       

      I still don't think that is the problem though.  The report looks OK.  I've talked to some other people here and we are looking at the trace file to see if there is something else with your database that might be causing the problem.   Thanks for your patience.

    • JustRhianna
      I took the updated part of the statement out so it will still diplay the new answers and it works. Possible defect?
    • JustRhianna

      I spoke to soon. If I go to page:

       

      http://www.nikonusa.com/Service-And-Support/Product-Support.page

       

      and clear cache between clicking on each link it goes back to no results

    • monique perkins

      Your report should run now.  You were hitting the max_join_size sometimes and that was causing it to return no answers.  I'm not sure why this was set on the report (it's not a setting in the console).  That's not my area of expertise :) 

       

      A new report copy should have worked for you as well. 

    • JustRhianna
      No go still seeing the issue. I have a case open but it is not going anywhere.
    • monique perkins

      I don't think I'm seeing the issue on your site.  I hit  the support page - cleared cache - and tried a link.  I can do this for all the links.  Also when I hit the original urls you gave I get results for each.

       

      What steps are you using?  Also -are you in development mode?  I am not.

    • JustRhianna
      Not sure what you mean by developent mode. I am looking at it on production if that is what you mean.

    community forum