[問題] 水怪rpg 安裝後的問題,請看看

[kkkkkkk]

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.rpg_level' 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.rpg_level, u.rpg_cur_hp, u.rpg_max_hp, u.rpg_cur_mp, u.rpg_max_mp, u.rpg_cur_exp, u.rpg_max_exp, u.rpg_attack, u.rpg_defense, u.rpg_magic, u.rpg_speed, u.rpg_medals, 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 = 2 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 399
File : viewtopic.php

請問有大大知道我錯了什麼嗎?
如何修正呢?

[computer315]

代碼: 選擇全部

# 個人資料
ALTER TABLE `phpbb_users`
ADD `user_bank` int(11) unsigned NOT NULL default '0',
ADD `user_bank_time` int(11) default '0',
ADD `user_robfail` smallint(5) default '0',
ADD `rpg_rob_cnt` smallint(5) unsigned default '0',
ADD `rpg_robbed_cnt` smallint(5) unsigned default '0',
ADD `rpg_rob_succ` smallint(5) unsigned default '0',
ADD `rpg_rob_fail` smallint(5) unsigned default '0',
ADD `rpg_rob_money` int(11) unsigned default '0',
ADD `rpg_robbed_money` int(11) unsigned default '0',
ADD `rpg_level` smallint(5) NOT NULL default '1',
ADD `rpg_cur_exp` mediumint(8) NOT NULL default '0',
ADD `rpg_max_exp` mediumint(8) NOT NULL default '9',
ADD `rpg_cur_hp` mediumint(8) NOT NULL default '18',
ADD `rpg_max_hp` mediumint(8) NOT NULL default '18',
ADD `rpg_cur_mp` mediumint(8) NOT NULL default '8',
ADD `rpg_max_mp` mediumint(8) NOT NULL default '8',
ADD `rpg_attack` mediumint(8) NOT NULL default '1',
ADD `rpg_defense` mediumint(8) NOT NULL default '1',
ADD `rpg_magic` mediumint(8) NOT NULL default '1',
ADD `rpg_speed` mediumint(8) NOT NULL default '1',
ADD `rpg_medals` varchar(200) default '路人',
ADD `rpg_richer_pos` int(10) default NULL;

呃...你有確實執行以上這段SQL嗎...?