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 (
    88349, 88350, 89665, 88265, 88266, 88272, 
    88344, 88345, 88346, 88347, 89663, 
    89664, 89671, 89660, 89659, 88343, 
    89658, 88342, 88338, 88337, 88330, 
    88340, 88341, 88335, 88336, 88333, 
    88331, 88332, 88339, 88328, 88327, 
    88326, 94384, 94385, 94386, 94388, 
    94389, 94390, 94391, 94392, 94393, 
    94394, 94395, 94398, 94401, 94402, 
    94403, 94404, 94405, 94406, 94407, 
    94408, 94409, 94410, 94411, 94412, 
    94413, 94414, 94415, 94416, 94417, 
    94418, 94420, 94421, 94422, 94425, 
    94854, 94855, 94856, 94857, 94861, 
    94862, 94863, 94864, 94865, 94866, 
    94869, 94872, 94873, 94874, 94875, 
    94876, 94877, 94878, 94879, 94880, 
    94881, 94882, 94883, 94884, 94885, 
    94886, 94887, 94888, 94889, 94890
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00176

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 (88349,88350,89665,88265,88266,88272,88344,88345,88346,88347,89663,89664,89671,89660,89659,88343,89658,88342,88338,88337,88330,88340,88341,88335,88336,88333,88331,88332,88339,88328,88327,88326,94384,94385,94386,94388,94389,94390,94391,94392,94393,94394,94395,94398,94401,94402,94403,94404,94405,94406,94407,94408,94409,94410,94411,94412,94413,94414,94415,94416,94417,94418,94420,94421,94422,94425,94854,94855,94856,94857,94861,94862,94863,94864,94865,94866,94869,94872,94873,94874,94875,94876,94877,94878,94879,94880,94881,94882,94883,94884,94885,94886,94887,94888,94889,94890)) 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
88265 D 96303
88266 D 96304
88272 D 96310
88326 D 96364
88327 D 96365
88328 D 96366
88330 D 96368
88331 D 96369
88332 D 96370
88333 D 96371
88335 D 96373
88336 D 96374
88337 D 96375
88338 D 96376
88339 D 96377
88340 D 96378
88341 D 96379
88342 D 96380
88343 D 96381
88344 D 96382
88345 D 96383
88346 D 96384
88347 D 96385
88349 D 96387
88350 D 96388
89658 D 97696
89659 D 97697
89660 D 97698
89663 D 97701
89664 D 97702
89665 D 97703
89671 D 97709
94384 B 102529
94385 B 102530
94386 B 102531
94388 B 102533
94389 B 102534
94390 B 102535
94391 B 102536
94392 B 102537
94393 B 102538
94394 B 102539
94395 B 102540
94398 B 102543
94401 B 102546
94402 B 102547
94403 B 102548
94404 B 102549
94405 B 102550
94406 B 102551
94407 B 102552
94408 B 102553
94409 B 102554
94410 B 102555
94411 B 102556
94412 B 102557
94413 B 102558
94414 B 102559
94415 B 102560
94416 B 102561
94417 B 102562
94418 B 102563
94420 B 102565
94421 B 102566
94422 B 102567
94425 B 102570
94854 B 103026
94855 B 103027
94856 B 103028
94857 B 103029
94861 B 103033
94862 B 103034
94863 B 103035
94864 B 103036
94865 B 103037
94866 B 103038
94869 B 103041
94872 B 103044
94873 B 103045
94874 B 103046
94875 B 103047
94876 B 103048
94877 B 103049
94878 B 103050
94879 B 103051
94880 B 103052
94881 B 103053
94882 B 103054
94883 B 103055
94884 B 103056
94885 B 103057
94886 B 103058
94887 B 103059
94888 B 103060
94889 B 103061
94890 B 103062