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 (
    95977, 95978, 95979, 95980, 95981, 95982, 
    95983, 95984, 95985, 95986, 95987, 
    95988, 95989, 95990, 95991, 95992, 
    95993, 95994, 95995, 95996, 95997, 
    95998, 95999, 96000, 96001, 96002, 
    96003, 96004, 96005, 96006, 96007, 
    96008, 96009, 96010, 96011, 96012, 
    96013, 96014, 96015, 96016, 96017, 
    96018, 96019, 96020, 96021, 96022, 
    96023, 96024, 96025, 96026, 96027, 
    96028, 96029, 96030, 96031, 96032, 
    96033, 96034, 96035, 96036, 96037, 
    96038, 96039, 96040, 96041, 96042, 
    96043, 96044, 96045, 96046, 96047, 
    96048, 96049, 96050, 96051, 96052, 
    96053, 96054, 96055, 96056, 96057, 
    96058, 96059, 96060, 96061, 96062, 
    96063, 96064, 96065, 96066, 96067, 
    96068, 96069, 96070, 96071, 96072
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00159

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 (95977,95978,95979,95980,95981,95982,95983,95984,95985,95986,95987,95988,95989,95990,95991,95992,95993,95994,95995,95996,95997,95998,95999,96000,96001,96002,96003,96004,96005,96006,96007,96008,96009,96010,96011,96012,96013,96014,96015,96016,96017,96018,96019,96020,96021,96022,96023,96024,96025,96026,96027,96028,96029,96030,96031,96032,96033,96034,96035,96036,96037,96038,96039,96040,96041,96042,96043,96044,96045,96046,96047,96048,96049,96050,96051,96052,96053,96054,96055,96056,96057,96058,96059,96060,96061,96062,96063,96064,96065,96066,96067,96068,96069,96070,96071,96072)) 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
95977 B 104149
95978 B 104150
95979 B 104151
95980 B 104152
95981 B 104153
95982 B 104154
95983 B 104155
95984 B 104156
95985 B 104157
95986 B 104158
95987 B 104159
95988 B 104160
95989 B 104161
95990 B 104162
95991 B 104163
95992 B 104164
95993 B 104165
95994 B 104166
95995 B 104167
95996 B 104168
95997 B 104169
95998 B 104170
95999 B 104171
96000 B 104172
96001 B 104173
96002 B 104174
96003 B 104175
96004 B 104176
96005 B 104177
96006 B 104178
96007 B 104179
96008 B 104180
96009 B 104181
96010 B 104182
96011 B 104183
96012 B 104184
96013 B 104185
96014 B 104186
96015 B 104187
96016 B 104188
96017 B 104189
96018 B 104190
96019 B 104191
96020 B 104192
96021 B 104193
96022 B 104194
96023 B 104195
96024 B 104196
96025 B 104197
96026 B 104198
96027 B 104199
96028 B 104200
96029 B 104201
96030 B 104202
96031 B 104203
96032 B 104204
96033 B 104205
96034 B 104206
96035 B 104207
96036 B 104208
96037 B 104209
96038 B 104210
96039 B 104211
96040 B 104212
96041 B 104213
96042 B 104214
96043 B 104215
96044 B 104216
96045 B 104217
96046 B 104218
96047 B 104219
96048 B 104220
96049 B 104221
96050 B 104222
96051 B 104223
96052 B 104224
96053 B 104225
96054 B 104226
96055 B 104227
96056 B 104228
96057 B 104229
96058 B 104230
96059 B 104231
96060 B 104232
96061 B 104233
96062 B 104234
96063 B 104235
96064 B 104236
96065 B 104237
96066 B 104238
96067 B 104239
96068 B 104240
96069 B 104241
96070 B 104242
96071 B 104243
96072 B 104244