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 = 7257 
WHERE 
  cscart_products_categories.product_id IN (
    88077, 88141, 88144, 88939, 87986, 87946, 
    87947, 87949, 88043, 87956, 89982, 
    89983, 89984, 88081, 84702, 84705, 
    91052, 88003, 88046, 88080, 84697, 
    84698, 88028, 88140, 88143, 88508, 
    87890, 84695, 88937, 87877
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01525

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "74.99"
    },
    "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": 83,
            "rows_produced_per_join": 83,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "8.59",
              "eval_cost": "8.30",
              "prefix_cost": "16.89",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (88077,88141,88144,88939,87986,87946,87947,87949,88043,87956,89982,89983,89984,88081,84702,84705,91052,88003,88046,88080,84697,84698,88028,88140,88143,88508,87890,84695,88937,87877))"
          }
        },
        {
          "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": 83,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "20.75",
              "eval_cost": "8.30",
              "prefix_cost": "45.94",
              "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": "20.75",
              "eval_cost": "0.42",
              "prefix_cost": "74.99",
              "data_read_per_join": "10K"
            },
            "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
84695 7208M,7309,7241,7346
84697 7208M,7309,7241,7346
84698 7346,7208M,7241,7309
84702 7346,7208M,7309,7241
84705 7309,7346,7208M,7241
87877 7309,7241,7208M,7346
87890 7309,7346,7241,7208M
87946 7258M
87947 7258M
87949 7258M
87956 7258M
87986 7258M
88003 7258M
88028 7258M
88043 7258M
88046 7345,7347,7259M
88077 7258M
88080 7258M
88081 7258M
88140 7346,7241,7309,7208M
88141 7346,7241,7208M,7309
88143 7208M,7241,7309,7346
88144 7346,7208M,7309,7241
88508 7309,7346,7241,7208M
88937 7208M,7309,7241,7346
88939 7241,7208M,7309,7346
89982 7347,7345,7259M
89983 7345,7259M,7347
89984 7345,7259M,7347
91052 7208M,7309,7241,7346