| Author |
 Topic  |
|
|
canis
Starting Member
38 Posts |
 Posted - 25 September 2008 : 09:02:27
|
We have discovered that users that existed before we installed "Private Messages MOD for Snitz Forums" have the M_PMRECEIVE = "" (NULL). Member that have come later have M_PMRECEIVE=0 og M_PMRECEIVE=1. Is it any easy way to update all blank M_RECEIVE to 1? It is not possible to change this in the userprofile.
Is there some fix to this or is it an other way to update the profile without update the MDB manually?
By trying to run PM_options.asp I get this error:
Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment: 'fLang'
pm_options.asp, line 155
Her is the lines around line 155
if rs("M_PMRECEIVE") = "1" then
Response.Write fLang(strLangPm_Options00100)
else
Response.Write fLang()
end if
I suppose fLang need a value.
I suppose the main is that I need a value for the M_PMRECEIVE ?
< |
Edited by - canis on 25 September 2008 10:19:05 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
canis
Starting Member
38 Posts |
Posted - 25 September 2008 : 11:36:37
|
| There is a table called FORUM_PM with a field M_MESSAGE that contains the message itself.< |
Edited by - canis on 25 September 2008 11:36:58 |
 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 25 September 2008 : 12:06:43
|
The M_PMRECEIVE field is added to the members table, though.
< |
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 September 2008 : 12:08:22
|
Paste this into the Alternate Mod Setup window, in Admin Options and then click Execute. Should do what you need.
[UPDATE]
MEMBERS
M_PMRECEIVE#1#(M_PMRECEIVE <>0 AND M_PMRECEIVE<>1)
[END]
< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
canis
Starting Member
38 Posts |
Posted - 25 September 2008 : 15:42:44
|
Before I was able to do this update I got this error:
We suddenly got this error in our forum:
Microsoft JET Database Engine error '80004005'
Could not delete from specified tables.
/inc_func_common.asp, line 304
I can't access the forum in any way!
I suppose it is some clean up that fails, or neccesary access!
Updated: It seem to have been an internal hang, lock in database. It fixed it self !
Atle
< |
Edited by - canis on 25 September 2008 16:38:49 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
canis
Starting Member
38 Posts |
Posted - 25 September 2008 : 18:36:21
|
I got following response:
Database Update
Updating Forum Values..
UPDATE FORUM_MEMBERS SET M_PMRECEIVE = 1 WHERE (M_PMRECEIVE <>0 AND M_PMRECEIVE<>1)
Value(s) updated successfully
Database setup finished
However, in the MEMBERs list only the new'es members had the PM icon.
< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 September 2008 : 18:56:36
|
| I'm not sure the cause for that is the value of M_PMRECEIVE. Can you have a look in the database and see what happens with the value of M_PMRECEIVE for all the members?< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
canis
Starting Member
38 Posts |
Posted - 25 September 2008 : 19:26:21
|
| ruirib : The M_PMRECEIV is still blank for all the users that do not snow the PM ICON. For those users that have the ICON the M_PMRECEIVE=1. So the datebase is not updated.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
canis
Starting Member
38 Posts |
Posted - 26 September 2008 : 14:58:35
|
Yes ruirib, now it worked just perfect. All the users with 1 got the PM ICON in members.
Thank you so very much again.
I'm just curious. In the ADD MOD window, were can I find the SQL rules.
Your:
[UPDATE]
MEMBERS
M_PMRECEIVE#1#(M_PMRECEIVE IS NULL)
[END]
is converted to "UPDATE FORUM_MEMBERS SET M_PMRECEIVE = 1 WHERE (M_PMRECEIVE IS NULL)"< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 27 September 2008 : 06:49:41
|
I think he means the DBS syntax.
Its been posted before, I just don't have the link handy at the moment. A search for "DBS", "DBS Script", or something along those lines should turn it up.< |
|
|
|
canis
Starting Member
38 Posts |
Posted - 27 September 2008 : 07:08:32
|
Yes AnonJr, you are right.
Thaks for the info, I'll find them then!< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
