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 (
    92530, 92523, 92536, 92540, 90702, 90706, 
    90648, 90687, 90629, 92537, 90714, 
    90720, 90713, 90719, 90700, 90704, 
    90728, 90729, 90677, 84260, 90684, 
    90685, 90690, 90691, 90626, 90627, 
    90632, 90633, 90646, 90619, 90717, 
    90723, 90725, 90727, 92535, 90644, 
    90667, 90609, 90674, 90675, 90680, 
    90681, 90712, 90718, 90586, 90587, 
    90730, 90731
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.02740

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "82.19"
    },
    "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": 91,
            "rows_produced_per_join": 91,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "9.39",
              "eval_cost": "9.10",
              "prefix_cost": "18.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 (92530,92523,92536,92540,90702,90706,90648,90687,90629,92537,90714,90720,90713,90719,90700,90704,90728,90729,90677,84260,90684,90685,90690,90691,90626,90627,90632,90633,90646,90619,90717,90723,90725,90727,92535,90644,90667,90609,90674,90675,90680,90681,90712,90718,90586,90587,90730,90731))"
          }
        },
        {
          "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": 91,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "22.75",
              "eval_cost": "9.10",
              "prefix_cost": "50.34",
              "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": "22.75",
              "eval_cost": "0.46",
              "prefix_cost": "82.19",
              "data_read_per_join": "11K"
            },
            "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
84260 7196M,7195 0
90586 7286M
90587 7286M
90609 7331,7253M
90619 7253M,7331
90626 7253M,7331
90627 7253M,7331
90629 7253M,7331
90632 7253M,7331
90633 7253M,7331
90644 7331,7253M
90646 7331,7253M
90648 7331,7253M
90667 7253M,7331
90674 7331,7253M
90675 7331,7253M
90677 7331,7253M
90680 7331,7253M
90681 7331,7253M
90684 7331,7253M
90685 7253M,7331
90687 7253M,7331
90690 7331,7253M
90691 7331,7253M
90700 7253M,7331
90702 7253M,7331
90704 7253M,7331
90706 7331,7253M
90712 7285M,7330
90713 7285M,7330
90714 7330,7285M
90717 7330,7285M
90718 7330,7285M
90719 7330,7285M
90720 7330,7285M
90723 7285M,7330
90725 7285M,7330
90727 7285M,7330
90728 7330,7285M
90729 7330,7285M
90730 7330,7285M
90731 7285M,7330
92523 7254M
92530 7195M,7196 0
92535 7254M
92536 7254M
92537 7195M,7254 0
92540 7251,7195M 0