 | [Solved] problem with private messages |  |
 Posted: 05/19/2007 1:57 PM |
 |
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 7:15 PM
Location: Birmingham, UK.
|
|
|
|
|
 |
When I click on a pm message i get this
| Code:
|
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 ' u2.username AS username_2, u2.user_id AS user_id_2, u.user_sig_bbcode_uid, u.us' at line 1
SELECT u.username AS username_1, u.user_id AS user_id_1, u.user_session_time AS user_session_time_1, u.user_allow_viewonline,, 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 = 5 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 : 244
File : privmsg.php
|
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem with private messages | |
| Posted: 05/19/2007 6:40 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 7:15 PM
Location: Birmingham, UK.
|
|
|
|
|
|
| Btw I think since installing the email links directly to new pms mod I got this error |
|
|
|
|
| Back to Top |
|
|
| Re: problem with private messages | |
| Posted: 05/19/2007 6:50 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 2:15 PM
Location: St Pete, FL
|
|
|
|
|
|
There's an extra comma in the query:
| Code:
|
|
u.user_allow_viewonline,, u2.username AS username_2
|
So this is what I did to correct the problem:
OPEN
privmsg.php
FIND
| Code:
|
|
u.user_allow_viewonline,,
|
REPLACE WITH
| Code:
|
|
u.user_allow_viewonline,
|
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem with private messages | |
| Posted: 05/19/2007 7:01 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 7:15 PM
Location: Birmingham, UK.
|
|
|
|
|
|
Woah I didn't notice that lol  niceone Nightrider  |
|
|
|
|
| Back to Top |
|
|
| Re: problem with private messages | |
| Posted: 05/19/2007 11:46 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 2:15 PM
Location: St Pete, FL
|
|
|
|
|
|
It would be easy to overlook, especially if you are not familiar with SQL...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem with private messages | |
| Posted: 05/20/2007 4:07 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 7:15 PM
Location: Birmingham, UK.
|
|
|
|
|
|
| How did you notice just that one extra comma? do you use software to detect errors or something or did you just see it from the debug window ... 8) |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem with private messages | |
| Posted: 05/20/2007 4:44 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 2:15 PM
Location: St Pete, FL
|
|
|
|
|
|
The error message tells you where the error is close to, so then I looked for anything that was obviously wrong. I was a database programmer in a previous life, so I know SQL pretty good. An obvious error to me may not be so to an untrained eye...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem with private messages | |
| Posted: 05/20/2007 4:50 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 7:15 PM
Location: Birmingham, UK.
|
|
|
|
|
|
I see, ok then. Thanks  |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] problem with private messages | |
| Posted: 05/20/2007 5:43 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 2:15 PM
Location: St Pete, FL
|
|
|
|
|
|
As always, you are quite welcome Chris...
  |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
