SailNet Community - Reply to Topic
Thread: Can''t view messages Reply to Thread
Send Trackbacks to (Separate multiple URLs with spaces) :
Post Icons
You may choose an icon for your message from the following list:

Register Now

In order to be able to post messages on the SailNet Community forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
Please note: After entering 3 characters a list of Usernames already in use will appear and the list will disappear once a valid Username is entered.

User Name:
Please enter a password for your user account. Note that passwords are case-sensitive.


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:


Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.

  Additional Options
Miscellaneous Options

Click here to view the posting rules you are bound to when clicking the
'Submit Reply' button below

  Topic Review (Newest First)
10-13-2003 06:08 AM
Can''''t view messages

I''m testing the board. For the past week or so I have been unable to view any of the threads on the message board.

If I log in to view the ''messages since last visit'' I CAN see those messages bu cannon view the threads.

I''ve submitted the error message that appears, to no avail.

Anyone else have the same problem? The error message follows:

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix ''M'' does not match with a table name or alias name used in the query.

SQL = "Select M.MemberID, M.MessageID, M.username, M.Authorname, M.useremail, MessageDate, M.MessageCopy, M.signature As signatureYN, (SELECT ShowEmail FROM MsgBoard_Members WHERE MsgBoard_Members.MemberID=M.MemberID) AS ShowEmail, (select signature FROM MsgBoard_Members WHere signature !='''' AND MemberID=M.MemberID) AS SignatureContent ,(SELECT MemberProfile FROM vw_MsgBoardMemberProfile WHERE M.MemberID=vw_MsgBoardMemberProfile.MemberID) AS Member_Txt_Profile FROM MsgBoard_Messages WHERE M.TopicID=8214 and flag_active = 1 ORDER BY MessageDate DESC"

Data Source = "SAILNET"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (39:2) to (39:53) in the template file F:\MEMBERS\HTDOCS\MESSAGEBOARD\READMESSAGE.CFM.

Date/Time: 10/13/03 10:06:21
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Win 9x 4.90)
Remote Address:
HTTP Referer:
Query String: Forum=3&Topic=8214

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

For the best viewing experience please update your browser to Google Chrome