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_seo_names.object_id AS product_id, 
  cscart_seo_names.name AS seo_name, 
  cscart_seo_names.path AS seo_path 
FROM 
  cscart_seo_names 
WHERE 
  cscart_seo_names.object_id IN (
    92503, 92504, 92505, 92506, 92507, 92192, 
    92193, 92194, 92195, 92196, 92204, 
    92205, 92206, 92207, 92208, 92209, 
    92442, 92443, 92448, 92147, 92148, 
    92149, 92349, 92350, 92351, 92352, 
    89643, 89646, 89524, 83998, 84000, 
    84002, 84004, 84034, 90075, 90062, 
    84022, 84023, 84024, 84025, 84037, 
    89617, 89630, 83955, 83957, 83959, 
    83961, 92067
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00194

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.62"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code"
      ],
      "key_length": "206",
      "rows_examined_per_scan": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.82",
        "eval_cost": "4.80",
        "prefix_cost": "21.62",
        "data_read_per_join": "81K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (92503,92504,92505,92506,92507,92192,92193,92194,92195,92196,92204,92205,92206,92207,92208,92209,92442,92443,92448,92147,92148,92149,92349,92350,92351,92352,89643,89646,89524,83998,84000,84002,84004,84034,90075,90062,84022,84023,84024,84025,84037,89617,89630,83955,83957,83959,83961,92067)) and (`nuie_scalesta_net`.`cscart_seo_names`.`type` = 'p') and (`nuie_scalesta_net`.`cscart_seo_names`.`dispatch` = '') and (`nuie_scalesta_net`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
83955 white-topaz-with-lever-handle-wall-mounted-bath-filler 7184/7186
83957 white-topaz-with-crosshead-handle-wall-mounted-bath-filler 7184/7186
83959 white-topaz-with-lever-handle-wall-mounted-bath-filler-en 7184/7186
83961 white-topaz-with-crosshead-handle-wall-mounted-bath-filler-en 7184/7186
83998 black-topaz-with-lever-handle-deck-mounted-bath-filler 7184/7186
84000 black-topaz-with-crosshead-handle-deck-mounted-bath-filler 7184/7186
84002 black-topaz-with-lever-handle-deck-mounted-bath-filler-en 7184/7186
84004 black-topaz-with-crosshead-handle-deck-mounted-bath-filler-en 7184/7186
84022 black-topaz-with-lever-handle-3-tap-hole-basin-mixer 7184/7187
84023 black-topaz-with-crosshead-handle-3-tap-hole-basin-mixer 7184/7187
84024 black-topaz-with-lever-handle-3-tap-hole-basin-mixer-en 7184/7187
84025 black-topaz-with-crosshead-handle-3-tap-hole-basin-mixer-en 7184/7187
84034 brass-topaz-with-crosshead-handle-deck-mounted-bath-filler 7184/7186
84037 brass-topaz-with-crosshead-handle-3-tap-hole-basin-mixer 7184/7187
89524 sottile-bath-shower-mixer 7184/7185
89617 tec-lever-4-tap-hole-bath-mixer 7184/7186
89630 tec-crosshead-4-tap-hole-bath-mixer 7184/7187
89643 revolution-4-tap-bath-shower-mixer 7184/7186
89646 revolution-bath-shower-mixer 7184/7185
90062 willow-bath-shower-mixer 7184/7185
90075 windon-deck-mounted-5-tap-hole-bath-shower-mixer 7184/7185
92067 victrion-deck-mounted-lever-mono-bidet-mixer-tap-en 7184
92147 standpipes-traditional-cast-freestanding-bath-legs-660mm-x-40mm-en 7148
92148 standpipes-traditional-cast-freestanding-bath-legs-660mm-x-40mm-en-en 7148
92149 standpipes-traditional-cast-freestanding-bath-legs-660mm-x-40mm-en-en-en 7148
92192 bath-wastes-plug-and-chain-exposed-ext-bath-waste-en 7148
92193 bath-wastes-plug-and-chain-exposed-ext-bath-waste-en-en 7148
92194 bath-wastes-plug-and-chain-exposed-ext-bath-waste-en-en-en 7148
92195 bath-wastes-plug-and-chain-exposed-ext-bath-waste-en-en-en-en 7148
92196 bath-wastes-plug-and-chain-exposed-ext-bath-waste-en-en-en-en-en 7148
92204 bath-wastes-push-down-exposed-bath-waste-en 7148
92205 bath-wastes-push-down-exposed-bath-waste-en-en 7148
92206 bath-wastes-push-down-exposed-bath-waste-en-en-en 7148
92207 bath-wastes-push-down-exposed-bath-waste-en-en-en-en 7148
92208 bath-wastes-push-down-exposed-bath-waste-en-en-en-en-en 7148
92209 bath-wastes-push-down-exposed-bath-waste-en-en-en-en-en-en 7148
92349 standpipes-660x40-freestanding-legs 7148
92350 standpipes-660x40-freestanding-legs-en 7148
92351 standpipes-660x40-freestanding-legs-en-en 7148
92352 standpipes-660x40-freestanding-legs-en-en-en 7148
92442 plug-and-chain-exposed-bath-waste 7148
92443 plug-and-chain-exposed-bath-waste-en 7148
92448 push-down-exposed-bath-waste 7148
92503 extended-bath-filler-en-en-en 7148
92504 extended-bath-filler-en-en-en-en 7148
92505 extended-bath-filler-en-en-en-en-en 7148
92506 extended-bath-filler-en-en-en-en-en-en 7148
92507 extended-bath-filler-en-en-en-en-en-en-en 7148