Diese FEhlermeldung bekomme ich angezeigt!Could not read user informations
DEBUG MODE
SQL Error : 1064 Fehler in der Syntax bei 'BY bl_id = 6, bl_id = 5, bl_id = 4, bl_id = 3, bl_id = 2, bl_id ' in Zeile 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 >= 1082472475) 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=2) LEFT JOIN phpbb_buddy as i ON i.user_id=2 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 = 6, bl_id = 5, bl_id = 4, bl_id = 3, bl_id = 2, bl_id = 1 ORDER BY u.username ASC, u.username ASC
Line : 734
File : /home/.sites/126/site211/web/phpBB2plus/profilcp/profilcp_buddy.php
Kann mir jemand nen Tipp geben?
Der Code ist übrigens folgender code
Code: Alles auswählen
// read the number of row
------> 734 if ( !($result = $db->sql_query($sql)) ) message_die(GENERAL_ERROR, "Could not read user informations", '', __LINE__, __FILE__, $sql);
$total_users = $db->sql_numrows($result);
$sql .= " LIMIT $start, " . $board_config['topics_per_page'];
if ( !($result = $db->sql_query($sql)) ) message_die(GENERAL_ERROR, "Could not read user informations", '', __LINE__, __FILE__, $sql);
$users = array();
)