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 = 7228 
WHERE 
  cscart_products_categories.product_id IN (
    98590, 98591, 98592, 98593, 98594, 98595, 
    98596, 98597, 98598, 98599, 98600, 
    98601, 98602, 98603, 98604, 98605, 
    98606, 98607, 98608, 98609, 98610, 
    98611, 98612, 98613, 98614, 98615, 
    98616, 98617, 98618, 98619, 98620, 
    98621, 98622, 98623, 98624, 98625, 
    98626, 98627, 98628, 98629, 98630, 
    98631, 98632, 98633, 98634, 98635, 
    98636, 98637, 98638, 98639, 98640, 
    98641, 98642, 98643, 98644, 98645, 
    98646, 98647, 98648, 98649, 98650, 
    98651, 98652, 98653, 98654, 98655, 
    98656, 98657, 98658, 98659, 98660, 
    98661, 98662, 98663, 98664, 98665, 
    98666, 98667, 98668, 98669, 98670, 
    98671, 98672, 98673, 98674, 98675, 
    98676, 98677, 98678, 98679, 98680, 
    98681, 98760, 98761, 99012, 99013
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01665

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "86.69"
    },
    "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": 96,
            "rows_produced_per_join": 96,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "9.89",
              "eval_cost": "9.60",
              "prefix_cost": "19.49",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (98590,98591,98592,98593,98594,98595,98596,98597,98598,98599,98600,98601,98602,98603,98604,98605,98606,98607,98608,98609,98610,98611,98612,98613,98614,98615,98616,98617,98618,98619,98620,98621,98622,98623,98624,98625,98626,98627,98628,98629,98630,98631,98632,98633,98634,98635,98636,98637,98638,98639,98640,98641,98642,98643,98644,98645,98646,98647,98648,98649,98650,98651,98652,98653,98654,98655,98656,98657,98658,98659,98660,98661,98662,98663,98664,98665,98666,98667,98668,98669,98670,98671,98672,98673,98674,98675,98676,98677,98678,98679,98680,98681,98760,98761,99012,99013))"
          }
        },
        {
          "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": 96,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "24.00",
              "eval_cost": "9.60",
              "prefix_cost": "53.09",
              "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.00",
              "eval_cost": "0.48",
              "prefix_cost": "86.69",
              "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
98590 7229M
98591 7229M
98592 7229M
98593 7229M
98594 7229M
98595 7229M
98596 7229M
98597 7229M
98598 7229M
98599 7229M
98600 7231M
98601 7231M
98602 7234M
98603 7231M
98604 7229M
98605 7229M
98606 7234M
98607 7231M
98608 7234M
98609 7231M
98610 7234M
98611 7231M
98612 7231M
98613 7231M
98614 7229M
98615 7229M
98616 7231M
98617 7229M
98618 7229M
98619 7229M
98620 7229M
98621 7229M
98622 7229M
98623 7229M
98624 7229M
98625 7234M
98626 7231M
98627 7234M
98628 7231M
98629 7234M
98630 7231M
98631 7231M
98632 7231M
98633 7231M
98634 7234M
98635 7231M
98636 7234M
98637 7231M
98638 7234M
98639 7231M
98640 7231M
98641 7231M
98642 7234M
98643 7234M
98644 7231M
98645 7231M
98646 7231M
98647 7231M
98648 7234M
98649 7231M
98650 7231M
98651 7229M
98652 7231M
98653 7231M
98654 7234M
98655 7234M
98656 7234M
98657 7231M
98658 7231M
98659 7231M
98660 7234M
98661 7231M
98662 7234M
98663 7231M
98664 7234M
98665 7231M
98666 7231M
98667 7231M
98668 7231M
98669 7231M
98670 7234M
98671 7231M
98672 7231M
98673 7231M
98674 7231M
98675 7231M
98676 7231M
98677 7231M
98678 7231M
98679 7231M
98680 7231M
98681 7229M
98760 7229M
98761 7229M
99012 7229M
99013 7229M