IntegraMOD

Could not read user informations

DEBUG MODE

SQL Error : 1054 Unknown column 'r.rank_id' in 'on clause'

SELECT DISTINCT
u.*,
u.user_lastvisit AS user_lastvisit_virt,
i.buddy_visible AS user_my_visible_virt,
b.buddy_visible AS user_visible_virt,
u.user_cellular AS user_cellular_virt,
(CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_friend_virt,
u.user_home_fax AS user_home_fax_virt,
u.user_home_phone AS user_home_phone_virt,
(CASE WHEN b.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_ignore_virt,
u.user_regdate AS user_regdate_virt,
u.user_pager AS user_pager_virt,
u.user_posts AS user_posts_virt,
u.user_work_fax AS user_work_fax_virt,
u.user_work_phone AS user_work_phone_virt,
(CASE WHEN i.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_my_friend_virt,
u.user_icq AS user_icq_virt,
(CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_my_ignore_virt,
u.user_interests AS user_interests_virt,
u.user_from AS user_from_virt,
u.user_msnm AS user_msnm_virt,
u.user_occ AS user_occ_virt,
(CASE WHEN u.user_session_time >= (1183897013-300) THEN 1 ELSE 0 END) AS user_online_virt,
u.user_realname AS user_realname_virt,
u.user_skype AS user_skype_virt,
u.user_yim AS user_yim_virt,
u.user_aim AS user_aim_virt,
u.user_lang AS user_lang_virt,
r.rank_title AS user_rank_title_virt,
u.user_website AS user_website_virt,
u.user_warnings AS user_warnings_virt,
u.user_birthday AS user_birthday_virt,
1 AS user_pm_virt,
u.user_timezone AS user_timezone_virt,
u.user_flag AS user_flag_virt,
u.user_gender AS user_gender_virt,
u.user_holidays AS user_holidays_virt,
u.user_email AS user_email_virt,
u.username AS username_virt,
cr.rank_id AS user_custom_rank_virt,
u.user_main AS user_main_virt,
u.user_alt1 AS user_alt1_virt,
u.user_alt2 AS user_alt2_virt,
u.user_alt3 AS user_alt3_virt,
u.user_alt4 AS user_alt4_virt,
1 AS user_email_display,
1 AS user_generic_display,
1 AS user_messengers_display,
1 AS user_pm_display,
1 AS user_real_display,
1 AS user_viewonline_display,
1 AS user_webdisplay_display
FROM (((((
phpbb_users AS u)
LEFT JOIN phpbb_buddy AS i ON i.user_id=2 AND i.buddy_id=u.user_id)
LEFT JOIN phpbb_buddy AS b ON b.user_id=u.user_id AND b.buddy_id=2)
LEFT JOIN phpbb_ranks AS cr ON (r.rank_id = u.user_custom_rank AND r.rank_special <0> 0 AND r.rank_special <0>= r.rank_min AND u.user_posts < r.rank_max))
WHERE u.user_id <> -1
ORDER BY username_virt ASC



Line : 920
File : profilcp_buddy.php