Home  •  FAQ  •   Forums

It is currently Fri Jun 22, 2018 8:40 am

All times are UTC - 7 hours [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: SQL Error when posting
PostPosted: Tue Sep 23, 2008 8:34 am 
Senior Community Leader
Senior Community Leader
User avatar

Joined: Fri Jul 29, 2005 6:00 pm
Posts: 3007
Location: Denver
It seems that there are times when an SQL error comes up while trying to post. The content of the post may preview just fine but then error during the Submit phase.

The SQL error appears to be the result of copy/paste or certain keyboard settings.

It is best to type your post directly into a post/reply box on the board. If you need to copy/paste data from another source, you run the risk of punctuation becoming distorted, causing the SQL error. If you've copied/pasted data from another source outside of the board, please select all of the data in your post/reply box and copy it before attempting to submit your post. If you get the SQL error, you will be able to use your browser's Back button, paste the post content back into the post/reply box, edit and try again.

When in doubt, erase and re-type in the post/reply box any and all punctuation. Usually the " and , marks are the most noticeable as being slightly off however it's best to address ALL non-directly-typed punctuation in this manner, even if the ? and - and ! and . don't look different or odd.

The original text being copied from another source:
Image

Gets pasted into a BPDR post/reply box:
Image

With the punctuation deleted & rekeyed:
Image

Then it will post correctly, without an SQL error - at least in my experience.

"I get this," Clinton said. "My view is ... why say, ever, anything bad about a person? Why don't we like them and celebrate them and be happy for her elevation to the ticket? And just say that she was a good choice for him and we disagree with them?"

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


Top
 Profile  
 
 Post subject: Re: SQL Error when posting
PostPosted: Tue Jan 20, 2009 3:28 pm 
Community Leader
Community Leader
User avatar

Joined: Mon Nov 28, 2005 6:00 pm
Posts: 679
Location: Australia
I only just found this thread - I emailed the Admin team about it before reading this so you needn't reply to me.

Smart quotes - how annoying!

_________________
~ Sarah


Top
 Profile  
 
 Post subject: Re: SQL Error when posting
PostPosted: Fri Apr 17, 2009 3:53 pm 
Senior Community Leader
Senior Community Leader

Joined: Wed Aug 24, 2005 6:00 pm
Posts: 375
Location: UK
This should be fixed now. Let me know if it happens again.


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

All times are UTC - 7 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


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