I'm in the process of converting my site from Access to MySQL. I have done the database conversion and uploaded but when viewing the site I get -
[MySQL][ODBC 3.51 Driver][mysqld-5.0.51b-community-nt]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 '[pmcount] FROM FORUM_MEMBERS , FORUM_PM WHERE FORUM_MEMBERS.M_NAME = 'Timeshar' at line 1
/test/forum/inc_header.asp, line 505
The code relates to -
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSqL = "SELECT count(M_TO) as pmcount"
end if
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS , " & strTablePrefix & "PM "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME = '" & strDBNTUserName & "'"
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "PM.M_TO "
strSql = strSql & " AND " & strTablePrefix & "PM.M_READ = 0 "
Set rsPM = my_Conn.Execute(strSql)
which is part of the PM mod. Line 505 is the Set rsPM = my_Conn.Execute(strSql)
Any ideas ?
Topic Locked
Posted - 31 December 2009 : 05:24:58
