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 (
    99033, 99034, 99035, 99036, 99037, 99038, 
    99039, 99040, 99041, 99042, 99043, 
    99044, 99045, 99046, 99047, 99048, 
    99049, 99050, 99051, 99052, 99053, 
    99054, 99055, 99189, 99190, 99191, 
    99239, 99282, 99283, 99284, 99285, 
    99286, 99287, 99288, 99289, 99290, 
    99291, 99292, 99293, 99294, 99295, 
    99296, 99297, 99298, 99299, 99300, 
    99301, 99302, 99303, 99304, 99305, 
    99306, 99307, 99308, 99309, 99310, 
    99311, 99312, 99319, 99320, 99321, 
    99356, 99357, 99358, 99359, 99360, 
    99361, 99362, 99363, 99364, 99365, 
    99366, 99367, 99368, 99374, 99375, 
    99376, 99377, 99378, 99379, 99380, 
    99381, 99382, 99383, 99384, 99385, 
    99386, 99387, 99388, 99389, 99390, 
    99391, 99392, 99393, 99394, 99395
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.02104

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "100.20"
    },
    "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": 111,
            "rows_produced_per_join": 111,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "11.40",
              "eval_cost": "11.10",
              "prefix_cost": "22.50",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (99033,99034,99035,99036,99037,99038,99039,99040,99041,99042,99043,99044,99045,99046,99047,99048,99049,99050,99051,99052,99053,99054,99055,99189,99190,99191,99239,99282,99283,99284,99285,99286,99287,99288,99289,99290,99291,99292,99293,99294,99295,99296,99297,99298,99299,99300,99301,99302,99303,99304,99305,99306,99307,99308,99309,99310,99311,99312,99319,99320,99321,99356,99357,99358,99359,99360,99361,99362,99363,99364,99365,99366,99367,99368,99374,99375,99376,99377,99378,99379,99380,99381,99382,99383,99384,99385,99386,99387,99388,99389,99390,99391,99392,99393,99394,99395))"
          }
        },
        {
          "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": 111,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "27.75",
              "eval_cost": "11.10",
              "prefix_cost": "61.35",
              "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": 5,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "27.75",
              "eval_cost": "0.56",
              "prefix_cost": "100.20",
              "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')))"
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
99033 7253M,7331
99034 7253M,7331
99035 7253M,7331
99036 7252M
99037 7252M
99038 7252M
99039 7253M,7331
99040 7253M,7331
99041 7253M,7331
99042 7253M,7331
99043 7253M,7331
99044 7253M,7331
99045 7253M,7331
99046 7253M,7331
99047 7253M,7331
99048 7252M
99049 7252M
99050 7254M
99051 7254M
99052 7254M
99053 7254M
99054 7222M
99055 7222M
99189 7222M
99190 7222M
99191 7222M
99239 7222M
99282 7254M
99283 7254M
99284 7254M
99285 7254M
99286 7254M
99287 7254M
99288 7254M
99289 7254M
99290 7254M
99291 7254M
99292 7254M
99293 7254M
99294 7254M
99295 7254M
99296 7254M
99297 7254M
99298 7254M
99299 7254M
99300 7254M
99301 7254M
99302 7254M
99303 7254M
99304 7254M
99305 7254M
99306 7254M
99307 7254M
99308 7254M
99309 7254M
99310 7254M
99311 7254M
99312 7254M
99319 7253M,7331
99320 7252M
99321 7252M
99356 7222M
99357 7222M
99358 7222M
99359 7222M
99360 7222M
99361 7222M
99362 7222M
99363 7222M
99364 7222M
99365 7222M
99366 7222M
99367 7285M,7330
99368 7285M,7330
99374 7222M
99375 7222M
99376 7222M
99377 7222M
99378 7222M
99379 7222M
99380 7222M
99381 7222M
99382 7222M
99383 7222M
99384 7222M
99385 7222M
99386 7222M
99387 7222M
99388 7222M
99389 7222M
99390 7222M
99391 7222M
99392 7222M
99393 7222M
99394 7222M
99395 7222M