| Author |
 Topic  |
|
|
Lagzdin
Starting Member
Russia
13 Posts |
 Posted - 28 July 2005 : 14:55:17
|
Good afternoon.
I’ve been using this forum pattern for my site for 2 years. Thank you.
Version info: [Snitz Forums 2000 Version 3.4.03]
Today I’ve downloaded MOD (PRIVATE MESSAGES)
MOD Version: 3.5.05
Forum Version: 3.3.04
Author: GarethMoore1979
Uploaded: 11/1/2004 5:08:33 PM
I took it form here:
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=62
(the first MOD from the top)
I had two problems during setup procedure:
1. When you open a topic you can see only the first post with the following error message:
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]'
/forum1/inc_func_common.asp, line 782
Here you can see the page with the error:
http://accent-club.ru/forum1/topic.asp?TOPIC_ID=4625
This error appears after I implement the following instruction:
TOPIC.ASP
Find following: (about line 311)
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO"
Add , M.M_PMRECEIVE so that it now looks like:
strSql = "SELECT M.M_NAME, M.M_RECEIVE_EMAIL, M.M_AIM, M.M_ICQ, M.M_MSN, M.M_YAHOO, M.M_PMRECEIVE"
Before the implementation of the instruction everything was OK!!!
Here’s the line # 782 from the file /inc_func_common.asp
781 case "dmmmy"
782 chkDate = Mid(fDate,7,2) & " " & _
783 Monthname(Mid(fDate,5,2),0) & " " & _
784 Mid(fDate,1,4)
2. When I enter my «Private Messages» I can do everything I want, except reading incoming messages, i.e. when I open “sent messages” everything OK, but if I open “incoming messages” then I see the following:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near ','.
/forum1/privateread.asp, line 58
You can see it here:
http://accent-club.ru/forum1/privateread.asp?id=4
The line #58 from the file privateread.asp
56 strSql = "SELECT M.MEMBER_ID, M.M_NAME, M.M_ICQ, M.M_MSN, M.M_YAHOO, M.M_AIM, M.M_TITLE, M.M_LEVEL, M.M_AVATAR_URL, M.M_POSTS, M.M_HOMEPAGE, M.M_COUNTRY, M.M_PMRECEIVE, P.M_ID, P.M_TO, P.M_SUBJECT, P.M_SENT, P.M_FROM, P.M_MESSAGE FROM, M.M_AVATAR_URL, " & strMemberTablePrefix & "MEMBERS M , " & strTablePrefix & "PM P WHERE M.MEMBER_ID = P.M_FROM AND P.M_TO = " & getMemberID(chkString(strDBNTUserName,"SQLString")) & " AND P.M_ID = " & cLng(Request.QueryString("id"))
57
58 Set rs = my_Conn.Execute(strSql)
Please, help me to solve these problems. Thank you in advance.
|
Alexey Lagzdin
Hyundai Accent Club Russia
http://www.accent-club.ru/forum |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 28 July 2005 : 15:20:41
|
quote:
The line #58 from the file privateread.asp
56 strSql = "SELECT M.MEMBER_ID, M.M_NAME, M.M_ICQ, M.M_MSN, M.M_YAHOO, M.M_AIM, M.M_TITLE, M.M_LEVEL, M.M_AVATAR_URL, M.M_POSTS, M.M_HOMEPAGE, M.M_COUNTRY, M.M_PMRECEIVE, P.M_ID, P.M_TO, P.M_SUBJECT, P.M_SENT, P.M_FROM, P.M_MESSAGE FROM, M.M_AVATAR_URL, " & strMemberTablePrefix & "MEMBERS M , " & strTablePrefix & "PM P WHERE M.MEMBER_ID = P.M_FROM AND P.M_TO = " & getMemberID(chkString(strDBNTUserName,"SQLString")) & " AND P.M_ID = " & cLng(Request.QueryString("id"))
57
58 Set rs = my_Conn.Execute(strSql)
My guess on the SQL statement would be the "," immediatly after the FROM (as highlighted in orange). |
Edited by - AnonJr on 28 July 2005 17:25:29 |
 |
|
|
Lagzdin
Starting Member
Russia
13 Posts |
Posted - 28 July 2005 : 15:59:24
|
Sorry, but I understood nothing, as "," IS immediatly after FROM
How must look the right SQL? |
Alexey Lagzdin
Hyundai Accent Club Russia
http://www.accent-club.ru/forum |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 28 July 2005 : 17:23:00
|
Change to:
(Minus the extra line breaks I added to keep it from stretching off the screen...)
strSql = "SELECT M.MEMBER_ID, M.M_NAME, M.M_ICQ, M.M_MSN, M.M_YAHOO, M.M_AIM, M.M_TITLE, M.M_LEVEL,
M.M_AVATAR_URL, M.M_POSTS, M.M_HOMEPAGE, M.M_COUNTRY, M.M_PMRECEIVE, P.M_ID, P.M_TO, P.M_SUBJECT,
P.M_SENT, P.M_FROM, P.M_MESSAGE FROM M.M_AVATAR_URL, " & strMemberTablePrefix & "MEMBERS M , " &
strTablePrefix & "PM P WHERE M.MEMBER_ID = P.M_FROM AND P.M_TO = " &
getMemberID(chkString(strDBNTUserName,"SQLString")) & "
AND P.M_ID = " & cLng(Request.QueryString("id"))
Set rs = my_Conn.Execute(strSql)
In line 56, where you see "FROM" there was a comma right after it. The script was expecting a table name, and when there was none, it choked. |
Edited by - AnonJr on 28 July 2005 17:26:08 |
|
|
|
Lagzdin
Starting Member
Russia
13 Posts |
Posted - 28 July 2005 : 17:37:21
|
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'M.M_AVATAR_URL'.
/forum1/privateread.asp, line 59
|
Alexey Lagzdin
Hyundai Accent Club Russia
http://www.accent-club.ru/forum |
|
|
|
Lagzdin
Starting Member
Russia
13 Posts |
Posted - 29 July 2005 : 05:25:50
|
Problem 1.
This is good cod:
TOPIC.ASP
line 509
if iReplyCount = "" then '## No replies found in DB
' Nothing
else
intI = 0
rM_NAME = 0
rM_RECEIVE_EMAIL = 1
rM_AIM = 2
rM_ICQ = 3
rM_MSN = 4
rM_YAHOO = 5
rM_PM = 6
rM_TITLE = 7
rMEMBER_ID = 8
rM_HOMEPAGE = 9
rM_LEVEL = 10
rM_POSTS = 11
rM_COUNTRY = 12
rM_Avatar = 13
rREPLY_ID = 14
rFORUM_ID = 15
rR_AUTHOR = 16
rTOPIC_ID = 17
rR_MESSAGE = 18
rR_LAST_EDIT = 19
rR_LAST_EDITBY = 20
rR_SIG = 21
rR_STATUS = 22
rR_DATE = 23
if CanShowSignature = 1 then
rM_SIG = 24
end if
Problem 2
This is good SQL:
strSql = "SELECT M.MEMBER_ID, M.M_NAME, M.M_ICQ, M.M_MSN, M.M_YAHOO, M.M_AIM, M.M_TITLE, M.M_LEVEL, M.M_AVATAR_URL, M.M_POSTS, M.M_HOMEPAGE, M.M_COUNTRY, M.M_PMRECEIVE, P.M_ID, P.M_TO, P.M_SUBJECT, P.M_SENT, P.M_FROM, P.M_MESSAGE FROM " & strMemberTablePrefix & "MEMBERS M , " & strTablePrefix & "PM P WHERE M.MEMBER_ID = P.M_FROM AND P.M_TO = " & getMemberID(chkString(strDBNTUserName,"SQLString")) & " AND P.M_ID = " & cLng(Request.QueryString("id"))
|
Alexey Lagzdin
Hyundai Accent Club Russia
http://www.accent-club.ru/forum |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 29 July 2005 : 13:28:21
|
quote:
Originally posted by Lagzdin
Invalid object name 'M.M_AVATAR_URL'.
/forum1/privateread.asp, line 59
yeah, I missed that part after the FROM ...  as I'm sure you've discovered, its easy to miss these things if you aren't very careful!
M.M_AVATAR_URL looks to be a field that should have been placed before the FROM in the statement. I would double check and make sure it doesn't reference anything you need...
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 July 2005 : 17:30:53
|
quote:
Originally posted by AnonJr
M.M_AVATAR_URL looks to be a field that should have been placed before the FROM in the statement. I would double check and make sure it doesn't reference anything you need...
That field is from the Avatar Mod,it should come before the FROM. This is what the line should look:
strSql = "SELECT M.MEMBER_ID, M.M_NAME, M.M_ICQ, M.M_MSN, M.M_YAHOO, M.M_AIM, M.M_TITLE, M.M_LEVEL, M.M_POSTS, M.M_HOMEPAGE, M.M_COUNTRY, M.M_AVATAR_URL, M.M_PMRECEIVE, P.M_ID, P.M_TO, P.M_SUBJECT, P.M_SENT, P.M_FROM, P.M_MESSAGE FROM " & strMemberTablePrefix & "MEMBERS M , " & strTablePrefix & "PM P WHERE M.MEMBER_ID = P.M_FROM AND P.M_TO = " & getMemberID(chkString(strDBNTUserName,"SQLString")) & " AND P.M_ID = " & cLng(Request.QueryString("id"))
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 29 July 2005 : 19:12:14
|
Good to keep in mind as this is on my list for the Warsong Records Forum. |
|
|
| |
Topic |
|
|
|
Topic Locked
