Can''t view messages - SailNet Community

   Search Sailnet:

 forums  store  


Quick Menu
Forums           
Articles          
Galleries        
Boat Reviews  
Classifieds     
Search SailNet 
Boat Search (new)

Shop the
SailNet Store
Anchor Locker
Boatbuilding & Repair
Charts
Clothing
Electrical
Electronics
Engine
Hatches and Portlights
Interior And Galley
Maintenance
Marine Electronics
Navigation
Other Items
Plumbing and Pumps
Rigging
Safety
Sailing Hardware
Trailer & Watersports
Clearance Items

Advertise Here






Go Back   SailNet Community > General Interest Forums > Boat Review and Purchase Forum
 Not a Member? 


Reply
 
LinkBack Thread Tools
  #1  
Old 10-13-2003
ct ct is offline
Member
 
Join Date: Jun 2003
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
ct is on a distinguished road
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: 209.26.169.230
HTTP Referer: http://members.sailnet.com/messageboard/viewtopic.cfm?ForumID=3
Query String: Forum=3&Topic=8214
Reply With Quote Share with Facebook
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can''t view messages ct Boat Review and Purchase Forum 2 10-14-2003 09:59 AM
View a Mac 25 in Dallas area Michfar Boat Review and Purchase Forum 0 03-19-2001 07:36 AM


All times are GMT -4. The time now is 03:00 PM.

Add to My Yahoo!         
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.1
(c) Marine.com LLC 2000-2012