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 = 7336 
WHERE 
  cscart_products_categories.product_id IN (
    95938, 95939, 95942, 95943, 96213, 96214, 
    96215, 96216, 96217, 96218, 96219, 
    96220, 96221, 96222, 96223, 96224, 
    96225, 96226, 96227, 96228, 96229, 
    96230, 96231, 96232, 96233, 96234, 
    96235, 96236, 96237, 96238, 96239, 
    96240, 96241, 96242, 96243, 96244, 
    96334, 96336, 96338, 96340, 96341, 
    96342, 96343, 96344, 96345, 96346, 
    96347, 96348
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01656

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "97.50"
    },
    "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": 108,
            "rows_produced_per_join": 108,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "11.10",
              "eval_cost": "10.80",
              "prefix_cost": "21.90",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (95938,95939,95942,95943,96213,96214,96215,96216,96217,96218,96219,96220,96221,96222,96223,96224,96225,96226,96227,96228,96229,96230,96231,96232,96233,96234,96235,96236,96237,96238,96239,96240,96241,96242,96243,96244,96334,96336,96338,96340,96341,96342,96343,96344,96345,96346,96347,96348))"
          }
        },
        {
          "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": 108,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "27.00",
              "eval_cost": "10.80",
              "prefix_cost": "59.70",
              "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": "27.00",
              "eval_cost": "0.54",
              "prefix_cost": "97.50",
              "data_read_per_join": "14K"
            },
            "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
95938 7219M,7313,7338
95939 7219M,7313,7338
95942 7219M,7313,7338
95943 7219M,7313,7338
96213 7217M,7337
96214 7217M,7337
96215 7217M,7337
96216 7217M,7337
96217 7217M,7337
96218 7217M,7337
96219 7217M,7337
96220 7217M,7337
96221 7217M,7337
96222 7217M,7337
96223 7217M,7337
96224 7217M,7337
96225 7217M,7337
96226 7217M,7337
96227 7217M,7337
96228 7217M,7337
96229 7217M,7337
96230 7217M,7337
96231 7217M,7337
96232 7217M,7337
96233 7217M,7337
96234 7217M,7337
96235 7217M,7337
96236 7217M,7337
96237 7217M,7337
96238 7217M,7337
96239 7217M,7337
96240 7217M,7337
96241 7217M,7337
96242 7217M,7337
96243 7217M,7337
96244 7217M,7337
96334 7217M,7337
96336 7217M,7337
96338 7217M,7337
96340 7217M,7337
96341 7219M,7313,7338
96342 7219M,7313,7338
96343 7219M,7313,7338
96344 7219M,7313,7338
96345 7219M,7313,7338
96346 7219M,7313,7338
96347 7219M,7313,7338
96348 7219M,7313,7338