1 頁 (共 1 頁)

[問題] 安裝cashmod 後無法看文

發表於 : 2005-10-21 20:40
隨緣
問題外掛:CAshMod222
使用版本:phpBB:2.0.17
參考文章:http://phpbb-tw.net/phpbb/viewtopic.php?t=37167
已安裝外掛:簡易子版v1.2 Quick reply 勳章mod


狀況描述:
在安裝完之後,進入討論區,點選文章主題出現以下字樣\r

Could not obtain post/user information.

DEBUG MODE

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

SELECT u.username, u.user_cash, 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, 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 = 5 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 410
File : viewtopic.php

代碼: 選擇全部

LIMIT $start, ".$board_config['posts_per_page'];
$cm_viewtopic->generate_columns($template,$forum_id,$sql);
if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, "Could not obtain post/user information.", '', __LINE__, __FILE__, $sql);
}
這是我懷疑出錯的部份
我應如何解決?

發表於 : 2005-10-21 21:47
心靈捕手
To 隨緣:

建議您:
執行 資料庫 更新!
#
#-----[ SQL ]------------------------------------------
#
# There is an automatic sql installer that works currently for mysql and mssql
# It is neccessary to copy the file sql_install.php to your main phpbb directory and run it from there
# After that, you want to delete the file immediately.
#
# If you prefer to run the queries manually yourself, or to translate it to a different dbms
# than mysql or mssql, the raw queries are located in sql_222.txt, but are only available for mysql.
# I will try to include more dbms's for the installer for future releases, but nothing is guaranteed
# at present
#