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 = 7318 
WHERE 
  cscart_products_categories.product_id IN (
    90150, 90165, 84073, 84081, 90149, 90164, 
    90142, 90157, 90148, 90163, 84072, 
    84080, 90147, 90162, 84071, 84079, 
    84095, 90141, 90156, 90297, 90304, 
    84057, 84065, 84070, 84078, 85973, 
    84069, 84077, 90140, 90155
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.00130

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "54.28"
    },
    "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": 60,
            "rows_produced_per_join": 60,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "6.28",
              "eval_cost": "6.00",
              "prefix_cost": "12.28",
              "data_read_per_join": "960"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (90150,90165,84073,84081,90149,90164,90142,90157,90148,90163,84072,84080,90147,90162,84071,84079,84095,90141,90156,90297,90304,84057,84065,84070,84078,85973,84069,84077,90140,90155))"
          }
        },
        {
          "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": 60,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "15.00",
              "eval_cost": "6.00",
              "prefix_cost": "33.28",
              "data_read_per_join": "960"
            },
            "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": 3,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "15.00",
              "eval_cost": "0.30",
              "prefix_cost": "54.28",
              "data_read_per_join": "7K"
            },
            "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
84057 7319,7193M
84065 7319,7193M
84069 7319,7193M
84070 7319,7193M
84071 7319,7193M
84072 7319,7193M
84073 7319,7193M
84077 7319,7193M
84078 7319,7193M
84079 7319,7193M
84080 7319,7193M
84081 7319,7193M
84095 7319,7193M
85973 7319,7193M
90140 7319,7193M
90141 7319,7193M
90142 7319,7193M
90147 7319,7193M
90148 7319,7193M
90149 7319,7193M
90150 7319,7193M
90155 7319,7193M
90156 7319,7193M
90157 7319,7193M
90162 7319,7193M
90163 7319,7193M
90164 7319,7193M
90165 7319,7193M
90297 7319,7193M
90304 7319,7193M