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 = 7313 
WHERE 
  cscart_products_categories.product_id IN (
    91870, 91869, 91871, 91872, 91873, 91874, 
    91875, 85038, 92458, 92459, 92460, 
    92461, 92462, 92463, 92464, 92489, 
    92490, 92491, 92492, 92493, 92494, 
    92495, 86892, 92211, 92216, 92218, 
    92219, 92220, 92221, 92222
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.00124

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "64.43"
    },
    "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": 113,
            "rows_produced_per_join": 113,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "11.60",
              "eval_cost": "11.30",
              "prefix_cost": "22.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 (91870,91869,91871,91872,91873,91874,91875,85038,92458,92459,92460,92461,92462,92463,92464,92489,92490,92491,92492,92493,92494,92495,86892,92211,92216,92218,92219,92220,92221,92222))"
          }
        },
        {
          "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.25",
              "eval_cost": "0.57",
              "prefix_cost": "62.45",
              "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.41",
              "eval_cost": "0.57",
              "prefix_cost": "64.43",
              "data_read_per_join": "90"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
85038 7341,7342,7343,7157M
86892 7341,7342,7343,7157M
91869 7341,7342,7343,7157M
91870 7341,7342,7343,7157M
91871 7341,7342,7343,7157M
91872 7341,7342,7343,7157M
91873 7341,7342,7343,7157M
91874 7341,7342,7343,7157M
91875 7341,7342,7343,7157M
92211 7341,7342,7343,7157M
92216 7341,7342,7343,7157M
92218 7341,7342,7343,7157M
92219 7341,7342,7343,7157M
92220 7341,7342,7343,7157M
92221 7341,7342,7343,7157M
92222 7341,7342,7343,7157M
92458 7341,7342,7343,7157M
92459 7341,7342,7343,7157M
92460 7341,7342,7343,7157M
92461 7341,7342,7343,7157M
92462 7341,7342,7343,7157M
92463 7341,7342,7343,7157M
92464 7341,7342,7343,7157M
92489 7313,7338,7219M 0
92490 7313,7338,7219M 0
92491 7313,7338,7219M 0
92492 7313,7338,7219M 0
92493 7313,7338,7219M 0
92494 7313,7338,7219M 0
92495 7313,7338,7219M 0