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 (
    99891, 99892, 99893, 99894, 99895, 99896, 
    99897, 99898, 99899, 99900, 99901, 
    99902, 99903, 99904, 99905, 99906, 
    99907, 99908, 99909, 99910, 99911, 
    99912, 99913, 99914, 99915, 99916, 
    99917, 99918, 99919, 99920, 99921, 
    99922, 99923, 99924, 99925, 99926, 
    99927, 99928, 99929, 99930, 99931, 
    99932, 99933, 99934, 99935, 99936, 
    99937, 99938, 99939, 99940, 99941, 
    99942, 99943, 99944, 99945, 99946, 
    99947, 99948, 99949, 99950, 99951, 
    99952, 99953, 99954, 99955, 99956, 
    99957, 99958, 99959, 99960, 99961, 
    99962, 99963, 99964, 99965, 99966, 
    99967, 99968, 99969, 99970, 99971, 
    99972, 99973, 99974, 99975, 99976, 
    99977, 99978, 99979, 99980, 99981, 
    99982, 99983, 99984, 99985, 99986
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00245

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 (99891,99892,99893,99894,99895,99896,99897,99898,99899,99900,99901,99902,99903,99904,99905,99906,99907,99908,99909,99910,99911,99912,99913,99914,99915,99916,99917,99918,99919,99920,99921,99922,99923,99924,99925,99926,99927,99928,99929,99930,99931,99932,99933,99934,99935,99936,99937,99938,99939,99940,99941,99942,99943,99944,99945,99946,99947,99948,99949,99950,99951,99952,99953,99954,99955,99956,99957,99958,99959,99960,99961,99962,99963,99964,99965,99966,99967,99968,99969,99970,99971,99972,99973,99974,99975,99976,99977,99978,99979,99980,99981,99982,99983,99984,99985,99986)) 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
99891 rnd-grc114a-p 7228/7229
99892 rnd-grc114w-p 7228/7229
99893 rnd-hnv10-p 7228/7230/7234
99894 rnd-hnv10a-p 7228/7230/7234
99895 rnd-hnv10ad-p 7228/7230/7231
99896 rnd-hnv10d-p 7228/7230/7231
99897 rnd-hnv14-p 7228/7230/7234
99898 rnd-hnv14a-p 7228/7230/7234
99899 rnd-hnv14ad-p 7228/7230/7231
99900 rnd-hnv14d-p 7228/7230/7231
99901 rnd-hnv17-p 7228/7230/7234
99902 rnd-hnv17a-p 7228/7230/7234
99903 rnd-hnv17ad-p 7228/7230/7231
99904 rnd-hnv17d-p 7228/7230/7231
99905 rnd-hnv20-p 7228/7230/7234
99906 rnd-hnv20a-p 7228/7230/7234
99907 rnd-hnv20ad-p 7228/7230/7231
99908 rnd-hnv20d-p 7228/7230/7231
99909 rnd-hnv24-p 7228/7230/7234
99910 rnd-hnv24a-p 7228/7230/7234
99911 rnd-hnv24ad-p 7228/7230/7231
99912 rnd-hnv24d-p 7228/7230/7231
99913 rnd-hnv7-p 7228/7230/7234
99914 rnd-hnv7a-p 7228/7230/7234
99915 rnd-hnv7ad-p 7228/7230/7231
99916 rnd-hnv7d-p 7228/7230/7231
99917 rnd-le418a-p 7228/7230/7234
99918 rnd-le418w-p 7228/7230/7234
99919 rnd-lg1-p 7228/7229
99920 rnd-lg2-p 7228/7229
99921 rnd-mc5080-p 7228/7229
99922 rnd-mc5110-p 7228/7229
99923 rnd-mc5140-p 7228/7229
99924 rnd-mtr5077-p 7228/7229
99925 rnd-mtr5099-p 7228/7229
99926 rnd-mtr5141-p 7228/7229
99927 rnd-nl6140-p 7228/7229
99928 rnd-nrd081045-p 7228/7229
99929 rnd-nrd081055-p 7228/7229
99930 rnd-nrd120045-p 7228/7229
99931 rnd-nrd120055-p 7228/7229
99932 rnd-nv2315a-p 7228/7230/7234
99933 rnd-nv2315ad-p 7228/7230/7231
99934 rnd-nv2315w-p 7228/7230/7234
99935 rnd-nv2315wd-p 7228/7230/7231
99936 rnd-nv2318a-p 7228/7230/7231
99937 rnd-nv2318ad-p 7228/7230/7231
99938 rnd-nv2318w-p 7228/7230/7234
99939 rnd-nv2318wd-p 7228/7230/7231
99940 rnd-nv2915a-p 7228/7230/7234
99941 rnd-nv2915ad-p 7228/7230/7231
99942 rnd-nv2915w-p 7228/7230/7234
99943 rnd-nv2915wd-p 7228/7230/7231
99944 rnd-nv2918a-p 7228/7230/7231
99945 rnd-nv2918ad-p 7228/7230/7231
99946 rnd-nv2918w-p 7228/7230/7231
99947 rnd-nv2918wd-p 7228/7230/7231
99948 rnd-nv3515a-p 7228/7230/7234
99949 rnd-nv3515ad-p 7228/7230/7231
99950 rnd-nv3515w-p 7228/7230/7234
99951 rnd-nv3515wd-p 7228/7230/7231
99952 rnd-nv3518a-p 7228/7230/7231
99953 rnd-nv3518ad-p 7228/7230/7231
99954 rnd-nv3518w-p 7228/7230/7231
99955 rnd-nv3518wd-p 7228/7230/7231
99956 rnd-nv4115a-p 7228/7230/7234
99957 rnd-nv4115ad-p 7228/7230/7231
99958 rnd-nv4115w-p 7228/7230/7234
99959 rnd-nv4115wd-p 7228/7230/7231
99960 rnd-nv4118a-p 7228/7230/7231
99961 rnd-nv4118ad-p 7228/7230/7231
99962 rnd-nv4118w-p 7228/7230/7234
99963 rnd-nv4118wd-p 7228/7230/7231
99964 rnd-nv4715a-p 7228/7230/7234
99965 rnd-nv4715ad-p 7228/7230/7231
99966 rnd-nv4715w-p 7228/7230/7234
99967 rnd-nv4715wd-p 7228/7230/7231
99968 rnd-nv4718ad-p 7228/7230/7231
99969 rnd-nv4718w-p 7228/7230/7231
99970 rnd-nv4718wd-p 7228/7230/7231
99971 rnd-nv5315a-p 7228/7230/7231
99972 rnd-nv5315ad-p 7228/7230/7231
99973 rnd-nv5315wd-p 7228/7230/7231
99974 rnd-nv5318a-p 7228/7230/7234
99975 rnd-nv5318ad-p 7228/7230/7231
99976 rnd-nv5318w-p 7228/7230/7234
99977 rnd-nv5318wd-p 7228/7230/7231
99978 rnd-nvh210dw-p 7228/7230/7231
99979 rnd-nvh212dw-p 7228/7230/7231
99980 rnd-nvh212sw-p 7228/7230/7234
99981 rnd-nvh214da-p 7228/7230/7231
99982 rnd-nvh214dw-p 7228/7230/7231
99983 rnd-nvh214sw-p 7228/7230/7234
99984 rnd-nvh506dw-p 7228/7230/7231
99985 rnd-nvh506sw-p 7228/7230/7234
99986 rnd-nvh508da-p 7228/7230/7231