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 (
    96349, 96537, 96559, 96560, 96561, 96842, 
    96843, 96844, 96845, 96846, 96847, 
    97057, 97058, 97059, 97060, 97061, 
    97062, 97063, 97064, 97065, 97066, 
    97067, 97068, 97069, 97070, 97071, 
    97072, 97073, 97074, 97075
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00094

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "13.52"
    },
    "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": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "10.52",
        "eval_cost": "3.00",
        "prefix_cost": "13.52",
        "data_read_per_join": "50K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (96349,96537,96559,96560,96561,96842,96843,96844,96845,96846,96847,97057,97058,97059,97060,97061,97062,97063,97064,97065,97066,97067,97068,97069,97070,97071,97072,97073,97074,97075)) 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
96349 sy-fsb403-a 7195/7254
96537 237bla17-p 7195/7251/7253
96559 237cas152-p 7195/7251/7253
96560 237cas1752-p 7195/7251/7253
96561 237cas182-p 7195/7251/7253
96842 aqven6121-p 7195/7222
96843 aqven6130-p 7195/7222
96844 aqven6135-p 7195/7222
96845 aqven6137-p 7195/7222
96846 aqven6139-p 7195/7222
96847 aqven6140-p 7195/7222
97057 asb1500-p 7195/7251/7253
97058 asb1700-p 7195/7251/7253
97059 baa001-m 7195/7254
97060 baa001s-m 7195/7254
97061 bab005-p 7195/7254
97062 bab005b-p 7195/7254
97063 bab005bs-m 7195/7254
97064 bab005f-p 7195/7254
97065 bab005fs-m 7195/7254
97066 bab005gm-p 7195/7254
97067 bab005gms-m 7195/7254
97068 bab005ig-p 7195/7254
97069 bab005igs-m 7195/7254
97070 bab005kg-p 7195/7254
97071 bab005kgs-m 7195/7254
97072 bab005m-p 7195/7254
97073 bab005me-p 7195/7254
97074 bab005mes-m 7195/7254
97075 bab005ms-m 7195/7254