Database Updates
373 Entries

Find out what’s changed on the site! Check back here for information about database additions, reading order placements, error fixes, or new user features.

We’re updated every day, often more than once!

Up Down
By | Sunday, June 20, 2010 | 2:41 pm | 0 Comments | Blog > Database Updates

Fixed a couple small things I noticed on my way to do a little database work. The thumbnails were only showing up on the default post type – now they are universally enabled so you can add book covers etc.

Second, I just fixed a little formatting on the Recent Forum Posts sidebar widget – now they are spaced out a little more and don’t get jumbled when a shorter post title is on top.

Want to stay up to date? Click here to subscribe to updates by RSS!
You can also sign up to get updates by Email!
By | Sunday, June 20, 2010 | 3:32 am | 0 Comments | Blog > Database Updates

Ok, so I’m currently running Quick Cache instead of Super Cache or Hyper Cache (notice a theme with these names? Really creative programmers, right?)

So far this is the absolutely fastest of the plugins I’ve tried. Page load time of cached pages is down to 1.5 seconds for everything I’ve tested so far.

I DO still have the problem where category pages are being cached and not refreshed with a new post being added to the database. The options are fairly limited with this plugin (I miss Hyper Cache’s more complex options, but again, it doesn’t work with my current set up at all). Basically, I can set it delete none of the cache on the new post or edit, purge the item for that particular post, purge the item and the home page, or purge EVERYTHING.

I don’t want to purge everything, since 99& of the site won’t change on the one post, but I do want it to purge lists generated with Custom Taxonomies, Tags, and Categories – because that is the main site content. I’ve posted on the wordpress forums about this and hopefully someone will help me find a solution soon.

Regardless, I’ve set it so the forums never cache, still – so while they load a little slower than the rest of the site, they will always show user feedback instantly instead of new posts taking a minute to show up.

Comments, though, should show up instantly on the post if not in the “3 comments” on this item type text in the blog view.

Again, let me know if you run into any weirdness as you go through the site. Your feedback has helped me a LOT with this project.

Oh darn it all:

Just a minute after I posted this I ran into an error where it was displaying the cached pages of ME logged in to any user who visited the page. So there’s something weird going on with the logged in user caching and I had to disable that. Which means that the site will run fast for any casual visitor, but still slower for any of us who comment or log in. Frustrating!

I’ll see if there is any way I can fix that as well.. or, for gosh sakes, find yet another alternative.

Want to stay up to date? Click here to subscribe to updates by RSS!
You can also sign up to get updates by Email!
By | Sunday, June 20, 2010 | 2:49 am | 0 Comments | Blog > Database Updates

There was a problem where Custom Post Types were not showing up on Category listings. They worked fine on custom taxonomy listings, but not on categories for some reason. Since the main reading orders on the site are made through these listings, and books are going to be given custom post types soon, this was a pretty big problem.

The solution turned out to be kind of simple, though it took me a while to figure it out.

Basically, I just needed to change the query that called the posts for the loop. What I was having trouble with was adding an array of all the custom post type names.

When I realized I could just use the term “any” in the function to just include ALL the custom post types that were marked as that category…. well, that made my life a lot easier. Holleeee crap!

<?php query_posts($query_string . ‘&order=asc&post_type=any’); ?>

That’s the final query there on the index. Really not that bad – but I’d much rather have an any query that works through proper sorting than really having to customize a new template for every single reading order. This should work though – the test books I put in temporarily seemed to confirm it.

And now back to getting the cache going again.

Want to stay up to date? Click here to subscribe to updates by RSS!
You can also sign up to get updates by Email!
By | Sunday, June 20, 2010 | 2:01 am | 0 Comments | Blog > Database Updates

I’m just not happy with how WP-Super Cache handles the files for this site. It may work for other sites, but because of the nature of our listings (basically Category listings) the reading orders don’t update with the publication of new book entries. They would eventually, after they expire, but it’s not easy to set it to just refresh category pages after any addition.

Hyper Cache could do that, but it doesn’t seem to play nice with WordPress 3.0

So, I’m investigating alternatives tonight. Again, hate to slow down the site by uninstalling, but I need to before installing a new system.

If this doesn’t take forever, maybe I’ll get to finally write my next review so I can move on to my next book. I haven’t read a comic in a week!

Want to stay up to date? Click here to subscribe to updates by RSS!
You can also sign up to get updates by Email!
By | Saturday, June 19, 2010 | 1:41 am | 1 Comment | Blog > Database Updates

I fixed the caching issue that Daniel and I were talking about on the forum so now you should be able to see your response right after you’ve posted it, instead of having to wait for the system to work through the old cache file and start serving a new one.

I also made the “you must be logged in to post” text bigger and made it double as a link to the login page. The inline login on the forum just isn’t working for some reason, unfortunately. I’ll try to get that going in the future.

Also, I added a header image (from the cover of a More Fun Comics issue) to the Comics listing. Which isn’t sorted at all, by the way.

Want to stay up to date? Click here to subscribe to updates by RSS!
You can also sign up to get updates by Email!