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 (
    99396, 99397, 99398, 100358, 100395, 
    100396, 100397, 100398, 100400, 100401, 
    100402, 100403, 100404, 100405, 100406, 
    100407, 100408, 100409, 100410, 100411, 
    100412, 100413, 100414, 100415, 100416, 
    100417, 100418, 100419, 100420, 100421, 
    100422, 100423, 100424, 100425, 100426, 
    100427, 100428, 100429, 100430, 100477, 
    100478, 100500, 100503, 100849, 100850, 
    100851, 100852, 100857, 100858, 100859, 
    100860, 100861, 100862, 100867, 100868, 
    100869, 100870, 100877, 100878, 101055, 
    101056, 101057, 101058, 101059, 101060, 
    101061, 101062, 101063, 101064, 101065, 
    101066, 101067, 101068, 101069, 101070, 
    101071, 101072, 101073, 101074, 101075, 
    101076, 101077, 101078, 101079, 101080, 
    101081, 101082, 101083, 101084, 101085, 
    101086, 101087, 101088, 101089, 101090, 
    101091
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01498

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "96.60"
    },
    "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": 107,
            "rows_produced_per_join": 107,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "11.00",
              "eval_cost": "10.70",
              "prefix_cost": "21.70",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (99396,99397,99398,100358,100395,100396,100397,100398,100400,100401,100402,100403,100404,100405,100406,100407,100408,100409,100410,100411,100412,100413,100414,100415,100416,100417,100418,100419,100420,100421,100422,100423,100424,100425,100426,100427,100428,100429,100430,100477,100478,100500,100503,100849,100850,100851,100852,100857,100858,100859,100860,100861,100862,100867,100868,100869,100870,100877,100878,101055,101056,101057,101058,101059,101060,101061,101062,101063,101064,101065,101066,101067,101068,101069,101070,101071,101072,101073,101074,101075,101076,101077,101078,101079,101080,101081,101082,101083,101084,101085,101086,101087,101088,101089,101090,101091))"
          }
        },
        {
          "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": 107,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "26.75",
              "eval_cost": "10.70",
              "prefix_cost": "59.15",
              "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": 5,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "26.75",
              "eval_cost": "0.54",
              "prefix_cost": "96.60",
              "data_read_per_join": "13K"
            },
            "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
99396 7222M
99397 7222M
99398 7222M
100358 7222M
100395 7285M,7330
100396 7285M,7330
100397 7196M
100398 7196M
100400 7254M
100401 7254M
100402 7254M
100403 7254M
100404 7254M
100405 7254M
100406 7254M
100407 7254M
100408 7254M
100409 7254M
100410 7254M
100411 7254M
100412 7254M
100413 7252M
100414 7196M
100415 7285M,7330
100416 7285M,7330
100417 7254M
100418 7254M
100419 7254M
100420 7254M
100421 7254M
100422 7254M
100423 7254M
100424 7254M
100425 7254M
100426 7254M
100427 7254M
100428 7253M,7331
100429 7252M
100430 7252M
100477 7287M
100478 7287M
100500 7196M
100503 7196M
100849 7286M
100850 7286M
100851 7286M
100852 7286M
100857 7286M
100858 7287M
100859 7287M
100860 7287M
100861 7287M
100862 7287M
100867 7285M,7330
100868 7285M,7330
100869 7285M,7330
100870 7285M,7330
100877 7285M,7330
100878 7285M,7330
101055 7254M
101056 7254M
101057 7254M
101058 7254M
101059 7254M
101060 7254M
101061 7254M
101062 7254M
101063 7254M
101064 7254M
101065 7254M
101066 7254M
101067 7254M
101068 7254M
101069 7254M
101070 7254M
101071 7254M
101072 7254M
101073 7254M
101074 7254M
101075 7254M
101076 7254M
101077 7254M
101078 7254M
101079 7254M
101080 7254M
101081 7254M
101082 7254M
101083 7254M
101084 7254M
101085 7254M
101086 7254M
101087 7254M
101088 7254M
101089 7254M
101090 7254M
101091 7254M