[問題]急!!水怪RPG問題PO文章~賽馬~骰子

文章由夜楓 » 2003-12-07 21:03

問題外掛：水怪RPG問題
使用版本：phpBB 2.0.6
PHP風格:subBlack3d
狀況描述：

我有照者"依夢兒"大大的教學做~水怪 RPG 完整安裝版
全部用好之後出現以下錯誤

可以發表文章就是要看文章時出現以下錯誤

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_us' at line 1

SELECT u.user_money, u.username, u.user_id, u.user_posts, u.user_level, 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_robfail, 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 = 4 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 393
File : c:\appserv\www\viewtopic.php

還有我的賽馬和骰子..的圖片都變成叉燒包啦!!怎麼解決ㄚ?

文章由 **messagebox** » 2003-12-30 05:51

SELECT u.user_money, u.username, u.user_id, u.user_posts, u.user_level, 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_robfail, 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 = 4 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

把逗點加上

文章由 **mit** » 2003-12-30 10:57

挖靠...眼睛真利一.一+

文章由 **jackopq** » 2004-01-07 01:27

我和他狀況一樣也是照那篇做的
phpbb版本2.0.3
狀況出現\r
Could not obtain post/user information
加了逗點一樣不行~

文章由 **依夢兒** » 2004-01-07 04:31

jackopq 寫:加了逗點一樣不行~

你的錯誤訊息咧？

文章由 **jackopq** » 2004-01-07 20:16

一樣在看文章和在發表文章都會出現\r
就只跑出這一行~
Could not obtain post/user information
然後無法看文章和發表~

我後面並沒有出現錯誤訊息

文章由 **mit** » 2004-01-07 20:29

jackopq 寫:一樣在看文章和在發表文章都會出現\r
Could not obtain post/user information
然後無法看文章和發表~

你有關掉debug嗎?

人家樓主至少有附上debug資訊，
可是我看你明明沒有debug資訊啊...
你以為全天下的phpbb錯誤訊息只要第一句是Could not obtain post/user information那就都是一樣的錯誤了啊

文章由 **messagebox** » 2004-01-07 20:41

我的回答同MIT兄~~
請將DEBUG打開~~
並附上錯誤訊息~~

文章由 **jackopq** » 2004-01-07 22:22

對不起喔不要生氣\r
我不知為何原本設定是關閉的
剛剛翻了會兒文章才找到如何打開QQ"
訊息如下

代碼: 選擇全部

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

SELECT u.username, u.user_money , 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, pt.pay_money, pt.pay_user, pt.pay_see, pt.pay_gotmoney , u.user_allowsmile,u.user_robfail, 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 FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 804 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

文章由 **StickyKid** » 2004-01-07 22:27

您沒有把該打的資料打完整喔

在posting.php和viewtopic.php

夢兒都有提到

文章由 **吉川拓也** » 2004-01-07 22:31

jackopq 寫:對不起喔不要生氣\r
我不知為何原本設定是關閉的
剛剛翻了會兒文章才找到如何打開QQ"
訊息如下

代碼: 選擇全部

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

SELECT u.username, u.user_money , 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, pt.pay_money, pt.pay_user, pt.pay_see, pt.pay_gotmoney , u.user_allowsmile,u.user_robfail, 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 FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 804 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

語法執行不完全 . 找不到u.user_robfail這個欄位...
把水怪的SQL語法在去phpmyadmin執行如果顯示欄位已經存再就一一比對新增 !!

文章由 **jackopq** » 2004-01-07 23:54

問題解決嚕
感謝各位大大解答^^"