[問題] 緊急~Point System出現問題

[cbolong]

●架設主機作業系統：Windows　ｘｐ
●快速架站程式：Appserv
●免費空間連結： http://burning-g.net/
●您的上網方式：ADSL
●您安裝的程式：Apache + php + MySql
●您的 phpBB2 版本：phpBB2.0.13
我全部都按照\r
http://phpbb-tw.net/phpbb/viewtopic.php ... %A8t%B2%CE
所做的~
但出現這個~
Could not obtain post/user information.

DEBUG MODE

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

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_points, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 16 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 398
File : /home/cbolong/public_html/phpbb/viewtopic.php

[Man520]

●架設主機作業系統：Windows　ｘｐ
●快速架站程式：Appserv
●免費空間連結： http://burning-g.net/
●您的上網方式：ADSL
●您安裝的程式：Apache + php + MySql
●您的 phpBB2 版本：phpBB2.0.13
我全部都按照
http://phpbb-tw.net/phpbb/viewtopic.php ... %A8t%B2%CE
所做的~
但出現這個~
Could not obtain post/user information.

DEBUG MODE

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

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_points, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts, p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 16 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 398
File : /home/cbolong/public_html/phpbb/viewtopic.php

試試~~

[cbolong]

試啥><??
我看文章時就會卡在這個畫面~
有誰知道如何解決嗎

[Man520]

紅色指:

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_points, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts, p.phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 16 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

[cbolong]

紅色那個逗點呀~您的意思是要加入那個逗點嗎??
可是我在/home/cbolong/public_html/phpbb/viewtopic.php
沒有找到\r
FROM phpbb_posts, p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 16 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
這一段耶～

[tseesther]

你只照著文章中的教學做嗎？還是已經下載了整個程式來做？

因為我看除了該教學之外，應該還有些檔案要上載，或者要到mysql加欄位等等... 你欠的可能是這些吧？

[Man520]

你只照著文章中的教學做嗎？還是已經下載了整個程式來做？

因為我看除了該教學之外，應該還有些檔案要上載，或者要到mysql加欄位等等... 你欠的可能是這些吧？

應該不是..我裝水怪時也出現這問題,
我當時也漏了好幾個","
經細心檢查加上去就沒事了...

[寒冰軒]

自爆