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 = 7148 
WHERE 
  cscart_products_categories.product_id IN (
    95869, 95870, 95871, 95872, 95873, 95874, 
    95875, 95876, 95877, 95878, 95879, 
    95880, 95881, 95882, 95883, 95884, 
    95890, 95893, 95895, 95896, 95897, 
    95898, 95899, 95900, 95901, 95902, 
    95903, 95904, 95905, 95906
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.00223

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "65.00"
    },
    "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": 114,
            "rows_produced_per_join": 114,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "11.70",
              "eval_cost": "11.40",
              "prefix_cost": "23.10",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (95869,95870,95871,95872,95873,95874,95875,95876,95877,95878,95879,95880,95881,95882,95883,95884,95890,95893,95895,95896,95897,95898,95899,95900,95901,95902,95903,95904,95905,95906))"
          }
        },
        {
          "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": "28.50",
              "eval_cost": "0.57",
              "prefix_cost": "63.00",
              "data_read_per_join": "14K"
            },
            "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": 5,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "1.43",
              "eval_cost": "0.57",
              "prefix_cost": "65.00",
              "data_read_per_join": "91"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
95869 7241,7309,7346,7208M
95870 7241,7309,7346,7208M
95871 7241,7309,7346,7208M
95872 7241,7309,7346,7208M
95873 7241,7309,7346,7208M
95874 7241,7309,7346,7208M
95875 7241,7309,7346,7208M
95876 7241,7309,7346,7208M
95877 7241,7309,7346,7208M
95878 7241,7309,7346,7208M
95879 7241,7309,7346,7208M
95880 7241,7309,7346,7208M
95881 7241,7309,7346,7208M
95882 7241,7309,7346,7208M
95883 7241,7309,7346,7208M
95884 7241,7309,7346,7208M
95890 7263M
95893 7263M
95895 7241,7309,7346,7208M
95896 7241,7309,7346,7208M
95897 7241,7309,7346,7208M
95898 7241,7309,7346,7208M
95899 7241,7309,7346,7208M
95900 7241,7309,7346,7208M
95901 7241,7309,7346,7208M
95902 7241,7309,7346,7208M
95903 7241,7309,7346,7208M
95904 7241,7309,7346,7208M
95905 7241,7309,7346,7208M
95906 7241,7309,7346,7208M