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 = 7251 
WHERE 
  cscart_products_categories.product_id IN (
    90611, 90662, 90668, 90604, 90610, 90650, 
    90676, 90692, 90693, 90653, 90659, 
    90618, 90634, 90635, 90643, 90595, 
    90601, 90652, 90658, 90594, 90600, 
    90666, 90608, 84041, 84232, 84044, 
    84235, 90656, 84236, 90598, 84043, 
    84040, 84231, 84234, 88100, 87864, 
    87866, 84039, 84230, 84042, 88098, 
    84233, 87831, 87844, 87850, 88096, 
    87860, 87862, 87829, 87842, 87848, 
    87858, 87863, 87865, 87827, 87840, 
    87833, 87846, 87838, 87856, 87854, 
    87834, 87852, 93787, 93788, 94367, 
    94368, 94369, 94370, 94371, 94372, 
    94373, 94374, 94375, 94376, 94377, 
    94378, 94379, 95399, 95400, 95401, 
    95434, 95435, 95436, 95437, 95438, 
    95439, 95440, 95441, 95704, 95705, 
    95728, 95729, 95730, 95731, 95732
  ) 
GROUP BY 
  cscart_products_categories.product_id

Query time 0.01605

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "130.67"
    },
    "grouping_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "6.61"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_categories",
            "access_type": "ALL",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "p_category_id"
            ],
            "rows_examined_per_scan": 208,
            "rows_produced_per_join": 8,
            "filtered": "4.00",
            "cost_info": {
              "read_cost": "20.72",
              "eval_cost": "0.83",
              "prefix_cost": "21.55",
              "data_read_per_join": "21K"
            },
            "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')))"
          }
        },
        {
          "table": {
            "table_name": "cscart_products_categories",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "link_type",
              "pt"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "ref": [
              "nuie_scalesta_net.cscart_categories.category_id"
            ],
            "rows_examined_per_scan": 117,
            "rows_produced_per_join": 6,
            "filtered": "0.68",
            "cost_info": {
              "read_cost": "2.33",
              "eval_cost": "0.66",
              "prefix_cost": "121.75",
              "data_read_per_join": "105"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type"
            ],
            "attached_condition": "(`nuie_scalesta_net`.`cscart_products_categories`.`product_id` in (90611,90662,90668,90604,90610,90650,90676,90692,90693,90653,90659,90618,90634,90635,90643,90595,90601,90652,90658,90594,90600,90666,90608,84041,84232,84044,84235,90656,84236,90598,84043,84040,84231,84234,88100,87864,87866,84039,84230,84042,88098,84233,87831,87844,87850,88096,87860,87862,87829,87842,87848,87858,87863,87865,87827,87840,87833,87846,87838,87856,87854,87834,87852,93787,93788,94367,94368,94369,94370,94371,94372,94373,94374,94375,94376,94377,94378,94379,95399,95400,95401,95434,95435,95436,95437,95438,95439,95440,95441,95704,95705,95728,95729,95730,95731,95732))"
          }
        },
        {
          "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": 6,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "1.65",
              "eval_cost": "0.66",
              "prefix_cost": "124.06",
              "data_read_per_join": "105"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "position"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id category_ids position
84039 7252M
84040 7252M
84041 7252M
84042 7252M
84043 7252M
84044 7252M
84230 7253M,7331
84231 7253M,7331
84232 7253M,7331
84233 7253M,7331
84234 7253M,7331
84235 7253M,7331
84236 7253M,7331
87827 7252M
87829 7252M
87831 7252M
87833 7253M,7331
87834 7253M,7331
87838 7253M,7331
87840 7253M,7331
87842 7253M,7331
87844 7253M,7331
87846 7252M
87848 7252M
87850 7252M
87852 7253M,7331
87854 7253M,7331
87856 7253M,7331
87858 7253M,7331
87860 7253M,7331
87862 7253M,7331
87863 7253M,7331
87864 7253M,7331
87865 7252M
87866 7252M
88096 7253M,7331
88098 7252M
88100 7252M
90594 7253M,7331
90595 7253M,7331
90598 7253M,7331
90600 7253M,7331
90601 7253M,7331
90604 7253M,7331
90608 7253M,7331
90610 7253M,7331
90611 7253M,7331
90618 7253M,7331
90634 7253M,7331
90635 7253M,7331
90643 7253M,7331
90650 7253M,7331
90652 7253M,7331
90653 7253M,7331
90656 7253M,7331
90658 7253M,7331
90659 7253M,7331
90662 7253M,7331
90666 7253M,7331
90668 7253M,7331
90676 7253M,7331
90692 7253M,7331
90693 7253M,7331
93787 7253M,7331
93788 7252M
94367 7252M
94368 7252M
94369 7252M
94370 7252M
94371 7252M
94372 7253M,7331
94373 7253M,7331
94374 7253M,7331
94375 7253M,7331
94376 7253M,7331
94377 7253M,7331
94378 7253M,7331
94379 7253M,7331
95399 7253M,7331
95400 7253M,7331
95401 7253M,7331
95434 7253M,7331
95435 7253M,7331
95436 7253M,7331
95437 7253M,7331
95438 7253M,7331
95439 7253M,7331
95440 7253M,7331
95441 7253M,7331
95704 7253M,7331
95705 7253M,7331
95728 7253M,7331
95729 7253M,7331
95730 7253M,7331
95731 7253M,7331
95732 7253M,7331