Home  •  FAQ  •   Forums

It is currently Thu Mar 28, 2024 6:27 am

All times are UTC - 7 hours [ DST ]




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Error message whilst trying to post
PostPosted: Sun Aug 24, 2008 7:52 pm 
New Member
New Member

Joined: Sat Apr 29, 2006 6:00 pm
Posts: 498
I just lost a post. This is the message that I got:
Quote:
General Error
SQL ERROR [ mysql4 ]

Data too long for column 'post_text' at row 1 [1406]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


Top
 Profile  
 
 Post subject: Re: Error message whilst trying to post
PostPosted: Sun Aug 24, 2008 8:26 pm 
New Member
New Member

Joined: Sat Apr 29, 2006 6:00 pm
Posts: 498
I've tried to post the same message a few times now and am still getting the same error message. Is it because my post is too long?


Top
 Profile  
 
 Post subject: Re: Error message whilst trying to post
PostPosted: Mon Aug 25, 2008 1:48 pm 
Senior Community Leader
Senior Community Leader

Joined: Wed Aug 24, 2005 6:00 pm
Posts: 375
Location: UK
It does seem to be saying that your post is too long. I've not seen that before though.


Top
 Profile  
 
 Post subject: Re: Error message whilst trying to post
PostPosted: Mon Aug 25, 2008 10:11 pm 
New Member
New Member

Joined: Sat Apr 29, 2006 6:00 pm
Posts: 498
Ok, no probs. It doesn't really matter now anyway. I was looking for feedback on something, but ran it past a friend instead. The post isn't what I consider long (in comparison to others) but it just didn't seem to want to go through. Are there restrictions on post-length in the various parts of the board? Was trying to post in On The Couch?


Top
 Profile  
 
 Post subject: Re: Error message whilst trying to post
PostPosted: Tue Aug 26, 2008 9:27 am 
Senior Community Leader
Senior Community Leader

Joined: Wed Aug 24, 2005 6:00 pm
Posts: 375
Location: UK
There shouldn't be any special restrictions on post length in different sections. It was an "SQL error" which means the database didn't like it. I'm not doing to try to do anything unless it becomes a more widespread problem.


Top
 Profile  
 
 Post subject: Re: Error message whilst trying to post
PostPosted: Tue Aug 26, 2008 9:41 am 
Senior Community Leader
Senior Community Leader
User avatar

Joined: Fri Jul 29, 2005 6:00 pm
Posts: 3007
Location: Denver
This message displays next to every post/reply box:
Quote:
Message body:
Enter your message here, it may contain no more than 60,000 characters.

_________________
Like BPD Recovery on Facebook.
Follow BPD_Recovery on Twitter.


Top
 Profile  
 
 Post subject: Re: Error message whilst trying to post
PostPosted: Tue Aug 26, 2008 2:17 pm 
New Member
New Member

Joined: Sat Apr 29, 2006 6:00 pm
Posts: 498
Ash wrote:
This message displays next to every post/reply box:
Quote:
Message body:
Enter your message here, it may contain no more than 60,000 characters.


Ok thanks. I hadn't even noticed that. duh! Will bear this in mind for the future.


Top
 Profile  
 
 Post subject: Re: Error message whilst trying to post
PostPosted: Tue Aug 26, 2008 7:43 pm 
Community Member
Community Member
User avatar

Joined: Mon Nov 28, 2005 6:00 pm
Posts: 1800
Location: texas
dont lose track counting at 40,463....lol....

_________________
"no one can walk on you unless you lay down first"
-old saying-


Top
 Profile  
 
 Post subject: Re: Error message whilst trying to post
PostPosted: Wed Aug 27, 2008 7:26 am 
Senior Community Leader
Senior Community Leader
User avatar

Joined: Fri Jul 29, 2005 6:00 pm
Posts: 3007
Location: Denver
When in doubt, I'll usually copy my post into a fresh Word document and use Tools, Word Count to check how many characters I've got in there. It's not terribly difficult (for me and some other folks, I think) to hit 60,000 characters in one sitting.

_________________
Like BPD Recovery on Facebook.
Follow BPD_Recovery on Twitter.


Top
 Profile  
 
 Post subject: Re: Error message whilst trying to post
PostPosted: Mon Sep 01, 2008 10:05 pm 
New Member
New Member

Joined: Sat Apr 29, 2006 6:00 pm
Posts: 498
Same error message whilst trying to post in OTB.

Pages = 1
Words = 350
Characters (no spaces) = 1589
Characters (with spaces) = 1939
Paragraphs = 5
Lines = 22

Nowhere near 60,000 characters. Could the problem be due to typing the post in a word document, then copying and pasting it onto the board? The last time this happened, I also had pasted the post from a word document.


Top
 Profile  
 
 Post subject: Re: Error message whilst trying to post
PostPosted: Tue Sep 02, 2008 8:03 am 
Senior Community Leader
Senior Community Leader
User avatar

Joined: Fri Jul 29, 2005 6:00 pm
Posts: 3007
Location: Denver
If you're using any coding that requires " marks, then there might be a problem with the display though I can't imagine it would be enough to cause the error you describe.

In Word, the " marks go all slanty which, when copied over to the board, don't tell the software to do anything.

Again, I can't imagine how this would cause the problem you describe unless you have any other oddly laid out characters copied over that somehow mess with the post's formatting to such a degree, like maybe an inadvertent SQL or HTML command.

Does the error only happen when you type first in Word and then copy/paste to the board?

========================================================

Alrighty then, I think we have our answer. I had a copied/pasted quote sample included to point to and it showed okay in preview but then when I hit submit, I too got the SQL error.

I do believe it's something to do with the copy/paste of Word.

Can you try to use Word Pad instead? I believe the RTF format is a lot more plain than the DOC format which may be hiding gremlins that are at odds with the software.

_________________
Like BPD Recovery on Facebook.
Follow BPD_Recovery on Twitter.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC - 7 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 11 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group