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 (
    92530, 92523, 92536, 92540, 90702, 90706, 
    90648, 90687, 90629, 92537, 90714, 
    90720, 90713, 90719, 90700, 90704, 
    90728, 90729, 90677, 84260, 90684, 
    90685, 90690, 90691, 90626, 90627, 
    90632, 90633, 90646, 90619, 90717, 
    90723, 90725, 90727, 92535, 90644, 
    90667, 90609, 90674, 90675, 90680, 
    90681, 90712, 90718, 90586, 90587, 
    90730, 90731
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00063

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.62"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.82",
        "eval_cost": "4.80",
        "prefix_cost": "21.62",
        "data_read_per_join": "81K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (92530,92523,92536,92540,90702,90706,90648,90687,90629,92537,90714,90720,90713,90719,90700,90704,90728,90729,90677,84260,90684,90685,90690,90691,90626,90627,90632,90633,90646,90619,90717,90723,90725,90727,92535,90644,90667,90609,90674,90675,90680,90681,90712,90718,90586,90587,90730,90731)) 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
84260 curved-back-to-wall-bath-and-panel 7195/7196
90586 1700-b-bath-panel-and-chrome-screen-left-hand 7195/7284/7286
90587 1700-b-bath-panel-and-chrome-screen-right-hand 7195/7284/7286
90609 1700x750-standard-bath-panel-and-screen-en-en-en-en-en 7195/7251/7253
90619 1700x700-eternalite-bath-panel-and-screen-en-en-en-en-en 7195/7251/7253
90626 1700x750-eternalite-bath-panel-and-screen-en-en 7195/7251/7253
90627 1700x750-eternalite-bath-panel-and-screen-en-en-en 7195/7251/7253
90629 1700x750-eternalite-bath-panel-and-screen-en-en-en-en-en 7195/7251/7253
90632 1700x750-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en 7195/7251/7253
90633 1700x750-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en 7195/7251/7253
90644 1700x750-standard-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90646 1700x700-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90648 1700x750-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90667 1700x750-standard-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90674 1700x700-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90675 1700x700-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90677 1700x700-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90680 1700x700-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90681 1700x700-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90684 1700x750-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90685 1700x750-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90687 1700x750-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90690 1700x750-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90691 1700x750-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90700 1700x700-standard-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90702 1700x750-standard-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90704 1700x700-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90706 1700x750-eternalite-bath-panel-and-screen-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7195/7251/7253
90712 1700-square-bath-panel-and-chrome-screen-left-hand 7195/7284/7285
90713 1700-square-bath-panel-and-chrome-screen-left-hand-en 7195/7284/7285
90714 1700-square-bath-panel-and-chrome-screen-left-hand-en-en 7195/7284/7285
90717 1700-square-bath-panel-and-chrome-screen-left-hand-en-en-en-en-en 7195/7284/7285
90718 1700-square-bath-panel-and-chrome-screen-right-hand 7195/7284/7285
90719 1700-square-bath-panel-and-chrome-screen-right-hand-en 7195/7284/7285
90720 1700-square-bath-panel-and-chrome-screen-right-hand-en-en 7195/7284/7285
90723 1700-square-bath-panel-and-chrome-screen-right-hand-en-en-en-en-en 7195/7284/7285
90725 1700-square-bath-panel-and-black-screen-left-hand-en 7195/7284/7285
90727 1700-square-bath-panel-and-black-screen-right-hand-en 7195/7284/7285
90728 1700-square-bath-panel-and-black-screen-left-hand-en-en 7195/7284/7285
90729 1700-square-bath-panel-and-black-screen-right-hand-en-en 7195/7284/7285
90730 1700-square-bath-panel-and-b-brass-screen-left-hand 7195/7284/7285
90731 1700-square-bath-panel-and-b-brass-screen-right-hand 7195/7284/7285
92523 freestanding-double-ended-oval-bath-tub-1600mm-x-700mm 7195
92530 freestanding-single-ended-right-hand-corner-bath-tub-1500mm-x-800mm 7195
92535 freestanding-double-ended-boat-bath-tub-1800mm-x-745mm 7195
92536 soft-square-double-ended-freestanding-bath-tub-1700mm-x-800mm 7195
92537 curved-back-to-wall-double-ended-bath-tub-1500mm-x-750mm 7195
92540 square-freestanding-back-to-wall-bath-tub-1700mm-x-735mm 7195