竹貓星球

發表於 : **2004-12-29 21:37**

想請教各位前輩,我在裝完貨幣外掛之後,發現在閱讀私人訊息的時候出現以下錯誤:

一般錯誤 

Could not query private message post 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 '' at line 10

SELECT u.username AS username_1, u.user_id AS user_id_1, u2.username AS username_2, u2.user_id AS user_id_2, u.user_sig_bbcode_uid, 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_avatar, pm.*, pmt.privmsgs_bbcode_uid, pmt.privmsgs_text FROM phpbb_privmsgs pm, phpbb_privmsgs_text pmt, phpbb_users u, phpbb_users u2 WHERE pm.privmsgs_id = 417 AND pmt.privmsgs_text_id = pm.privmsgs_id AND ( ( pm.privmsgs_to_userid = 2 AND ( pm.privmsgs_type = 0 OR pm.privmsgs_type = 1 OR pm.privmsgs_type = 5 ) AND u.user_id = pm.privmsgs_from_userid AND u2.user_id = pm.privmsgs_to_userid

Line : 239
File : /home/lovelymo/public_html/forum/privmsg.php

●架設主機作業系統：Linux
●上網方式：ADSL
●phpBB版本：phpBB 2.0.11
●網站位置：魔鬼筋肉客棧
●測試帳號：TEST 測試密碼：TEST

我自己找了很久也找不出原因,只在收件夾的部分有錯誤,其他都可以正常使用,麻煩各位前輩抽空幫我看一下問題,十分感激

發表於 : **2004-12-30 08:57**

你的錯誤訊息中，括號數跟原始的 phpBB 不同

代碼: 選擇全部

		case 'inbox':
			$l_box_name = $lang['Inbox'];
			$pm_sql_user = "AND pm.privmsgs_to_userid = " . $userdata['user_id'] . " 
				AND ( pm.privmsgs_type = " . PRIVMSGS_READ_MAIL . " 
					OR pm.privmsgs_type = " . PRIVMSGS_NEW_MAIL . " 
					OR pm.privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " )";
			break;

但是你的顯示

代碼: 選擇全部

					AND ( ( pm.privmsgs_to_userid = 2 
					AND ( pm.privmsgs_type = 0 
					OR pm.privmsgs_type = 1 
					OR pm.privmsgs_type = 5 )

這個部分可以查看看

~Mac

發表於 : **2004-12-30 09:15**

非常謝謝Mac前輩的幫忙~

小妹問題已經照前輩提供的語法解決了~十分感激

竹貓星球

[問題] 閱讀新私人訊息出現錯誤(已解決)

[問題] 閱讀新私人訊息出現錯誤(已解決)