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 (
    93782, 93783, 93784, 93785, 93786, 94026, 
    94027, 94028, 94029, 94030, 94031, 
    94032, 94033, 94074, 94075, 94428, 
    94452, 94453, 94454, 94455, 94456, 
    94458, 94459, 94460, 94461, 94462, 
    94709, 94717, 94718, 94719, 94720, 
    94721, 94722, 94723, 94724, 94725, 
    94726, 94727, 94728, 94729, 94730, 
    94731, 94732, 94733, 94734, 94735, 
    94736, 94737, 94738, 94739, 94740, 
    94741, 94742, 94743, 94744, 94745, 
    94746, 94747, 94748, 94749, 94750, 
    94751, 94752, 94753, 94754, 94755, 
    94756, 94757, 94758, 94759, 94760, 
    94761, 94762, 94763, 94764, 94765, 
    94816, 94950, 94951, 95565, 95566, 
    95567, 95568, 95569, 95570, 95571, 
    95572, 95573, 95574, 95575, 95576, 
    95577, 95578, 95579, 95580, 95581
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00099

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 (93782,93783,93784,93785,93786,94026,94027,94028,94029,94030,94031,94032,94033,94074,94075,94428,94452,94453,94454,94455,94456,94458,94459,94460,94461,94462,94709,94717,94718,94719,94720,94721,94722,94723,94724,94725,94726,94727,94728,94729,94730,94731,94732,94733,94734,94735,94736,94737,94738,94739,94740,94741,94742,94743,94744,94745,94746,94747,94748,94749,94750,94751,94752,94753,94754,94755,94756,94757,94758,94759,94760,94761,94762,94763,94764,94765,94816,94950,94951,95565,95566,95567,95568,95569,95570,95571,95572,95573,95574,95575,95576,95577,95578,95579,95580,95581)) 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
93782 B 101922
93783 B 101923
93784 B 101924
93785 B 101925
93786 B 101926
94026 B 102166
94027 B 102167
94028 B 102168
94029 B 102169
94030 B 102170
94031 B 102171
94032 B 102172
94033 B 102173
94074 B 102214
94075 B 102215
94428 B 102573
94452 B 102624
94453 B 102625
94454 B 102626
94455 B 102627
94456 B 102628
94458 B 102630
94459 B 102631
94460 B 102632
94461 B 102633
94462 B 102634
94709 B 102881
94717 B 102889
94718 B 102890
94719 B 102891
94720 B 102892
94721 B 102893
94722 B 102894
94723 B 102895
94724 B 102896
94725 B 102897
94726 B 102898
94727 B 102899
94728 B 102900
94729 B 102901
94730 B 102902
94731 B 102903
94732 B 102904
94733 B 102905
94734 B 102906
94735 B 102907
94736 B 102908
94737 B 102909
94738 B 102910
94739 B 102911
94740 B 102912
94741 B 102913
94742 B 102914
94743 B 102915
94744 B 102916
94745 B 102917
94746 B 102918
94747 B 102919
94748 B 102920
94749 B 102921
94750 B 102922
94751 B 102923
94752 B 102924
94753 B 102925
94754 B 102926
94755 B 102927
94756 B 102928
94757 B 102929
94758 B 102930
94759 B 102931
94760 B 102932
94761 B 102933
94762 B 102934
94763 B 102935
94764 B 102936
94765 B 102937
94816 B 102988
94950 B 103122
94951 B 103123
95565 B 103737
95566 B 103738
95567 B 103739
95568 B 103740
95569 B 103741
95570 B 103742
95571 B 103743
95572 B 103744
95573 B 103745
95574 B 103746
95575 B 103747
95576 B 103748
95577 B 103749
95578 B 103750
95579 B 103751
95580 B 103752
95581 B 103753