Print Page | Close Window

Getting "\r\n" in each post???

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20601
Printed Date: 11 April 2026 at 10:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Getting "\r\n" in each post???
Posted By: rollbg
Subject: Getting "\r\n" in each post???
Date Posted: 08 July 2006 at 7:56pm
Getting strange characters in posts. At the end of each post I get "\r\n" What is this and how to get rid of it.

I also get this error when I try to edit the post:
SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message, tblThread.Show_signature, tblThread.IP_addr, tblThread.Hide, tblThread.File_uploads FROM tblThread WHERE tblThread.Thread_ID=2;

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Query-based update failed because the row to update could not be found.

/survivor/forum/edit_post.asp, line 562

And I installed the forum few times (with new database) but I still get the same error :(




Replies:
Posted By: WebWiz-Bruce
Date Posted: 10 July 2006 at 9:39am
These both seem very strange.

What database version are you using and what web server?


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: rollbg
Date Posted: 10 July 2006 at 5:46pm
Im using MySQL and my host is on brinkster.com so I guess it is Win Server 2000 or 2003!
You could check it at http://aimto.net/survivor/forum/


Posted By: WebWiz-Bruce
Date Posted: 10 July 2006 at 5:49pm
Are you using a free Brinskter account with ads.

If so then this will be the problem as the ads injected into the pages will course problems.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: rollbg
Date Posted: 10 July 2006 at 5:51pm
Not Free it is a Professional Package :(


Posted By: WebWiz-Bruce
Date Posted: 10 July 2006 at 5:59pm
Do you have a link to your forum to be able to have a look?

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: rollbg
Date Posted: 10 July 2006 at 6:10pm
Sure,
You could check it at http://aimto.net/survivor/forum/


Posted By: dpyers
Date Posted: 10 July 2006 at 9:00pm
Those are newline and carriage return characters.

Might happen if someone was posting from a linux set up.

Also seen when people try to use a mail form to relay spam by inserting a bcc.


-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: ctscott
Date Posted: 10 July 2006 at 9:29pm
that sorta looks like  javascript special characters "tab" and "newline" are being appended to the posts.

-------------
______________________
http://www.cfbtrivia.com" rel="nofollow - College Football Trivia


Posted By: jckruger
Date Posted: 11 July 2006 at 12:19am
http://www.aimto.net/survivor/forum/ - http://www.aimto.net/survivor/forum/


Posted By: WebWiz-Bruce
Date Posted: 11 July 2006 at 8:08am
I've had a look and can't see why or how the \r\n is being added as there is no code like that in web wiz forums.

The only thing I can think is that either the files have been modified or you are using something other than FTP to upload the files which may also be modifying the code.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: dpyers
Date Posted: 11 July 2006 at 10:10pm
you might want to search if your using Chr(13) or Chr(10) in your asp code or using the variables vbCR or vbLF whch are the equivilents of \r and \n


-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: rollbg
Date Posted: 13 July 2006 at 6:51pm
No files have been modified, Im uploading with CuteFTP can it modify the code ? :(


Posted By: WebWiz-Bruce
Date Posted: 14 July 2006 at 8:23am
It sounds like it could be server related, what server OS are you using and what database version?

Also, if using SQL server or mySQL on another server, check the language settings are the same.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: dpyers
Date Posted: 14 July 2006 at 8:36pm
Originally posted by rollbg rollbg wrote:

No files have been modified, Im uploading with CuteFTP can it modify the code ? :(


Some ftp programs can modify text file transfers if they think either the sending or destination machine is a unix box.
/r/n are unix characters for the end of a text line and an advance to a new line. You may want to check the cuteftp oprions to see if there's any option for toggling unix text lines.


-------------

Lead me not into temptation... I know the short cut, follow me.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net