[外掛]求助phpbb plus 會員列表

文章由 **sexgoin** » 2004-05-29 11:33

以下是錯誤訊息有大大能幫忙嗎?
謝謝...

Could not read user informations

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_nickname' in 'field list'

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, (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_online_display, (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_email = 1) AND ( (u.user_viewemail = 1) OR ( (u.user_viewemail = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_email_display, (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_pm = 1) AND ( (u.user_viewpm = 1) OR ( (u.user_viewpm = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_pm_display, (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_www_display, (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) as user_messanger_display, (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) 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 >= 1085800866) AND ((CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) = 1) THEN 1 ELSE 0 END) as user_online, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_pm = 1) AND ( (u.user_viewpm = 1) OR ( (u.user_viewpm = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) = 1 THEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_pm = 1) AND ( (u.user_viewpm = 1) OR ( (u.user_viewpm = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) ELSE 0 END) as user_pm, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_email = 1) AND ( (u.user_viewemail = 1) OR ( (u.user_viewemail = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_email ELSE '' END) as user_email_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_icq ELSE '' END) as user_icq_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_aim ELSE '' END) as user_aim_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_yim ELSE '' END) as user_yim_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_messanger = 1) AND ( (u.user_viewmessanger = 1) OR ( (u.user_viewmessanger = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_msnm ELSE '' END) as user_msnm_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_regdate ELSE 0 END) as user_regdate_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_lastvisit ELSE 0 END) as user_lastvisit_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ((CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) = 1) OR ( (u.user_allow_viewonline = 1) OR ( (u.user_allow_viewonline = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_posts ELSE 0 END) as user_posts_virt, (CASE WHEN ((CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END) = 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 (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_timezone ELSE 0 END) as user_timezone_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_lang ELSE '' END) as user_lang_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_website ELSE '' END) as user_website_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_realname ELSE '' END) as user_realname_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_nickname ELSE '' END) as user_nickname_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_website = 1) AND ( (u.user_viewwebsite = 1) OR ( (u.user_viewwebsite = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_vip_title ELSE '' END) as user_vip_title_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_gender ELSE 0 END) as user_gender_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_birthday ELSE '' END) as user_birthday_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_from ELSE '' END) as user_from_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_occ ELSE '' END) as user_occ_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_interests ELSE '' END) as user_interests_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_home_phone ELSE '' END) as user_home_phone_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_home_fax ELSE '' END) as user_home_fax_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_work_phone ELSE '' END) as user_work_phone_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_work_fax ELSE '' END) as user_work_fax_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=1 THEN u.user_cellular ELSE '' END) as user_cellular_virt, (CASE WHEN (CASE WHEN (u.user_id = 4) OR ( ((CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) <> 1) AND ( ('1' = '1') AND (u.user_allow_real = 1) AND ( (u.user_viewreal = 1) OR ( (u.user_viewreal = 2) AND ((CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) = 1) ) ) ) ) THEN 1 ELSE 0 END)=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=4) LEFT JOIN phpbb_buddy as i ON i.user_id=4 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_id ORDER BY u.username ASC, u.username ASC

Line : 745
File : c:\apache\htdocs\phplus\profilcp\profilcp_buddy.php

文章由 **夢幻LUGIA** » 2004-05-29 11:48

plus請移駕至分站..

Unknown column 'u.user_nickname' in 'field list'
資料庫沒有會員暱稱這個欄位

文章由 **sexgoin** » 2004-05-29 12:00

但已新增了呀...在資料表中已進入phpbb_users新增該欄位了呀但還是無法解決
不知有無辦法解決呢?

文章由 **夢幻LUGIA** » 2004-05-29 12:24

分站好像掛了...=____________=|||

檢查一下是否有拼錯欄位名稱之類的小錯誤...
試試看這句SQL會不會出錯，如果還是有問題...那就應該是欄位名稱或資料表名稱錯了...?_?

代碼: 選擇全部

SELECT user_nickname FROM phpbb_users

文章由 **shihchieh** » 2004-05-29 18:05

一看就知道了
多了一個, u.username ASC

接續的問題請移駕plus中文支援站~請勿再跟貼