Odd reporting bug...

Discussion in 'Troubleshooting' started by microlinx, Jan 6, 2006.

  1. microlinx

    microlinx Member

    Joined:
    Oct 26, 2004
    Messages:
    268
    I have been running aMember for 1 year.
    After the 1st of the year, the default report shows only one week for the year 2006. That is normal and just fine.

    However, when I request a weekly report for Jan 1 2005 through Jan 6 2006, it gives me every week from Jan 6 2005 to the last week in 2005. This week is blank (zero) and NEXT week is shown with this weeks numbers.
    See report below: The report range is for 1/1/2005 thru 1/6/2006
    Today's date is 1/6/2006 (but report shows data into next week)

    previous weeks are ok... bold is where the error resides.
    ...
    12/11/2005 - 12/17/2005 51 49 813.45 781.55
    12/18/2005 - 12/24/2005 66 58 1,052.70 925.10
    12/25/2005 - 12/31/2005 87 78 1,387.65 1,244.10
    01/01/2006 - 01/07/2006 0 0 0.00 0.00
    01/08/2006 - 01/14/2006 72 66 1,148.40 1,052.70

    Just thought you (Alex) should know.

    Please remove this post once you review, unless others would like to duplicate or verify.

    Current vesion is 2.3.5 Pro
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Thank you for reporting this bug. It will be fixed.
  3. microlinx

    microlinx Member

    Joined:
    Oct 26, 2004
    Messages:
    268
    Thanks Alex...

    Also, doing a normal report request for the current year (2006) skips the first week of the year and moves all report data forward one full week.
  4. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Which MySQL version are you using? It most likely a bug in MySQL.
  5. microlinx

    microlinx Member

    Joined:
    Oct 26, 2004
    Messages:
    268
    MySQL 4.0.25
    and
    phpMyAdmin 2.6.4-pl2

Share This Page