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 > On Board > 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 Quick reply to this message Share with Facebook
  #2  
Old 10-13-2003
Senior Member
 
Join Date: Nov 2000
Posts: 407
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 15
tsenator is on a distinguished road
Can''''t view messages

This happens a lot on this Bulletin Board. And I think if it goes out on a friday, you won''t see it up until the next week.

This is mostly a free Bulletin Board and it''s hard for Sailnet to put the resources into the tech support needed to keep this up 7x24x365
Reply With Quote Quick reply to this message Share with Facebook
  #3  
Old 10-14-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

Thanks--

As of this a.m. all''s well.
Reply With Quote Quick reply to this message Share with Facebook
Reply

Quick Reply
Message:
Options

By choosing to post the reply above you agree to the rules you agreed to when joining Sailnet.
Click Here to view those rules.

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:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.
Password:
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:

Log-in

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.




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 0 10-13-2003 07:08 AM
View a Mac 25 in Dallas area Michfar Boat Review and Purchase Forum 0 03-19-2001 08:36 AM


All times are GMT -4. The time now is 08:22 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

The SailNet.com store is owned and operated by a company independent of the SailNet.com forum. You are now leaving the SailNet forum. Click OK to continue or Cancel to return to the SailNet forum.