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 = 7195 
WHERE 
  cscart_products_categories.product_id IN (
    97070, 97071, 97072, 97073, 97074, 97075, 
    97076, 97077, 97078, 97079, 97080, 
    97081, 97082, 97084, 97085, 97086, 
    97087, 97088, 97089, 97090, 97091, 
    97092, 97093, 97094, 97095, 97096, 
    97097, 97098, 97099, 97100, 97101, 
    97102, 97103, 97104, 97105, 97106, 
    97107, 97108, 97109, 97110, 97111, 
    97112, 97113, 97114, 97115, 97116, 
    97117, 97118, 97119, 97120, 97121, 
    97122, 97123, 97124, 97125, 97126, 
    97127, 97128, 97129, 97130, 97131, 
    97132, 97133, 97134, 97135, 97136, 
    97137, 97138, 97139, 97140, 97141, 
    97142, 97143, 97144, 97145, 97146, 
    97147, 97148, 97149, 97150, 97151, 
    97152, 97153, 97154, 97155, 97156, 
    97157, 97158, 97159, 97160, 97161, 
    97162, 97163, 97164, 97165, 97166
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01518

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "86.69"
    },
    "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": 96,
            "rows_produced_per_join": 96,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "9.89",
              "eval_cost": "9.60",
              "prefix_cost": "19.49",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (97070,97071,97072,97073,97074,97075,97076,97077,97078,97079,97080,97081,97082,97084,97085,97086,97087,97088,97089,97090,97091,97092,97093,97094,97095,97096,97097,97098,97099,97100,97101,97102,97103,97104,97105,97106,97107,97108,97109,97110,97111,97112,97113,97114,97115,97116,97117,97118,97119,97120,97121,97122,97123,97124,97125,97126,97127,97128,97129,97130,97131,97132,97133,97134,97135,97136,97137,97138,97139,97140,97141,97142,97143,97144,97145,97146,97147,97148,97149,97150,97151,97152,97153,97154,97155,97156,97157,97158,97159,97160,97161,97162,97163,97164,97165,97166))"
          }
        },
        {
          "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": 96,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "24.00",
              "eval_cost": "9.60",
              "prefix_cost": "53.09",
              "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": 4,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "24.00",
              "eval_cost": "0.48",
              "prefix_cost": "86.69",
              "data_read_per_join": "12K"
            },
            "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
97070 7254M
97071 7254M
97072 7254M
97073 7254M
97074 7254M
97075 7254M
97076 7254M
97077 7254M
97078 7254M
97079 7254M
97080 7254M
97081 7254M
97082 7254M
97084 7254M
97085 7254M
97086 7254M
97087 7254M
97088 7254M
97089 7254M
97090 7254M
97091 7254M
97092 7254M
97093 7254M
97094 7254M
97095 7254M
97096 7254M
97097 7254M
97098 7254M
97099 7254M
97100 7254M
97101 7254M
97102 7254M
97103 7254M
97104 7254M
97105 7254M
97106 7254M
97107 7254M
97108 7254M
97109 7254M
97110 7254M
97111 7254M
97112 7254M
97113 7254M
97114 7254M
97115 7254M
97116 7254M
97117 7254M
97118 7254M
97119 7254M
97120 7254M
97121 7254M
97122 7254M
97123 7254M
97124 7254M
97125 7254M
97126 7254M
97127 7254M
97128 7254M
97129 7254M
97130 7254M
97131 7254M
97132 7254M
97133 7254M
97134 7254M
97135 7254M
97136 7254M
97137 7254M
97138 7254M
97139 7254M
97140 7254M
97141 7254M
97142 7254M
97143 7254M
97144 7254M
97145 7254M
97146 7254M
97147 7254M
97148 7254M
97149 7254M
97150 7254M
97151 7254M
97152 7254M
97153 7254M
97154 7254M
97155 7254M
97156 7254M
97157 7254M
97158 7254M
97159 7254M
97160 7254M
97161 7254M
97162 7254M
97163 7254M
97164 7254M
97165 7254M
97166 7254M