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 (
    90034, 90035, 90036, 90037, 87864, 87866, 
    90042, 90043, 90044, 90045, 90046, 
    90047, 90058, 90059, 84039, 84230, 
    84042, 88098, 84233, 87831, 87844, 
    90014, 90015, 90016, 90017, 90026, 
    90027, 90028, 90029, 90030, 90031, 
    87850, 88096, 87860, 87884, 87886, 
    87862, 88315, 91431, 87829, 87842, 
    87848, 87858, 88314, 87863, 87865, 
    87827, 87840, 87833, 87846, 87838, 
    88308, 88313, 88320, 88322, 87856, 
    87836, 87854, 87834, 87852, 92318, 
    88254, 92319, 92321, 92320, 88259, 
    88256, 88257, 85630, 88258, 87872, 
    92317, 88317, 88318, 88011, 88255, 
    88252, 88061, 92316, 87871, 88012, 
    88309, 88310, 91432, 88307, 88253, 
    88319, 88321, 85639, 88010, 88251, 
    88306, 88312, 85640, 88311, 92892
  ) 
  AND cscart_discussion.object_type = "P" 
GROUP BY 
  cscart_discussion.object_id

Query time 0.00140

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 (90034,90035,90036,90037,87864,87866,90042,90043,90044,90045,90046,90047,90058,90059,84039,84230,84042,88098,84233,87831,87844,90014,90015,90016,90017,90026,90027,90028,90029,90030,90031,87850,88096,87860,87884,87886,87862,88315,91431,87829,87842,87848,87858,88314,87863,87865,87827,87840,87833,87846,87838,88308,88313,88320,88322,87856,87836,87854,87834,87852,92318,88254,92319,92321,92320,88259,88256,88257,85630,88258,87872,92317,88317,88318,88011,88255,88252,88061,92316,87871,88012,88309,88310,91432,88307,88253,88319,88321,85639,88010,88251,88306,88312,85640,88311,92892)) 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
84039 D 92077
84042 D 92080
84230 D 92268
84233 D 92271
85630 D 93668
85639 D 93677
85640 D 93678
87827 D 95865
87829 D 95867
87831 D 95869
87833 D 95871
87834 D 95872
87836 D 95874
87838 D 95876
87840 D 95878
87842 D 95880
87844 D 95882
87846 D 95884
87848 D 95886
87850 D 95888
87852 D 95890
87854 D 95892
87856 D 95894
87858 D 95896
87860 D 95898
87862 D 95900
87863 D 95901
87864 D 95902
87865 D 95903
87866 D 95904
87871 D 95909
87872 D 95910
87884 D 95922
87886 D 95924
88010 D 96048
88011 D 96049
88012 D 96050
88061 D 96099
88096 D 96134
88098 D 96136
88251 D 96289
88252 D 96290
88253 D 96291
88254 D 96292
88255 D 96293
88256 D 96294
88257 D 96295
88258 D 96296
88259 D 96297
88306 D 96344
88307 D 96345
88308 D 96346
88309 D 96347
88310 D 96348
88311 D 96349
88312 D 96350
88313 D 96351
88314 D 96352
88315 D 96353
88317 D 96355
88318 D 96356
88319 D 96357
88320 D 96358
88321 D 96359
88322 D 96360
90014 D 98052
90015 D 98053
90016 D 98054
90017 D 98055
90026 D 98064
90027 D 98065
90028 D 98066
90029 D 98067
90030 D 98068
90031 D 98069
90034 D 98072
90035 D 98073
90036 D 98074
90037 D 98075
90042 D 98080
90043 D 98081
90044 D 98082
90045 D 98083
90046 D 98084
90047 D 98085
90058 D 98096
90059 D 98097
91431 D 99504
91432 D 99505
92316 D 100420
92317 D 100421
92318 D 100422
92319 D 100423
92320 D 100424
92321 D 100425
92892 B 101032