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 = 7165 
WHERE 
  cscart_products_categories.product_id IN (
    98894, 98895, 98896, 98898, 98899, 98900, 
    98901, 98902, 98903, 98904, 98905, 
    98906, 98907, 98908, 98909, 99519, 
    99520, 99521, 99522, 99523, 99524, 
    99525, 99526, 99527, 100181, 100182, 
    100183, 100184, 100185, 100186, 100187, 
    100188, 100189, 100190, 100191, 100192, 
    100193, 100194, 100195, 100196, 100197, 
    100198, 100199, 100200, 100201, 100202, 
    100203, 100204, 100205, 100206, 100207, 
    100208, 100209, 100210, 100211, 100217, 
    100218, 100219, 100220, 100221, 100222, 
    100223, 100224, 100225, 100226, 100227, 
    100228, 100229, 100230, 100231, 100232, 
    100233, 100234, 100235, 100236, 100237, 
    100238, 100239, 100240, 100241, 100242, 
    100243, 100244, 100245, 100246, 100247, 
    100248, 100249, 100250, 100251, 100252, 
    100253, 100254, 100255, 100256, 100257
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.00670

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "94.80"
    },
    "grouping_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_products_categories",
            "access_type": "range",
            "possible_keys": [
              "PRIMARY",
              "link_type",
              "pt"
            ],
            "key": "pt",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "rows_examined_per_scan": 105,
            "rows_produced_per_join": 105,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "10.80",
              "eval_cost": "10.50",
              "prefix_cost": "21.30",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (98894,98895,98896,98898,98899,98900,98901,98902,98903,98904,98905,98906,98907,98908,98909,99519,99520,99521,99522,99523,99524,99525,99526,99527,100181,100182,100183,100184,100185,100186,100187,100188,100189,100190,100191,100192,100193,100194,100195,100196,100197,100198,100199,100200,100201,100202,100203,100204,100205,100206,100207,100208,100209,100210,100211,100217,100218,100219,100220,100221,100222,100223,100224,100225,100226,100227,100228,100229,100230,100231,100232,100233,100234,100235,100236,100237,100238,100239,100240,100241,100242,100243,100244,100245,100246,100247,100248,100249,100250,100251,100252,100253,100254,100255,100256,100257))"
          }
        },
        {
          "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": 105,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "26.25",
              "eval_cost": "10.50",
              "prefix_cost": "58.05",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "p_category_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "ref": [
              "nuie_scalesta_net.cscart_products_categories.category_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 5,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "26.25",
              "eval_cost": "0.53",
              "prefix_cost": "94.80",
              "data_read_per_join": "13K"
            },
            "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')))"
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
98894 7177M
98895 7177M
98896 7177M
98898 7173M
98899 7173M
98900 7176M
98901 7173M
98902 7176M
98903 7176M
98904 7179M
98905 7173M
98906 7174M
98907 7174M
98908 7174M
98909 7174M
99519 7225M,7226
99520 7225M,7226
99521 7225M,7226
99522 7225M,7226
99523 7225M,7226
99524 7225M,7226
99525 7225M,7226
99526 7225M,7226
99527 7225M,7226
100181 7168M
100182 7168M
100183 7168M
100184 7168M
100185 7168M
100186 7168M
100187 7172M
100188 7172M
100189 7172M
100190 7172M
100191 7172M
100192 7168M
100193 7168M
100194 7168M
100195 7172M
100196 7172M
100197 7172M
100198 7168M
100199 7168M
100200 7168M
100201 7168M
100202 7168M
100203 7168M
100204 7168M
100205 7168M
100206 7168M
100207 7168M
100208 7168M
100209 7168M
100210 7168M
100211 7168M
100217 7168M
100218 7175M
100219 7175M
100220 7175M
100221 7175M
100222 7175M
100223 7175M
100224 7175M
100225 7175M
100226 7175M
100227 7176M
100228 7168M
100229 7168M
100230 7168M
100231 7168M
100232 7168M
100233 7179M
100234 7179M
100235 7179M
100236 7179M
100237 7179M
100238 7179M
100239 7168M
100240 7168M
100241 7168M
100242 7176M
100243 7176M
100244 7176M
100245 7176M
100246 7176M
100247 7176M
100248 7177M
100249 7177M
100250 7177M
100251 7168M
100252 7168M
100253 7168M
100254 7177M
100255 7177M
100256 7177M
100257 7177M