[外掛]從phpbb2.06 升級到 plus 1.3 的問題 拜託

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

版主: 版主管理群

主題已鎖定
jris
星球普通子民
星球普通子民
文章: 3
註冊時間: 2004-01-02 23:17

[外掛]從phpbb2.06 升級到 plus 1.3 的問題 拜託

文章 jris » 2004-06-09 22:51

各位大家好, 這是我第一次發言.

問題:
我把我的討論區PHPBB 2.06 升級到 plus 1.3. 每種東西都很順, 唯讀一個東西不順, 希望有經驗的大大們幫我解決這個問題

當我按"會員列表"的時候, 下面就顯現出這樣的code. 請問我是哪裡做錯了呢? 我是將 2.06 升到1.3 的. 有誰可以幫助我嗎?

您可以看看我的情況到 http://www.uq.com.tw/phpbb案會員列表..

謝謝

User Name: test
password: test

代碼: 選擇全部

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 >= 1086787534) 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 : /home2/uqcoma/public_html/phpbb/profilcp/profilcp_buddy.php
----------------------------------------------------------------
●架設主機作業系統:Linux 吧. 我用Virtue server (http://www.t35.com) (付費的)
●phpBB2 版本:phpBB Plus 1.3 (從2.6升級到Plus 1.3)
●錯誤代碼:請使用 BBcode 標籤將錯誤代碼標註,範例如下(這是為了避免語法衝突)
●我的網址: http://www.uq.com.tw/phpbb

神川小羽
調皮の小羽
調皮の小羽
文章: 1464
註冊時間: 2004-05-01 05:55
來自: 謎樣之筱語
聯繫:

文章 神川小羽 » 2004-06-09 23:12

錯誤訊息應該是..............
SQL Error : 1054 Unknown column 'u.user_nickname' in 'field list'
在\r
Line : 745
File : /home2/uqcoma/public_html/phpbb/profilcp/profilcp_buddy.php
這是我剛剛去您提供的測試帳號去看的結果
您看您能不能把
profilcp_buddy.php的745的上下10行PO上來 這樣可能會比較容易讓竹貓眾多大大找到答案唷 :oops:

不過其實我沒用過PLUS的版本.......
-.-

吉川拓也
竹貓忠實會員
竹貓忠實會員
文章: 1216
註冊時間: 2003-02-09 18:24
來自: [ G.I.T ]
聯繫:

Re: [外掛]從phpbb2.06 升級到 plus 1.3 的問題 拜託

文章 吉川拓也 » 2004-06-09 23:52

jris 寫:各位大家好, 這是我第一次發言.

問題:
我把我的討論區PHPBB 2.06 升級到 plus 1.3. 每種東西都很順, 唯讀一個東西不順, 希望有經驗的大大們幫我解決這個問題

當我按"會員列表"的時候, 下面就顯現出這樣的code. 請問我是哪裡做錯了呢? 我是將 2.06 升到1.3 的. 有誰可以幫助我嗎?

您可以看看我的情況到 http://www.uq.com.tw/phpbb案會員列表..

謝謝

User Name: test
password: test

代碼: 選擇全部

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 >= 1086787534) 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 : /home2/uqcoma/public_html/phpbb/profilcp/profilcp_buddy.php
----------------------------------------------------------------
●架設主機作業系統:Linux 吧. 我用Virtue server (http://www.t35.com) (付費的)
●phpBB2 版本:phpBB Plus 1.3 (從2.6升級到Plus 1.3)
●錯誤代碼:請使用 BBcode 標籤將錯誤代碼標註,範例如下(這是為了避免語法衝突)
●我的網址: http://www.uq.com.tw/phpbb
請先下載英文版內的 profilcp_buddy.php 覆蓋原本的檔案 !
另外 plus 問題請至 plus 分站發文 ^^
竹貓分站 : http://www.phpbb-tw.com/plus/portal.php
善用 搜尋 可以解決您 90% 的問題
頭腦清晰,選擇正確。 (╯▔︹▔)╯~╘═╛

jris
星球普通子民
星球普通子民
文章: 3
註冊時間: 2004-01-02 23:17

文章 jris » 2004-06-10 04:55

解決了, 解決了, 感謝你們的大恩大德. 看到你們都留言, 懹我聯想到, 原來我是沒有從英文版升級到中文版.. 哈哈. 感謝你們的提醒...

還有, 我有先去plus 留言, 可是 plus 一天不到3個留言的速度.. 要等很久, 所以想說來這裡post 看看... 抱歉, 照成困擾..... :-P :-P :-P :-P


----------------------------------------------------------------
●架設主機作業系統:Linux 吧. 我用Virtue server (http://www.t35.com) (付費的)
●phpBB2 版本:phpBB Plus 1.3 (從2.6升級到Plus 1.3)
●錯誤代碼:請使用 BBcode 標籤將錯誤代碼標註,範例如下(這是為了避免語法衝突)
●我的網址: http://www.uq.com.tw/phpbb

主題已鎖定

回到「phpBB 2 plus 綜合討論」