phpBB.de

phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/

Private Nachrichten Fehler

https://www.phpbb.de/community/viewtopic.php?t=68589

Seite 1 von 1

Private Nachrichten Fehler

Verfasst: 22.10.2004 19:29
von ATARI
Moin Moin, ich kann in meinem Board 2.0.10'er phpBB ( www.sx1-forum.de ) zwar PMs verfassen und versenden (kommen auch an), jedoch kann ich sie dann nicht lesen, weder im Posteingang, Postausgang noch Gesendete Nachrichten.

Es kommt dann dieser Fehler:

Code: Alles auswählen

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 ' u.user_allow_viewonline AS user_allow_viewonline_1, u2.user_al

SELECT u.username AS username_1, u.user_id AS user_id_1, u.user_absence, u.user_absence_mode, 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,, u.user_allow_viewonline AS user_allow_viewonline_1, u2.user_allow_viewonline AS user_allow_viewonline_2, u.user_session_time AS user_session_time_1, u2.user_session_time AS user_session_time_2 pm.*, pmt.privmsgs_bbcode_uid, pmt.privmsgs_text FROM orion_privmsgs pm, orion_privmsgs_text pmt, orion_users u, orion_users u2 WHERE pm.privmsgs_id = 3 AND pmt.privmsgs_text_id = pm.privmsgs_id AND pm.privmsgs_from_userid = 2 AND ( 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 : 240
File : /usr/export/www/vhosts/funnetwork/hosting/tomtrance/orion/privmsg.php

Kann mir jemand sagen wie ich diesen Fehler beheben kann?


Danke schon mal im Vorraus! ;)

Verfasst: 22.10.2004 20:21
von PhilippK
Da hast du wohl 'nen Mod falsch eingebaut:

Code: Alles auswählen

u.user_avatar,, u.user_allow_viewonline AS user_allow_viewonline_1, u2.user_allow_viewonline AS user_allow_viewonline_2, u.user_session_time AS user_session_time_1, u2.user_session_time AS user_session_time_2 pm.*,
das doppelte Komma nach user_avatar sollte vor pm.* stehen.

Gruß, Philipp

Verfasst: 22.10.2004 20:49
von ATARI
geht wieder ned.

Code: Alles auswählen

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 ' pm.*, pmt.privmsgs_bbcode_uid, pmt.privmsgs_text FROM orion_

SELECT u.username AS username_1, u.user_id AS user_id_1, u.user_absence, u.user_absence_mode, 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, u.user_allow_viewonline AS user_allow_viewonline_1, u2.user_allow_viewonline AS user_allow_viewonline_2, u.user_session_time AS user_session_time_1, u2.user_session_time AS user_session_time_2,, pm.*, pmt.privmsgs_bbcode_uid, pmt.privmsgs_text FROM orion_privmsgs pm, orion_privmsgs_text pmt, orion_users u, orion_users u2 WHERE pm.privmsgs_id = 3 AND pmt.privmsgs_text_id = pm.privmsgs_id AND pm.privmsgs_from_userid = 2 AND ( 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 : 240
File : /usr/export/www/vhosts/funnetwork/hosting/tomtrance/orion/privmsg.php

hier meine komplette privgmsg.php:
http://tomtrance.to.funpic.de/error.txt

Verfasst: 22.10.2004 21:14
von PhilippK
Nur ein Komma verschieben und nicht zwei neue reinmachen :-)

Gruß, Philipp

Verfasst: 22.10.2004 22:06
von ATARI
okay habs hinbekommen, danke schonmal!


nun noch ein kleiner schönheitsfehler in der privgmsgs_read_body.tpl

wie bekomme ich das wieder gescheit hin?

screenshot:
http://tomtrance.to.funpic.de/pm_error.JPG (kopieren und einfügen)
und der code von der datei:

Code: Alles auswählen

<br />
<table cellspacing="2" cellpadding="2" border="0" align="center">
<tr>
<td>{INBOX_IMG}</td>
<td class="nav">{INBOX} &nbsp;</td>
<td>{SENTBOX_IMG}</td>
<td class="nav">{SENTBOX} &nbsp;</td>
<td>{OUTBOX_IMG}</td>
<td class="nav">{OUTBOX} &nbsp;</td>
<td>{SAVEBOX_IMG}</td>
<td class="nav">{SAVEBOX} &nbsp;</td>
</tr>
</table>
<br />
<form method="post" action="{S_PRIVMSGS_ACTION}">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td><img src="images/spacer.gif" alt="" width="15" height="26" /></td>
		<td><table border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td><img src="templates/fiapplegreen/images/lang_english/tabt.gif" alt="" width="80" height="6" /></td>
				</tr>
				<tr>
					<td class="postbkg">{REPLY_PM_IMG}</td>
				</tr>
			</table>
		</td>
		<td width="100%" class="nav">&nbsp;&nbsp;&nbsp;<a href="{U_INDEX}">{L_INDEX}</a></td>
	</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" class="ttb">
	<tr>
		<td><img src="templates/fiapplegreen/images/tt12_l.gif" width="10" height="12" alt="" /></td>
		<td class="tt12bkg"><img src="images/spacer.gif" width="200" height="12" alt="" /></td>
		<td><img src="templates/fiapplegreen/images/tt12_r.gif" width="10" height="12" alt="" /></td>
	</tr>
</table>

<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline">
<tr>
<th colspan="2">{BOX_NAME} :: {L_MESSAGE}</th>
</tr>
<tr>
<td align="right" class="row2"><span class="explaintitle">{L_FROM}:</span></td>
<td class="row2"><span class="name">{MESSAGE_FROM}</span></td>
</tr>
<tr>
<td align="right" class="row2"><span class="explaintitle">{L_TO}:</span></td>
<td class="row2"><span class="name">{MESSAGE_TO}</span></td>
</tr>
<tr>
<td align="right" class="row2"><span class="explaintitle">{L_POSTED}:</span></td>
<td class="row2"><span class="genmed">{POST_DATE}</span></td>
</tr>
<tr>
<td align="right" class="row2"><span class="explaintitle">&nbsp;&nbsp;{L_SUBJECT}:</span></td>
<td width="100%" class="row2"><table width="100%" border="0" cellspacing="1" cellpadding="0">
	<tr>
		<td class="genmed">{POST_SUBJECT}</td>
		<td align="right">{QUOTE_PM_IMG}{EDIT_PM_IMG}</td>
	</tr>
</table></td>
</tr>
<tr>
	  <td valign="top" colspan="2" class="row1"><span class="postbody">{MESSAGE}</span>
<!-- BEGIN postrow -->
	{ATTACHMENTS}
<!-- END postrow -->
	  </td>
</tr>
<tr>
<td height="28" valign="bottom" colspan="2" class="row1"> {PROFILE_IMG} {PM_IMG} 
{EMAIL_IMG} {WWW_IMG} {AIM_IMG} {YIM_IMG} {MSN_IMG} {ICQ_IMG}</td>
</tr>
<tr>
<td class="cat" colspan="2" align="right">{S_HIDDEN_FIELDS}
<input type="submit" name="save" value="{L_SAVE_MSG}" class="button" />
&nbsp; 
<input type="submit" name="delete" value="{L_DELETE_MSG}" class="button" />
<!-- BEGIN switch_attachments -->
		&nbsp; 
		<input type="submit" name="pm_delete_attach" value="{L_DELETE_ATTACHMENTS}" class="liteoption" />
<!-- END switch_attachments -->
</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" class="ttb">
<tr> 
<td><img src="templates/fiapplegreen/images/tb12_l.gif" width="10" height="12" alt="" /></td>
<td class="tb12bkg"><img src="images/spacer.gif" width="200" height="12" alt="" /></td>
<td><img src="templates/fiapplegreen/images/tb12_r.gif" width="10" height="12" alt="" /></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td><img src="images/spacer.gif" alt="" width="15" height="26" /></td>
		<td><table border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td><img src="templates/fiapplegreen/images/lang_english/tabsp.gif" alt="" width="80" height="2" /></td>
				</tr>
				<tr>
					<td class="postbkg">{REPLY_PM_IMG}</td>
				</tr>
				<tr>
					<td><img src="templates/fiapplegreen/images/lang_english/tabb.gif" alt="" width="80" height="6" /></td>
				</tr>
			</table>
		</td>
		<td width="100%" class="nav">&nbsp;&nbsp;&nbsp;<a href="{U_INDEX}">{L_INDEX}</a></td>
	</tr>
</table>
</form>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
	<tr>
		<td><br />{JUMPBOX}</td>
	</tr>
</table>

thx schon mal..
Alle Zeiten sind UTC+01:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de