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 (
    97368, 97369, 97370, 97371, 97372, 97373, 
    97374, 97375, 97376, 97377, 97378, 
    97379, 97380, 97381, 97382, 97383, 
    97384, 97385, 97386, 97387, 97388, 
    97389, 97390, 97391, 97392, 97393, 
    97394, 97395, 97396, 97397, 97398, 
    97399, 97400, 97401, 97402, 97403, 
    97404, 97405, 97406, 97407, 97408, 
    97409, 97410, 97411, 97412, 97413, 
    97414, 97415, 97416, 97417, 97418, 
    97419, 97420, 97421, 97422, 97423, 
    97424, 97425, 97506, 97507, 97508, 
    97509, 97510, 97511, 97512, 97513, 
    97514, 97515, 97516, 97517, 97518, 
    97519, 97520, 97521, 97522, 97523, 
    97524, 97534, 97535, 97536, 97537, 
    97538, 97539, 97540, 97541, 97542, 
    97543, 97544, 97545, 97546, 97547, 
    97548, 97549, 97550, 97551, 97552
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00148

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 (97368,97369,97370,97371,97372,97373,97374,97375,97376,97377,97378,97379,97380,97381,97382,97383,97384,97385,97386,97387,97388,97389,97390,97391,97392,97393,97394,97395,97396,97397,97398,97399,97400,97401,97402,97403,97404,97405,97406,97407,97408,97409,97410,97411,97412,97413,97414,97415,97416,97417,97418,97419,97420,97421,97422,97423,97424,97425,97506,97507,97508,97509,97510,97511,97512,97513,97514,97515,97516,97517,97518,97519,97520,97521,97522,97523,97524,97534,97535,97536,97537,97538,97539,97540,97541,97542,97543,97544,97545,97546,97547,97548,97549,97550,97551,97552)) 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
97368 B 105549
97369 B 105550
97370 B 105551
97371 B 105552
97372 B 105553
97373 B 105554
97374 B 105555
97375 B 105556
97376 B 105557
97377 B 105558
97378 B 105559
97379 B 105560
97380 B 105561
97381 B 105562
97382 B 105563
97383 B 105564
97384 B 105565
97385 B 105566
97386 B 105567
97387 B 105568
97388 B 105569
97389 B 105570
97390 B 105571
97391 B 105572
97392 B 105573
97393 B 105574
97394 B 105575
97395 B 105576
97396 B 105577
97397 B 105578
97398 B 105579
97399 B 105580
97400 B 105581
97401 B 105582
97402 B 105583
97403 B 105584
97404 B 105585
97405 B 105586
97406 B 105587
97407 B 105588
97408 B 105589
97409 B 105590
97410 B 105591
97411 B 105592
97412 B 105593
97413 B 105594
97414 B 105595
97415 B 105596
97416 B 105597
97417 B 105598
97418 B 105599
97419 B 105600
97420 B 105601
97421 B 105602
97422 B 105603
97423 B 105604
97424 B 105605
97425 B 105606
97506 B 105687
97507 B 105688
97508 B 105689
97509 B 105690
97510 B 105691
97511 B 105692
97512 B 105693
97513 B 105694
97514 B 105695
97515 B 105696
97516 B 105697
97517 B 105698
97518 B 105699
97519 B 105700
97520 B 105701
97521 B 105702
97522 B 105703
97523 B 105704
97524 B 105705
97534 B 105715
97535 B 105716
97536 B 105717
97537 B 105718
97538 B 105719
97539 B 105720
97540 B 105721
97541 B 105722
97542 B 105723
97543 B 105724
97544 B 105725
97545 B 105726
97546 B 105727
97547 B 105728
97548 B 105729
97549 B 105730
97550 B 105731
97551 B 105732
97552 B 105733