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 (
    88058, 84851, 88037, 88059, 88060, 87907, 
    87940, 88091, 88090, 88087, 88086, 
    93150, 93151, 93152, 93153, 93154, 
    93155, 93156, 93157, 93158, 93159, 
    93789, 93795, 93796, 93797, 94448, 
    94450, 94451, 94504, 94796, 94797, 
    94798, 94799, 94800, 94801, 94802, 
    94803, 94804, 94805, 94806, 94807, 
    94808, 94809, 94810, 94823, 94824, 
    94825, 94826, 94827, 94828, 94829, 
    94830, 94831, 94832, 94842, 95312, 
    95313, 95555, 95556, 95736, 95737, 
    95738, 95739, 95740, 95741, 95742, 
    95743, 95744, 95745, 95746, 95747, 
    95748, 95749, 95750, 95751, 95752, 
    95753, 95754, 95755, 95765, 95786, 
    95787, 95788, 95813, 95814, 95815, 
    95816, 95817, 95818, 95819, 95820, 
    95832, 95833, 95834, 95835, 95836
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00241

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 (88058,84851,88037,88059,88060,87907,87940,88091,88090,88087,88086,93150,93151,93152,93153,93154,93155,93156,93157,93158,93159,93789,93795,93796,93797,94448,94450,94451,94504,94796,94797,94798,94799,94800,94801,94802,94803,94804,94805,94806,94807,94808,94809,94810,94823,94824,94825,94826,94827,94828,94829,94830,94831,94832,94842,95312,95313,95555,95556,95736,95737,95738,95739,95740,95741,95742,95743,95744,95745,95746,95747,95748,95749,95750,95751,95752,95753,95754,95755,95765,95786,95787,95788,95813,95814,95815,95816,95817,95818,95819,95820,95832,95833,95834,95835,95836)) 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
84851 lawton-550mm-basin-and-pedestal 7197/7204/7205
87907 round-vessel-358-x-368-x-137mm 7197/7204/7255
87940 chancery-500mm-basin-1-tap-hole 7210/7257/7262
88037 richmond-515mm-cloakroom-basin 7210/7257/7262
88058 richmond-560mm-3-tap-hole-basin 7210/7257/7262
88059 richmond-500mm-basin-2-tap-hole 7210/7257/7262
88060 richmond-500mm-basin-1-tap-hole 7210/7257/7262
88086 melbourne-350mm-wall-hung-basin 7210/7257/7262
88087 melbourne-450mm-wall-hung-basin 7210/7257/7262
88090 melbourne-350mm-wall-hung-basin-en 7210/7257/7262
88091 melbourne-450mm-wall-hung-basin-en 7210/7257/7262
93150 crp306w 7197/7198/7199
93151 crp340 7197/7198/7209
93152 crp341w 7197/7198/7209
93153 crp600w 7197/7198/7209
93154 crp606w 7197/7198/7199
93155 csp300w 7197/7198/7209
93156 csp406w 7197/7198/7199
93157 csp440 7197/7198/7209
93158 css006 7197/7198/7203
93159 css007 7197/7198/7203
93789 ncg606 7197/7198/7199
93795 nck106 7197/7198/7199
93796 nck140 7197/7198/7209
93797 ncs750 7197/7198/7203
94448 pp848 7197/7198/7199
94450 bar003 7197/7198/7203
94451 bar004 7197/7204/7205
94504 bayc023 7197/7198/7264
94796 clw006 7197/7198/7203
94797 clw007 7197/7198/7203
94798 mil002 7197/7204/7205
94799 mil003 7197/7204/7205
94800 mil004 7197/7204/7206
94801 mil005 7197/7204/7206
94802 mil250 7197/7198/7203
94803 mil251 7197/7198/7203
94804 mil286 7197/7198/7199
94805 mil296 7197/7198/7199
94806 ncg505 7197/7198/7199
94807 ncg551 7197/7198/7203
94808 ncg651 7197/7198/7203
94809 nck206 7197/7198/7199
94810 nck240 7197/7198/7209
94823 ram002 7197/7204/7205
94824 ram003 7197/7204/7205
94825 ram140 7197/7198/7209
94826 ram150 7197/7198/7203
94827 ram832 7197/7204/7256
94828 ram842 7197/7204/7256
94829 ram862 7197/7204/7256
94830 ram932 7197/7204/7256
94831 ram942 7197/7204/7256
94832 ramw002 7197/7198/7199
94842 23701p2-j 7197/7198/7203
95312 sy-angelwh 7197/7198/7209
95313 sy-angelwhblk 7197/7198/7209
95555 238cdocmcclevbl-r 7197/7198/7203
95556 238cdocms001-r 7197/7198
95736 emb102 7197/7204/7256
95737 emb140 7197/7198/7209
95738 hct001 7197/7198/7203
95739 hct001bb 7197/7198/7203
95740 hct002 7197/7198/7203
95741 hct002bb 7197/7198/7203
95742 hct003 7197/7198/7203
95743 hct004 7197/7204/7205
95744 hct004a 7197/7204/7205
95745 hct004b 7197/7204/7205
95746 hct005 7197/7204/7205
95747 hct005a 7197/7204/7205
95748 hct005b 7197/7204/7205
95749 hec002 7197/7204/7205
95750 hec003 7197/7204/7205
95751 hec004 7197/7204/7206
95752 hec005 7197/7204/7206
95753 hec008 7197/7198/7199
95754 hec009 7197/7198/7203
95755 hec010 7197/7198/7209
95765 hes010 7197/7198/7209
95786 hun806 7197/7198/7199
95787 hun840 7197/7198/7209
95788 hun856 7197/7198/7199
95813 lul002 7197/7204/7205
95814 lul003 7197/7204/7205
95815 lul004 7197/7204/7205
95816 lul005 7197/7204/7206
95817 lul006 7197/7204/7206
95818 lul007 7197/7204/7206
95819 lul008 7197/7198/7203
95820 lul010 7197/7198/7209
95832 lxbl006 7197
95833 lxbv001 7197/7204/7255
95834 lxbv002 7197/7204/7255
95835 lxbv005 7197/7204/7255
95836 lxbv006 7197/7204/7255