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 (
    99699, 99700, 99701, 99702, 99703, 99704, 
    99705, 99706, 99707, 99708, 99709, 
    99710, 99711, 99712, 99713, 99714, 
    99715, 99716, 99717, 99718, 99719, 
    99720, 99721, 99722, 99723, 99724, 
    99725, 99726, 99727, 99728, 99729, 
    99730, 99731, 99732, 99733, 99734, 
    99735, 99736, 99737, 99738, 99739, 
    99740, 99741, 99742, 99743, 99744, 
    99745, 99746, 99747, 99748, 99749, 
    99750, 99751, 99752, 99753, 99754, 
    99755, 99756, 99757, 99758, 99759, 
    99760, 99761, 99762, 99763, 99764, 
    99765, 99766, 99767, 99768, 99769, 
    99770, 99771, 99772, 99773, 99774, 
    99775, 99776, 99777, 99778, 99779, 
    99780, 99781, 99782, 99783, 99784, 
    99785, 99786, 99787, 99788, 99789, 
    99790, 99791, 99792, 99793, 99794
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00145

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 (99699,99700,99701,99702,99703,99704,99705,99706,99707,99708,99709,99710,99711,99712,99713,99714,99715,99716,99717,99718,99719,99720,99721,99722,99723,99724,99725,99726,99727,99728,99729,99730,99731,99732,99733,99734,99735,99736,99737,99738,99739,99740,99741,99742,99743,99744,99745,99746,99747,99748,99749,99750,99751,99752,99753,99754,99755,99756,99757,99758,99759,99760,99761,99762,99763,99764,99765,99766,99767,99768,99769,99770,99771,99772,99773,99774,99775,99776,99777,99778,99779,99780,99781,99782,99783,99784,99785,99786,99787,99788,99789,99790,99791,99792,99793,99794)) 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
99699 B 107879
99700 B 107880
99701 B 107881
99702 B 107882
99703 B 107883
99704 B 107884
99705 B 107885
99706 B 107886
99707 B 107887
99708 B 107888
99709 B 107889
99710 B 107890
99711 B 107891
99712 B 107892
99713 B 107893
99714 B 107894
99715 B 107895
99716 B 107896
99717 B 107897
99718 B 107898
99719 B 107899
99720 B 107900
99721 B 107901
99722 B 107902
99723 B 107903
99724 B 107904
99725 B 107905
99726 B 107906
99727 B 107907
99728 B 107908
99729 B 107909
99730 B 107910
99731 B 107911
99732 B 107912
99733 B 107913
99734 B 107914
99735 B 107915
99736 B 107916
99737 B 107917
99738 B 107918
99739 B 107919
99740 B 107920
99741 B 107921
99742 B 107922
99743 B 107923
99744 B 107924
99745 B 107925
99746 B 107926
99747 B 107927
99748 B 107928
99749 B 107929
99750 B 107930
99751 B 107931
99752 B 107932
99753 B 107933
99754 B 107934
99755 B 107935
99756 B 107936
99757 B 107937
99758 B 107938
99759 B 107939
99760 B 107940
99761 B 107941
99762 B 107942
99763 B 107943
99764 B 107944
99765 B 107945
99766 B 107946
99767 B 107947
99768 B 107948
99769 B 107949
99770 B 107950
99771 B 107951
99772 B 107952
99773 B 107953
99774 B 107954
99775 B 107955
99776 B 107956
99777 B 107957
99778 B 107958
99779 B 107959
99780 B 107960
99781 B 107961
99782 B 107962
99783 B 107963
99784 B 107964
99785 B 107965
99786 B 107966
99787 B 107967
99788 B 107968
99789 B 107969
99790 B 107970
99791 B 107971
99792 B 107972
99793 B 107973
99794 B 107974