mysql errors with wp-mail after upgrade to 1.5.1.3 from 1.5.1.2

Ok… I have no idea what just happened, but I sent a test message to my blogs email address… and it posted with no errors at all.

I suppose my mail client (Evolution) may have sent the original message with errors… Bizarre.

Still unresolved unfortunately… it’s annoying as hell.

To provide some comparison, when posting via the web interface the mysql.log shows this. Same content as from the email post that failed.


2 Init DB blog-ddiction
2 Query SELECT * FROM wp_users WHERE user_level > 0
2 Query SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
2 Query SELECT ID, user_login, user_pass FROM wp_users WHERE user_login = 'admin'
2 Query SELECT * FROM wp_categories
2 Query SELECT COUNT(*) FROM wp_comments WHERE comment_approved = '0'
2 Query SHOW TABLE STATUS LIKE 'wp_posts'
2 Query SELECT post_name FROM wp_posts WHERE post_name = 'cuz-im-a-meme-whore-and-my-brain-is-fried-from-working-over-the-weekend' AND post_status = 'publish' AND ID != '943' LIMIT 1
2 Query INSERT INTO wp_posts
(ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, post_modified, post_modified_gmt, post_parent, menu_order)
VALUES
('943', '1', '2005-07-24 18:08:33', '2005-07-25 01:08:33', 'Congratulations on being the creator of a new
Evil Plan (tm)!
Your objective is simple: World Domination.

Your motive is a little bit more complex: Power

Stage One
To begin your plan, you must first assassinate a pope. This will
cause the world to whisper among themselves, alarmed by your
arrival. Who is this despoiler of all that is good and nice and
true? Where did they come from? And why do they look so good in
a corporate suit?

Stage Two
Next, you must seize control of the Internet. This will all be
done from a obsidian citadel, a mysterious place of unrivaled
dark glory. Upon seeing this, the world will gibber like madmen,
as countless hordes of computer programmers hasten to do your
every bidding.

Stage Three
Finally, you must prepare your corporate takeover, bringing
about a 1984 police state. Your name shall become synonymous
with fear, and no man will ever again dare cross you. Everyone
will bow before your cunning intelligence, and the world will
have no choice but to whisper your name in fear. ', 'Cuz I\'m a meme whore, and my brain is fried from working over the weekend', '', 'publish', 'open', 'open', '', 'cuz-im-a-meme-whore-and-my-brain-is-fried-from-working-over-the-weekend', '', '2005-07-24 18:08:33', '2005-07-25 01:08:33', '0', '0')
2 Query SELECT * FROM wp_post2cat WHERE post_id = 943 AND category_id = 1
2 Query INSERT INTO wp_post2cat
(post_id, category_id)
VALUES
(943, 1)
2 Query SELECT * FROM wp_posts WHERE ID=943
2 Query UPDATE wp_posts SET guid = 'http://blog.ddiction.com/?p=943' WHERE ID = '943'
050724 19:08:35 3 Connect username@localhost on
3 Init DB blog-ddiction
3 Query SELECT * FROM wp_users WHERE user_level > 0
3 Query SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
3 Query SELECT * FROM wp_categories
3 Query SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2005-07-25 01:08:59' AND (post_status = "publish" OR post_author = 3 AND post_status != 'draft' AND post_status != 'static') GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10
3 Query SELECT DISTINCT
post_id, cat_ID FROM wp_categories, wp_post2cat
WHERE category_id = cat_ID AND post_id IN (943,942,941,939,938,937,936,935,934,933)
3 Query SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1')
WHERE ID IN (943,942,941,939,938,937,936,935,934,933)
GROUP BY ID
3 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN(943,942,941,939,938,937,936,935,934,933) ORDER BY post_id, meta_key
3 Query SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2005-07-24 18:08:35’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
050724 19:08:36 3 Query SELECT * FROM wp_posts WHERE post_status = ‘static’ ORDER BY post_title ASC
3 Query SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2005-07-24 18:08:36’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
3 Query SELECT cat_ID, cat_name, category_nicename, category_description, category_parent
FROM wp_categories
WHERE cat_ID > 0
ORDER BY cat_id asc
3 Query SELECT cat_ID,
COUNT(wp_post2cat.post_id) AS cat_count
FROM wp_categories
INNER JOIN wp_post2cat ON (cat_ID = category_id)
INNER JOIN wp_posts ON (ID = post_id)
WHERE post_status = ‘publish’
AND post_date_gmt < ‘2005-07-25 01:08:36’
GROUP BY category_id
3 Query SELECT option_value FROM wp_options WHERE option_name = ‘blogfilename’
3 Query SELECT cat_id, cat_name, auto_toggle, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, text_before_link, text_after_link, text_after_all, list_limit FROM wp_linkcategories WHERE cat_id=1
3 Query SELECT link_url, link_name, link_image, link_target,
link_description, link_rating, link_rel , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated , UNIX_TIMESTAMP(link_updated) AS link_updated_f
FROM wp_links
WHERE link_visible = ‘Y’ AND link_category = 1 ORDER BY rand() ASC
3 Query SELECT COUNT(ID) FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2005-07-25 01:08:59’ AND (post_status = “publish” OR post_author = 3 AND post_status != ‘draft’ AND post_status != ‘static’)
3 Quit
050724 19:08:49 1 Query SELECT username, crypt, “”, uid, gid, pop, “”, “”, realname, “” FROM users WHERE username = “hcarrigan@allcan.com”
4 Connect username@localhost on
4 Init DB blog-ddiction
4 Query SELECT * FROM wp_users WHERE user_level > 0
4 Query SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’
4 Query SELECT * FROM wp_categories
4 Query SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2005-07-25 01:08:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10
4 Query SELECT DISTINCT
post_id, cat_ID FROM wp_categories, wp_post2cat
WHERE category_id = cat_ID AND post_id IN (943,942,941,939,938,937,936,935,934,933)
4 Query SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = ‘1’)
WHERE ID IN (943,942,941,939,938,937,936,935,934,933)
GROUP BY ID
4 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN(943,942,941,939,938,937,936,935,934,933) ORDER BY post_id, meta_key
4 Query SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2005-07-24 18:08:49’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
4 Query SELECT * FROM wp_posts WHERE post_status = ‘static’ ORDER BY post_title ASC
4 Query SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2005-07-24 18:08:49’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
4 Query SELECT cat_ID, cat_name, category_nicename, category_description, category_parent
FROM wp_categories
WHERE cat_ID > 0
ORDER BY cat_id asc
4 Query SELECT cat_ID,
COUNT(wp_post2cat.post_id) AS cat_count
FROM wp_categories
INNER JOIN wp_post2cat ON (cat_ID = category_id)
INNER JOIN wp_posts ON (ID = post_id)
WHERE post_status = ‘publish’
AND post_date_gmt < ‘2005-07-25 01:08:49’
GROUP BY category_id
4 Query SELECT option_value FROM wp_options WHERE option_name = ‘blogfilename’
4 Query SELECT cat_id, cat_name, auto_toggle, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, text_before_link, text_after_link, text_after_all, list_limit FROM wp_linkcategories WHERE cat_id=1
4 Query SELECT link_url, link_name, link_image, link_target,
link_description, link_rating, link_rel , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated , UNIX_TIMESTAMP(link_updated) AS link_updated_f
FROM wp_links
WHERE link_visible = ‘Y’ AND link_category = 1 ORDER BY rand() ASC
4 Query SELECT COUNT(ID) FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2005-07-25 01:08:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’)
4 Quit
050724 19:08:52 5 Connect username@localhost on
5 Init DB blog-ddiction
5 Query SELECT * FROM wp_users WHERE user_level > 0
5 Query SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’
5 Query SELECT * FROM wp_categories
5 Query SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2005-07-25 01:08:59’ AND (post_status = “publish” OR post_author = 3 AND post_status != ‘draft’ AND post_status != ‘static’) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10
5 Query SELECT DISTINCT
post_id, cat_ID FROM wp_categories, wp_post2cat
WHERE category_id = cat_ID AND post_id IN (943,942,941,939,938,937,936,935,934,933)
5 Query SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = ‘1’)
WHERE ID IN (943,942,941,939,938,937,936,935,934,933)
GROUP BY ID
5 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN(943,942,941,939,938,937,936,935,934,933) ORDER BY post_id, meta_key
5 Query SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2005-07-24 18:08:52’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
050724 19:08:53 5 Query SELECT * FROM wp_posts WHERE post_status = ‘static’ ORDER BY post_title ASC
5 Query SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2005-07-24 18:08:53’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
5 Query SELECT cat_ID, cat_name, category_nicename, category_description, category_parent
FROM wp_categories
WHERE cat_ID > 0
ORDER BY cat_id asc
5 Query SELECT cat_ID,
COUNT(wp_post2cat.post_id) AS cat_count
FROM wp_categories
INNER JOIN wp_post2cat ON (cat_ID = category_id)
INNER JOIN wp_posts ON (ID = post_id)
WHERE post_status = ‘publish’
AND post_date_gmt < ‘2005-07-25 01:08:53’
GROUP BY category_id
5 Query SELECT option_value FROM wp_options WHERE option_name = ‘blogfilename’
5 Query SELECT cat_id, cat_name, auto_toggle, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, text_before_link, text_after_link, text_after_all, list_limit FROM wp_linkcategories WHERE cat_id=1
5 Query SELECT link_url, link_name, link_image, link_target,
link_description, link_rating, link_rel , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated , UNIX_TIMESTAMP(link_updated) AS link_updated_f
FROM wp_links
WHERE link_visible = ‘Y’ AND link_category = 1 ORDER BY rand() ASC
5 Query SELECT COUNT(ID) FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2005-07-25 01:08:59’ AND (post_status = “publish” OR post_author = 3 AND post_status != ‘draft’ AND post_status != ‘static’)
5 Quit

I’ve created a ticket over here -> http://trac.wordpress.org/ticket/1536 to track this issue as well. Perhaps if a others chime in with bug reports we can get this looked at.