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
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. |
rollbg wrote: