| Author |
 Topic  |
|
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
 Posted - 25 October 2004 : 09:10:56
|
I have recently switched servers and I think this was the start of this problem. Im using a mysql database.
Each time anyone on my forum sends a private messgae- for some reason it isnt saving it to the outbox.
In the database there is the following setup in forum_PM:
M_OUTBOX#smallint#NULL#1 (1= show messgae in outbox, 0= dont show).
I have checked the database and it appears that as default it should be '1' (ie to show message in outbox), but when a message is created and sent the database always gives '0' to that field (so the message isnt showing in outbox). This has only happened since moving servers so I cant think it is the script, but something to do with the database. |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 October 2004 : 11:14:54
|
Soo, what you asking Gareth? How to fix it?
Just change the default value to 1, instead of 0 for the M_OUTBOX field.
Either way, this should be in the Help: MOD Implementation forum. |
Support Snitz Forums
|
 |
|
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
Posted - 25 October 2004 : 11:51:29
|
I did mention that
quote:
I have checked the database and it appears that as default it should be '1' (ie to show message in outbox), but when a message is created and sent the database always gives '0' to that field
In mysql the default value of that field IS set to '1' but its not giving it that value when a message is created! |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 October 2004 : 15:29:16
|
Oh. So the default value is set to 1, but the value is 0 when a message is created. I see.
It could be that the query that inserts the value into the database, when a new message is created, is entering a 0. Can you track down the query that is exectued when a new message is created? |
Support Snitz Forums
|
|
|
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
Posted - 25 October 2004 : 16:02:22
|
| how would I do this (sorry). |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 26 October 2004 : 14:05:06
|
Ok, well I am not too familar with the private messages mod.
If you can provide links to txt files of the files that sends the private message.
There should be 2 files I would need to look at.
One file allows you to type the message in a text box. I think it's privatesend.asp ?
Second file actually sends the message to the user. After you click Send on the form. Maybe privatesend_info.asp ? |
Support Snitz Forums
|
|
|
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 26 October 2004 : 16:00:54
|
Line 346 in privatesend_info.asp sets the M_OUTBOX field to 0 on every new message you send. You can change to 1 if you want. See if that solves it.strSql = strSql & ", " & "0" |
Support Snitz Forums
|
|
|
|
GarethMoore1979
Junior Member
United Kingdom
220 Posts |
Posted - 26 October 2004 : 16:35:10
|
thanks! that worked!! (just for the record incase anyone else has this problem there are 2 instances of the following (on for new pm's and the other for replys).
quote:
if request.cookies(strCookieURL & "paging")("outbox") = "double" or request.cookies(strCookieURL & "paging")("outbox") = "single" then
strSql = strSql & ", '" & 1 & "')"
else
strSql = strSql & ", '" & 0 & "')"
end if
...I changed the '0' in red to '1' and that worked. (I never thought to look in privatesend_info, I was just looking in privatesend).
There are 3 types of layouts for the inbox:
1- Inbox and Outbox on a single page
2- Inbox and Outbox on seperate pages
3- No Outbox at all.
This info is all stored in cookies and not the database. It seems that for some reason this info is not being written to the cookie and so this part of the script presumes there is no inbox and so doesnt put the pm into the outbox (ie, write '1' into the field). This is odd as it always used to do it, only since I changed servers last week- this has me puzzled!
oh well its sorted now!! thanks for your help!
 |
Edited by - GarethMoore1979 on 26 October 2004 16:45:32 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 26 October 2004 : 17:56:53
|
Glad I could point you in the right direction.  |
Support Snitz Forums
|
|
|
| |
Topic |
|
Topic Locked
