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 = 7251 
WHERE 
  cscart_products_categories.product_id IN (
    95733, 95734, 95735, 96153, 96170, 96171, 
    96172, 96173, 96174, 96175, 96537, 
    96559, 96560, 96561, 97057, 97058, 
    97953, 97954, 97955, 97956, 97957, 
    97958, 97994, 97995, 97996, 97997, 
    97998, 97999, 98000, 98496, 98497, 
    98498, 98499, 98500, 98501, 99026, 
    99027, 99028, 99029, 99030, 99032, 
    99033, 99034, 99035, 99036, 99037, 
    99038, 99039, 99040, 99041, 99042, 
    99043, 99044, 99045, 99046, 99047, 
    99048, 99049, 99319, 99320, 99321, 
    100413, 100428, 100429, 100430
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.00623

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "97.50"
    },
    "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 (95733,95734,95735,96153,96170,96171,96172,96173,96174,96175,96537,96559,96560,96561,97057,97058,97953,97954,97955,97956,97957,97958,97994,97995,97996,97997,97998,97999,98000,98496,98497,98498,98499,98500,98501,99026,99027,99028,99029,99030,99032,99033,99034,99035,99036,99037,99038,99039,99040,99041,99042,99043,99044,99045,99046,99047,99048,99049,99319,99320,99321,100413,100428,100429,100430))"
          }
        },
        {
          "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": 108,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "27.00",
              "eval_cost": "10.80",
              "prefix_cost": "59.70",
              "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.00",
              "eval_cost": "0.54",
              "prefix_cost": "97.50",
              "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
95733 7253M,7331
95734 7253M,7331
95735 7253M,7331
96153 7252M
96170 7253M,7331
96171 7253M,7331
96172 7253M,7331
96173 7253M,7331
96174 7252M
96175 7252M
96537 7253M,7331
96559 7253M,7331
96560 7253M,7331
96561 7253M,7331
97057 7253M,7331
97058 7253M,7331
97953 7252M
97954 7252M
97955 7252M
97956 7252M
97957 7252M
97958 7252M
97994 7253M,7331
97995 7253M,7331
97996 7253M,7331
97997 7253M,7331
97998 7253M,7331
97999 7253M,7331
98000 7253M,7331
98496 7253M,7331
98497 7253M,7331
98498 7253M,7331
98499 7253M,7331
98500 7253M,7331
98501 7253M,7331
99026 7252M
99027 7252M
99028 7252M
99029 7253M,7331
99030 7253M,7331
99032 7253M,7331
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
99319 7253M,7331
99320 7252M
99321 7252M
100413 7252M
100428 7253M,7331
100429 7252M
100430 7252M