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 = 7228 
WHERE 
  cscart_products_categories.product_id IN (
    86267, 86288, 91421, 86340, 86341, 86266, 
    86287, 87749, 86302, 86315, 87752, 
    86275, 86294, 86320, 86295, 86301, 
    86314, 86321, 86274, 87741, 86264, 
    86285, 86265, 86286, 86242, 86293, 
    86319, 86240, 86263, 86284, 87739, 
    87740, 86239, 86241, 87737, 87738, 
    93401, 93402, 93403, 93404, 93405, 
    93406, 94678, 94679, 94680, 94681, 
    94682, 94683, 94684, 94685, 95101, 
    95102, 95103, 95104, 95105, 95106, 
    95107, 95108, 95109, 95110, 95111, 
    95112, 95113, 95114, 95115, 95116, 
    95117, 95118, 95119, 95120, 95121, 
    95122, 95123, 95124, 95125, 95126, 
    95127, 95128, 95129, 95130, 95131, 
    95132, 95133, 95134, 95135, 95136, 
    95137, 95138, 95139, 95140, 95141, 
    95142, 95143, 95144, 95145, 95146
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01573

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "88.49"
    },
    "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": 98,
            "rows_produced_per_join": 98,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "10.10",
              "eval_cost": "9.80",
              "prefix_cost": "19.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 (86267,86288,91421,86340,86341,86266,86287,87749,86302,86315,87752,86275,86294,86320,86295,86301,86314,86321,86274,87741,86264,86285,86265,86286,86242,86293,86319,86240,86263,86284,87739,87740,86239,86241,87737,87738,93401,93402,93403,93404,93405,93406,94678,94679,94680,94681,94682,94683,94684,94685,95101,95102,95103,95104,95105,95106,95107,95108,95109,95110,95111,95112,95113,95114,95115,95116,95117,95118,95119,95120,95121,95122,95123,95124,95125,95126,95127,95128,95129,95130,95131,95132,95133,95134,95135,95136,95137,95138,95139,95140,95141,95142,95143,95144,95145,95146))"
          }
        },
        {
          "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": 98,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "24.50",
              "eval_cost": "9.80",
              "prefix_cost": "54.20",
              "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.50",
              "eval_cost": "0.49",
              "prefix_cost": "88.50",
              "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
86239 7229M
86240 7229M
86241 7229M
86242 7229M
86263 7234M
86264 7231M
86265 7234M
86266 7231M
86267 7234M
86274 7229M
86275 7229M
86284 7234M
86285 7231M
86286 7234M
86287 7231M
86288 7234M
86293 7234M
86294 7231M
86295 7234M
86301 7234M
86302 7234M
86314 7234M
86315 7234M
86319 7234M
86320 7231M
86321 7234M
86340 7231M
86341 7231M
87737 7229M
87738 7229M
87739 7229M
87740 7229M
87741 7229M
87749 7250M,7228 0
87752 7229M
91421 7228M,7250 0
93401 7229M
93402 7229M
93403 7229M
93404 7229M
93405 7229M
93406 7229M
94678 7229M
94679 7229M
94680 7229M
94681 7229M
94682 7229M
94683 7229M
94684 7229M
94685 7229M
95101 7229M
95102 7229M
95103 7229M
95104 7229M
95105 7229M
95106 7229M
95107 7229M
95108 7229M
95109 7229M
95110 7229M
95111 7229M
95112 7229M
95113 7229M
95114 7229M
95115 7229M
95116 7229M
95117 7229M
95118 7229M
95119 7229M
95120 7229M
95121 7229M
95122 7229M
95123 7229M
95124 7229M
95125 7229M
95126 7229M
95127 7229M
95128 7229M
95129 7229M
95130 7229M
95131 7229M
95132 7229M
95133 7229M
95134 7229M
95135 7229M
95136 7229M
95137 7229M
95138 7229M
95139 7229M
95140 7229M
95141 7229M
95142 7229M
95143 7229M
95144 7229M
95145 7229M
95146 7229M