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 (
    92503, 92504, 92505, 92506, 92507, 92192, 
    92193, 92194, 92195, 92196, 92204, 
    92205, 92206, 92207, 92208, 92209, 
    92442, 92443, 92448, 92147, 92148, 
    92149, 92349, 92350, 92351, 92352, 
    89643, 89646, 89524, 83998, 84000, 
    84002, 84004, 84034, 90075, 90062, 
    84022, 84023, 84024, 84025, 84037, 
    89617, 89630, 83955, 83957, 83959, 
    83961, 92067, 92068, 92069, 92070, 
    92071, 92072, 92073, 92083, 92084, 
    92085, 92086, 92087, 92088, 92089, 
    91297, 92139, 92140, 92141, 92142, 
    92143, 92144, 92145, 86380, 92043, 
    92044, 92045, 92046, 92047, 92048, 
    92049, 92059, 92060, 92061, 92062, 
    92063, 92064, 92065, 92075, 92076, 
    92077, 92078, 92079, 92080, 92081, 
    92131, 92132, 92133, 92134, 92135
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00147

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 (92503,92504,92505,92506,92507,92192,92193,92194,92195,92196,92204,92205,92206,92207,92208,92209,92442,92443,92448,92147,92148,92149,92349,92350,92351,92352,89643,89646,89524,83998,84000,84002,84004,84034,90075,90062,84022,84023,84024,84025,84037,89617,89630,83955,83957,83959,83961,92067,92068,92069,92070,92071,92072,92073,92083,92084,92085,92086,92087,92088,92089,91297,92139,92140,92141,92142,92143,92144,92145,86380,92043,92044,92045,92046,92047,92048,92049,92059,92060,92061,92062,92063,92064,92065,92075,92076,92077,92078,92079,92080,92081,92131,92132,92133,92134,92135)) 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
83955 D 91993
83957 D 91995
83959 D 91997
83961 D 91999
83998 D 92036
84000 D 92038
84002 D 92040
84004 D 92042
84022 D 92060
84023 D 92061
84024 D 92062
84025 D 92063
84034 D 92072
84037 D 92075
86380 D 94418
89524 D 97562
89617 D 97655
89630 D 97668
89643 D 97681
89646 D 97684
90062 D 98100
90075 D 98113
91297 D 99370
92043 D 100121
92044 D 100122
92045 D 100123
92046 D 100124
92047 D 100125
92048 D 100126
92049 D 100127
92059 D 100137
92060 D 100138
92061 D 100139
92062 D 100140
92063 D 100141
92064 D 100142
92065 D 100143
92067 D 100145
92068 D 100146
92069 D 100147
92070 D 100148
92071 D 100149
92072 D 100150
92073 D 100151
92075 D 100153
92076 D 100154
92077 D 100155
92078 D 100156
92079 D 100157
92080 D 100158
92081 D 100159
92083 D 100161
92084 D 100162
92085 D 100163
92086 D 100164
92087 D 100165
92088 D 100166
92089 D 100167
92131 D 100209
92132 D 100210
92133 D 100211
92134 D 100212
92135 D 100213
92139 D 100217
92140 D 100218
92141 D 100219
92142 D 100220
92143 D 100221
92144 D 100222
92145 D 100223
92147 D 100225
92148 D 100226
92149 D 100227
92192 D 100270
92193 D 100271
92194 D 100272
92195 D 100273
92196 D 100274
92204 D 100282
92205 D 100283
92206 D 100284
92207 D 100285
92208 D 100286
92209 D 100287
92349 D 100453
92350 D 100454
92351 D 100455
92352 D 100456
92442 D 100546
92443 D 100547
92448 D 100552
92503 D 100607
92504 D 100608
92505 D 100609
92506 D 100610
92507 D 100611