Author |
Topic |
|
choppermc
New Member
Australia
80 Posts |
Posted - 06 November 2003 : 05:37:05
|
Hi all, I have installed the PM pager mod and I am getting an error only when replying to a message using the pager system on pm_pop_privatesend_info.asp:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]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 ' 1, '20031106202457', 0, 0, '1')' at line 1
/pm_pop_privatesend_info.asp, line 267
Can anyone help with this. Thanks
|
Oh....Is that it? |
|
soxc
New Member
53 Posts |
Posted - 06 November 2003 : 09:11:06
|
It might be the date format ('20031106202457'). This is a guess though. I'm not familuar with MySQL syntax. Can you do a response.write of the SQL before the call.
response.write strSQL '(or what ever the var is call) response.end '(this will end the page execution)
then post it to this message.
|
|
|
choppermc
New Member
Australia
80 Posts |
Posted - 07 November 2003 : 02:27:27
|
OK soxc, Here it is,
INSERT INTO FORUM_PM ( M_SUBJECT, M_MESSAGE, M_TO, M_FROM, M_SENT, M_MAIL, M_READ, M_OUTBOX) VALUES ( 'RE: ', 'This Is A test Message ', , 1, '20031107171756', 0, 0, '1')
I don't understand, if I forward the message, it works. If I reply to the message, I get errors. |
Oh....Is that it? |
|
|
soxc
New Member
53 Posts |
Posted - 07 November 2003 : 10:45:48
|
It looks like the 3rd parameter is missing from the SQL statement values. ( 'RE: ', 'This Is A test Message ', , 1, '20031107171756', 0, 0, '1')
It does not seem to have a value for M_TO.
Not sure why this is the case. |
|
|
|
Topic |
|
|
|