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 = 7184 
WHERE 
  cscart_products_categories.product_id IN (
    97221, 97222, 97223, 97224, 97225, 97226, 
    97227, 97567, 97570, 97573, 97576, 
    97577, 97578, 97579, 97580, 97582, 
    97583, 97584, 97585, 97586, 97833, 
    97841, 97842, 97843, 97844, 97845, 
    97846, 97847, 97848, 97849, 97850, 
    97851, 97852, 97853, 97854, 97855, 
    97856, 97857, 97858, 97859, 97860, 
    97861, 97862, 97863, 97864, 97865, 
    97866, 97867, 97868, 97869, 97870, 
    97871, 97872, 97873, 97874, 97875, 
    97876, 97877, 97878, 97879, 97880, 
    97881, 97882, 97883, 97884, 97885, 
    97886, 97887, 97888, 97889, 97890, 
    97891, 97892, 97893, 97894, 97895, 
    97896, 97897, 97898, 97899, 97900, 
    97901, 97902, 97903, 97904, 97905, 
    97906, 97907, 97908, 97909, 97910, 
    97911, 97912, 97913, 97914, 97915
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.00306

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "112.70"
    },
    "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": 198,
            "rows_produced_per_join": 198,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "20.13",
              "eval_cost": "19.80",
              "prefix_cost": "39.93",
              "data_read_per_join": "3K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (97221,97222,97223,97224,97225,97226,97227,97567,97570,97573,97576,97577,97578,97579,97580,97582,97583,97584,97585,97586,97833,97841,97842,97843,97844,97845,97846,97847,97848,97849,97850,97851,97852,97853,97854,97855,97856,97857,97858,97859,97860,97861,97862,97863,97864,97865,97866,97867,97868,97869,97870,97871,97872,97873,97874,97875,97876,97877,97878,97879,97880,97881,97882,97883,97884,97885,97886,97887,97888,97889,97890,97891,97892,97893,97894,97895,97896,97897,97898,97899,97900,97901,97902,97903,97904,97905,97906,97907,97908,97909,97910,97911,97912,97913,97914,97915))"
          }
        },
        {
          "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": 9,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "49.50",
              "eval_cost": "0.99",
              "prefix_cost": "109.23",
              "data_read_per_join": "25K"
            },
            "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": 9,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "2.48",
              "eval_cost": "0.99",
              "prefix_cost": "112.70",
              "data_read_per_join": "158"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
97221 7341,7342,7343,7157M
97222 7341,7342,7343,7157M
97223 7341,7342,7343,7157M
97224 7341,7342,7343,7157M
97225 7341,7342,7343,7157M
97226 7341,7342,7343,7157M
97227 7341,7342,7343,7157M
97567 7341,7342,7343,7157M
97570 7341,7342,7343,7157M
97573 7341,7342,7343,7157M
97576 7341,7342,7343,7157M
97577 7341,7342,7343,7157M
97578 7341,7342,7343,7157M
97579 7341,7342,7343,7157M
97580 7341,7342,7343,7157M
97582 7341,7342,7343,7157M
97583 7341,7342,7343,7157M
97584 7341,7342,7343,7157M
97585 7341,7342,7343,7157M
97586 7341,7342,7343,7157M
97833 7186M
97841 7185M
97842 7188M
97843 7186M
97844 7185M
97845 7185M
97846 7188M
97847 7186M
97848 7185M
97849 7185M
97850 7185M
97851 7188M
97852 7186M
97853 7185M
97854 7185M
97855 7188M
97856 7186M
97857 7185M
97858 7185M
97859 7188M
97860 7186M
97861 7185M
97862 7185M
97863 7188M
97864 7186M
97865 7185M
97866 7185M
97867 7188M
97868 7186M
97869 7185M
97870 7185M
97871 7188M
97872 7186M
97873 7185M
97874 7313,7338,7219M
97875 7341,7342,7343,7157M
97876 7341,7342,7343,7157M
97877 7341,7342,7343,7157M
97878 7341,7342,7343,7157M
97879 7341,7342,7343,7157M
97880 7341,7342,7343,7157M
97881 7341,7342,7343,7157M
97882 7341,7342,7343,7157M
97883 7313,7338,7219M
97884 7313,7338,7219M
97885 7313,7338,7219M
97886 7341,7342,7343,7157M
97887 7313,7338,7219M
97888 7341,7342,7343,7157M
97889 7313,7338,7219M
97890 7186M
97891 7186M
97892 7186M
97893 7186M
97894 7186M
97895 7186M
97896 7186M
97897 7186M
97898 7186M
97899 7186M
97900 7186M
97901 7186M
97902 7186M
97903 7185M
97904 7185M
97905 7185M
97906 7185M
97907 7185M
97908 7185M
97909 7185M
97910 7185M
97911 7188M
97912 7188M
97913 7188M
97914 7188M
97915 7186M