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

Query time 0.00141

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 (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)) 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
84851 D 92889
87907 D 95945
87940 D 95978
88037 D 96075
88058 D 96096
88059 D 96097
88060 D 96098
88086 D 96124
88087 D 96125
88090 D 96128
88091 D 96129
93150 B 101290
93151 B 101291
93152 B 101292
93153 B 101293
93154 B 101294
93155 B 101295
93156 B 101296
93157 B 101297
93158 B 101298
93159 B 101299
93789 B 101929
93795 B 101935
93796 B 101936
93797 B 101937
94448 B 102594
94450 B 102622
94451 B 102623
94504 B 102676
94796 B 102968
94797 B 102969
94798 B 102970
94799 B 102971
94800 B 102972
94801 B 102973
94802 B 102974
94803 B 102975
94804 B 102976
94805 B 102977
94806 B 102978
94807 B 102979
94808 B 102980
94809 B 102981
94810 B 102982
94823 B 102995
94824 B 102996
94825 B 102997
94826 B 102998
94827 B 102999
94828 B 103000
94829 B 103001
94830 B 103002
94831 B 103003
94832 B 103004
94842 B 103014
95312 B 103484
95313 B 103485
95555 B 103727
95556 B 103728
95736 B 103908
95737 B 103909
95738 B 103910
95739 B 103911
95740 B 103912
95741 B 103913
95742 B 103914
95743 B 103915
95744 B 103916
95745 B 103917
95746 B 103918
95747 B 103919
95748 B 103920
95749 B 103921
95750 B 103922
95751 B 103923
95752 B 103924
95753 B 103925
95754 B 103926
95755 B 103927
95765 B 103937
95786 B 103958
95787 B 103959
95788 B 103960
95813 B 103985
95814 B 103986
95815 B 103987
95816 B 103988
95817 B 103989
95818 B 103990
95819 B 103991
95820 B 103992
95832 B 104004
95833 B 104005
95834 B 104006
95835 B 104007
95836 B 104008