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 (
    90699, 90703, 90707, 90640, 90641, 90649, 
    90683, 90689, 90733, 90842, 90625, 
    90631, 90596, 90597, 90602, 90603, 
    90708, 90710, 90682, 90688, 90624, 
    90630, 90696, 90697, 90701, 90705, 
    90673, 90679, 90638, 90639, 90647, 
    90615, 90621, 90672, 90678, 90651, 
    90686, 90614, 90620, 90628, 90694, 
    90695, 90636, 90637, 90645, 90663, 
    90669, 90605, 90611, 90662, 90668, 
    90604, 90610, 90650, 90676, 90692, 
    90693, 90653, 90659, 90618, 90634, 
    90635, 90643, 90595, 90601, 90652, 
    90658, 90594, 90600, 90666, 90608, 
    84041, 84232, 84044, 84235, 90656, 
    84236, 90598, 84043, 90048, 90049, 
    90050, 90051, 90052, 90053, 84040, 
    84231, 84234, 88316, 88100, 90018, 
    90019, 90020, 90021, 90032, 90033
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.00677

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "131.15"
    },
    "grouping_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "6.96"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "ALL",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "p_category_id"
            ],
            "rows_examined_per_scan": 208,
            "rows_produced_per_join": 8,
            "filtered": "4.00",
            "cost_info": {
              "read_cost": "20.72",
              "eval_cost": "0.83",
              "prefix_cost": "21.55",
              "data_read_per_join": "21K"
            },
            "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": "cscart_products_categories",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "link_type",
              "pt"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "ref": [
              "nuie_scalesta_net.cscart_categories.category_id"
            ],
            "rows_examined_per_scan": 117,
            "rows_produced_per_join": 6,
            "filtered": "0.71",
            "cost_info": {
              "read_cost": "2.33",
              "eval_cost": "0.70",
              "prefix_cost": "121.75",
              "data_read_per_join": "111"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (90699,90703,90707,90640,90641,90649,90683,90689,90733,90842,90625,90631,90596,90597,90602,90603,90708,90710,90682,90688,90624,90630,90696,90697,90701,90705,90673,90679,90638,90639,90647,90615,90621,90672,90678,90651,90686,90614,90620,90628,90694,90695,90636,90637,90645,90663,90669,90605,90611,90662,90668,90604,90610,90650,90676,90692,90693,90653,90659,90618,90634,90635,90643,90595,90601,90652,90658,90594,90600,90666,90608,84041,84232,84044,84235,90656,84236,90598,84043,90048,90049,90050,90051,90052,90053,84040,84231,84234,88316,88100,90018,90019,90020,90021,90032,90033))"
          }
        },
        {
          "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": 6,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "1.74",
              "eval_cost": "0.70",
              "prefix_cost": "124.19",
              "data_read_per_join": "111"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
84040 7252M
84041 7252M
84043 7252M
84044 7252M
84231 7253M,7331
84232 7253M,7331
84234 7253M,7331
84235 7253M,7331
84236 7253M,7331
88100 7252M
88316 7222M
90018 7286M
90019 7286M
90020 7286M
90021 7286M
90032 7287M
90033 7287M
90048 7285M,7330
90049 7285M,7330
90050 7285M,7330
90051 7285M,7330
90052 7285M,7330
90053 7285M,7330
90594 7253M,7331
90595 7253M,7331
90596 7253M,7331
90597 7253M,7331
90598 7253M,7331
90600 7253M,7331
90601 7253M,7331
90602 7253M,7331
90603 7253M,7331
90604 7253M,7331
90605 7253M,7331
90608 7253M,7331
90610 7253M,7331
90611 7253M,7331
90614 7253M,7331
90615 7253M,7331
90618 7253M,7331
90620 7253M,7331
90621 7253M,7331
90624 7253M,7331
90625 7253M,7331
90628 7253M,7331
90630 7253M,7331
90631 7253M,7331
90634 7253M,7331
90635 7253M,7331
90636 7253M,7331
90637 7253M,7331
90638 7253M,7331
90639 7253M,7331
90640 7253M,7331
90641 7253M,7331
90643 7253M,7331
90645 7253M,7331
90647 7253M,7331
90649 7253M,7331
90650 7253M,7331
90651 7253M,7331
90652 7253M,7331
90653 7253M,7331
90656 7253M,7331
90658 7253M,7331
90659 7253M,7331
90662 7253M,7331
90663 7253M,7331
90666 7253M,7331
90668 7253M,7331
90669 7253M,7331
90672 7253M,7331
90673 7253M,7331
90676 7253M,7331
90678 7253M,7331
90679 7253M,7331
90682 7253M,7331
90683 7253M,7331
90686 7253M,7331
90688 7253M,7331
90689 7253M,7331
90692 7253M,7331
90693 7253M,7331
90694 7253M,7331
90695 7253M,7331
90696 7253M,7331
90697 7253M,7331
90699 7253M,7331
90701 7253M,7331
90703 7253M,7331
90705 7253M,7331
90707 7253M,7331
90708 7253M,7331
90710 7253M,7331
90733 7195,7196M 0
90842 7196M