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 (
    91301, 83112, 83122, 83132, 89624, 90066, 
    86384, 89618, 89631, 87370, 89609, 
    89610, 89625, 89638, 90069, 89634, 
    89726, 90091, 90101, 90078, 85533, 
    89015, 90072, 90077, 84108, 89621, 
    89183, 83102, 92198, 92199, 92200, 
    92201, 92202, 92444, 92445, 92446, 
    92447, 89622, 89635, 91372, 91374, 
    83091, 91310, 86387, 84098, 90086, 
    90088, 90098, 83129, 90085, 91309, 
    92146, 83994, 83995, 83996, 83997, 
    92018, 92106, 89012, 91302, 91371, 
    91373, 86382, 89192, 85541, 91370, 
    92003, 92004, 92005, 92006, 92007, 
    92008, 92009, 92091, 92092, 92093, 
    92094, 92095, 92096, 92097, 92203, 
    92449, 91381, 91383, 83113, 83123, 
    83990, 83991, 83992, 83993, 89614, 
    89627, 83100, 85532, 91294, 84106
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00170

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 (91301,83112,83122,83132,89624,90066,86384,89618,89631,87370,89609,89610,89625,89638,90069,89634,89726,90091,90101,90078,85533,89015,90072,90077,84108,89621,89183,83102,92198,92199,92200,92201,92202,92444,92445,92446,92447,89622,89635,91372,91374,83091,91310,86387,84098,90086,90088,90098,83129,90085,91309,92146,83994,83995,83996,83997,92018,92106,89012,91302,91371,91373,86382,89192,85541,91370,92003,92004,92005,92006,92007,92008,92009,92091,92092,92093,92094,92095,92096,92097,92203,92449,91381,91383,83113,83123,83990,83991,83992,83993,89614,89627,83100,85532,91294,84106)) 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
83091 D 91129
83100 D 91138
83102 D 91140
83112 D 91150
83113 D 91151
83122 D 91160
83123 D 91161
83129 D 91167
83132 D 91170
83990 D 92028
83991 D 92029
83992 D 92030
83993 D 92031
83994 D 92032
83995 D 92033
83996 D 92034
83997 D 92035
84098 D 92136
84106 D 92144
84108 D 92146
85532 D 93570
85533 D 93571
85541 D 93579
86382 D 94420
86384 D 94422
86387 D 94425
87370 D 95408
89012 D 97050
89015 D 97053
89183 D 97221
89192 D 97230
89609 D 97647
89610 D 97648
89614 D 97652
89618 D 97656
89621 D 97659
89622 D 97660
89624 D 97662
89625 D 97663
89627 D 97665
89631 D 97669
89634 D 97672
89635 D 97673
89638 D 97676
89726 D 97764
90066 D 98104
90069 D 98107
90072 D 98110
90077 D 98115
90078 D 98116
90085 D 98123
90086 D 98124
90088 D 98126
90091 D 98129
90098 D 98136
90101 D 98139
91294 D 99367
91301 D 99374
91302 D 99375
91309 D 99382
91310 D 99383
91370 D 99443
91371 D 99444
91372 D 99445
91373 D 99446
91374 D 99447
91381 D 99454
91383 D 99456
92003 D 100081
92004 D 100082
92005 D 100083
92006 D 100084
92007 D 100085
92008 D 100086
92009 D 100087
92018 D 100096
92091 D 100169
92092 D 100170
92093 D 100171
92094 D 100172
92095 D 100173
92096 D 100174
92097 D 100175
92106 D 100184
92146 D 100224
92198 D 100276
92199 D 100277
92200 D 100278
92201 D 100279
92202 D 100280
92203 D 100281
92444 D 100548
92445 D 100549
92446 D 100550
92447 D 100551
92449 D 100553