[問題] phpBB2 Plus會員列表ㄉ問題^^

phpBB Plus Support
本區是討論關於 phpBB 2 plus 使用上的問題討論!
(發表文章請按照公告格式發表,違者砍文)

版主: 版主管理群

主題已鎖定
gh70641
星球普通子民
星球普通子民
文章: 8
註冊時間: 2005-02-04 15:35

[問題] phpBB2 Plus會員列表ㄉ問題^^

文章 gh70641 » 2005-02-21 19:58

這是什ㄇ原因阿這ㄍ問題出現在會員列表^^

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, 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 >= 1108986571) 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_nickname ELSE '' END) as user_nickname_virt, (CASE WHEN 1=1 THEN u.user_vip_title ELSE '' END) as user_vip_title_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_id ORDER BY u.username ASC, u.username ASC

Line : 745
File : c:\appserv\www\php\profilcp\profilcp_buddy.php


還有一ㄍ是出現在個人資料修改ㄉ部分
Could not update user table

DEBUG MODE

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

UPDATE phpbb_users SET user_nickname = '', user_realname = '', user_viewwebsite = '1', user_viewmessanger = '1', user_viewreal = '1', user_website = '', user_icq = '', user_aim = '', user_msnm = '', user_yim = '', user_gender = '0', user_birthday = '0', user_from = '', user_from_flag = 'blank.gif', user_occ = '', user_interests = '', user_home_phone = '', user_home_fax = '', user_work_phone = '', user_work_fax = '', user_cellular = '', user_pager = '', user_last_birthday = 0 WHERE user_id = 2

Line : 144
File : c:\appserv\www\php\profilcp\profilcp_profil_base.php

麻煩各位PHP高手ㄉ大大幫忙解決依下小弟ㄉ問題還有可以請教依下ㄇㄚ
我架了兩種論壇請問差在哪裡ㄚ
一ㄍ是phpBB2 Plus
一ㄍ是 phpBB 2.0.11


●架設主機作業系統:Windows xp pr
●快速架站程式:Appserv2.3.0
●您的上網方式:ADSL 2m/512
●您安裝的程式:Apache + php + MySql
●您的 phpBB2 版本: phpBB2 Plus based on phpBB 2.0.6
●您的 phpBB2 連結網址:http://220.135.150.98/php/index.php

主題已鎖定

回到「phpBB 2 plus 綜合討論」