Now while playing around with the stats API over the weekend, I noticed some unusual things:
- “blog_uri=futtta.wordpress.com” works
- “blog_uri=blog.futtta.be” results in “Error: zero rows returned.”
The API also supports blog_id instead of blog_uri and after some digging for blog_id’s I found that they are listed in (the html source of) the blog dropdown-list on your wordpress.com-dashboard stats page. And there the problem became clear: I had two blog_id ‘s for the same blog_uri (blog.futtta.be) and the first one was defunct:
- “blog_id=2184847” results in “Error: zero rows returned.”
- “blog_id=2185033” works just fine
As I can’t remove the entry with the faulty blog_id from the Stats DB and as I can’t change the Android WordPress app to use one of multiple blog_id’s instead of the blog_uri, I can’t fix this little bugger myself, so I contacted WordPress Support. But how did I end up with 2 blog_id’s in the database?