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 = 7251 
WHERE 
  cscart_products_categories.product_id IN (
    90661, 90698, 90699, 90703, 90707, 90640, 
    90641, 90649, 90683, 90689, 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
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01507

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 (90661,90698,90699,90703,90707,90640,90641,90649,90683,90689,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))"
          }
        },
        {
          "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
90596 7253M,7331
90597 7253M,7331
90602 7331,7253M
90603 7331,7253M
90605 7253M,7331
90614 7253M,7331
90615 7331,7253M
90620 7331,7253M
90621 7331,7253M
90624 7331,7253M
90625 7331,7253M
90628 7331,7253M
90630 7253M,7331
90631 7253M,7331
90636 7253M,7331
90637 7253M,7331
90638 7253M,7331
90639 7253M,7331
90640 7253M,7331
90641 7253M,7331
90645 7253M,7331
90647 7331,7253M
90649 7331,7253M
90651 7331,7253M
90661 7331,7253M
90663 7331,7253M
90669 7331,7253M
90672 7253M,7331
90673 7253M,7331
90678 7331,7253M
90679 7331,7253M
90682 7331,7253M
90683 7331,7253M
90686 7331,7253M
90688 7331,7253M
90689 7331,7253M
90694 7331,7253M
90695 7253M,7331
90696 7253M,7331
90697 7253M,7331
90698 7253M,7331
90699 7253M,7331
90701 7331,7253M
90703 7253M,7331
90705 7253M,7331
90707 7331,7253M
90708 7331,7253M
90710 7253M,7331