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 (
    98432, 98433, 98434, 98435, 98436, 98437, 
    98438, 98439, 98440, 98441, 98442, 
    98443, 98446, 98447, 98449, 98450, 
    98451, 98452, 98453, 98455, 98456, 
    98476, 98477, 98478, 98479, 98480, 
    98481, 98482, 98483, 98484
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.00161

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "61.59"
    },
    "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": 108,
            "rows_produced_per_join": 108,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "11.10",
              "eval_cost": "10.80",
              "prefix_cost": "21.90",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (98432,98433,98434,98435,98436,98437,98438,98439,98440,98441,98442,98443,98446,98447,98449,98450,98451,98452,98453,98455,98456,98476,98477,98478,98479,98480,98481,98482,98483,98484))"
          }
        },
        {
          "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": "27.00",
              "eval_cost": "0.54",
              "prefix_cost": "59.70",
              "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.35",
              "eval_cost": "0.54",
              "prefix_cost": "61.59",
              "data_read_per_join": "86"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
98432 7313,7338,7219M
98433 7341,7342,7343,7157M
98434 7313,7338,7219M
98435 7341,7342,7343,7157M
98436 7313,7338,7219M
98437 7313,7338,7219M
98438 7313,7338,7219M
98439 7341,7342,7343,7157M
98440 7341,7342,7343,7157M
98441 7341,7342,7343,7157M
98442 7313,7338,7219M
98443 7341,7342,7343,7157M
98446 7313,7338,7219M
98447 7341,7342,7343,7157M
98449 7313,7338,7219M
98450 7313,7338,7219M
98451 7341,7342,7343,7157M
98452 7313,7338,7219M
98453 7341,7342,7343,7157M
98455 7313,7338,7219M
98456 7341,7342,7343,7157M
98476 7341,7342,7343,7157M
98477 7341,7342,7343,7157M
98478 7341,7342,7343,7157M
98479 7341,7342,7343,7157M
98480 7341,7342,7343,7157M
98481 7341,7342,7343,7157M
98482 7182,7300,7149M
98483 7341,7342,7343,7157M
98484 7341,7342,7343,7157M