|
Viccan
Starting Member
7 Posts |
 Posted - 21 March 2005 : 19:56:59
|
Instead of showing the replies and posts of users, forum does just show digits. Topics are loaded up without any problems, but their replies arent. It isn't even possible to delete the posts with the gibberish, since it doesn't seem to exist. When I try to delete or edit such a "corrupted" post I get the error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.23a-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
/forum/post.asp, line 339
OR
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.23a-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND M.M_STATUS = 1' at line 1
/forum/pop_delete.asp, line 820
This is what is in that area in post.asp:
if strRqMethod = "EditTopic" or strRqMethod = "TopicQuote" then
'## Forum_SQL
strSql = "SELECT M.M_NAME, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_STICKY, T.T_SIG, T.T_MESSAGE "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "TOPICS T "
strSql = strSql & " WHERE M.MEMBER_ID = T.T_AUTHOR AND T.TOPIC_ID = " & strRqTopicID
set rs = my_Conn.Execute (strSql)
TxtSub = rs("T_SUBJECT")
strAuthor = rs("T_AUTHOR")
if strStickyTopic = "1" then
strTopicSticky = rs("T_STICKY")
end if
AND in pop_delete.asp:
function chkUser3(fName, fPassword, fReply)
'## Forum_SQL
strSql = "SELECT M.MEMBER_ID, M.M_LEVEL, M.M_NAME, M.M_PASSWORD, R.R_AUTHOR "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "REPLY R "
StrSql = strSql & " WHERE M." & strDBNTSQLName & " = '" & fName & "' "
if strAuthType="db" then
strSql = strSql & " AND M.M_PASSWORD = '" & fPassword &"' "
End If
strSql = strSql & " AND R.REPLY_ID = " & fReply
strSql = strSql & " AND M.M_STATUS = " & 1
set rsCheck = my_Conn.Execute (strSql)
ANYBODY HELP? |
Edited by - ruirib on 22 March 2005 08:35:24 |
|
Topic Locked
