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 = 7197 
WHERE 
  cscart_products_categories.product_id IN (
    88058, 84851, 88037, 88059, 88060, 87907, 
    87940, 88091, 88090, 88087, 88086, 
    93150, 93151, 93152, 93153, 93154, 
    93155, 93156, 93157, 93158, 93159, 
    93789, 93795, 93796, 93797, 94448, 
    94450, 94451, 94504, 94796, 94797, 
    94798, 94799, 94800, 94801, 94802, 
    94803, 94804, 94805, 94806, 94807, 
    94808, 94809, 94810, 94823, 94824, 
    94825, 94826, 94827, 94828, 94829, 
    94830, 94831, 94832, 94842, 95312, 
    95313, 95555, 95556, 95736, 95737, 
    95738, 95739, 95740, 95741, 95742, 
    95743, 95744, 95745, 95746, 95747, 
    95748, 95749, 95750, 95751, 95752, 
    95753, 95754, 95755, 95765, 95786, 
    95787, 95788, 95813, 95814, 95815, 
    95816, 95817, 95818, 95819, 95820, 
    95832, 95833, 95834, 95835, 95836
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01532

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "101.10"
    },
    "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": 112,
            "rows_produced_per_join": 112,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "11.50",
              "eval_cost": "11.20",
              "prefix_cost": "22.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 (88058,84851,88037,88059,88060,87907,87940,88091,88090,88087,88086,93150,93151,93152,93153,93154,93155,93156,93157,93158,93159,93789,93795,93796,93797,94448,94450,94451,94504,94796,94797,94798,94799,94800,94801,94802,94803,94804,94805,94806,94807,94808,94809,94810,94823,94824,94825,94826,94827,94828,94829,94830,94831,94832,94842,95312,95313,95555,95556,95736,95737,95738,95739,95740,95741,95742,95743,95744,95745,95746,95747,95748,95749,95750,95751,95752,95753,95754,95755,95765,95786,95787,95788,95813,95814,95815,95816,95817,95818,95819,95820,95832,95833,95834,95835,95836))"
          }
        },
        {
          "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": 112,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "28.00",
              "eval_cost": "11.20",
              "prefix_cost": "61.90",
              "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.00",
              "eval_cost": "0.56",
              "prefix_cost": "101.10",
              "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
84851 7205M
87907 7255M
87940 7256M,7262
88037 7256M,7262
88058 7256M,7262
88059 7256M,7262
88060 7256M,7262
88086 7256M,7262
88087 7256M,7262
88090 7256M,7262
88091 7256M,7262
93150 7199M
93151 7209M
93152 7209M
93153 7209M
93154 7199M
93155 7209M
93156 7199M
93157 7209M
93158 7203M
93159 7203M
93789 7199M
93795 7199M
93796 7209M
93797 7203M
94448 7199M
94450 7203M
94451 7205M
94504 7264M
94796 7203M
94797 7203M
94798 7205M
94799 7205M
94800 7206M
94801 7206M
94802 7203M
94803 7203M
94804 7199M
94805 7199M
94806 7199M
94807 7203M
94808 7203M
94809 7199M
94810 7209M
94823 7205M
94824 7205M
94825 7209M
94826 7203M
94827 7256M,7262
94828 7256M,7262
94829 7256M,7262
94830 7256M,7262
94831 7256M,7262
94832 7199M
94842 7203M
95312 7209M
95313 7209M
95555 7203M
95556 7198M,7266
95736 7256M,7262
95737 7209M
95738 7203M
95739 7203M
95740 7203M
95741 7203M
95742 7203M
95743 7205M
95744 7205M
95745 7205M
95746 7205M
95747 7205M
95748 7205M
95749 7205M
95750 7205M
95751 7206M
95752 7206M
95753 7199M
95754 7203M
95755 7209M
95765 7209M
95786 7199M
95787 7209M
95788 7199M
95813 7205M
95814 7205M
95815 7205M
95816 7206M
95817 7206M
95818 7206M
95819 7203M
95820 7209M
95832 7197M 0
95833 7255M
95834 7255M
95835 7255M
95836 7255M