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 (
    92909, 92910, 92911, 92912, 92934, 92935, 
    92936, 92937, 92938, 92939, 92940, 
    92941, 92942, 92943, 92944, 92945, 
    93016, 93017, 93018, 93019, 93020, 
    93021, 93022, 93023, 93024, 93025, 
    93026, 93027, 93028, 93029, 93030, 
    93031, 93032, 93033, 93034, 93035, 
    93036, 93037, 93038, 93039, 93040, 
    93041, 93042, 93043, 93044, 93045, 
    93046, 93047, 93048, 93049, 93050, 
    93051, 93052, 93053, 93054, 93055, 
    93056, 93057, 93058, 93059, 93060, 
    93061, 93062, 93063, 93064, 93065, 
    93066, 93067, 93068, 93069, 93070, 
    93280, 93281, 93282, 93283, 93284, 
    93285, 93286, 93287, 93288, 93289, 
    93290, 93291, 93294, 93338, 93339, 
    93359, 93360, 93361, 93523, 93524, 
    93525, 93526, 93527, 93528, 93781
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00239

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.23"
    },
    "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": 96,
      "rows_produced_per_join": 96,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "33.63",
        "eval_cost": "9.60",
        "prefix_cost": "43.23",
        "data_read_per_join": "162K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (92909,92910,92911,92912,92934,92935,92936,92937,92938,92939,92940,92941,92942,92943,92944,92945,93016,93017,93018,93019,93020,93021,93022,93023,93024,93025,93026,93027,93028,93029,93030,93031,93032,93033,93034,93035,93036,93037,93038,93039,93040,93041,93042,93043,93044,93045,93046,93047,93048,93049,93050,93051,93052,93053,93054,93055,93056,93057,93058,93059,93060,93061,93062,93063,93064,93065,93066,93067,93068,93069,93070,93280,93281,93282,93283,93284,93285,93286,93287,93288,93289,93290,93291,93294,93338,93339,93359,93360,93361,93523,93524,93525,93526,93527,93528,93781)) 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
92909 bin803 7184/7186
92910 bin803f 7184/7186
92911 bin821 7184/7185
92912 bin821f 7184/7185
92934 can303 7184/7186
92935 can304 7184/7185
92936 can403 7184/7186
92937 can404 7184/7185
92938 can803 7184/7186
92939 can804 7184/7185
92940 car303 7184/7186
92941 car304 7184/7185
92942 car403 7184/7186
92943 car404 7184/7185
92944 car803 7184/7186
92945 car804 7184/7185
93016 che300bc 7184/7186
93017 che300bco 7184/7186
93018 che300bg 7184/7186
93019 che300bn 7184/7186
93020 che300co 7184/7186
93021 che300g 7184/7186
93022 che300n 7184/7186
93023 che301 7184/7186
93024 che301bc 7184/7186
93025 che301bco 7184/7186
93026 che301bg 7184/7186
93027 che301bn 7184/7186
93028 che301co 7184/7186
93029 che301g 7184/7186
93030 che301n 7184/7186
93031 che303 7184/7186
93032 che303bc 7184/7186
93033 che303bco 7184/7186
93034 che303bg 7184/7186
93035 che303bn 7184/7186
93036 che303co 7184/7186
93037 che303g 7184/7186
93038 che303n 7184/7186
93039 che306 7184/7188
93040 che306bc 7184/7188
93041 che306bco 7184/7188
93042 che306bg 7184/7188
93043 che306bn 7184/7188
93044 che306co 7184/7188
93045 che306g 7184/7188
93046 che306n 7184/7188
93047 che308bc 7184/7186
93048 che308bco 7184/7186
93049 che308bg 7184/7186
93050 che308bn 7184/7186
93051 che308co 7184/7186
93052 che308g 7184/7186
93053 che308n 7184/7186
93054 che321 7184/7185
93055 che321bc 7184/7185
93056 che321bco 7184/7185
93057 che321bg 7184/7185
93058 che321bn 7184/7185
93059 che321co 7184/7185
93060 che321g 7184/7185
93061 che321n 7184/7185
93062 che333 7184/7186
93063 che333bc 7184/7186
93064 che333bco 7184/7186
93065 che333bg 7184/7186
93066 che333bn 7184/7186
93067 che333co 7184/7186
93068 che333g 7184/7186
93069 che333n 7184/7186
93070 che375 7184/7185
93280 dty303 7184/7186
93281 dty304 7184/7185
93282 e1521 7184/7219
93283 e1527 7148/7156/7157
93284 e321 7184/7219
93285 e327e 7148/7156/7157
93286 e421 7184/7219
93287 e427e 7148/7156/7157
93288 e721 7184/7219
93289 e727e 7148/7156/7157
93290 e821 7184/7219
93291 e827e 7148/7156/7157
93294 ek1510 7184/7219
93338 er407 7184/7219
93339 er807 7184/7219
93359 hal303 7184/7186
93360 hal403 7184/7186
93361 hal803 7184/7186
93523 kal303 7184/7186
93524 kal304 7184/7185
93525 kal403 7184/7186
93526 kal404 7184/7185
93527 kal803 7184/7186
93528 kal804 7184/7185
93781 nav303 7184/7186