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 (
    97553, 97554, 97555, 97556, 97557, 97558, 
    97559, 97560, 97561, 97562, 97563, 
    97564, 97565, 97566, 97568, 97569, 
    97571, 97572, 97587, 97588, 97589, 
    97590, 97591, 97592, 97593, 97594, 
    97595, 97596, 97597, 97598, 97599, 
    97600, 97601, 97602, 97603, 97604, 
    97605, 97606, 97607, 97713, 97714, 
    97715, 97953, 97954, 97955, 97956, 
    97957, 97958, 97994, 97995, 97996, 
    97997, 97998, 97999, 98000, 98024, 
    98025, 98026, 98027, 98028, 98029, 
    98457, 98458, 98459, 98460, 98461, 
    98462, 98463, 98464, 98465, 98466, 
    98467, 98468, 98469, 98470, 98471, 
    98472, 98473, 98474, 98475, 98496, 
    98497, 98498, 98499, 98500, 98501, 
    98515, 98521, 98522, 99026, 99027, 
    99028, 99029, 99030, 99031, 99032
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00143

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 (97553,97554,97555,97556,97557,97558,97559,97560,97561,97562,97563,97564,97565,97566,97568,97569,97571,97572,97587,97588,97589,97590,97591,97592,97593,97594,97595,97596,97597,97598,97599,97600,97601,97602,97603,97604,97605,97606,97607,97713,97714,97715,97953,97954,97955,97956,97957,97958,97994,97995,97996,97997,97998,97999,98000,98024,98025,98026,98027,98028,98029,98457,98458,98459,98460,98461,98462,98463,98464,98465,98466,98467,98468,98469,98470,98471,98472,98473,98474,98475,98496,98497,98498,98499,98500,98501,98515,98521,98522,99026,99027,99028,99029,99030,99031,99032)) 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
97553 B 105734
97554 B 105735
97555 B 105736
97556 B 105737
97557 B 105738
97558 B 105739
97559 B 105740
97560 B 105741
97561 B 105742
97562 B 105743
97563 B 105744
97564 B 105745
97565 B 105746
97566 B 105747
97568 B 105749
97569 B 105750
97571 B 105752
97572 B 105753
97587 B 105768
97588 B 105769
97589 B 105770
97590 B 105771
97591 B 105772
97592 B 105773
97593 B 105774
97594 B 105775
97595 B 105776
97596 B 105777
97597 B 105778
97598 B 105779
97599 B 105780
97600 B 105781
97601 B 105782
97602 B 105783
97603 B 105784
97604 B 105785
97605 B 105786
97606 B 105787
97607 B 105788
97713 B 105894
97714 B 105895
97715 B 105896
97953 B 106134
97954 B 106135
97955 B 106136
97956 B 106137
97957 B 106138
97958 B 106139
97994 B 106175
97995 B 106176
97996 B 106177
97997 B 106178
97998 B 106179
97999 B 106180
98000 B 106181
98024 B 106205
98025 B 106206
98026 B 106207
98027 B 106208
98028 B 106209
98029 B 106210
98457 B 106638
98458 B 106639
98459 B 106640
98460 B 106641
98461 B 106642
98462 B 106643
98463 B 106644
98464 B 106645
98465 B 106646
98466 B 106647
98467 B 106648
98468 B 106649
98469 B 106650
98470 B 106651
98471 B 106652
98472 B 106653
98473 B 106654
98474 B 106655
98475 B 106656
98496 B 106677
98497 B 106678
98498 B 106679
98499 B 106680
98500 B 106681
98501 B 106682
98515 B 106696
98521 B 106702
98522 B 106703
99026 B 107207
99027 B 107208
99028 B 107209
99029 B 107210
99030 B 107211
99031 B 107212
99032 B 107213