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_products_categories.product_id, 
  GROUP_CONCAT(
    IF(
      cscart_products_categories.link_type = "M", 
      CONCAT(
        cscart_products_categories.category_id, 
        "M"
      ), 
      cscart_products_categories.category_id
    )
  ) AS category_ids, 
  product_position_source.position AS position 
FROM 
  cscart_products_categories 
  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id 
  AND cscart_categories.storefront_id IN (0, 1) 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  LEFT JOIN cscart_products_categories AS product_position_source ON cscart_products_categories.product_id = product_position_source.product_id 
  AND product_position_source.category_id = 7148 
WHERE 
  cscart_products_categories.product_id IN (
    85599, 92212, 92213, 92214, 92215, 92217, 
    92223, 92465, 92466, 90827, 92191, 
    84238, 87995, 89167, 89168, 89170, 
    89171, 92430, 91978, 91981, 82361, 
    82432, 82563, 82567, 82571, 87882, 
    92228, 92229, 92230, 92231, 92237, 
    92469, 92470, 92471, 92439, 91865, 
    85585, 92366, 92367, 92368, 92369, 
    92370, 92371, 92372, 90324, 90326, 
    91977, 91979, 91980, 91982, 91983, 
    91892, 92150, 82556, 84254, 84259, 
    85596, 87577, 87592, 87607, 88788, 
    92197, 92457, 85646, 85583, 91866, 
    91867, 92325, 92326, 92327, 92328, 
    89595, 89596, 89597, 82336, 86251, 
    90054, 90056, 90057, 86861, 87875, 
    90323, 91936, 92240, 92245, 92247, 
    92248, 92249, 92250, 92252, 92253, 
    92485, 92486, 92487, 84252, 84253
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01738

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "135.66"
    },
    "grouping_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "10.30"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "ALL",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "p_category_id"
            ],
            "rows_examined_per_scan": 208,
            "rows_produced_per_join": 8,
            "filtered": "4.00",
            "cost_info": {
              "read_cost": "20.72",
              "eval_cost": "0.83",
              "prefix_cost": "21.55",
              "data_read_per_join": "21K"
            },
            "used_columns": [
              "category_id",
              "usergroup_ids",
              "status",
              "storefront_id"
            ],
            "attached_condition": "((`nuie_scalesta_net`.`cscart_categories`.`storefront_id` in (0,1)) and ((`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`nuie_scalesta_net`.`cscart_categories`.`usergroup_ids`))) and (`nuie_scalesta_net`.`cscart_categories`.`status` in ('A','H')))"
          }
        },
        {
          "table": {
            "table_name": "cscart_products_categories",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "link_type",
              "pt"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "ref": [
              "nuie_scalesta_net.cscart_categories.category_id"
            ],
            "rows_examined_per_scan": 117,
            "rows_produced_per_join": 10,
            "filtered": "1.05",
            "cost_info": {
              "read_cost": "2.33",
              "eval_cost": "1.03",
              "prefix_cost": "121.75",
              "data_read_per_join": "164"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (85599,92212,92213,92214,92215,92217,92223,92465,92466,90827,92191,84238,87995,89167,89168,89170,89171,92430,91978,91981,82361,82432,82563,82567,82571,87882,92228,92229,92230,92231,92237,92469,92470,92471,92439,91865,85585,92366,92367,92368,92369,92370,92371,92372,90324,90326,91977,91979,91980,91982,91983,91892,92150,82556,84254,84259,85596,87577,87592,87607,88788,92197,92457,85646,85583,91866,91867,92325,92326,92327,92328,89595,89596,89597,82336,86251,90054,90056,90057,86861,87875,90323,91936,92240,92245,92247,92248,92249,92250,92252,92253,92485,92486,92487,84252,84253))"
          }
        },
        {
          "table": {
            "table_name": "product_position_source",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "pt"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id",
              "product_id"
            ],
            "key_length": "6",
            "ref": [
              "const",
              "nuie_scalesta_net.cscart_products_categories.product_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 10,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "2.58",
              "eval_cost": "1.03",
              "prefix_cost": "125.35",
              "data_read_per_join": "164"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
82336 7151M,7301
82361 7148,7149,7160M 0
82432 7148,7163,7164M 0
82556 7161M,7303
82563 7161M,7303
82567 7161M,7303
82571 7161M,7303
84238 7194M
84252 7194M
84253 7194M
84254 7194M
84259 7194M
85583 7149M,7182,7300
85585 7157M,7341,7342,7343
85596 7148,7158,7159M 0
85599 7148,7158,7159M 0
85646 7148,7156,7157M 0
86251 7148,7163,7164M 0
86861 7148,7207M 0
87577 7194M
87592 7194M
87607 7194M
87875 7208M,7241,7309,7346
87882 7208M,7241,7309,7346
87995 7148,7207,7208M 0
88788 7194M
89167 7148,7163,7164M 0
89168 7148,7163,7164M 0
89170 7148,7163,7164M 0
89171 7148,7163,7164M 0
89595 7151M,7301
89596 7151M,7301
89597 7151M,7301
90054 7194M
90056 7194M
90057 7194M
90323 7247M,7265
90324 7247M,7265
90326 7247M,7265
90827 7208M,7241,7309,7346
91865 7148M,7156,7157 0
91866 7148M,7156,7157 0
91867 7148M,7156,7157 0
91892 7157M,7341,7342,7343
91936 7151M,7301
91977 7161M,7303
91978 7161M,7303
91979 7161M,7303
91980 7161M,7303
91981 7161M,7303
91982 7161M,7303
91983 7161M,7303
92150 7157M,7341,7342,7343
92191 7157M,7341,7342,7343
92197 7157M,7341,7342,7343
92212 7157M,7341,7342,7343
92213 7157M,7341,7342,7343
92214 7157M,7341,7342,7343
92215 7157M,7341,7342,7343
92217 7157M,7341,7342,7343
92223 7157M,7341,7342,7343
92228 7157M,7341,7342,7343
92229 7157M,7341,7342,7343
92230 7157M,7341,7342,7343
92231 7157M,7341,7342,7343
92237 7157M,7341,7342,7343
92240 7219M,7313,7338
92245 7219M,7313,7338
92247 7219M,7313,7338
92248 7219M,7313,7338
92249 7219M,7313,7338
92250 7219M,7313,7338
92252 7219M,7313,7338
92253 7219M,7313,7338
92325 7148M,7156,7157 0
92326 7148M,7156,7157 0
92327 7148M,7156,7157 0
92328 7148M,7156,7157 0
92366 7148M,7156,7157 0
92367 7148M,7156,7157 0
92368 7148M,7156,7157 0
92369 7148M,7156,7157 0
92370 7148M,7156,7157 0
92371 7148M,7156,7157 0
92372 7148M,7156,7157 0
92430 7263M
92439 7263M
92457 7157M,7341,7342,7343
92465 7157M,7341,7342,7343
92466 7157M,7341,7342,7343
92469 7157M,7341,7342,7343
92470 7157M,7341,7342,7343
92471 7157M,7341,7342,7343
92485 7219M,7313,7338
92486 7219M,7313,7338
92487 7219M,7313,7338