| Author |
 Topic  |
|
|
Neilr
Junior Member
Australia
107 Posts |
 Posted - 07 January 2005 : 06:07:38
|
Hi,
I am trying to install the message icon mod (because they wanted it)into 3.4.05.
I am getting this error when clicking active topics.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '.'.
/forum/active.asp, line 308
Instructions tell me in Active.asp to replace a couple lines of code:
Look for this code: (at approx Line #263)
"MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME " & _
"FROM " & strMemberTablePrefix & "MEMBERS M, " & _
Replace it with this code:
"MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, " & _
"T.T_MSGICON " & _
"FROM " & strMemberTablePrefix & "MEMBERS M, " & _
But this is the existing code:
"MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, " & _
"F.F_PRIVATEFORUMS, " & _
"F.F_PASSWORD_NEW " & _
"FROM " & strMemberTablePrefix & "MEMBERS M, " & _
and finally this is what I have currently which seems to be causing the error:
"MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, " & _
"F.F_PRIVATEFORUMS, " & _
"F.F_PASSWORD_NEW " & _
"T.T_MSGICON " & _
"FROM " & strMemberTablePrefix & "MEMBERS M, " & _
It's got me  Everything else seems to work.
Appreciate a pointer or two.
Cheers
Neil
|
Edited by - Neilr on 07 January 2005 06:19:58 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 07 January 2005 : 06:27:13
|
Can you post a link to a *.txt version of your modified active.asp? Or post line 308 here with along with the 5 or so lines above and below it.
|
 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.” |
 |
|
|
Neilr
Junior Member
Australia
107 Posts |
Posted - 07 January 2005 : 06:57:05
|
Here ya go Shaggy;
306: Set rs = Server.CreateObject("ADODB.Recordset")
307: if strDBType <> "mysql" then rs.cachesize = 50
308: rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly,
309: adCmdText
310:
311: if rs.EOF then
recActiveTopicsCount = ""
(Dont know how to do the text thing  )
Neil |
Edited by - Neilr on 07 January 2005 06:59:02 |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 07 January 2005 : 07:11:41
|
That's OK.
Stick the following immediately above line 306 and post back with the results.
response.write strSql
response.end
Wouldn't hurt if you included the block of code that creates strSql, either 
|
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.” |
|
|
|
Neilr
Junior Member
Australia
107 Posts |
Posted - 07 January 2005 : 07:18:31
|
OK Shaggy did that and this time I didnt get the error in active topics but this instead:
SELECT F.FORUM_ID, F.F_SUBJECT, F.F_SUBSCRIPTION, F.F_STATUS, C.CAT_ID, C.CAT_NAME, C.CAT_SUBSCRIPTION, C.CAT_STATUS, T.T_STATUS, T.T_VIEW_COUNT, T.TOPIC_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_REPLIES, T.T_UREPLIES, M.M_NAME, T.T_LAST_POST_AUTHOR, T.T_LAST_POST, T.T_LAST_POST_REPLY_ID, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, F.F_PRIVATEFORUMS, F.F_PASSWORD_NEW T.T_MSGICON FROM FORUM_MEMBERS M, FORUM_FORUM F, FORUM_TOPICS T, FORUM_CATEGORY C, FORUM_MEMBERS MEMBERS_1 WHERE T.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID AND F.F_TYPE = 0 AND F.FORUM_ID = T.FORUM_ID AND C.CAT_ID = T.CAT_ID AND M.MEMBER_ID = T.T_AUTHOR AND (T.T_LAST_POST > '20050107223435') ORDER BY C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, T.T_LAST_POST DESC
and here is the whole block..
end if
strSql = strSql & ") "
strSql = strSql & " ORDER BY C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, T.T_LAST_POST DESC "
Set rs = Server.CreateObject("ADODB.Recordset")
if strDBType <> "mysql" then rs.cachesize = 50
rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
if rs.EOF then
recActiveTopicsCount = ""
else
allActiveTopics = rs.GetRows(adGetRowsRest)
recActiveTopicsCount = UBound(allActiveTopics,2)
end if
rs.close
set rs = nothing
Might have to work out this text thing
Tar
Neil |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Neilr
Junior Member
Australia
107 Posts |
Posted - 07 January 2005 : 08:28:41
|
",T.T_MSGICON " & _
Missing a comma!!!!!!!!!!!
Neil |
|
|
|
Neilr
Junior Member
Australia
107 Posts |
Posted - 07 January 2005 : 08:29:59
|
Ya beat me Podge but well done anyway.
I had to walk away and come back to it.
Thanks for your help guys.
Cheers
Neil |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 07 January 2005 : 09:45:54
|
quote:
Originally posted by Neilr
I had to walk away and come back to it.
[black]Always the best way - it's amazing the things we programmers can miss with jaded eyes!  |
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.” |
|
|
|
Playboy80
Starting Member
United Kingdom
11 Posts |
Posted - 06 April 2005 : 07:57:02
|
I am having the same trouble with that MOD.
I have fixed the active.asp error, but have since got this error when posting a message.
Error Type:
Microsoft JET Database Engine (0x80040E14)
Number of query values and destination fields are not the same.
/forum/post_info.asp, line 1033
I have gone through the instructions 3 times (never changed anything on line 1033) but the same error keeps happening.
i am using version 3.4.05 if that helps.
The txt around line 1033 is:
1029 sstrSql = strSql & ", " & "'" & txtMessage & "'"
1030 strSql = strSql & ", " & cLng(Request.Form("strMessageIcon"))
1031 strSql = strSql & ")"
1032
1033 my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
1034
1035 ' DEM --> Do not update totals on topics and forums database if post is moderated...Added if and end if
1036 if Moderation = "No" then
Please help.  |
|
|
| |
Topic |
|
|
|
Topic Locked
