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 (
    90699, 90703, 90707, 90640, 90641, 90649, 
    90683, 90689, 90733, 90842, 90625, 
    90631, 90596, 90597, 90602, 90603, 
    90708, 90710, 90682, 90688, 90624, 
    90630, 90696, 90697, 90701, 90705, 
    90673, 90679, 90638, 90639, 90647, 
    90615, 90621, 90672, 90678, 90651, 
    90686, 90614, 90620, 90628, 90694, 
    90695, 90636, 90637, 90645, 90663, 
    90669, 90605, 90611, 90662, 90668, 
    90604, 90610, 90650, 90676, 90692, 
    90693, 90653, 90659, 90618, 90634, 
    90635, 90643, 90595, 90601, 90652, 
    90658, 90594, 90600, 90666, 90608, 
    84041, 84232, 84044, 84235, 90656, 
    84236, 90598, 84043, 90048, 90049, 
    90050, 90051, 90052, 90053, 84040, 
    84231, 84234, 88316, 88100, 90018, 
    90019, 90020, 90021, 90032, 90033
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00204

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 (90699,90703,90707,90640,90641,90649,90683,90689,90733,90842,90625,90631,90596,90597,90602,90603,90708,90710,90682,90688,90624,90630,90696,90697,90701,90705,90673,90679,90638,90639,90647,90615,90621,90672,90678,90651,90686,90614,90620,90628,90694,90695,90636,90637,90645,90663,90669,90605,90611,90662,90668,90604,90610,90650,90676,90692,90693,90653,90659,90618,90634,90635,90643,90595,90601,90652,90658,90594,90600,90666,90608,84041,84232,84044,84235,90656,84236,90598,84043,90048,90049,90050,90051,90052,90053,84040,84231,84234,88316,88100,90018,90019,90020,90021,90032,90033)) 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
84040 D 92078
84041 D 92079
84043 D 92081
84044 D 92082
84231 D 92269
84232 D 92270
84234 D 92272
84235 D 92273
84236 D 92274
88100 D 96138
88316 D 96354
90018 D 98056
90019 D 98057
90020 D 98058
90021 D 98059
90032 D 98070
90033 D 98071
90048 D 98086
90049 D 98087
90050 D 98088
90051 D 98089
90052 D 98090
90053 D 98091
90594 D 98646
90595 D 98647
90596 D 98648
90597 D 98649
90598 D 98650
90600 D 98652
90601 D 98653
90602 D 98654
90603 D 98655
90604 D 98656
90605 D 98657
90608 D 98660
90610 D 98662
90611 D 98663
90614 D 98666
90615 D 98667
90618 D 98670
90620 D 98672
90621 D 98673
90624 D 98676
90625 D 98677
90628 D 98680
90630 D 98682
90631 D 98683
90634 D 98686
90635 D 98687
90636 D 98688
90637 D 98689
90638 D 98690
90639 D 98691
90640 D 98692
90641 D 98693
90643 D 98695
90645 D 98697
90647 D 98699
90649 D 98701
90650 D 98702
90651 D 98703
90652 D 98704
90653 D 98705
90656 D 98708
90658 D 98710
90659 D 98711
90662 D 98714
90663 D 98715
90666 D 98718
90668 D 98720
90669 D 98721
90672 D 98724
90673 D 98725
90676 D 98728
90678 D 98730
90679 D 98731
90682 D 98734
90683 D 98735
90686 D 98738
90688 D 98740
90689 D 98741
90692 D 98744
90693 D 98745
90694 D 98746
90695 D 98747
90696 D 98748
90697 D 98749
90699 D 98751
90701 D 98753
90703 D 98755
90705 D 98757
90707 D 98759
90708 D 98760
90710 D 98762
90733 D 98786
90842 D 98896