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 = 7143 
WHERE 
  cscart_products_categories.product_id IN (
    86855, 84265, 89384, 89389, 89300, 89432, 
    89731, 89439, 82381, 89301, 82396, 
    86851, 89440, 82416, 86853, 89431, 
    89299, 84263, 84267, 89349, 89334, 
    83088, 89124, 89128, 89160, 89551, 
    82343, 89350, 89263, 89340, 82450, 
    82451, 86238, 91290, 84264, 91913, 
    91914, 91915, 91916, 91917, 91918, 
    91919, 82332, 86814, 86844, 89101, 
    89336, 89729
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01683

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "74.09"
    },
    "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": 82,
            "rows_produced_per_join": 82,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "8.49",
              "eval_cost": "8.20",
              "prefix_cost": "16.69",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (86855,84265,89384,89389,89300,89432,89731,89439,82381,89301,82396,86851,89440,82416,86853,89431,89299,84263,84267,89349,89334,83088,89124,89128,89160,89551,82343,89350,89263,89340,82450,82451,86238,91290,84264,91913,91914,91915,91916,91917,91918,91919,82332,86814,86844,89101,89336,89729))"
          }
        },
        {
          "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": 82,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "20.50",
              "eval_cost": "8.20",
              "prefix_cost": "45.39",
              "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": 4,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "20.50",
              "eval_cost": "0.41",
              "prefix_cost": "74.09",
              "data_read_per_join": "10K"
            },
            "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
82332 7147M
82343 7145M
82381 7326M
82396 7145M
82416 7146M
82450 7160M,7305
82451 7160M,7305
83088 7147M
84263 7145M
84264 7145M
84265 7147M
84267 7145M
86238 7302M
86814 7147M
86844 7147M
86851 7145M
86853 7145M
86855 7145M
89101 7147M
89124 7147M
89128 7147M
89160 7147M
89263 7325,7324,7143,7154M,7153 0
89299 7143,7154M,7153,7324,7325 0
89300 7324,7325,7154M,7143,7153 0
89301 7324,7325,7154M,7143,7153 0
89334 7326M
89336 7326M
89340 7153,7143,7288M 0
89349 7153,7143,7325,7324,7154M 0
89350 7324,7154M,7153,7143,7325 0
89384 7154M,7153,7143 0
89389 7324,7143,7153,7325,7154M 0
89431 7147M
89432 7145M
89439 7145M
89440 7146M
89551 7147M
89729 7145M
89731 7147M
91290 7147M
91913 7146M
91914 7146M
91915 7146M
91916 7146M
91917 7146M
91918 7146M
91919 7146M