1 頁 (共 1 頁)

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

發表於 : 2005-04-03 23:04
cbolong
●架設主機作業系統:Windows xp
●快速架站程式: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

發表於 : 2005-04-03 23:21
Man520
●架設主機作業系統:Windows xp
●快速架站程式: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
試試~~

發表於 : 2005-04-03 23:25
cbolong
試啥><??
我看文章時就會卡在這個畫面~
有誰知道如何解決嗎

發表於 : 2005-04-03 23:33
Man520
紅色指:
cbolong 寫: 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

發表於 : 2005-04-03 23:43
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
這一段耶~

發表於 : 2005-04-04 00:42
tseesther
你只照著文章中的教學做嗎?還是已經下載了整個程式來做?

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

發表於 : 2005-04-04 13:29
Man520
tseesther 寫:你只照著文章中的教學做嗎?還是已經下載了整個程式來做?

因為我看除了該教學之外,應該還有些檔案要上載,或者要到mysql加欄位等等... 你欠的可能是這些吧?
應該不是..我裝水怪時也出現這問題,
我當時也漏了好幾個","
經細心檢查加上去就沒事了...

發表於 : 2005-04-04 15:03
寒冰軒
自爆