竹貓星球

發表於 : **2005-04-09 20:46**

我要回覆文章的時候卻出現了這樣的錯誤，請問該怎麼解決呢?

一般錯誤 

Could not obtain post/user information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.pay_money, pt.pay_user FROM phpbb_posts p, phpbb_users u, ph

SELECT u.username, u.user_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid pt.pay_money, pt.pay_user FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 80 AND p.poster_id = u.user_id AND p.post_id = pt.post_id ORDER BY p.post_time DESC LIMIT 15

Line : 115
File : topic_review.php

已安裝外掛
IntegratedToplist_1_0_3
hide bbcode
Quick Search
Pay_Money_MOD_1.0.8
CashMod2.2.2
bank_v3
shoutbox_1.1.5

發表於 : **2005-04-09 21:06**

修復資料表

發表於 : **2005-04-09 21:17**

ghostfbnm 寫:

代碼: 選擇全部

SQL Error : 1064 [b][color=red]You have an error in your SQL syntax;[/color][/b] check the manual that corresponds to your MySQL server version for the right syntax to use [b][color=red]near '.pay_money, pt.pay_user FROM phpbb_posts p, phpbb_users u, ph[/color][/b]

SELECT u.username, u.user_id, p.*, pt.post_text, pt.post_subject, [b][color=blue]pt.bbcode_uid pt.pay_money[/color][/b], pt.pay_user FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 80 AND p.poster_id = u.user_id AND p.post_id = pt.post_id ORDER BY p.post_time DESC LIMIT 15

Line : 115
File : topic_review.php

訊息說的很清楚了~是語法錯誤
那是在pt.bbcode_uid後面少一個,造成的

發表於 : **2005-04-09 22:21**

謝謝大大...

原來是我少一個逗點符號 = =

感謝你們唷

竹貓星球

[問題] 回覆文章出現錯誤

[問題] 回覆文章出現錯誤

Re: [問題] 回覆文章出現錯誤

[反應] 嗯嗯