User Error
PDOException Object ( [message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and t1.category_id IN (SELECT category_id FROM nukeviet_home.tms_vi_social_us...' at line 1 [string:Exception:private] => [code:protected] => 42000 [file:protected] => /home/nukeviet/domains/nuke.vn/public_html/vendor/vinades/nukeviet/Core/Database.php [line:protected] => 562 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/nukeviet/domains/nuke.vn/public_html/vendor/vinades/nukeviet/Core/Database.php [line] => 562 [function] => prepare [class] => PDO [type] => -> [args] => Array ( [0] => SELECT COUNT(t1.id) FROM nukeviet_home.tms_vi_social_notification t1 LEFT JOIN nukeviet_home.tms_vi_social_notification_user t2 ON t2.notification_id=t1.id WHERE ((t1.type="new_post_category" and t1.user_id != and t1.category_id IN (SELECT category_id FROM nukeviet_home.tms_vi_social_user_category where user_id=) and t1.time_add > ALL (SELECT time_add FROM nukeviet_home.tms_vi_social_user_category where user_id=)) OR (t1.type="new_comment_post_category" and t1.user_id != and t1.category_id IN (SELECT category_id FROM nukeviet_home.tms_vi_social_post_category where user_id=)) OR (t1.type="new_comment_post_category_reply" and t1.user_id != and t1.comment_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_comment where user_id=)) OR (t1.type="new_like_post_category" and t1.user_id != and t1.obid IN (SELECT id FROM nukeviet_home.tms_vi_social_post_category where user_id=)) OR (t1.type="new_dislike_post_category" and t1.user_id != and t1.obid IN (SELECT id FROM nukeviet_home.tms_vi_social_post_category where user_id=)) OR (t1.type="new_like_comment_post_category" and t1.user_id != and t1.category_id IN (SELECT category_id FROM nukeviet_home.tms_vi_social_post_category where user_id=)) OR (t1.type="new_dislike_comment_post_category" and t1.user_id != and t1.category_id IN (SELECT category_id FROM nukeviet_home.tms_vi_social_post_category where user_id=)) OR (t1.type="new_like_comment_post_category_reply" and t1.user_id != and t1.comment_reply_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_comment_reply where user_id=)) OR (t1.type="new_dislike_comment_post_category_reply" and t1.user_id != and t1.comment_reply_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_comment_reply where user_id=)) OR (t1.type="new_level_management" and t1.user_id=) OR (t1.type="new_comment_post_user" and t1.user_id != and t1.comment_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment where post_id=t1.obid)) OR (t1.type="new_like_post_user" and t1.user_id != and t1.obid IN (SELECT id FROM nukeviet_home.tms_vi_social_user_post where user_id=)) OR (t1.type="new_dislike_post_user" and t1.user_id != and t1.obid IN (SELECT id FROM nukeviet_home.tms_vi_social_user_post where user_id=)) OR (t1.type="new_like_post_user_comment" and t1.user_id != and t1.comment_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment where user_id=)) OR (t1.type="new_dislike_comment_post_user" and t1.user_id != and t1.comment_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment where user_id=)) OR (t1.type="new_comment_post_user_reply" and t1.user_id != and t1.comment_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment where post_id=t1.obid)) OR (t1.type="new_like_comment_post_user_reply" and t1.user_id != and t1.comment_reply_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment_reply where user_id=)) OR (t1.type="new_unlike_comment_post_user_reply" and t1.user_id != and t1.comment_reply_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment_reply where user_id=)) OR (t1.type="new_comment_post_category_tag" and t1.user_id = ) OR (t1.type="new_comment_post_user_tag" and t1.user_id =) ) and ((t2.status=1 and t2.user_id=) OR t2.status IS NULL) [1] => Array ( ) ) ) [1] => Array ( [file] => /home/nukeviet/domains/nuke.vn/public_html/modules/social/funcs/notification.php [line] => 45 [function] => prepare [class] => NukeViet\Core\Database [type] => -> [args] => Array ( [0] => SELECT COUNT(t1.id) FROM nukeviet_home.tms_vi_social_notification t1 LEFT JOIN nukeviet_home.tms_vi_social_notification_user t2 ON t2.notification_id=t1.id WHERE ((t1.type="new_post_category" and t1.user_id != and t1.category_id IN (SELECT category_id FROM nukeviet_home.tms_vi_social_user_category where user_id=) and t1.time_add > ALL (SELECT time_add FROM nukeviet_home.tms_vi_social_user_category where user_id=)) OR (t1.type="new_comment_post_category" and t1.user_id != and t1.category_id IN (SELECT category_id FROM nukeviet_home.tms_vi_social_post_category where user_id=)) OR (t1.type="new_comment_post_category_reply" and t1.user_id != and t1.comment_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_comment where user_id=)) OR (t1.type="new_like_post_category" and t1.user_id != and t1.obid IN (SELECT id FROM nukeviet_home.tms_vi_social_post_category where user_id=)) OR (t1.type="new_dislike_post_category" and t1.user_id != and t1.obid IN (SELECT id FROM nukeviet_home.tms_vi_social_post_category where user_id=)) OR (t1.type="new_like_comment_post_category" and t1.user_id != and t1.category_id IN (SELECT category_id FROM nukeviet_home.tms_vi_social_post_category where user_id=)) OR (t1.type="new_dislike_comment_post_category" and t1.user_id != and t1.category_id IN (SELECT category_id FROM nukeviet_home.tms_vi_social_post_category where user_id=)) OR (t1.type="new_like_comment_post_category_reply" and t1.user_id != and t1.comment_reply_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_comment_reply where user_id=)) OR (t1.type="new_dislike_comment_post_category_reply" and t1.user_id != and t1.comment_reply_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_comment_reply where user_id=)) OR (t1.type="new_level_management" and t1.user_id=) OR (t1.type="new_comment_post_user" and t1.user_id != and t1.comment_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment where post_id=t1.obid)) OR (t1.type="new_like_post_user" and t1.user_id != and t1.obid IN (SELECT id FROM nukeviet_home.tms_vi_social_user_post where user_id=)) OR (t1.type="new_dislike_post_user" and t1.user_id != and t1.obid IN (SELECT id FROM nukeviet_home.tms_vi_social_user_post where user_id=)) OR (t1.type="new_like_post_user_comment" and t1.user_id != and t1.comment_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment where user_id=)) OR (t1.type="new_dislike_comment_post_user" and t1.user_id != and t1.comment_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment where user_id=)) OR (t1.type="new_comment_post_user_reply" and t1.user_id != and t1.comment_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment where post_id=t1.obid)) OR (t1.type="new_like_comment_post_user_reply" and t1.user_id != and t1.comment_reply_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment_reply where user_id=)) OR (t1.type="new_unlike_comment_post_user_reply" and t1.user_id != and t1.comment_reply_id IN (SELECT id FROM nukeviet_home.tms_vi_social_post_user_comment_reply where user_id=)) OR (t1.type="new_comment_post_category_tag" and t1.user_id = ) OR (t1.type="new_comment_post_user_tag" and t1.user_id =) ) and ((t2.status=1 and t2.user_id=) OR t2.status IS NULL) ) ) [2] => Array ( [file] => /home/nukeviet/domains/nuke.vn/public_html/index.php [line] => 396 [args] => Array ( [0] => /home/nukeviet/domains/nuke.vn/public_html/modules/social/funcs/notification.php ) [function] => require ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and t1.category_id IN (SELECT category_id FROM nukeviet_home.tms_vi_social_us...' at line 1 ) )
(Code: 855eced2206df3a930a5e472762b5b23)
If you have any questions about this site,
please contact the site administrator for more information