PHP Deprecated

Message

unserialize(): Passing null to parameter #1 ($data) of type string is deprecated

Error at

app/addons/hybrid_auth/func.php, line: 200

Backtrace

File:app/addons/hybrid_auth/func.php
Line:200
Function:{closure}
File:app/Tygh/Registry.php
Line:800
Function:{closure}
File:app/addons/hybrid_auth/func.php
Line:222
Function:getOrSetCache
File:app/addons/hybrid_auth/controllers/frontend/init.post.php
Line:17
Function:fn_hybrid_auth_get_providers_list
File:app/functions/fn.control.php
Line:727
Function:include
File:app/functions/fn.control.php
Line:458
Function:fn_run_controller
File:index.php
Line:19
Function:fn_dispatch
SELECT 
  cscart_products_categories.product_id, 
  GROUP_CONCAT(
    IF(
      cscart_products_categories.link_type = "M", 
      CONCAT(
        cscart_products_categories.category_id, 
        "M"
      ), 
      cscart_products_categories.category_id
    )
  ) AS category_ids, 
  product_position_source.position AS position 
FROM 
  cscart_products_categories 
  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id 
  AND cscart_categories.storefront_id IN (0, 1) 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  LEFT JOIN cscart_products_categories AS product_position_source ON cscart_products_categories.product_id = product_position_source.product_id 
  AND product_position_source.category_id = 7195 
WHERE 
  cscart_products_categories.product_id IN (
    90616, 90617, 90622, 90623, 90724, 90726, 
    90716, 90722, 90592, 90593, 92534, 
    89243, 89244, 89253, 89254, 90588, 
    90590, 90657, 90642, 92533, 90664, 
    90665, 90670, 90671, 89245, 89246, 
    89247, 89248, 90589, 90591, 90606, 
    90607, 90612, 90613, 90599, 90715, 
    90721, 89249, 89250, 89251, 89252, 
    90709, 90711, 90654, 90655, 90660, 
    90661, 90698
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01790

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "72.29"
    },
    "grouping_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_products_categories",
            "access_type": "range",
            "possible_keys": [
              "PRIMARY",
              "link_type",
              "pt"
            ],
            "key": "pt",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "rows_examined_per_scan": 80,
            "rows_produced_per_join": 80,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "8.29",
              "eval_cost": "8.00",
              "prefix_cost": "16.29",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (90616,90617,90622,90623,90724,90726,90716,90722,90592,90593,92534,89243,89244,89253,89254,90588,90590,90657,90642,92533,90664,90665,90670,90671,89245,89246,89247,89248,90589,90591,90606,90607,90612,90613,90599,90715,90721,89249,89250,89251,89252,90709,90711,90654,90655,90660,90661,90698))"
          }
        },
        {
          "table": {
            "table_name": "product_position_source",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "pt"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id",
              "product_id"
            ],
            "key_length": "6",
            "ref": [
              "const",
              "nuie_scalesta_net.cscart_products_categories.product_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 80,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "20.00",
              "eval_cost": "8.00",
              "prefix_cost": "44.29",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "p_category_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "ref": [
              "nuie_scalesta_net.cscart_products_categories.category_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 4,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "20.00",
              "eval_cost": "0.40",
              "prefix_cost": "72.29",
              "data_read_per_join": "10K"
            },
            "used_columns": [
              "category_id",
              "usergroup_ids",
              "status",
              "storefront_id"
            ],
            "attached_condition": "((`nuie_scalesta_net`.`cscart_categories`.`storefront_id` in (0,1)) and ((`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids`))) and (`nuie_scalesta_net`.`cscart_categories`.`status` in ('A','H')))"
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
89243 7285M,7330
89244 7285M,7330
89245 7286M
89246 7286M
89247 7286M
89248 7286M
89249 7287M
89250 7287M
89251 7287M
89252 7287M
89253 7330,7285M
89254 7285M,7330
90588 7287M
90589 7287M
90590 7287M
90591 7287M
90592 7287M
90593 7287M
90599 7331,7253M
90606 7253M,7331
90607 7331,7253M
90612 7331,7253M
90613 7331,7253M
90616 7331,7253M
90617 7331,7253M
90622 7331,7253M
90623 7331,7253M
90642 7331,7253M
90654 7331,7253M
90655 7253M,7331
90657 7253M,7331
90660 7331,7253M
90661 7331,7253M
90664 7331,7253M
90665 7253M,7331
90670 7253M,7331
90671 7253M,7331
90698 7253M,7331
90709 7253M,7331
90711 7253M,7331
90715 7330,7285M
90716 7330,7285M
90721 7330,7285M
90722 7330,7285M
90724 7330,7285M
90726 7330,7285M
92533 7254M
92534 7254M