shabicht

Excellent, thanks for the follow up.

Thanks!! Any ETA? Q1, Q2, etc.

Well, that would still require to enter something. I was hoping for a fully automatic solution that requires no manual intervention.

Well, if nothing else, the issue has been logged and maybe someone will come across this thread next time the issue happens.

Yeah, the edit was done via the app.

Nope, checking “Do not post Tweets by default (editing only)” posting (and getting a tweet) and then editing the post still resulted in a second tweet.

As a further follow up, it was not the upgrade that fixed the issue, but checking “Update when a post is edited”.

It seems the Windows Phone 8 WordPress app uploads the content in a manner that creates the post without the WP to Twitter plugin knowing; however, at the end of the upload, the app shows “Uploading Changes”, which I guess is a final edit of the now existing post. I’m trying to read the code, and it looks like they are doing an edit instead of an add.
https://windowsphone.trac.www.ads-software.com/browser#trunk/WordPress/Resources

The posts on my site don’t get edited too often, so having “Update when a post is edited” turned on is a solution that will work for me.

That is a function of your theme. YOu need something like:

<a href="<?php print esc_html(get_syndication_permalink($post->ID)); ?>" title="<?php the_title(); ?>" target="_blank">link to article</a>

You could fix this in the codebase:
https://github.com/radgeek/feedwordpress/blob/master/syndicationdataqueries.class.php if the project allows for it.

For those of you still getting the error “The data could not be converted to UTF-8” I found a fix for the issue today. The problem seems to be with the opensource code simplepie. I downloaded the latest version here:
https://dev.simplepie.org/

I then replaced my file /wp-includes/class-simplepie.php with the newer version and the issue went away. (I’m be monitoring over the next day to make sure).

I would guess that the issue was intermittent because the newer posts in a feed caused the post causing the issue to get pushed out of the feed over time.

Mark this post as [resolved]. Turning off “Optimize IN clauses” fixed the issue.

Rolled back mysql to CentOS repo. Same issue.

mysqladmin Ver 8.42 Distrib 5.1.66, for redhat-linux-gnu on x86_64
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version 5.1.66
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 22 min 8 sec

Threads: 2 Questions: 86440 Slow queries: 3 Opens: 87 Flush tables: 1 Open tables: 64 Queries per second avg: 65.90

Rolled back to:
PHP 5.3.3 (cli) (built: Jul 3 2012 16:53:21)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies

Same issue.

To eliminate this as a theme issue I tried both “Twenty Ten” and “Twenty Twelve”, both which still gave the error:

“Nothing Found
Apologies, but no results were found for the requested archive. Perhaps searching will help find a related post.”

For the record:
PHP 5.4.10 (cli) (built: Dec 19 2012 11:45:14)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2012 Zend Technologies

mysqladmin Ver 8.42 Distrib 5.5.28, for Linux on x86_64
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version 5.5.28
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 12 days 1 hour 55 min 41 sec

Threads: 7 Questions: 41300184 Slow queries: 690 Opens: 309 Flush tables: 1 Open tables: 234 Queries per second avg: 39.569

Server version: Apache/2.2.15 (Unix)
Server built: Feb 13 2012 22:31:42

I’ve done some testing. Whenever I turn on the 2012.1218 version I get the following errors in the apache error_log when trying to access anything like https://example.com/category/foobar.

[Thu Jan 03 09:50:33 2013] [error] [client x.x.x.x] 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 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id = 6251 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

[Thu Jan 03 09:50:52 2013] [error] [client x.x.x.x] 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 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id = 23479 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

[Thu Jan 03 09:51:35 2013] [error] [client x.x.x.x] 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 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id = 23479 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

[Thu Jan 03 09:51:41 2013] [error] [client x.x.x.x] 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 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id = 6636 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

I’ll need to look more, but thought I’d share that information.