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 (
    98590, 98591, 98592, 98593, 98594, 98595, 
    98596, 98597, 98598, 98599, 98600, 
    98601, 98602, 98603, 98604, 98605, 
    98606, 98607, 98608, 98609, 98610, 
    98611, 98612, 98613, 98614, 98615, 
    98616, 98617, 98618, 98619, 98620, 
    98621, 98622, 98623, 98624, 98625, 
    98626, 98627, 98628, 98629, 98630, 
    98631, 98632, 98633, 98634, 98635, 
    98636, 98637, 98638, 98639, 98640, 
    98641, 98642, 98643, 98644, 98645, 
    98646, 98647, 98648, 98649, 98650, 
    98651, 98652, 98653, 98654, 98655, 
    98656, 98657, 98658, 98659, 98660, 
    98661, 98662, 98663, 98664, 98665, 
    98666, 98667, 98668, 98669, 98670, 
    98671, 98672, 98673, 98674, 98675, 
    98676, 98677, 98678, 98679, 98680, 
    98681, 98760, 98761, 99012, 99013
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00133

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 (98590,98591,98592,98593,98594,98595,98596,98597,98598,98599,98600,98601,98602,98603,98604,98605,98606,98607,98608,98609,98610,98611,98612,98613,98614,98615,98616,98617,98618,98619,98620,98621,98622,98623,98624,98625,98626,98627,98628,98629,98630,98631,98632,98633,98634,98635,98636,98637,98638,98639,98640,98641,98642,98643,98644,98645,98646,98647,98648,98649,98650,98651,98652,98653,98654,98655,98656,98657,98658,98659,98660,98661,98662,98663,98664,98665,98666,98667,98668,98669,98670,98671,98672,98673,98674,98675,98676,98677,98678,98679,98680,98681,98760,98761,99012,99013)) 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
98590 B 106771
98591 B 106772
98592 B 106773
98593 B 106774
98594 B 106775
98595 B 106776
98596 B 106777
98597 B 106778
98598 B 106779
98599 B 106780
98600 B 106781
98601 B 106782
98602 B 106783
98603 B 106784
98604 B 106785
98605 B 106786
98606 B 106787
98607 B 106788
98608 B 106789
98609 B 106790
98610 B 106791
98611 B 106792
98612 B 106793
98613 B 106794
98614 B 106795
98615 B 106796
98616 B 106797
98617 B 106798
98618 B 106799
98619 B 106800
98620 B 106801
98621 B 106802
98622 B 106803
98623 B 106804
98624 B 106805
98625 B 106806
98626 B 106807
98627 B 106808
98628 B 106809
98629 B 106810
98630 B 106811
98631 B 106812
98632 B 106813
98633 B 106814
98634 B 106815
98635 B 106816
98636 B 106817
98637 B 106818
98638 B 106819
98639 B 106820
98640 B 106821
98641 B 106822
98642 B 106823
98643 B 106824
98644 B 106825
98645 B 106826
98646 B 106827
98647 B 106828
98648 B 106829
98649 B 106830
98650 B 106831
98651 B 106832
98652 B 106833
98653 B 106834
98654 B 106835
98655 B 106836
98656 B 106837
98657 B 106838
98658 B 106839
98659 B 106840
98660 B 106841
98661 B 106842
98662 B 106843
98663 B 106844
98664 B 106845
98665 B 106846
98666 B 106847
98667 B 106848
98668 B 106849
98669 B 106850
98670 B 106851
98671 B 106852
98672 B 106853
98673 B 106854
98674 B 106855
98675 B 106856
98676 B 106857
98677 B 106858
98678 B 106859
98679 B 106860
98680 B 106861
98681 B 106862
98760 B 106941
98761 B 106942
99012 B 107193
99013 B 107194