1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Fixed Latest Ordering?

Discussion in 'Resolved Bugs' started by PERuss, Sep 22, 2014.

  1. PERuss

    PERuss Member Xen Notices

    Not really sure how to explain this but after imported our products over, we're going through and adding in branding free as an optional extra for each product. After each time we add an optional extra the item gets boosted, sometimes to the top, sometimes in the middle of the list.

    Initial list:

    order1.png
    1. Core
    2. Fusion Gamer
    3. Splash
    4. Detour
    5. Frag Zone
    6. Zipped
    7. Adara
    8. Apex
    9. Modest
    10. Legendary

    This is after adding the branding free as an optional extra to Legendary
    order2.png
    1. Core
    2. Fusion Gamer
    3. Splash
    4. Detour
    5. Frag Zone
    6. Zipped
    7. Legendary
    8. Adara
    9. Apex
    10. Modest


    This is after adding the branding free as an optional extra to Modest
    order3.png

    1. Core
    2. Fusion Gamer
    3. Splash
    4. Detour
    5. Modest
    6. Frag Zone
    7. Zipped
    8. Legendary
    9. Adara
    10. Apex

    When I did core it was like #9, added optional extra and it went to the top.
     
    Last edited: Sep 22, 2014
  2. Chris D

    Chris D Xen Resources Developer Staff Member Xen Notices

    This is fixed now.

    Could you please go through the products and double check that the version history and specifically the release dates of each version are correct?

    This bug may have caused the current versions to get a much older release date. This may impact on the versions which are available to download.

    This query ought to fix the problem, but I'd urge you to back up the xenproduct_version table first! Then check everything is correct and if it isn't, revert back to the backup of that table, but I've just tested and this query seems to work fine:

    Code:
    UPDATE xenproduct_version AS version, xf_attachment AS attachment
       SET version.release_date = attachment.attach_date
     WHERE version.product_version_id = attachment.content_id
       AND attachment.content_type = 'xenproduct_version'
     

Share This Page