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 (
    93787, 93788, 93798, 93799, 93800, 93801, 
    93802, 93803, 93804, 93805, 93806, 
    93807, 93808, 93809, 93810, 93811, 
    93812, 93813, 93814, 93815, 93816, 
    93817, 93818, 93832, 93833, 93834, 
    93835, 93836, 93837, 93838, 93839, 
    93840, 93841, 93882, 93883, 93884, 
    93885, 94367, 94368, 94369, 94370, 
    94371, 94372, 94373, 94374, 94375, 
    94376, 94377, 94378, 94379, 94380, 
    94438, 94463, 94464, 94465, 94466, 
    94467, 94468, 94469, 94470, 94471, 
    94472, 94473, 94474, 94475, 94476, 
    94477, 94478, 94479, 94480, 94481, 
    94482, 94483, 94589, 94590, 94591, 
    94811, 94812, 94820, 94821, 94959, 
    94960, 94961, 94962, 94963, 94964, 
    95360, 95394, 95395, 95396, 95397, 
    95398, 95399, 95400, 95401, 95424
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00199

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 (93787,93788,93798,93799,93800,93801,93802,93803,93804,93805,93806,93807,93808,93809,93810,93811,93812,93813,93814,93815,93816,93817,93818,93832,93833,93834,93835,93836,93837,93838,93839,93840,93841,93882,93883,93884,93885,94367,94368,94369,94370,94371,94372,94373,94374,94375,94376,94377,94378,94379,94380,94438,94463,94464,94465,94466,94467,94468,94469,94470,94471,94472,94473,94474,94475,94476,94477,94478,94479,94480,94481,94482,94483,94589,94590,94591,94811,94812,94820,94821,94959,94960,94961,94962,94963,94964,95360,95394,95395,95396,95397,95398,95399,95400,95401,95424)) 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
93787 B 101927
93788 B 101928
93798 B 101938
93799 B 101939
93800 B 101940
93801 B 101941
93802 B 101942
93803 B 101943
93804 B 101944
93805 B 101945
93806 B 101946
93807 B 101947
93808 B 101948
93809 B 101949
93810 B 101950
93811 B 101951
93812 B 101952
93813 B 101953
93814 B 101954
93815 B 101955
93816 B 101956
93817 B 101957
93818 B 101958
93832 B 101972
93833 B 101973
93834 B 101974
93835 B 101975
93836 B 101976
93837 B 101977
93838 B 101978
93839 B 101979
93840 B 101980
93841 B 101981
93882 B 102022
93883 B 102023
93884 B 102024
93885 B 102025
94367 B 102509
94368 B 102510
94369 B 102511
94370 B 102512
94371 B 102513
94372 B 102514
94373 B 102515
94374 B 102516
94375 B 102517
94376 B 102518
94377 B 102519
94378 B 102520
94379 B 102521
94380 B 102522
94438 B 102584
94463 B 102635
94464 B 102636
94465 B 102637
94466 B 102638
94467 B 102639
94468 B 102640
94469 B 102641
94470 B 102642
94471 B 102643
94472 B 102644
94473 B 102645
94474 B 102646
94475 B 102647
94476 B 102648
94477 B 102649
94478 B 102650
94479 B 102651
94480 B 102652
94481 B 102653
94482 B 102654
94483 B 102655
94589 B 102761
94590 B 102762
94591 B 102763
94811 B 102983
94812 B 102984
94820 B 102992
94821 B 102993
94959 B 103131
94960 B 103132
94961 B 103133
94962 B 103134
94963 B 103135
94964 B 103136
95360 B 103532
95394 B 103566
95395 B 103567
95396 B 103568
95397 B 103569
95398 B 103570
95399 B 103571
95400 B 103572
95401 B 103573
95424 B 103596