Recent Forum Posts
-
Call for stripShow sites for gallery!
posted in forum Announcements by Esn on June 25, 2010 at 9:02 pm
-
Some things I'd like to do - lightboxes, 784px width, CC license
posted in forum Support Requests by Esn on June 15, 2010 at 2:24 pm
-
Archive Image Problem (resolved)
posted in forum Support Requests by Esn on June 9, 2010 at 1:23 pm
-
Can only view one Comic
posted in forum Support Requests by silvestri99 on May 27, 2010 at 10:34 pm
-
Latest comic shows, but not the rest.
posted in forum Support Requests by AlphaNeonic on May 21, 2010 at 5:13 pm
-
Call for stripShow sites for gallery!
Webcomics plugin for WordPress
Forums | Non-comic blog showing in reverse order
Non-comic blog showing in reverse order
3:23 pm
August 19, 2008
DrLaw
posts 3
Hi,
Love the work that you've done with stripShow, makes it really easy to get a comic site up and running!
Anyway, on my – presently unfinished – comic/blog: http://www.phasetoground.com the comics show up in the correct order but the non-comic posts show up in reverse order. I'm using stripShow 1.6.1 with WordPress 2.6.1 and PHP 5.1.4 (I think) on a Windows Server. Also, I'm using the default stripShow single category for comics.
I've checked the sql statements in the template and in stripshow.php, and they all seem to be in proper order (ordered by date, Descending). Is there another place to look, or is this an issue with WordPress 2.6.1 and/or the Windows setup?
Thanks In advance.
Dana
3:38 pm
August 19, 2008
Brad
posts 186
Do you happen to know what version of MySQL your server uses? This sounds like the same problem from this thread… I think we resolved that issue by upgrading MySQL.
4:53 pm
August 19, 2008
DrLaw
posts 3
It looks like the server is running 5.0.51, would there be that much of a difference between that and 5.0.67? The only difference between mine and the post you linked was that my comics are all showing up properly, it's just the non-comic categories that aren't working. I have 2 other categories (random, tech) with 1 post each in them, and i've tried putting them in the same category and also re-entering the dates to make sure that there wasn't anything wonky with them, but still the same results.
Thanks for your patience!
8:08 am
August 20, 2008
Brad
posts 186
OK, so here's what we found out: This appears to be a bug in MySQL 5.0.51, which affects the results from the query_posts function — it happens in WordPress in general, not just stripShow.
A discussion of this issue can be found here, along with a plugin you can add to work around the issue.
8:18 am
August 20, 2008
DrLaw
posts 3
Awesome, that fixed the problem right up! I just copied the text from that post into a new php file and uploaded and activated it in wordpress, and now the blog posts work fine.
Thanks again, you're the best!
- Dana
3:29 pm
August 20, 2008
EddieC
posts 7
Dunno if this helps anybody, but I installed Ubuntu server just yesterday (v 8.04.i386) and it came with MySQL v5.0.51a-3ubuntu5.1
Go figure.