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 (
    86267, 86288, 91421, 86340, 86341, 86266, 
    86287, 87749, 86302, 86315, 87752, 
    86275, 86294, 86320, 86295, 86301, 
    86314, 86321, 86274, 87741, 86264, 
    86285, 86265, 86286, 86242, 86293, 
    86319, 86240, 86263, 86284, 87739, 
    87740, 86239, 86241, 87737, 87738, 
    93401, 93402, 93403, 93404, 93405, 
    93406, 94678, 94679, 94680, 94681, 
    94682, 94683, 94684, 94685, 95101, 
    95102, 95103, 95104, 95105, 95106, 
    95107, 95108, 95109, 95110, 95111, 
    95112, 95113, 95114, 95115, 95116, 
    95117, 95118, 95119, 95120, 95121, 
    95122, 95123, 95124, 95125, 95126, 
    95127, 95128, 95129, 95130, 95131, 
    95132, 95133, 95134, 95135, 95136, 
    95137, 95138, 95139, 95140, 95141, 
    95142, 95143, 95144, 95145, 95146
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00238

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 (86267,86288,91421,86340,86341,86266,86287,87749,86302,86315,87752,86275,86294,86320,86295,86301,86314,86321,86274,87741,86264,86285,86265,86286,86242,86293,86319,86240,86263,86284,87739,87740,86239,86241,87737,87738,93401,93402,93403,93404,93405,93406,94678,94679,94680,94681,94682,94683,94684,94685,95101,95102,95103,95104,95105,95106,95107,95108,95109,95110,95111,95112,95113,95114,95115,95116,95117,95118,95119,95120,95121,95122,95123,95124,95125,95126,95127,95128,95129,95130,95131,95132,95133,95134,95135,95136,95137,95138,95139,95140,95141,95142,95143,95144,95145,95146)) 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
86239 straight-ladder-rail-500-x-700mm 7228/7229
86240 straight-ladder-rail-1100-x-500mm 7228/7229
86241 curved-ladder-rail-500-x-700mm 7228/7229
86242 curved-ladder-rail-1100-x-500mm 7228/7229
86263 horizontal-single-panel-radiator-600-x-412mm 7228/7230/7232
86264 horizontal-double-panel-radiator-600-x-412mm 7228/7230/7231
86265 horizontal-single-panel-radiator-600-x-586mm 7228/7230/7232
86266 horizontal-double-panel-radiator-600-x-586mm 7228/7230/7231
86267 horizontal-single-panel-radiator-600-x-992mm 7228/7230/7232
86274 heated-towel-rail-1200-x-450mm 7228/7230
86275 heated-towel-rail-1200-x-600mm 7228/7230
86284 horizontal-single-panel-radiator-600-x-412mm-en 7228/7230/7232
86285 horizontal-double-panel-radiator-600-x-412mm-en 7228/7230/7231
86286 horizontal-single-panel-radiator-600-x-586mm-en 7228/7230/7232
86287 horizontal-double-panel-radiator-600-x-586mm-en 7228/7230/7231
86288 horizontal-single-panel-radiator-600-x-992mm-en 7228/7230/7232
86293 horizontal-single-panel-radiator-600-x-412mm-en-en 7228/7230/7232
86294 horizontal-double-panel-radiator-600-x-412mm-en-en 7228/7230/7232
86295 horizontal-single-panel-radiator-600-x-586mm-en-en 7228/7230/7232
86301 vertical-single-panel-1500-x-354mm 7228/7230/7234
86302 single-panel-designer-radiator-1800-x-354mm 7228/7230/7234
86314 single-panel-designer-radiator-1500-x-354mm 7228/7230/7234
86315 single-panel-designer-radiator-1800-x-354mm-en 7228/7230/7234
86319 horizontal-single-panel-radiator-600-x-412mm-en-en-en 7228/7230/7232
86320 horizontal-double-panel-radiator-600-x-412mm-en-en-en 7228/7230/7232
86321 horizontal-single-panel-radiator-600-x-586mm-en-en-en 7228/7230/7232
86340 designer-radiator-1800-x-237mm 7228/7230/7234
86341 designer-radiator-1800-x-237mm-en 7228/7230/7234
87737 curved-ladder-rail-700-x-500mm 7228/7229
87738 straight-ladder-rail-700-x-500mm 7228/7229
87739 curved-ladder-rail-1150-x-500mm 7228/7229
87740 straight-ladder-rail-1150-x-500mm 7228/7229
87741 square-ladder-rail-800-x-500mm 7228/7229
87749 electric-towel-rail-720-x-400mm-300-watt-en 7228/7250
87752 lorica-straight-towel-radiator-with-round-rails-800mm-x-500mm 7228/7229
91421 electric-round-tube-towel-rail-with-10-bars-800mm-x-500mm 7228
93401 hk15012 7228/7229
93402 hk15080 7228/7229
93403 hk35012 7228/7229
93404 hk35080 7228/7229
93405 hk45012 7228/7229
93406 hk45080 7228/7229
94678 bayr001 7228/7229
94679 bayr002 7228/7229
94680 bayr003 7228/7229
94681 bayr004 7228/7229
94682 bayr008 7228/7229
94683 bayr009 7228/7229
94684 bayr010 7228/7229
94685 bayr011 7228/7229
95101 rl704n-k 7228/7229
95102 rl705mb-k 7228/7229
95103 rl705n-k 7228/7229
95104 rl706n-k 7228/7229
95105 rl707n-k 7228/7229
95106 rl709mb-k 7228/7229
95107 rl709n-k 7228/7229
95108 rll307mb-k 7228/7229
95109 rll307n-k 7228/7229
95110 rll308mb-k 7228/7229
95111 rll310mb-k 7228/7229
95112 rll310n-k 7228/7229
95113 rll312n-k 7228/7229
95114 rll316mb-k 7228/7229
95115 rll316n-k 7228/7229
95116 rll408mb-k 7228/7229
95117 rll408n-k 7228/7229
95118 rll412mb-k 7228/7229
95119 rll414mb-k 7228/7229
95120 rll414n-k 7228/7229
95121 rll416n-k 7228/7229
95122 rll418mb-k 7228/7229
95123 rll418n-k 7228/7229
95124 rll507mb-k 7228/7229
95125 rll507n-k 7228/7229
95126 rll508ant-k 7228/7229
95127 rll508mb-k 7228/7229
95128 rll508n-k 7228/7229
95129 rll511n-k 7228/7229
95130 rll512ant-k 7228/7229
95131 rll515mb-k 7228/7229
95132 rll515n-k 7228/7229
95133 rll516mb-k 7228/7229
95134 rll516n-k 7228/7229
95135 rll518mb-k 7228/7229
95136 rll607mb-k 7228/7229
95137 rll607n-k 7228/7229
95138 rll608mb-k 7228/7229
95139 rll608n-k 7228/7229
95140 rll610n-k 7228/7229
95141 rll611mb-k 7228/7229
95142 rll611n-k 7228/7229
95143 rll612n-k 7228/7229
95144 rll614mb-k 7228/7229
95145 rll614n-k 7228/7229
95146 rll615mb-k 7228/7229