|
Reichert
Starting Member
11 Posts |
 Posted - 03 May 2001 : 11:53:20
|
Trying to install the bookmarks MOD on a mySQL site, and it seems that mySQL doesn't like a SQL statement in bookmarks.asp.
The particular error is:
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/bookmark.asp, line 154
I did a response.write on strSql, and this is the SQL statement:
quote:
SELECT FORUM_Bookmarks.Bookmark_ID, FORUM_Category.Cat_Name, FORUM_Forum.F_SUBJECT, FORUM_Topics.Topic_ID, FORUM_Topics.T_subject, FORUM_Topics.T_Replies, FORUM_Topics.T_date, FORUM_Topics.T_Last_Post,FORUM_MEMBERS.M_NAME ,FORUM_TOPICS.FORUM_ID, FORUM_TOPICS.CAT_ID, FORUM_TOPICS.T_LAST_POST_AUTHOR FROM (FORUM_Category INNER JOIN FORUM_Forum ON FORUM_Category.Cat_ID = FORUM_Forum.CAT_ID) INNER JOIN (FORUM_Members INNER JOIN (FORUM_Bookmarks INNER JOIN FORUM_Topics ON FORUM_Bookmarks.B_TopicID = FORUM_Topics.Topic_ID) ON FORUM_Members.Member_id = FORUM_Topics.T_AUTHOR) ON FORUM_Forum.Forum_ID = FORUM_Topics.Forum_id WHERE (FORUM_Bookmarks.B_MemberID=14) AND FORUM_TOPICS.T_LAST_POST > '20010503091939'
which gives me this error in the mySQL client:
quote:
ERROR 1064: You have an error in your SQL syntax near '(FORUM_Members INNER JOIN (FORUM_Bookmarks INNER JOIN FORUM_Topics ON FORUM_Book' at line 1
Thanks in advance.
Stephen Palmer -=- Reichert
root@ Gearbox Software
Micah 6:8 "He has showed you, oh man, what is good ... "
|
|
Topic Locked
