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 (
    93787, 93788, 93798, 93799, 93800, 93801, 
    93802, 93803, 93804, 93805, 93806, 
    93807, 93808, 93809, 93810, 93811, 
    93812, 93813, 93814, 93815, 93816, 
    93817, 93818, 93832, 93833, 93834, 
    93835, 93836, 93837, 93838, 93839, 
    93840, 93841, 93882, 93883, 93884, 
    93885, 94367, 94368, 94369, 94370, 
    94371, 94372, 94373, 94374, 94375, 
    94376, 94377, 94378, 94379, 94380, 
    94438, 94463, 94464, 94465, 94466, 
    94467, 94468, 94469, 94470, 94471, 
    94472, 94473, 94474, 94475, 94476, 
    94477, 94478, 94479, 94480, 94481, 
    94482, 94483, 94589, 94590, 94591, 
    94811, 94812, 94820, 94821, 94959, 
    94960, 94961, 94962, 94963, 94964, 
    95360, 95394, 95395, 95396, 95397, 
    95398, 95399, 95400, 95401, 95424
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01937

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "102.90"
    },
    "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": 114,
            "rows_produced_per_join": 114,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "11.70",
              "eval_cost": "11.40",
              "prefix_cost": "23.10",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (93787,93788,93798,93799,93800,93801,93802,93803,93804,93805,93806,93807,93808,93809,93810,93811,93812,93813,93814,93815,93816,93817,93818,93832,93833,93834,93835,93836,93837,93838,93839,93840,93841,93882,93883,93884,93885,94367,94368,94369,94370,94371,94372,94373,94374,94375,94376,94377,94378,94379,94380,94438,94463,94464,94465,94466,94467,94468,94469,94470,94471,94472,94473,94474,94475,94476,94477,94478,94479,94480,94481,94482,94483,94589,94590,94591,94811,94812,94820,94821,94959,94960,94961,94962,94963,94964,95360,95394,95395,95396,95397,95398,95399,95400,95401,95424))"
          }
        },
        {
          "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": 114,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "28.50",
              "eval_cost": "11.40",
              "prefix_cost": "63.00",
              "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": "28.50",
              "eval_cost": "0.57",
              "prefix_cost": "102.90",
              "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
93787 7253M,7331
93788 7252M
93798 7254M
93799 7254M
93800 7254M
93801 7254M
93802 7254M
93803 7254M
93804 7254M
93805 7254M
93806 7254M
93807 7254M
93808 7254M
93809 7254M
93810 7254M
93811 7254M
93812 7254M
93813 7254M
93814 7254M
93815 7254M
93816 7254M
93817 7254M
93818 7254M
93832 7222M
93833 7222M
93834 7285M,7330
93835 7285M,7330
93836 7222M
93837 7222M
93838 7222M
93839 7222M
93840 7222M
93841 7222M
93882 7285M,7330
93883 7285M,7330
93884 7285M,7330
93885 7285M,7330
94367 7252M
94368 7252M
94369 7252M
94370 7252M
94371 7252M
94372 7253M,7331
94373 7253M,7331
94374 7253M,7331
94375 7253M,7331
94376 7253M,7331
94377 7253M,7331
94378 7253M,7331
94379 7253M,7331
94380 7254M
94438 7254M
94463 7254M
94464 7254M
94465 7254M
94466 7254M
94467 7254M
94468 7254M
94469 7254M
94470 7254M
94471 7254M
94472 7254M
94473 7254M
94474 7254M
94475 7254M
94476 7254M
94477 7254M
94478 7254M
94479 7254M
94480 7254M
94481 7254M
94482 7254M
94483 7254M
94589 7222M
94590 7222M
94591 7222M
94811 7254M
94812 7254M
94820 7222M
94821 7222M
94959 7222M
94960 7222M
94961 7222M
94962 7222M
94963 7222M
94964 7222M
95360 7287M
95394 7222M
95395 7222M
95396 7222M
95397 7222M
95398 7222M
95399 7253M,7331
95400 7253M,7331
95401 7253M,7331
95424 7222M