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 = 7195 
WHERE 
  cscart_products_categories.product_id IN (
    97272, 97273, 97274, 97275, 97276, 97277, 
    97278, 97279, 97280, 97281, 97282, 
    97283, 97284, 97285, 97286, 97287, 
    97288, 97289, 97290, 97291, 97292, 
    97293, 97294, 97295, 97296, 97297, 
    97298, 97299, 97300, 97301, 97302, 
    97303, 97304, 97305, 97306, 97307, 
    97308, 97309, 97310, 97311, 97312, 
    97313, 97314, 97315, 97316, 97317, 
    97318, 97319, 97320, 97321, 97322, 
    97323, 97324, 97325, 97326, 97327, 
    97328, 97329, 97330, 97331, 97332, 
    97333, 97334, 97335, 97336, 97337, 
    97338, 97339, 97340, 97341, 97342, 
    97343, 97344, 97345, 97346, 97347, 
    97348, 97349, 97350, 97351, 97352, 
    97353, 97354, 97355, 97356, 97357, 
    97358, 97359, 97360, 97361, 97362, 
    97363, 97364, 97365, 97366, 97367
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01634

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "86.69"
    },
    "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": 96,
            "rows_produced_per_join": 96,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "9.89",
              "eval_cost": "9.60",
              "prefix_cost": "19.49",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (97272,97273,97274,97275,97276,97277,97278,97279,97280,97281,97282,97283,97284,97285,97286,97287,97288,97289,97290,97291,97292,97293,97294,97295,97296,97297,97298,97299,97300,97301,97302,97303,97304,97305,97306,97307,97308,97309,97310,97311,97312,97313,97314,97315,97316,97317,97318,97319,97320,97321,97322,97323,97324,97325,97326,97327,97328,97329,97330,97331,97332,97333,97334,97335,97336,97337,97338,97339,97340,97341,97342,97343,97344,97345,97346,97347,97348,97349,97350,97351,97352,97353,97354,97355,97356,97357,97358,97359,97360,97361,97362,97363,97364,97365,97366,97367))"
          }
        },
        {
          "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": 96,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "24.00",
              "eval_cost": "9.60",
              "prefix_cost": "53.09",
              "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": "24.00",
              "eval_cost": "0.48",
              "prefix_cost": "86.69",
              "data_read_per_join": "12K"
            },
            "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
97272 7254M
97273 7254M
97274 7254M
97275 7254M
97276 7254M
97277 7254M
97278 7254M
97279 7254M
97280 7254M
97281 7254M
97282 7254M
97283 7254M
97284 7254M
97285 7254M
97286 7254M
97287 7254M
97288 7254M
97289 7254M
97290 7254M
97291 7254M
97292 7254M
97293 7254M
97294 7254M
97295 7254M
97296 7254M
97297 7254M
97298 7254M
97299 7254M
97300 7254M
97301 7254M
97302 7254M
97303 7254M
97304 7254M
97305 7254M
97306 7254M
97307 7254M
97308 7254M
97309 7254M
97310 7254M
97311 7254M
97312 7254M
97313 7254M
97314 7254M
97315 7254M
97316 7254M
97317 7254M
97318 7254M
97319 7254M
97320 7254M
97321 7254M
97322 7254M
97323 7254M
97324 7254M
97325 7254M
97326 7254M
97327 7254M
97328 7254M
97329 7254M
97330 7254M
97331 7254M
97332 7254M
97333 7254M
97334 7254M
97335 7254M
97336 7254M
97337 7254M
97338 7254M
97339 7254M
97340 7254M
97341 7254M
97342 7254M
97343 7254M
97344 7254M
97345 7254M
97346 7254M
97347 7254M
97348 7254M
97349 7254M
97350 7254M
97351 7254M
97352 7254M
97353 7254M
97354 7254M
97355 7254M
97356 7254M
97357 7254M
97358 7254M
97359 7254M
97360 7254M
97361 7254M
97362 7254M
97363 7254M
97364 7254M
97365 7254M
97366 7254M
97367 7254M