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 (
    94732, 94736, 94740, 94744, 94748, 96305, 
    96306, 96307, 96309, 96312, 96315, 
    96317, 96320, 96322, 96324, 96326, 
    96328, 96330, 96332, 96335, 96339, 
    97016, 97022, 97023, 97026, 97030, 
    97032, 97039, 97045, 97833, 97843, 
    97847, 97852, 97856, 97860, 97864, 
    97868, 97872, 97890, 97891, 97892, 
    97893, 97894, 97895, 97896, 97897, 
    97898, 97899, 97900, 97901, 97902, 
    97915, 97916, 97917, 97918, 97919, 
    97920, 97921, 97922, 97923, 97924, 
    97925, 97926, 97927, 97928, 97929, 
    97930, 97931, 97932, 97933, 97934, 
    97947, 97948, 97949, 97950, 97951, 
    97960, 97961, 97964, 97965, 97966, 
    97969, 97974, 97976, 97977, 97980, 
    97981, 97984, 97985, 98040, 98042, 
    98044, 98046, 98048, 98050, 98085
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00174

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 (94732,94736,94740,94744,94748,96305,96306,96307,96309,96312,96315,96317,96320,96322,96324,96326,96328,96330,96332,96335,96339,97016,97022,97023,97026,97030,97032,97039,97045,97833,97843,97847,97852,97856,97860,97864,97868,97872,97890,97891,97892,97893,97894,97895,97896,97897,97898,97899,97900,97901,97902,97915,97916,97917,97918,97919,97920,97921,97922,97923,97924,97925,97926,97927,97928,97929,97930,97931,97932,97933,97934,97947,97948,97949,97950,97951,97960,97961,97964,97965,97966,97969,97974,97976,97977,97980,97981,97984,97985,98040,98042,98044,98046,98048,98050,98085)) 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
94732 B 102904
94736 B 102908
94740 B 102912
94744 B 102916
94748 B 102920
96305 B 104477
96306 B 104478
96307 B 104479
96309 B 104481
96312 B 104484
96315 B 104487
96317 B 104489
96320 B 104492
96322 B 104494
96324 B 104496
96326 B 104498
96328 B 104500
96330 B 104502
96332 B 104504
96335 B 104507
96339 B 104511
97016 B 105197
97022 B 105203
97023 B 105204
97026 B 105207
97030 B 105211
97032 B 105213
97039 B 105220
97045 B 105226
97833 B 106014
97843 B 106024
97847 B 106028
97852 B 106033
97856 B 106037
97860 B 106041
97864 B 106045
97868 B 106049
97872 B 106053
97890 B 106071
97891 B 106072
97892 B 106073
97893 B 106074
97894 B 106075
97895 B 106076
97896 B 106077
97897 B 106078
97898 B 106079
97899 B 106080
97900 B 106081
97901 B 106082
97902 B 106083
97915 B 106096
97916 B 106097
97917 B 106098
97918 B 106099
97919 B 106100
97920 B 106101
97921 B 106102
97922 B 106103
97923 B 106104
97924 B 106105
97925 B 106106
97926 B 106107
97927 B 106108
97928 B 106109
97929 B 106110
97930 B 106111
97931 B 106112
97932 B 106113
97933 B 106114
97934 B 106115
97947 B 106128
97948 B 106129
97949 B 106130
97950 B 106131
97951 B 106132
97960 B 106141
97961 B 106142
97964 B 106145
97965 B 106146
97966 B 106147
97969 B 106150
97974 B 106155
97976 B 106157
97977 B 106158
97980 B 106161
97981 B 106162
97984 B 106165
97985 B 106166
98040 B 106221
98042 B 106223
98044 B 106225
98046 B 106227
98048 B 106229
98050 B 106231
98085 B 106266