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 (
    90034, 90035, 90036, 90037, 87864, 87866, 
    90042, 90043, 90044, 90045, 90046, 
    90047, 90058, 90059, 84039, 84230, 
    84042, 88098, 84233, 87831, 87844, 
    90014, 90015, 90016, 90017, 90026, 
    90027, 90028, 90029, 90030, 90031, 
    87850, 88096, 87860, 87884, 87886, 
    87862, 88315, 91431, 87829, 87842, 
    87848, 87858, 88314, 87863, 87865, 
    87827, 87840
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.02542

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "62.38"
    },
    "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": 69,
            "rows_produced_per_join": 69,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "7.18",
              "eval_cost": "6.90",
              "prefix_cost": "14.08",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (90034,90035,90036,90037,87864,87866,90042,90043,90044,90045,90046,90047,90058,90059,84039,84230,84042,88098,84233,87831,87844,90014,90015,90016,90017,90026,90027,90028,90029,90030,90031,87850,88096,87860,87884,87886,87862,88315,91431,87829,87842,87848,87858,88314,87863,87865,87827,87840))"
          }
        },
        {
          "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": 69,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "17.25",
              "eval_cost": "6.90",
              "prefix_cost": "38.23",
              "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": 3,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "17.25",
              "eval_cost": "0.35",
              "prefix_cost": "62.38",
              "data_read_per_join": "9K"
            },
            "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
84039 7252M
84042 7252M
84230 7253M,7331
84233 7331,7253M
87827 7252M
87829 7252M
87831 7252M
87840 7331,7253M
87842 7331,7253M
87844 7331,7253M
87848 7252M
87850 7252M
87858 7331,7253M
87860 7331,7253M
87862 7331,7253M
87863 7331,7253M
87864 7331,7253M
87865 7252M
87866 7252M
87884 7196M,7195 0
87886 7196M,7195 0
88096 7331,7253M
88098 7252M
88314 7222M
88315 7222M
90014 7286M
90015 7286M
90016 7286M
90017 7286M
90026 7286M
90027 7287M
90028 7287M
90029 7287M
90030 7287M
90031 7287M
90034 7287M
90035 7287M
90036 7287M
90037 7287M
90042 7330,7285M
90043 7330,7285M
90044 7285M,7330
90045 7285M,7330
90046 7285M,7330
90047 7285M,7330
90058 7330,7285M
90059 7330,7285M
91431 7222M