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 (
    97553, 97554, 97555, 97556, 97557, 97558, 
    97559, 97560, 97561, 97562, 97563, 
    97564, 97565, 97566, 97568, 97569, 
    97571, 97572, 97587, 97588, 97589, 
    97590, 97591, 97592, 97593, 97594, 
    97595, 97596, 97597, 97598, 97599, 
    97600, 97601, 97602, 97603, 97604, 
    97605, 97606, 97607, 97713, 97714, 
    97715, 97953, 97954, 97955, 97956, 
    97957, 97958, 97994, 97995, 97996, 
    97997, 97998, 97999, 98000, 98024, 
    98025, 98026, 98027, 98028, 98029, 
    98457, 98458, 98459, 98460, 98461, 
    98462, 98463, 98464, 98465, 98466, 
    98467, 98468, 98469, 98470, 98471, 
    98472, 98473, 98474, 98475, 98496, 
    98497, 98498, 98499, 98500, 98501, 
    98515, 98521, 98522, 99026, 99027, 
    99028, 99029, 99030, 99031, 99032
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00256

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 (97553,97554,97555,97556,97557,97558,97559,97560,97561,97562,97563,97564,97565,97566,97568,97569,97571,97572,97587,97588,97589,97590,97591,97592,97593,97594,97595,97596,97597,97598,97599,97600,97601,97602,97603,97604,97605,97606,97607,97713,97714,97715,97953,97954,97955,97956,97957,97958,97994,97995,97996,97997,97998,97999,98000,98024,98025,98026,98027,98028,98029,98457,98458,98459,98460,98461,98462,98463,98464,98465,98466,98467,98468,98469,98470,98471,98472,98473,98474,98475,98496,98497,98498,98499,98500,98501,98515,98521,98522,99026,99027,99028,99029,99030,99031,99032)) 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
97553 bas020-p 7195/7254
97554 bas020s-m 7195/7254
97555 bas030-p 7195/7254
97556 bas030-s180-p 7195/7254
97557 bas035s-m 7195/7254
97558 bas036-p 7195/7254
97559 bas040-p 7195/7254
97560 bas040s-m 7195/7254
97561 bas058-p 7195/7254
97562 bas058s-m 7195/7254
97563 bas060-p 7195/7254
97564 bas060-s180-p 7195/7254
97565 bas063-p 7195/7254
97566 bas063-s180-p 7195/7254
97568 bas065-p 7195/7254
97569 bas065-s180-p 7195/7254
97571 bas070-p 7195/7254
97572 bas070-s180-p 7195/7254
97587 bayb101-m 7195/7254
97588 bayb102-m 7195/7254
97589 bayb103-m 7195/7254
97590 bayb104-m 7195/7254
97591 bayb105-m 7195/7254
97592 bayb106-m 7195/7254
97593 bayb107-m 7195/7254
97594 bayb108-m 7195/7254
97595 bayb109-m 7195/7254
97596 bayb112-m 7195/7254
97597 bayb113-m 7195/7254
97598 bayb114-m 7195/7254
97599 bayb115-m 7195/7254
97600 bayb116-m 7195/7254
97601 bayb117-m 7195/7254
97602 bayb118-m 7195/7254
97603 bayb119-m 7195/7254
97604 bayb120-m 7195/7254
97605 bayb121-m 7195/7254
97606 bayb122-m 7195/7254
97607 bayb125-m 7195/7254
97713 baye201-m 7195/7222
97714 baye203-m 7195/7222
97715 baye204-m 7195/7222
97953 bde006-p 7195/7251/7252
97954 bde007-p 7195/7251/7252
97955 bde008-p 7195/7251/7252
97956 bde009-p 7195/7251/7252
97957 bde010-p 7195/7251/7252
97958 bde011-p 7195/7251/7252
97994 bmon008-p 7195/7251/7253
97995 bmon009-p 7195/7251/7253
97996 bmon010-p 7195/7251/7253
97997 bmon013-p 7195/7251/7253
97998 bmon014-p 7195/7251/7253
97999 bmon015-p 7195/7251/7253
98000 bmon017-p 7195/7251/7253
98024 bss010-m 7195/7222
98025 bss013-m 7195/7222
98026 bss015-m 7195/7222
98027 bss020-m 7195/7222
98028 bss025-m 7195/7222
98029 bss028-m 7195/7222
98457 ea101co-p 7195/7254
98458 ea101sv-p 7195/7254
98459 ea101wm-p 7195/7254
98460 ea102co-p 7195/7254
98461 ea102go-p 7195/7254
98462 ea102sv-p 7195/7254
98463 ea103co-p 7195/7254
98464 ea103go-p 7195/7254
98465 ea103sv-p 7195/7254
98466 ea104co-p 7195/7254
98467 ea104go-p 7195/7254
98468 ea104sv-p 7195/7254
98469 ea105co-p 7195/7254
98470 ea105go-p 7195/7254
98471 ea105sv-p 7195/7254
98472 ea106co-p 7195/7254
98473 ea106go-p 7195/7254
98474 ea106sv-p 7195/7254
98475 ea107mt-p 7195/7254
98496 em1500p-p 7195/7251/7253
98497 em1500p2-p 7195/7251/7253
98498 em1600p-p 7195/7251/7253
98499 em1600p2-p 7195/7251/7253
98500 em1700p-p 7195/7251/7253
98501 em1700p2-p 7195/7251/7253
98515 ersbs0-p 7195/7222
98521 erss1-p 7195/7222
98522 erssq-p 7195/7222
99026 nba209-p 7195/7251/7252
99027 nba210-p 7195/7251/7252
99028 nba214-p 7195/7251/7252
99029 nba308-p 7195/7251/7253
99030 nba404-p 7195/7251/7253
99031 nba405-p 7195/7284/7285
99032 nba407-p 7195/7251/7253