| Author |
 Topic  |
|
|
stwilson
Junior Member
USA
385 Posts |
 Posted - 05 August 2002 : 03:40:22
|
I am having trouble with members that use an apostrophe in the subject of the Private Messages mod. Has anyone else seen this? I searched the board for the solution but could not locate the fix, so forgive me it the answer is already posted.
Your help is appreciated.
STW
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 11 August 2002 : 14:17:31
|
is there a solution for this?
I have been using it for a while, but just recently had this error pop up.
A member can create and send a NEW message with an apostrophe in the subject, however it cannot be replied to, it results in this error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression ''RE: Hey it's me jo', 'test', 18, 3, '20020811100759', 0, 0, '1')'.
/PHS/privatesend_info.asp, line 339
|
http://www.dunzell.com |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 11 August 2002 : 15:20:08
|
| I'm not familiar with the MOD, but you would need to find where it writes the message to the database in privatesend_info.asp and either do a Replace(strValue,"'","''") or use the forum's built in functions to do it. If you want to post a few lines of code above the line number that is giving that error, I can make a suggestion for you. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 11 August 2002 : 16:36:55
|
starting from 337
337 end if
338
339 my_Conn.Execute (strSql)
if strEmail = "1" then
If Request.Form("Method_Type") = "Forward" then
if strPMNEmail = "1" then
DoReplyEmail
end if
|
http://www.dunzell.com |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 August 2002 : 16:51:59
|
on line #300 of privatesend_info.asp,
change this:
txtSubject = ChkString(strPMSubject,"title")
to this:
txtSubject = ChkString(strPMSubject,"SQLString") |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 17 August 2002 : 10:19:23
|
Just curious ... I have this MOD and was going to apply the fix. Before doing so, I decided to test my Forum to see if I even experienced the error. Happily, I didn't.
Was wondering why? Is is a SQL-only database problem? Or, something else. Like I say, I'm just curious - not complaining here! |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 17 August 2002 : 10:31:18
|
| you're chkString function for "title" might have the code necessary to avoid this error. |
|
|
| |
Topic |
|
Topic Locked
