Code: Alles auswählen
Could not read user informations
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'BY bl_id = 3, bl_id = 13, bl_id = 9, bl_id = 8, bl_id = 16, bl_id = 6, bl_id = 1' at line 27
SELECT DISTINCT u.*, (CASE WHEN u.user_from_flag = 'blank.gif' THEN '' ELSE TRIM(LEADING ' ' FROM SUBSTRING(LPAD(u.user_from_flag, 25, ' '), 1, 21)) END) as user_flag, 1 as user_online_display, 1 as user_email_display, 1 as user_pm_display, 1 as user_www_display, 1 as user_messanger_display, 1 as user_real_display, (CASE WHEN i.buddy_ignore = 0 THEN 1 ELSE 0 END) as user_my_friend, (CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) as user_my_ignore, (CASE WHEN i.buddy_visible = 1 THEN 1 ELSE 0 END) as user_my_visible, (CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) as user_friend, (CASE WHEN b.buddy_ignore = 1 THEN 1 ELSE 0 END) as user_ignore, (CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) as user_visible , (CASE WHEN i.buddy_ignore = 0 THEN 1 ELSE 0 END) as user_my_friend, (CASE WHEN (u.user_session_time >= 1085962282) AND (1 = 1) THEN 1 ELSE 0 END) as user_online, (CASE WHEN 1 = 1 THEN 1 ELSE 0 END) as user_pm, (CASE WHEN 1=1 THEN u.user_email ELSE '' END) as user_email_virt, (CASE WHEN 1=1 THEN u.user_icq ELSE '' END) as user_icq_virt, (CASE WHEN 1=1 THEN u.user_aim ELSE '' END) as user_aim_virt, (CASE WHEN 1=1 THEN u.user_yim ELSE '' END) as user_yim_virt, (CASE WHEN 1=1 THEN u.user_msnm ELSE '' END) as user_msnm_virt, (CASE WHEN 1=1 THEN u.user_regdate ELSE 0 END) as user_regdate_virt, (CASE WHEN 1=1 THEN u.user_lastvisit ELSE 0 END) as user_lastvisit_virt, (CASE WHEN 1=1 THEN u.user_posts ELSE 0 END) as user_posts_virt, (CASE WHEN (1 = 1) THEN ( COALESCE(sr.rank_title, SUBSTRING(MAX(CONCAT(LPAD(nr.rank_min,8,'0'), nr.rank_title)), 9)) ) ELSE '' END) as user_rank_title, (CASE WHEN 1=1 THEN u.user_timezone ELSE 0 END) as user_timezone_virt, (CASE WHEN 1=1 THEN u.user_lang ELSE '' END) as user_lang_virt, (CASE WHEN 1=1 THEN u.user_website ELSE '' END) as user_website_virt, (CASE WHEN 1=1 THEN u.user_realname ELSE '' END) as user_realname_virt, (CASE WHEN 1=1 THEN u.user_gender ELSE 0 END) as user_gender_virt, (CASE WHEN 1=1 THEN u.user_birthday ELSE '' END) as user_birthday_virt, (CASE WHEN 1=1 THEN u.user_from ELSE '' END) as user_from_virt, (CASE WHEN 1=1 THEN u.user_occ ELSE '' END) as user_occ_virt, (CASE WHEN 1=1 THEN u.user_interests ELSE '' END) as user_interests_virt, (CASE WHEN 1=1 THEN u.user_home_phone ELSE '' END) as user_home_phone_virt, (CASE WHEN 1=1 THEN u.user_home_fax ELSE '' END) as user_home_fax_virt, (CASE WHEN 1=1 THEN u.user_work_phone ELSE '' END) as user_work_phone_virt, (CASE WHEN 1=1 THEN u.user_work_fax ELSE '' END) as user_work_fax_virt, (CASE WHEN 1=1 THEN u.user_cellular ELSE '' END) as user_cellular_virt, (CASE WHEN 1=1 THEN u.user_pager ELSE '' END) as user_pager_virt FROM (((((phpbb_users as u LEFT JOIN phpbb_flags as f ON f.flag_image = u.user_from_flag) LEFT JOIN phpbb_buddy as b ON b.user_id=u.user_id AND b.buddy_id=7) LEFT JOIN phpbb_buddy as i ON i.user_id=7 AND i.buddy_id=u.user_id) LEFT JOIN phpbb_ranks as sr ON u.user_rank > 0 AND sr.rank_special = 1 AND u.user_rank = sr.rank_id) LEFT JOIN phpbb_ranks as nr ON u.user_rank = 0 AND nr.rank_special = 0 AND nr.rank_min <= u.user_posts) WHERE u.user_id <> -1 GROUP BY u.user_idORDER BY bl_id = 3, bl_id = 13, bl_id = 9, bl_id = 8, bl_id = 16, bl_id = 6, bl_id = 17, bl_id = 4, bl_id = 10, bl_id = 20 ORDER BY u.username ASC, u.username ASC
Line : 734
File : /home/www/web75/html/phpBB2x/profilcp/profilcp_buddy.phpWas sagt mir dieser Fehler? und wie kann ich ihn beheben?
