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 (
    95726, 95727, 95728, 95729, 95730, 95731, 
    95732, 95733, 95734, 95735, 96122, 
    96124, 96125, 96126, 96127, 96128, 
    96129, 96131, 96132, 96133, 96134, 
    96135, 96136, 96137, 96138, 96139, 
    96140, 96141, 96142, 96143, 96144, 
    96145, 96146, 96147, 96148, 96149, 
    96150, 96151, 96152, 96153, 96154, 
    96155, 96156, 96157, 96158, 96159, 
    96160, 96161, 96162, 96163, 96164, 
    96165, 96166, 96167, 96168, 96169, 
    96170, 96171, 96172, 96173, 96174, 
    96175, 96189, 96195, 96196, 96197, 
    96198, 96199, 96200, 96201, 96209, 
    96212, 96349, 96537, 96559, 96560, 
    96561, 96842, 96843, 96844, 96845, 
    96846, 96847, 97057, 97058, 97059, 
    97060, 97061, 97062, 97063, 97064, 
    97065, 97066, 97067, 97068, 97069
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00229

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 (95726,95727,95728,95729,95730,95731,95732,95733,95734,95735,96122,96124,96125,96126,96127,96128,96129,96131,96132,96133,96134,96135,96136,96137,96138,96139,96140,96141,96142,96143,96144,96145,96146,96147,96148,96149,96150,96151,96152,96153,96154,96155,96156,96157,96158,96159,96160,96161,96162,96163,96164,96165,96166,96167,96168,96169,96170,96171,96172,96173,96174,96175,96189,96195,96196,96197,96198,96199,96200,96201,96209,96212,96349,96537,96559,96560,96561,96842,96843,96844,96845,96846,96847,97057,97058,97059,97060,97061,97062,97063,97064,97065,97066,97067,97068,97069)) 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
95726 ea106sv 7195/7254
95727 ea107mt 7195/7254
95728 em1500atg 7195/7251/7253
95729 em1500p 7195/7251/7253
95730 em1500p2 7195/7251/7253
95731 em1600p 7195/7251/7253
95732 em1600p2 7195/7251/7253
95733 em1700atg 7195/7251/7253
95734 em1700p 7195/7251/7253
95735 em1700p2 7195/7251/7253
96122 sy-bel15l 7195/7284/7285
96124 sy-bel15r 7195/7284/7285
96125 sy-bel17l 7195/7284/7285
96126 sy-bel17pan 7195/7284/7285
96127 sy-bel17r 7195/7284/7285
96128 sy-eag15lsf 7195/7196
96129 sy-eag15rsf 7195/7196
96131 sy-evsb17 7195/7284/7285
96132 sy-fsb200-a 7195/7254
96133 sy-fsb201-a 7195/7254
96134 sy-fsb202-a 7195/7254
96135 sy-fsb202blk-a 7195/7254
96136 sy-fsb202mw-a 7195/7254
96137 sy-fsb203-a 7195/7254
96138 sy-fsb204-a 7195/7254
96139 sy-fsb204mw-a 7195/7254
96140 sy-fsb207-a 7195/7254
96141 sy-fsb301-a 7195/7254
96142 sy-fsb302-a 7195/7254
96143 sy-fsb303-a 7195/7254
96144 sy-fsb304-a 7195/7254
96145 sy-fsb305-a 7195/7254
96146 sy-fsb306-a 7195/7254
96147 sy-fsb307-a 7195/7254
96148 sy-fsb308-a 7195/7254
96149 sy-fsb309-a 7195/7254
96150 sy-fsb309blk-a 7195/7254
96151 sy-fsb310-a 7195/7254
96152 sy-fsb310hg 7195/7254
96153 sy-fsb311-a 7195/7251/7252
96154 sy-fsb312-a 7195/7196
96155 sy-fsb321l-a 7195/7284/7285
96156 sy-fsb321r-a 7195/7284/7285
96157 sy-fsb351-a 7195/7254
96158 sy-fsb352-a 7195/7254
96159 sy-fsb353-a 7195/7254
96160 sy-fsb398-a 7195/7254
96161 sy-fsb399-a 7195/7254
96162 sy-fsb400-a 7195/7254
96163 sy-fsb401-a 7195/7254
96164 sy-fsb402-a 7195/7254
96165 sy-fsb405-a 7195/7254
96166 sy-fsb406-a 7195/7254
96167 sy-fsb407-a 7195/7254
96168 sy-fsb601-a 7195/7254
96169 sy-fsb601mw-a 7195/7254
96170 sy-m342 7195/7251/7253
96171 sy-m343 7195/7251/7253
96172 sy-m344 7195/7251/7253
96173 sy-m512 7195/7251/7253
96174 sy-psn13611-n 7195/7251/7252
96175 sy-psn71607-n 7195/7251/7252
96189 sy-vod38 7195/7222
96195 sy-zb15ls 7195/7284/7287
96196 sy-zb16ls 7195/7284/7287
96197 sy-zb16rs 7195/7284/7287
96198 sy-zb17ls 7195/7284/7287
96199 sy-zb17rs 7195/7284/7287
96200 sy-zb18ls 7195/7284/7287
96201 sy-zb18rs 7195/7284/7287
96209 tj-lagunam 7195/7196
96212 tj-lagunas 7195/7196
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