Announcement

Collapse
No announcement yet.

New error with API call to AlsoBoughtProductsList_Load_Query

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    New error with API call to AlsoBoughtProductsList_Load_Query

    I am not sure when this happened. Possibly when I upgraded Miva yesterday to 10.08.01. An API call to AlsoBoughtProductsList_Load_Query has started failing.

    Sample Request:
    Code:
    {
      "Store_Code": "SAMPLE",
      "Product_Code": "ABC-123",
      "Count": 5,
      "Assigned": false,
      "Unassigned": true,
      "Filter": [ { "name": "search", "value": [ { "field": "active", "operator": "EQ", "value": true } ] } ],
      "Sort": "-alsobought_count",
      "Module_Code": "pdsalsobought",
      "Module_Function": "AlsoBoughtProductsList_Load_Query"
    }
    Sample Response
    Code:
    {
      "success": 0,
      "error_code": "MER-DBE-SQL-00001",
      "error_message": "mysql_stmt_prepare: Unknown column 'prod.page_id' in 'on clause'"
    }

    #2
    TipPro It looks like that module is not compatible with 10.08.01

    I have reached out to the module developer and they are currently working on an update to the module.

    They said that you can expect the update within the next few weeks.

    As soon as the module is updated we will update the version in apps store, https://apps.miva.com/also-bought-products.html, and I will respond to this post.
    Nicholas Adkins
    Technical Training Specialist / Miva, Inc.
    [email protected]
    https://www.miva.com/mivalearn

    Comment


      #3
      I appreciate the quick response. Thank you.

      Comment


        #4
        TipPro The new module (version 1.0001) is available in the app store: https://apps.miva.com/also-bought-products.html
        Nicholas Adkins
        Technical Training Specialist / Miva, Inc.
        [email protected]
        https://www.miva.com/mivalearn

        Comment


          #5
          I updated the module this morning. Everything looks good. Thank you.

          Comment

          Working...
          X