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 = 7184 
WHERE 
  cscart_products_categories.product_id IN (
    93782, 93783, 93784, 93785, 93786, 94026, 
    94027, 94028, 94029, 94030, 94031, 
    94032, 94033, 94074, 94075, 94428, 
    94452, 94453, 94454, 94455, 94456, 
    94458, 94459, 94460, 94461, 94462, 
    94709, 94717, 94718, 94719, 94720, 
    94721, 94722, 94723, 94724, 94725, 
    94726, 94727, 94728, 94729, 94730, 
    94731, 94732, 94733, 94734, 94735, 
    94736, 94737, 94738, 94739, 94740, 
    94741, 94742, 94743, 94744, 94745, 
    94746, 94747, 94748, 94749, 94750, 
    94751, 94752, 94753, 94754, 94755, 
    94756, 94757, 94758, 94759, 94760, 
    94761, 94762, 94763, 94764, 94765, 
    94816, 94950, 94951, 95565, 95566, 
    95567, 95568, 95569, 95570, 95571, 
    95572, 95573, 95574, 95575, 95576, 
    95577, 95578, 95579, 95580, 95581
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.00696

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "133.19"
    },
    "grouping_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "8.48"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "ALL",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "p_category_id"
            ],
            "rows_examined_per_scan": 208,
            "rows_produced_per_join": 8,
            "filtered": "4.00",
            "cost_info": {
              "read_cost": "20.72",
              "eval_cost": "0.83",
              "prefix_cost": "21.55",
              "data_read_per_join": "21K"
            },
            "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')))"
          }
        },
        {
          "table": {
            "table_name": "cscart_products_categories",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "link_type",
              "pt"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "ref": [
              "nuie_scalesta_net.cscart_categories.category_id"
            ],
            "rows_examined_per_scan": 117,
            "rows_produced_per_join": 8,
            "filtered": "0.87",
            "cost_info": {
              "read_cost": "2.33",
              "eval_cost": "0.85",
              "prefix_cost": "121.75",
              "data_read_per_join": "135"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (93782,93783,93784,93785,93786,94026,94027,94028,94029,94030,94031,94032,94033,94074,94075,94428,94452,94453,94454,94455,94456,94458,94459,94460,94461,94462,94709,94717,94718,94719,94720,94721,94722,94723,94724,94725,94726,94727,94728,94729,94730,94731,94732,94733,94734,94735,94736,94737,94738,94739,94740,94741,94742,94743,94744,94745,94746,94747,94748,94749,94750,94751,94752,94753,94754,94755,94756,94757,94758,94759,94760,94761,94762,94763,94764,94765,94816,94950,94951,95565,95566,95567,95568,95569,95570,95571,95572,95573,95574,95575,95576,95577,95578,95579,95580,95581))"
          }
        },
        {
          "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": 8,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "2.12",
              "eval_cost": "0.85",
              "prefix_cost": "124.71",
              "data_read_per_join": "135"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
93782 7185M
93783 7186M
93784 7185M
93785 7186M
93786 7185M
94026 7186M
94027 7185M
94028 7186M
94029 7185M
94030 7186M
94031 7185M
94032 7186M
94033 7185M
94074 7186M
94075 7185M
94428 7219M,7313,7338
94452 7157M,7341,7342,7343
94453 7157M,7341,7342,7343
94454 7157M,7341,7342,7343
94455 7157M,7341,7342,7343
94456 7157M,7341,7342,7343
94458 7157M,7341,7342,7343
94459 7157M,7341,7342,7343
94460 7157M,7341,7342,7343
94461 7157M,7341,7342,7343
94462 7157M,7341,7342,7343
94709 7186M
94717 7185M
94718 7188M
94719 7186M
94720 7185M
94721 7185M
94722 7188M
94723 7186M
94724 7185M
94725 7185M
94726 7185M
94727 7188M
94728 7186M
94729 7185M
94730 7185M
94731 7188M
94732 7186M
94733 7185M
94734 7185M
94735 7188M
94736 7186M
94737 7185M
94738 7185M
94739 7188M
94740 7186M
94741 7185M
94742 7185M
94743 7188M
94744 7186M
94745 7185M
94746 7185M
94747 7188M
94748 7186M
94749 7185M
94750 7219M,7313,7338
94751 7157M,7341,7342,7343
94752 7157M,7341,7342,7343
94753 7157M,7341,7342,7343
94754 7157M,7341,7342,7343
94755 7157M,7341,7342,7343
94756 7157M,7341,7342,7343
94757 7157M,7341,7342,7343
94758 7157M,7341,7342,7343
94759 7219M,7313,7338
94760 7219M,7313,7338
94761 7219M,7313,7338
94762 7157M,7341,7342,7343
94763 7219M,7313,7338
94764 7157M,7341,7342,7343
94765 7219M,7313,7338
94816 7219M,7313,7338
94950 7219M,7313,7338
94951 7219M,7313,7338
95565 7157M,7341,7342,7343
95566 7219M,7313,7338
95567 7157M,7341,7342,7343
95568 7157M,7341,7342,7343
95569 7219M,7313,7338
95570 7157M,7341,7342,7343
95571 7219M,7313,7338
95572 7157M,7341,7342,7343
95573 7157M,7341,7342,7343
95574 7219M,7313,7338
95575 7219M,7313,7338
95576 7157M,7341,7342,7343
95577 7157M,7341,7342,7343
95578 7219M,7313,7338
95579 7219M,7313,7338
95580 7219M,7313,7338
95581 7219M,7313,7338