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 = 7204 
WHERE 
  cscart_products_categories.product_id IN (
    84715, 92161, 92162, 92163, 92164, 92165, 
    92166, 84714, 84713, 84712, 84711, 
    84710, 87918, 87919, 87920, 87924, 
    87926, 87930, 87931, 87932, 84940, 
    84941, 87898, 87899, 87902, 84728, 
    84729, 84730, 84731, 84732, 84733, 
    87921, 87923, 87933, 87935, 84720, 
    84723, 84727, 84939, 84734, 84735, 
    84938, 84719, 84722, 84724, 84744, 
    84718, 84721, 84937, 84936, 87922, 
    87928, 87934, 84856, 84857, 84949, 
    84950, 84690, 84748, 87905, 84691, 
    87894, 84847, 84854, 84855, 87906, 
    84689, 84945, 84946, 84754, 84755, 
    84943, 84944, 87904, 87910, 87911, 
    87912, 87896, 88034, 84958, 87892, 
    87897, 84952, 84953, 87909, 87916, 
    87891, 87895, 87903, 87908, 87914, 
    84746, 87893, 87963, 84959, 87913
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01135

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "88.49"
    },
    "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": 98,
            "rows_produced_per_join": 98,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "10.10",
              "eval_cost": "9.80",
              "prefix_cost": "19.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 (84715,92161,92162,92163,92164,92165,92166,84714,84713,84712,84711,84710,87918,87919,87920,87924,87926,87930,87931,87932,84940,84941,87898,87899,87902,84728,84729,84730,84731,84732,84733,87921,87923,87933,87935,84720,84723,84727,84939,84734,84735,84938,84719,84722,84724,84744,84718,84721,84937,84936,87922,87928,87934,84856,84857,84949,84950,84690,84748,87905,84691,87894,84847,84854,84855,87906,84689,84945,84946,84754,84755,84943,84944,87904,87910,87911,87912,87896,88034,84958,87892,87897,84952,84953,87909,87916,87891,87895,87903,87908,87914,84746,87893,87963,84959,87913))"
          }
        },
        {
          "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": 98,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "24.50",
              "eval_cost": "9.80",
              "prefix_cost": "54.20",
              "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.50",
              "eval_cost": "0.49",
              "prefix_cost": "88.50",
              "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
84689 7205M
84690 7205M
84691 7206M
84710 7205M
84711 7205M
84712 7205M
84713 7206M
84714 7206M
84715 7206M
84718 7205M
84719 7205M
84720 7205M
84721 7205M
84722 7205M
84723 7205M
84724 7205M
84727 7205M
84728 7205M
84729 7205M
84730 7205M
84731 7205M
84732 7205M
84733 7205M
84734 7205M
84735 7205M
84744 7205M
84746 7205M
84748 7206M
84754 7205M
84755 7205M
84847 7205M
84854 7205M
84855 7205M
84856 7206M
84857 7206M
84936 7205M
84937 7205M
84938 7206M
84939 7206M
84940 7205M
84941 7206M
84943 7205M
84944 7205M
84945 7206M
84946 7206M
84949 7205M
84950 7205M
84952 7205M
84953 7205M
84958 7205M
84959 7206M
87891 7255M
87892 7255M
87893 7255M
87894 7255M
87895 7255M
87896 7255M
87897 7255M
87898 7255M
87899 7255M
87902 7255M
87903 7255M
87904 7262,7256M
87905 7262,7256M
87906 7255M
87908 7255M
87909 7255M
87910 7255M
87911 7255M
87912 7255M
87913 7255M
87914 7255M
87916 7255M
87918 7255M
87919 7255M
87920 7255M
87921 7255M
87922 7255M
87923 7255M
87924 7255M
87926 7255M
87928 7255M
87930 7255M
87931 7255M
87932 7255M
87933 7255M
87934 7255M
87935 7255M
87963 7205M
88034 7255M
92161 7205M
92162 7205M
92163 7205M
92164 7205M
92165 7205M
92166 7205M