I recently set up a WordPress blog at »
www.thelifeofbrian.info/blog. It's been a challenge getting everything moved over from the old blog (»
dfwdraco76.blogspot.com), but I'm getting there.
The problem I'm having at this point, which showed up after working correctly for at least a week, is that the "Recent Posts" box in the upper right hand corner is showing the FIRST 10 posts ever made to the blog instead of the LAST 10. It worked fine in the beginning. AND, when I use the "Recent Posts" widget built into WordPress - that works correctly.
According to my hosting company (»
www.thelifeofbrian.info/ ··· -update/) it is a problem with MySQL. When I asked them for a bug number they referred me to »
bugs.mysql.com/bug.php?id=32202. They're saying there's nothing they can do to fix it until MySQL fixes the problem, and there are no workarounds.
The problem I have with that is the fact that the build-in Recent Posts widget works just fine. So what I need to figure out is:
- What is the SQL query that the "Recent Posts" built into my theme is using?
- Where does this SQL query live so I can modify it
- What is the SQL query that the "Recent Posts" widget built into WordPress is using?
I haven't made much progress in this area just yet... I was hoping somebody here might have some suggestions on where to find this, or how to figure it out?