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_discussion.object_id AS product_id, 
  AVG(
    cscart_discussion_rating.rating_value
  ) AS average_rating, 
  cscart_discussion.type AS discussion_type, 
  cscart_discussion.thread_id AS discussion_thread_id 
FROM 
  cscart_discussion 
  LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id 
  AND cscart_discussion_posts.status = "A" 
  LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id 
  AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id 
  AND cscart_discussion_rating.rating_value != 0 
WHERE 
  cscart_discussion.object_id IN (
    91727, 91728, 91729, 91730, 91731, 91732, 
    91733, 91734, 91755, 91756, 91757, 
    91758, 91759, 91760, 91761, 91762, 
    91763, 91812, 91813, 91814, 91815, 
    84942, 84934, 92167, 84737, 84739, 
    84725, 87980, 87983, 84715, 84741, 
    92161, 92162, 92163, 87984, 87970, 
    92164, 92165, 92166, 84714, 84713, 
    88023, 84947, 88032, 84848, 87985, 
    84912, 84736, 84688, 84712, 87979, 
    84960, 87976, 87978, 84850, 84743, 
    84849, 84951, 84747, 84761, 84711, 
    84710, 84911, 84717, 87969, 87967, 
    88038, 84846, 84910, 87981, 87982, 
    85274, 84687, 84709, 87977, 87918, 
    87919, 87920, 87924, 87926, 87930, 
    87931, 87932, 88027, 88089, 84940, 
    84941, 88024, 87898, 87899, 87902, 
    87968, 84728, 84729, 84730, 88022
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00142

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "110.66"
    },
    "grouping_operation": {
      "using_temporary_table": true,
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_discussion",
            "access_type": "range",
            "possible_keys": [
              "object_id"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type"
            ],
            "key_length": "6",
            "rows_examined_per_scan": 96,
            "rows_produced_per_join": 96,
            "filtered": "100.00",
            "index_condition": "((`nuie_scalesta_net`.`cscart_discussion`.`object_id` in (91727,91728,91729,91730,91731,91732,91733,91734,91755,91756,91757,91758,91759,91760,91761,91762,91763,91812,91813,91814,91815,84942,84934,92167,84737,84739,84725,87980,87983,84715,84741,92161,92162,92163,87984,87970,92164,92165,92166,84714,84713,88023,84947,88032,84848,87985,84912,84736,84688,84712,87979,84960,87976,87978,84850,84743,84849,84951,84747,84761,84711,84710,84911,84717,87969,87967,88038,84846,84910,87981,87982,85274,84687,84709,87977,87918,87919,87920,87924,87926,87930,87931,87932,88027,88089,84940,84941,88024,87898,87899,87902,87968,84728,84729,84730,88022)) and (`nuie_scalesta_net`.`cscart_discussion`.`object_type` = 'P'))",
            "cost_info": {
              "read_cost": "57.61",
              "eval_cost": "9.60",
              "prefix_cost": "67.21",
              "data_read_per_join": "2K"
            },
            "used_columns": [
              "thread_id",
              "object_id",
              "object_type",
              "type"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_discussion_posts",
            "access_type": "ref",
            "possible_keys": [
              "thread_id",
              "thread_id_2"
            ],
            "key": "thread_id",
            "used_key_parts": [
              "thread_id"
            ],
            "key_length": "3",
            "ref": [
              "nuie_scalesta_net.cscart_discussion.thread_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 96,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "24.00",
              "eval_cost": "9.60",
              "prefix_cost": "100.81",
              "data_read_per_join": "42K"
            },
            "used_columns": [
              "post_id",
              "thread_id",
              "status"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_discussion_posts), (`nuie_scalesta_net`.`cscart_discussion_posts`.`status` = 'A'), true)"
          }
        },
        {
          "table": {
            "table_name": "cscart_discussion_rating",
            "access_type": "ALL",
            "possible_keys": [
              "PRIMARY",
              "thread_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 96,
            "filtered": "100.00",
            "using_join_buffer": "hash join",
            "cost_info": {
              "read_cost": "0.25",
              "eval_cost": "9.60",
              "prefix_cost": "110.66",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "rating_value",
              "post_id",
              "thread_id"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_discussion_rating), ((`nuie_scalesta_net`.`cscart_discussion_rating`.`post_id` = `nuie_scalesta_net`.`cscart_discussion_posts`.`post_id`) and (`nuie_scalesta_net`.`cscart_discussion_rating`.`thread_id` = `nuie_scalesta_net`.`cscart_discussion`.`thread_id`) and (`nuie_scalesta_net`.`cscart_discussion_rating`.`rating_value` <> 0)), true)"
          }
        }
      ]
    }
  }
}

Result

product_id average_rating discussion_type discussion_thread_id
84687 D 92725
84688 D 92726
84709 D 92747
84710 D 92748
84711 D 92749
84712 D 92750
84713 D 92751
84714 D 92752
84715 D 92753
84717 D 92755
84725 D 92763
84728 D 92766
84729 D 92767
84730 D 92768
84736 D 92774
84737 D 92775
84739 D 92777
84741 D 92779
84743 D 92781
84747 D 92785
84761 D 92799
84846 D 92884
84848 D 92886
84849 D 92887
84850 D 92888
84910 D 92948
84911 D 92949
84912 D 92950
84934 D 92972
84940 D 92978
84941 D 92979
84942 D 92980
84947 D 92985
84951 D 92989
84960 D 92998
85274 D 93312
87898 D 95936
87899 D 95937
87902 D 95940
87918 D 95956
87919 D 95957
87920 D 95958
87924 D 95962
87926 D 95964
87930 D 95968
87931 D 95969
87932 D 95970
87967 D 96005
87968 D 96006
87969 D 96007
87970 D 96008
87976 D 96014
87977 D 96015
87978 D 96016
87979 D 96017
87980 D 96018
87981 D 96019
87982 D 96020
87983 D 96021
87984 D 96022
87985 D 96023
88022 D 96060
88023 D 96061
88024 D 96062
88027 D 96065
88032 D 96070
88038 D 96076
88089 D 96127
91727 D 99800
91728 D 99801
91729 D 99802
91730 D 99803
91731 D 99804
91732 D 99805
91733 D 99806
91734 D 99807
91755 D 99828
91756 D 99829
91757 D 99830
91758 D 99831
91759 D 99832
91760 D 99833
91761 D 99834
91762 D 99835
91763 D 99836
91812 D 99890
91813 D 99891
91814 D 99892
91815 D 99893
92161 D 100239
92162 D 100240
92163 D 100241
92164 D 100242
92165 D 100243
92166 D 100244
92167 D 100245