| dbProcess called from: | /modules/forums/archive.asp | | Executing: | archive.asp : Get all topics from DB | | SQL String: | SELECT PORTAL_ARCHIVE_TOPICS.T_STATUS, PORTAL_ARCHIVE_TOPICS.CAT_ID, PORTAL_ARCHIVE_TOPICS.FORUM_ID, PORTAL_ARCHIVE_TOPICS.TOPIC_ID PORTAL_ARCHIVE_TOPICS.T_VIEW_COUNT, PORTAL_ARCHIVE_TOPICS.T_SUBJECT, PORTAL_ARCHIVE_TOPICS.T_MAIL, PORTAL_ARCHIVE_TOPICS.T_AUTHOR PORTAL_ARCHIVE_TOPICS.T_REPLIES, PORTAL_ARCHIVE_TOPICS.T_LAST_POST, PORTAL_ARCHIVE_TOPICS.T_LAST_POST_AUTHOR PORTAL_MEMBERS.M_NAME, PORTAL_MEMBERS_1 AS LAST_POST_AUTHOR_NAME FROM PORTAL_MEMBERS, PORTAL_ARCHIVE_TOPICS, PORTAL_MEMBERS AS PORTAL_MEMBERS_1 WHERE PORTAL_MEMBERS.MEMBER_ID = PORTAL_ARCHIVE_TOPICS.T_AUTHOR AND PORTAL_ARCHIVE_TOPICS.T_LAST_POST_AUTHOR = PORTAL_MEMBERS_1.MEMBER_ID AND PORTAL_ARCHIVE_TOPICS.FORUM_ID=? AND PORTAL_ARCHIVE_TOPICS.T_LAST_POST>? ORDER BY PORTAL_ARCHIVE_TOPICS.T_LAST_POST DESC | | # of @Parms passed | 2 | | @Parm1= | 2 | | @Parm2= | 18991130000000 |
DATABASE ERROR ! | | Error Number: | -2147217900 | | Description: | Syntax error (missing operator) in query expression 'PORTAL_ARCHIVE_TOPICS.TOPIC_ID PORTAL_ARCHIVE_TOPICS.T_VIEW_COUNT'. | | # of Records matched | 0 | | dbProcess: END debug |
|
Announcements