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 (
    97553, 97554, 97555, 97556, 97557, 97558, 
    97559, 97560, 97561, 97562, 97563, 
    97564, 97565, 97566, 97568, 97569, 
    97571, 97572, 97587, 97588, 97589, 
    97590, 97591, 97592, 97593, 97594, 
    97595, 97596, 97597, 97598, 97599, 
    97600, 97601, 97602, 97603, 97604, 
    97605, 97606, 97607, 97713, 97714, 
    97715, 97953, 97954, 97955, 97956, 
    97957, 97958, 97994, 97995, 97996, 
    97997, 97998, 97999, 98000, 98024, 
    98025, 98026, 98027, 98028, 98029, 
    98457, 98458, 98459, 98460, 98461, 
    98462, 98463, 98464, 98465, 98466, 
    98467, 98468, 98469, 98470, 98471, 
    98472, 98473, 98474, 98475, 98496, 
    98497, 98498, 98499, 98500, 98501, 
    98515, 98521, 98522, 99026, 99027, 
    99028, 99029, 99030, 99031, 99032
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01622

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "102.00"
    },
    "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": 113,
            "rows_produced_per_join": 113,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "11.60",
              "eval_cost": "11.30",
              "prefix_cost": "22.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 (97553,97554,97555,97556,97557,97558,97559,97560,97561,97562,97563,97564,97565,97566,97568,97569,97571,97572,97587,97588,97589,97590,97591,97592,97593,97594,97595,97596,97597,97598,97599,97600,97601,97602,97603,97604,97605,97606,97607,97713,97714,97715,97953,97954,97955,97956,97957,97958,97994,97995,97996,97997,97998,97999,98000,98024,98025,98026,98027,98028,98029,98457,98458,98459,98460,98461,98462,98463,98464,98465,98466,98467,98468,98469,98470,98471,98472,98473,98474,98475,98496,98497,98498,98499,98500,98501,98515,98521,98522,99026,99027,99028,99029,99030,99031,99032))"
          }
        },
        {
          "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": 113,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "28.25",
              "eval_cost": "11.30",
              "prefix_cost": "62.45",
              "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": "28.25",
              "eval_cost": "0.57",
              "prefix_cost": "102.00",
              "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
97553 7254M
97554 7254M
97555 7254M
97556 7254M
97557 7254M
97558 7254M
97559 7254M
97560 7254M
97561 7254M
97562 7254M
97563 7254M
97564 7254M
97565 7254M
97566 7254M
97568 7254M
97569 7254M
97571 7254M
97572 7254M
97587 7254M
97588 7254M
97589 7254M
97590 7254M
97591 7254M
97592 7254M
97593 7254M
97594 7254M
97595 7254M
97596 7254M
97597 7254M
97598 7254M
97599 7254M
97600 7254M
97601 7254M
97602 7254M
97603 7254M
97604 7254M
97605 7254M
97606 7254M
97607 7254M
97713 7222M
97714 7222M
97715 7222M
97953 7252M
97954 7252M
97955 7252M
97956 7252M
97957 7252M
97958 7252M
97994 7253M,7331
97995 7253M,7331
97996 7253M,7331
97997 7253M,7331
97998 7253M,7331
97999 7253M,7331
98000 7253M,7331
98024 7222M
98025 7222M
98026 7222M
98027 7222M
98028 7222M
98029 7222M
98457 7254M
98458 7254M
98459 7254M
98460 7254M
98461 7254M
98462 7254M
98463 7254M
98464 7254M
98465 7254M
98466 7254M
98467 7254M
98468 7254M
98469 7254M
98470 7254M
98471 7254M
98472 7254M
98473 7254M
98474 7254M
98475 7254M
98496 7253M,7331
98497 7253M,7331
98498 7253M,7331
98499 7253M,7331
98500 7253M,7331
98501 7253M,7331
98515 7222M
98521 7222M
98522 7222M
99026 7252M
99027 7252M
99028 7252M
99029 7253M,7331
99030 7253M,7331
99031 7285M,7330
99032 7253M,7331