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 (
    95726, 95727, 95728, 95729, 95730, 95731, 
    95732, 95733, 95734, 95735, 96122, 
    96124, 96125, 96126, 96127, 96128, 
    96129, 96131, 96132, 96133, 96134, 
    96135, 96136, 96137, 96138, 96139, 
    96140, 96141, 96142, 96143, 96144, 
    96145, 96146, 96147, 96148, 96149, 
    96150, 96151, 96152, 96153, 96154, 
    96155, 96156, 96157, 96158, 96159, 
    96160, 96161, 96162, 96163, 96164, 
    96165, 96166, 96167, 96168, 96169, 
    96170, 96171, 96172, 96173, 96174, 
    96175, 96189, 96195, 96196, 96197, 
    96198, 96199, 96200, 96201, 96209, 
    96212, 96349, 96537, 96559, 96560, 
    96561, 96842, 96843, 96844, 96845, 
    96846, 96847, 97057, 97058, 97059, 
    97060, 97061, 97062, 97063, 97064, 
    97065, 97066, 97067, 97068, 97069
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00153

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 (95726,95727,95728,95729,95730,95731,95732,95733,95734,95735,96122,96124,96125,96126,96127,96128,96129,96131,96132,96133,96134,96135,96136,96137,96138,96139,96140,96141,96142,96143,96144,96145,96146,96147,96148,96149,96150,96151,96152,96153,96154,96155,96156,96157,96158,96159,96160,96161,96162,96163,96164,96165,96166,96167,96168,96169,96170,96171,96172,96173,96174,96175,96189,96195,96196,96197,96198,96199,96200,96201,96209,96212,96349,96537,96559,96560,96561,96842,96843,96844,96845,96846,96847,97057,97058,97059,97060,97061,97062,97063,97064,97065,97066,97067,97068,97069)) 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
95726 B 103898
95727 B 103899
95728 B 103900
95729 B 103901
95730 B 103902
95731 B 103903
95732 B 103904
95733 B 103905
95734 B 103906
95735 B 103907
96122 B 104294
96124 B 104296
96125 B 104297
96126 B 104298
96127 B 104299
96128 B 104300
96129 B 104301
96131 B 104303
96132 B 104304
96133 B 104305
96134 B 104306
96135 B 104307
96136 B 104308
96137 B 104309
96138 B 104310
96139 B 104311
96140 B 104312
96141 B 104313
96142 B 104314
96143 B 104315
96144 B 104316
96145 B 104317
96146 B 104318
96147 B 104319
96148 B 104320
96149 B 104321
96150 B 104322
96151 B 104323
96152 B 104324
96153 B 104325
96154 B 104326
96155 B 104327
96156 B 104328
96157 B 104329
96158 B 104330
96159 B 104331
96160 B 104332
96161 B 104333
96162 B 104334
96163 B 104335
96164 B 104336
96165 B 104337
96166 B 104338
96167 B 104339
96168 B 104340
96169 B 104341
96170 B 104342
96171 B 104343
96172 B 104344
96173 B 104345
96174 B 104346
96175 B 104347
96189 B 104361
96195 B 104367
96196 B 104368
96197 B 104369
96198 B 104370
96199 B 104371
96200 B 104372
96201 B 104373
96209 B 104381
96212 B 104384
96349 B 104521
96537 B 104718
96559 B 104740
96560 B 104741
96561 B 104742
96842 B 105023
96843 B 105024
96844 B 105025
96845 B 105026
96846 B 105027
96847 B 105028
97057 B 105238
97058 B 105239
97059 B 105240
97060 B 105241
97061 B 105242
97062 B 105243
97063 B 105244
97064 B 105245
97065 B 105246
97066 B 105247
97067 B 105248
97068 B 105249
97069 B 105250