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 (
    82561, 90189, 90268, 91884, 90264, 91900, 
    90266, 90273, 90844, 91311, 91313, 
    91315, 90267, 90274, 85649, 85650, 
    85651, 82430, 82431, 82433, 91896, 
    90272, 86076, 86079, 86080, 90794, 
    90271, 90795, 91312, 91314, 91316, 
    86077, 86078, 90263, 90270, 90269, 
    90275, 90265, 92560, 92561, 92562, 
    92563, 92564, 92565, 92566, 92567, 
    92568, 92569
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01258

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "96.60"
    },
    "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": 107,
            "rows_produced_per_join": 107,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "11.00",
              "eval_cost": "10.70",
              "prefix_cost": "21.70",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (82561,90189,90268,91884,90264,91900,90266,90273,90844,91311,91313,91315,90267,90274,85649,85650,85651,82430,82431,82433,91896,90272,86076,86079,86080,90794,90271,90795,91312,91314,91316,86077,86078,90263,90270,90269,90275,90265,92560,92561,92562,92563,92564,92565,92566,92567,92568,92569))"
          }
        },
        {
          "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": 107,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "26.75",
              "eval_cost": "10.70",
              "prefix_cost": "59.15",
              "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.75",
              "eval_cost": "0.54",
              "prefix_cost": "96.60",
              "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
82430 7225M,7226
82431 7225M,7226
82433 7225M,7226
82561 7167M,7183,7283
85649 7167M,7183,7283
85650 7167M,7183,7283
85651 7167M,7183,7283
86076 7225M,7226
86077 7225M,7226
86078 7225M,7226
86079 7225M,7226
86080 7225M,7226
90189 7193M,7319
90263 7167M,7183,7283
90264 7167M,7183,7283
90265 7167M,7183,7283
90266 7167M,7183,7283
90267 7167M,7183,7283
90268 7167M,7183,7283
90269 7167M,7183,7283
90270 7167M,7183,7283
90271 7225M,7226
90272 7225M,7226
90273 7167M,7183,7283
90274 7167M,7183,7283
90275 7167M,7183,7283
90794 7225M,7226
90795 7225M,7226
90844 7225M,7226
91311 7167M,7183,7283
91312 7167M,7183,7283
91313 7167M,7183,7283
91314 7167M,7183,7283
91315 7167M,7183,7283
91316 7167M,7183,7283
91884 7225M,7226
91896 7225M,7226
91900 7225M,7226
92560 7173M
92561 7173M
92562 7173M
92563 7173M
92564 7173M
92565 7173M
92566 7173M
92567 7173M
92568 7173M
92569 7174M