Re: posting by E-mail

  • From: Steve Holmes <steve@xxxxxxxxxxxxxxx>
  • To: blindcasting@xxxxxxxxxxxxx
  • Date: Sun, 4 Dec 2005 12:32:28 -0700

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

I didn't look real closely at your message below but I remember now
getting similar errors when posting via e-mail.  You *MUST* quote your
quotes.  Let me explain.  If you use tick marks in your messages like
Steve's podcast, Jeff's file, etc.  the "'" must be doubled up.  In
other words, the above phrases should be typed as Jeff''s file, Steve''s
podcast, etc.  This is because SQL queries are being used to post your
blog and SQL syntax uses the single quote marks to delimit string
values.  A double tick mark ('') will be interpreted by SQL as one
single tick mark and left alone in your postings.  This bit me and took
me a little while to figure this out.  You would think WordPress could
parse this out for you but... So this work-around does the job just
fine.  Just remember to double up any single quote marks used in any WP
e-mail postings.

On Sat, Dec 03, 2005 at 04:46:45PM -0800, Jared Rimer wrote:
> Author = jared@xxxxxxxxxxxxx
> Content-type: text/plain, boundary:
> Raw content:
> Hi all,
> This is a test entry.  I'm sending by E-mail.  There is
> still the cancellation on the
> code
> amber web site
>  which you can still view.  Please feel free to
> contact me at any time if you need anything.
> Jared Rimer
> www.codeamber.org
> Phone 866-824-7876 and follow the voice prompts toll-free US and Canada 
> only.
> WordPress database error:
>  [You have an error in your SQL syntax.  Check the manual that 
> corresponds to your
> MySQL server version for the right syntax to use near 'm sending by 
> E-mail.  There
> is  still the cancellation on the ]
> INSERT INTO wp_posts    (post_author, post_date, post_date_gmt, 
> post_modified, post_modified_gmt,
> post_content, post_title, post_excerpt, post_category, post_status, 
> post_name, comment_status,
> ping_status, post_parent)    VALUES ('1', '2005-12-03 14:02:13', 
> '2005-12-03 22:02:13',
> '2005-12-03 14:02:13', '2005-12-03 22:02:13', 'Hi all,          This 
> is a test entry.
> I'm sending by E-mail.  There is  still the cancellation on the
> code  amber web site
>  which you can still view.  Please feel free to  contact me at any 
> time if you need
> anything.  Jared Rimer www.codeamber.org Phone 866-824-7876 and 
> follow the voice
> prompts toll-free US and Canada only.', 'This is a test entry', '', 
> '1', 'publish',
> 'this-is-a-test-entry', 'open', 'open', '0')
> WordPress database error:
>  [You have an error in your SQL syntax.  Check the manual that 
> corresponds to your
> MySQL server version for the right syntax to use near '' at line 3]
>    SELECT category_id    FROM wp_post2cat    WHERE post_id =
> WordPress database error:
>  [You have an error in your SQL syntax.  Check the manual that 
> corresponds to your
> MySQL server version for the right syntax to use near ' 1)' at line 2]
>      INSERT INTO wp_post2cat (post_id, category_id)      VALUES (, 1)
> WordPress database error:
>  [You have an error in your SQL syntax.  Check the manual that 
> corresponds to your
> MySQL server version for the right syntax to use near '' at line 1]
> SELECT pinged FROM wp_posts WHERE ID =
> Author = jared@xxxxxxxxxxxxx
> Content-type: text/plain, boundary:
> Raw content:
> If one of these makes it, I'll be good.
> Jared Rimer
> www.codeamber.org helper of the friends page
> Phone 866-824-7876 and follow the voice prompts toll-free US and Canada 
> only.
> This address is used to communicate with code amber and its
> contributors for donations.  If you receive a message from this
> address please keep in mind this fact.  If you have questions, call
> me.  Thank you.
> Other web sites you may visit are:
> Business website: http://www.superior-software.com/support
> Personal Website: http://www.asmodean.net/jrimer
> Music Education Network for the Visually Impaired http://menvi.org  a
> service done through Superior Software level one
> WBBY Internet Radio and All In Play team up.  Learn more
> http://www.menvi.org/allinplay
> WBBY Internet Radio web site: www.wbby.us
> WordPress database error:
>  [You have an error in your SQL syntax.  Check the manual that 
> corresponds to your
> MySQL server version for the right syntax to use near 'll be 
> good.  Jared Rimer www.codeamber.org
> helper of the fri]
> INSERT INTO wp_posts    (post_author, post_date, post_date_gmt, 
> post_modified, post_modified_gmt,
> post_content, post_title, post_excerpt, post_category, post_status, 
> post_name, comment_status,
> ping_status, post_parent)    VALUES ('1', '2005-12-03 14:29:44', 
> '2005-12-03 22:29:44',
> '2005-12-03 14:29:44', '2005-12-03 22:29:44', 'If one of these makes 
> it, I'll be
> good.  Jared Rimer www.codeamber.org helper of the friends page Phone 
> 866-824-7876
> and follow the voice prompts toll-free US and Canada only. This 
> address is used to
> communicate with code amber and its  contributors for donations.  If 
> you receive
> a message from this  address please keep in mind this fact.  If you 
> have questions,
> call  me.  Thank you. Other web sites you may visit are: Business 
> website: http://www.superior-software.com/support
> Personal Website: http://www.asmodean.net/jrimer Music Education 
> Network for the
> Visually Impaired http://menvi.org  a  service done through Superior 
> Software level
> one WBBY Internet Radio and All In Play team up.  Learn 
> more  http://www.menvi.org/allinplay
> WBBY Internet Radio web site: www.wbby.us', 'another test blog', '', 
> '1', 'publish',
> 'another-test-blog', 'open', 'open', '0')
> WordPress database error:
>  [You have an error in your SQL syntax.  Check the manual that 
> corresponds to your
> MySQL server version for the right syntax to use near '' at line 3]
>    SELECT category_id    FROM wp_post2cat    WHERE post_id =
> WordPress database error:
>  [You have an error in your SQL syntax.  Check the manual that 
> corresponds to your
> MySQL server version for the right syntax to use near ' 1)' at line 2]
>      INSERT INTO wp_post2cat (post_id, category_id)      VALUES (, 1)
> WordPress database error:
>  [You have an error in your SQL syntax.  Check the manual that 
> corresponds to your
> MySQL server version for the right syntax to use near '' at line 1]
> SELECT pinged FROM wp_posts WHERE ID =
> 
> 
> Does that sound familiar?  There are two posts, and I did contact 
> Jeff at Ultrahost about this and I'll be sending this to him.
> 
> At 03:50 PM 12/3/2005, you wrote:
> >Not sure;
> >I get them as well, something about SQL errors?
> >Sound familuar?
> >Shane
> >
> >
> >
> >  _____
> >
> >avast! Antivirus <http://www.avast.com> : Outbound message clean.
> >
> >
> >Virus Database (VPS): 0548-2, 12/03/2005
> >Tested on: 12/3/2005 6:50:03 PM
> >avast! - copyright (c) 1988-2005 ALWIL Software.
> 
> Jared Rimer
> Business website: http://www.superior-software.com/support
> Personal Website: http://www.asmodean.net/jrimer
> Music Education Network for the Visually Impaired  http://menvi.org a 
> service done through Superior Software level one
> WBBY Internet Radio and All In Play team up.  Learn more 
> http://www.menvi.org/allinplay
> WBBY Internet Radio: www.wbby.us 
> 
> 
> 
> 

- -- 
HolmesGrown Solutions
The best solutions for the best price!
http://ld.net/?holmesgrown
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.7 (GNU/Linux)

iD8DBQFDk0RLWSjv55S0LfERAw5YAKCcSddUPhLU/TFwVy29/e/HnNBQ+ACgn0yV
fGW/Zs0YbQ83HhEhtgK2zyE=
=JV/x
-----END PGP SIGNATURE-----

Other related posts: