Author |
Topic ![Next Topic Next Topic](images/icon_go_right.gif) |
Etymon
Advanced Member
![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif)
United States
2383 Posts |
Posted - 09 April 2009 : 07:07:35
|
Hey guys, is this part of the upgrade now? |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
AnonJr
Moderator
![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif)
United States
5768 Posts |
Posted - 09 April 2009 : 10:47:42
|
No fix has made it back into the 3.4.07 code. I've got most of the afternoon clear provided I don't get another interruption like this morning, so I'll try to post a DBS script that you can use to update your existing member base. A permanent solution will probably be added to the next version of the forum. |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
Carefree
Advanced Member
![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif) ![](images/icon_star_silver.gif)
Philippines
4207 Posts |
Posted - 09 April 2009 : 11:21:44
|
In lieu of a DBS script, you could save this as "allowem.asp" and run it. That way it would remain a one-time use file.
|
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
AnonJr
Moderator
![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif)
United States
5768 Posts |
Posted - 09 April 2009 : 12:07:08
|
Go to "(Alternative MOD Setup)" in your Admin Options and past ONE of the two bits below depending on what you want to do.
If you want to automatically allow all exisiting members (all the members you had prior to upgrading, including those with fewer than the specified number of posts) to be able to send e-mail, paste and run the following code:
If you want to set all exisiting members to "0" - which will only affect those with fewer than the specified number of posts - paste and run the following code:
|
Edited by - AnonJr on 09 April 2009 13:53:34 |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
HuwR
Forum Admin
![](images/icon_star_gold.gif) ![](images/icon_star_gold.gif) ![](images/icon_star_gold.gif) ![](images/icon_star_gold.gif) ![](images/icon_star_gold.gif)
United Kingdom
20584 Posts |
Posted - 09 April 2009 : 13:49:13
|
don't think that will work, as in this db they were all NULL not empty strings ![](images/icon_smile.gif) |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
AnonJr
Moderator
![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif)
United States
5768 Posts |
Posted - 09 April 2009 : 13:53:46
|
Now? |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
modifichicci
Average Member
![](images/icon_star_blue.gif) ![](images/icon_star_blue.gif) ![](images/icon_star_blue.gif)
Italy
787 Posts |
Posted - 12 April 2009 : 04:06:13
|
This could works?
change line intAllowEmail = cInt(rs("M_ALLOWEMAIL"))
to
checkAllowedmail = rs("M_ALLOWEMAIL")
if checkAllowedmail = "" then
strSql="UPDATE " & strMemberTablePrefix & "MEMBERS SET M_ALLOWEMAIL = 0 WHERE MEMBER_ID = " & MemberID"
set rsmail = Server.CreateObject("ADODB.Recordset")
rsmail.Open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
set rsmail=Nothing
strSql = "SELECT M_ALLOWEMAIL FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE MEMBER_ID = " & MemberID
set rs1 = my_Conn.Execute (strSql)
intAllowEmail = cInt(rs1("M_ALLOWEMAIL"))
rs1.close
else
intAllowEmail = cInt(rs("M_ALLOWEMAIL"))
end if
just for that db that doesn't set the default values.. My mysql has set 1 to all members in the upgrade |
Ernia e Laparocele Forum di Ernia e Laparocele Acces - MySql Migration Tutorial Adamantine forum |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
modifichicci
Average Member
![](images/icon_star_blue.gif) ![](images/icon_star_blue.gif) ![](images/icon_star_blue.gif)
Italy
787 Posts |
|
AnonJr
Moderator
![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif) ![](images/icon_star_bronze.gif)
United States
5768 Posts |
Posted - 16 April 2009 : 20:46:06
|
Sorry, work has had me a little distracted lately... I was promised it would slow down. But in this economy I'd rather be busy than not. ![](images/icon_smile_wink.gif) |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
modifichicci
Average Member
![](images/icon_star_blue.gif) ![](images/icon_star_blue.gif) ![](images/icon_star_blue.gif)
Italy
787 Posts |
|
Southern Girl
New Member
![](images/icon_star_orange.gif)
78 Posts |
Posted - 07 July 2009 : 19:39:13
|
Where do I paste the above?
![](images/icon_smile_blush.gif) |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
modifichicci
Average Member
![](images/icon_star_blue.gif) ![](images/icon_star_blue.gif) ![](images/icon_star_blue.gif)
Italy
787 Posts |
|
Southern Girl
New Member
![](images/icon_star_orange.gif)
78 Posts |
Posted - 09 July 2009 : 02:14:12
|
Smashing that worked!
![](images/icon_smile_wink.gif) |
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
markvh
Starting Member
USA
4 Posts |
Posted - 15 July 2009 : 16:01:43
|
I ran into this same problem two days ago before I knew that this forum existed and fixed it a differnt way. It was from a clean install of 3.4.07 . I realized that the problem stemmed from the users record for the M_ALLOWEMAIL field being initilaized incorrectly when the record is first created. So I modified register.asp to inilialize the field to zero. So the code now looks like this (starting at line 104 in register.asp) '## Forum_SQL strSql = "INSERT INTO " & strMemberTablePrefix & "MEMBERS " strSql = strSql & "(M_NAME" strSql = strSql & ", M_USERNAME" strSql = strSql & ", M_PASSWORD" strSql = strSql & ", M_LEVEL" strSql = strSql & ", M_EMAIL" strSql = strSql & ", M_DATE" strSql = strSql & ", M_COUNTRY" strSql = strSql & ", M_AIM" strSql = strSql & ", M_ICQ" strSql = strSql & ", M_MSN" strSql = strSql & ", M_YAHOO" strSql = strSql & ", M_POSTS" strSql = strSql & ", M_HOMEPAGE" strSql = strSql & ", M_LASTHEREDATE" strSql = strSql & ", M_STATUS" strSql = strSql & ", M_RECEIVE_EMAIL" strSql = strSql & ", M_LAST_IP" strSql = strSql & ", M_IP" strSql = strSql & ", M_SIG" strSql = strSql & ", M_VIEW_SIG" strSql = strSql & ", M_SIG_DEFAULT" strSql = strSql & ", M_FIRSTNAME" strSql = strSql & ", M_LASTNAME" strSql = strSql & ", M_CITY" strSql = strSql & ", M_STATE" strSql = strSql & ", M_PHOTO_URL" strSql = strSql & ", M_LINK1" strSql = strSql & ", M_LINK2" strSql = strsql & ", M_AGE" strSql = strsql & ", M_DOB" strSql = strSql & ", M_MARSTATUS" strSql = strsql & ", M_SEX" strSql = strSql & ", M_OCCUPATION" strSql = strSql & ", M_BIO" strSql = strSql & ", M_HOBBIES" strsql = strsql & ", M_LNEWS" strSql = strSql & ", M_QUOTE" strSql = strSql & ", M_SHA256" 'initialize M_ALLOWEMAIL strSql = strSql & ", M_ALLOWEMAIL" strSql = strSql & ") " strSql = strSql & " VALUES (" strSql = strSql & "'" & chkString(rsKey("M_NAME"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_USERNAME"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_PASSWORD"),"SQLString") & "'" strSql = strSql & ", " & "1" strSql = strSql & ", '" & chkString(rsKey("M_EMAIL"),"SQLString") & "'" strSql = strSql & ", '" & DateToStr(strForumTimeAdjust) & "'" strSql = strSql & ", '" & chkString(rsKey("M_COUNTRY"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_AIM"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_ICQ"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_MSN"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_YAHOO"),"SQLString") & "'" strSql = strSql & ", 0" strSql = strSql & ", '" & chkString(rsKey("M_HOMEPAGE"),"SQLString") & "'" strSql = strSql & ", '" & DateToStr(strForumTimeAdjust) & "'" strSql = strSql & ", 1" strSql = strSql & ", " & cLng(rsKey("M_RECEIVE_EMAIL")) & " " strSql = strSql & ", '" & chkString(rsKey("M_LAST_IP"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_IP"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_SIG"),"message") & "'" strSql = strSql & ", '" & chkString(rsKey("M_VIEW_SIG"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_SIG_DEFAULT"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_FIRSTNAME"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_LASTNAME"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_CITY"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_STATE"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_PHOTO_URL"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_LINK1"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_LINK2"),"SQLString") & "'" strSql = strsql & ", '" & chkString(rsKey("M_AGE"),"SQLString") & "'" strSql = strsql & ", '" & chkString(rsKey("M_DOB"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_MARSTATUS"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_SEX"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_OCCUPATION"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_BIO"),"message") & "'" strSql = strSql & ", '" & chkString(rsKey("M_HOBBIES"),"message") & "'" strSql = strSql & ", '" & chkString(rsKey("M_LNEWS"),"message") & "'" strSql = strSql & ", '" & chkString(rsKey("M_QUOTE"),"message") & "'" strSql = strSql & ", 1" 'initialize M_ALLOWEMAIL strSql = strSql & ", 0" strSql = strSql & ")"
|
![Go to Top of Page Go to Top of Page](images/icon_go_up.gif) |
|
modifichicci
Average Member
![](images/icon_star_blue.gif) ![](images/icon_star_blue.gif) ![](images/icon_star_blue.gif)
Italy
787 Posts |
|
Topic ![Next Topic Next Topic](images/icon_go_right.gif) |
|
|
|