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 (
    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
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00169

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 (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)) 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
84039 D 92077
84040 D 92078
84041 D 92079
84042 D 92080
84043 D 92081
84044 D 92082
84230 D 92268
84231 D 92269
84232 D 92270
84233 D 92271
84234 D 92272
84235 D 92273
84236 D 92274
87827 D 95865
87829 D 95867
87831 D 95869
87833 D 95871
87834 D 95872
87838 D 95876
87840 D 95878
87842 D 95880
87844 D 95882
87846 D 95884
87848 D 95886
87850 D 95888
87852 D 95890
87854 D 95892
87856 D 95894
87858 D 95896
87860 D 95898
87862 D 95900
87863 D 95901
87864 D 95902
87865 D 95903
87866 D 95904
88096 D 96134
88098 D 96136
88100 D 96138
90594 D 98646
90595 D 98647
90598 D 98650
90600 D 98652
90601 D 98653
90604 D 98656
90608 D 98660
90610 D 98662
90611 D 98663
90618 D 98670
90634 D 98686
90635 D 98687
90643 D 98695
90650 D 98702
90652 D 98704
90653 D 98705
90656 D 98708
90658 D 98710
90659 D 98711
90662 D 98714
90666 D 98718
90668 D 98720
90676 D 98728
90692 D 98744
90693 D 98745
93787 B 101927
93788 B 101928
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
95399 B 103571
95400 B 103572
95401 B 103573
95434 B 103606
95435 B 103607
95436 B 103608
95437 B 103609
95438 B 103610
95439 B 103611
95440 B 103612
95441 B 103613
95704 B 103876
95705 B 103877
95728 B 103900
95729 B 103901
95730 B 103902
95731 B 103903
95732 B 103904