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 (
    97167, 97168, 97169, 97170, 97171, 97172, 
    97173, 97174, 97175, 97176, 97177, 
    97178, 97179, 97180, 97181, 97182, 
    97183, 97184, 97185, 97186, 97187, 
    97188, 97189, 97190, 97191, 97192, 
    97193, 97194, 97195, 97196, 97197, 
    97198, 97199, 97200, 97201, 97202, 
    97203, 97204, 97205, 97206, 97207, 
    97208, 97209, 97210, 97211, 97212, 
    97213, 97214, 97215, 97216, 97217, 
    97218, 97228, 97229, 97230, 97231, 
    97232, 97233, 97234, 97235, 97236, 
    97237, 97238, 97239, 97240, 97241, 
    97242, 97243, 97244, 97245, 97246, 
    97247, 97248, 97249, 97250, 97251, 
    97252, 97253, 97254, 97255, 97256, 
    97257, 97258, 97259, 97260, 97261, 
    97262, 97263, 97264, 97265, 97266, 
    97267, 97268, 97269, 97270, 97271
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00084

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 (97167,97168,97169,97170,97171,97172,97173,97174,97175,97176,97177,97178,97179,97180,97181,97182,97183,97184,97185,97186,97187,97188,97189,97190,97191,97192,97193,97194,97195,97196,97197,97198,97199,97200,97201,97202,97203,97204,97205,97206,97207,97208,97209,97210,97211,97212,97213,97214,97215,97216,97217,97218,97228,97229,97230,97231,97232,97233,97234,97235,97236,97237,97238,97239,97240,97241,97242,97243,97244,97245,97246,97247,97248,97249,97250,97251,97252,97253,97254,97255,97256,97257,97258,97259,97260,97261,97262,97263,97264,97265,97266,97267,97268,97269,97270,97271)) 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
97167 B 105348
97168 B 105349
97169 B 105350
97170 B 105351
97171 B 105352
97172 B 105353
97173 B 105354
97174 B 105355
97175 B 105356
97176 B 105357
97177 B 105358
97178 B 105359
97179 B 105360
97180 B 105361
97181 B 105362
97182 B 105363
97183 B 105364
97184 B 105365
97185 B 105366
97186 B 105367
97187 B 105368
97188 B 105369
97189 B 105370
97190 B 105371
97191 B 105372
97192 B 105373
97193 B 105374
97194 B 105375
97195 B 105376
97196 B 105377
97197 B 105378
97198 B 105379
97199 B 105380
97200 B 105381
97201 B 105382
97202 B 105383
97203 B 105384
97204 B 105385
97205 B 105386
97206 B 105387
97207 B 105388
97208 B 105389
97209 B 105390
97210 B 105391
97211 B 105392
97212 B 105393
97213 B 105394
97214 B 105395
97215 B 105396
97216 B 105397
97217 B 105398
97218 B 105399
97228 B 105409
97229 B 105410
97230 B 105411
97231 B 105412
97232 B 105413
97233 B 105414
97234 B 105415
97235 B 105416
97236 B 105417
97237 B 105418
97238 B 105419
97239 B 105420
97240 B 105421
97241 B 105422
97242 B 105423
97243 B 105424
97244 B 105425
97245 B 105426
97246 B 105427
97247 B 105428
97248 B 105429
97249 B 105430
97250 B 105431
97251 B 105432
97252 B 105433
97253 B 105434
97254 B 105435
97255 B 105436
97256 B 105437
97257 B 105438
97258 B 105439
97259 B 105440
97260 B 105441
97261 B 105442
97262 B 105443
97263 B 105444
97264 B 105445
97265 B 105446
97266 B 105447
97267 B 105448
97268 B 105449
97269 B 105450
97270 B 105451
97271 B 105452