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 (
    92909, 92910, 92911, 92912, 92934, 92935, 
    92936, 92937, 92938, 92939, 92940, 
    92941, 92942, 92943, 92944, 92945, 
    93016, 93017, 93018, 93019, 93020, 
    93021, 93022, 93023, 93024, 93025, 
    93026, 93027, 93028, 93029, 93030, 
    93031, 93032, 93033, 93034, 93035, 
    93036, 93037, 93038, 93039, 93040, 
    93041, 93042, 93043, 93044, 93045, 
    93046, 93047, 93048, 93049, 93050, 
    93051, 93052, 93053, 93054, 93055, 
    93056, 93057, 93058, 93059, 93060, 
    93061, 93062, 93063, 93064, 93065, 
    93066, 93067, 93068, 93069, 93070, 
    93280, 93281, 93282, 93283, 93284, 
    93285, 93286, 93287, 93288, 93289, 
    93290, 93291, 93294, 93338, 93339, 
    93359, 93360, 93361, 93523, 93524, 
    93525, 93526, 93527, 93528, 93781
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.00231

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "72.38"
    },
    "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": 127,
            "rows_produced_per_join": 127,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "13.01",
              "eval_cost": "12.70",
              "prefix_cost": "25.71",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (92909,92910,92911,92912,92934,92935,92936,92937,92938,92939,92940,92941,92942,92943,92944,92945,93016,93017,93018,93019,93020,93021,93022,93023,93024,93025,93026,93027,93028,93029,93030,93031,93032,93033,93034,93035,93036,93037,93038,93039,93040,93041,93042,93043,93044,93045,93046,93047,93048,93049,93050,93051,93052,93053,93054,93055,93056,93057,93058,93059,93060,93061,93062,93063,93064,93065,93066,93067,93068,93069,93070,93280,93281,93282,93283,93284,93285,93286,93287,93288,93289,93290,93291,93294,93338,93339,93359,93360,93361,93523,93524,93525,93526,93527,93528,93781))"
          }
        },
        {
          "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": 6,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "31.75",
              "eval_cost": "0.64",
              "prefix_cost": "70.16",
              "data_read_per_join": "16K"
            },
            "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": "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": 6,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "1.59",
              "eval_cost": "0.64",
              "prefix_cost": "72.38",
              "data_read_per_join": "101"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
92909 7186M
92910 7186M
92911 7185M
92912 7185M
92934 7186M
92935 7185M
92936 7186M
92937 7185M
92938 7186M
92939 7185M
92940 7186M
92941 7185M
92942 7186M
92943 7185M
92944 7186M
92945 7185M
93016 7186M
93017 7186M
93018 7186M
93019 7186M
93020 7186M
93021 7186M
93022 7186M
93023 7186M
93024 7186M
93025 7186M
93026 7186M
93027 7186M
93028 7186M
93029 7186M
93030 7186M
93031 7186M
93032 7186M
93033 7186M
93034 7186M
93035 7186M
93036 7186M
93037 7186M
93038 7186M
93039 7188M
93040 7188M
93041 7188M
93042 7188M
93043 7188M
93044 7188M
93045 7188M
93046 7188M
93047 7186M
93048 7186M
93049 7186M
93050 7186M
93051 7186M
93052 7186M
93053 7186M
93054 7185M
93055 7185M
93056 7185M
93057 7185M
93058 7185M
93059 7185M
93060 7185M
93061 7185M
93062 7186M
93063 7186M
93064 7186M
93065 7186M
93066 7186M
93067 7186M
93068 7186M
93069 7186M
93070 7185M
93280 7186M
93281 7185M
93282 7313,7338,7219M
93283 7341,7342,7343,7157M
93284 7313,7338,7219M
93285 7341,7342,7343,7157M
93286 7313,7338,7219M
93287 7341,7342,7343,7157M
93288 7313,7338,7219M
93289 7341,7342,7343,7157M
93290 7313,7338,7219M
93291 7341,7342,7343,7157M
93294 7313,7338,7219M
93338 7313,7338,7219M
93339 7313,7338,7219M
93359 7186M
93360 7186M
93361 7186M
93523 7186M
93524 7185M
93525 7186M
93526 7185M
93527 7186M
93528 7185M
93781 7186M