Alright, let’s have a little fun… I just added a new blog and went to include it on the main page, but my code failed citing the database throwing errors. It took me forever to find. I’m curious if others can find it.<\/p>\n
I was further confused because the code worked fine until I added the new blog to the list of ones for it to use, and it was specifically built so that it wouldn’t matter how many blogs there were. It has a separate file that just lists blogs to include, and reads that file at runtime and builds a query to retrieve posts from all of them.<\/p>\n
You need some background, first… All the posts are stored in a database, so each has its own table. I built this monster query, basically looking something like (Get most recent posts from blog 1) UNION (Get more recent posts from blog 2) UNION (…3…), and then tack an “ORDER BY…” onto the end. Credit for this idea goes to Andrew; I’d have never thought of it myself.<\/p>\n
What the list includes is blog IDs in the database. They ranged from 2 to 9, skipping 8 (which isn’t used). After a bout of spam registrations, the numbers got run up, so when I included the new one, it was numbered 51.<\/p>\n
The below code (in PHP) calls some custom-rolled functions, but I’ll just say up front that the error does not depend on understanding how they work. Similarly, the answer does not have to do with caching in any way, so don’t get too hung up on the amount of code devoted to working with the cache. (And finally, I’m building one huge variable called $query the whole time, and then return that variable… This isn’t a crucial thing to understand either, I just wanted to explain it since it’s somewhat of a bizarre practice. .= is the PHP variable concatenation method.)<\/p>\n
\n\n\/\/ $count is the number of blogs to pull out\nfunction genRPQuery($count) {\n \/\/ Retrieve it from Memcache\n $query = getCachedObject(\"bigquery-$count\");\n \/\/ It'll return NULL if it doesn't exist, so we check for that...\n if($query) return $query;\n\n \/\/ Since we're here, we didn't return, and\n \/\/ thus didn't get it out of the cache\n\n \/\/ Next two lines read in the files. blogList()\n \/\/ returns a list of the blogs -- it's little more than a\n \/\/ file read with caching enabled.\n $blogs = explode(',', rtrim(blogList(),\"n\"));\n $fields = rtrim(cachedFile('.\/fields.inc',30), \"n\");\n\n foreach ($blogs as $i) {\n \/\/ We have a loop for each blog\n \/\/ For unfamiliar eyes, .= is PHP's means of variable concatenation\n \/\/ We're building a ridiculously-long query, each one a SELECT, encased in\n \/\/ parens, and we UNION them all together...\n $query .= \"(SELECT $fields FROM wp_\" . $i . \"_posts WHERE post_status='publish' AND post_type='post' AND post_password='' ORDER BY post_date DESC LIMIT $count)n\";\n \/\/ If we're not on the last one, insert a \"UNION\" in (see above)\n if($i\n<\/blockquote>\nRemember, it worked fine when the list was blogs number \"2,3,4,5,6,7,9\" but the simple change to \"2,3,4,5,6,7,9,51\" causes it to blow up and try run a query with invalid syntax. This made no sense to me, since the code was built to not care about things like that. I eventually found it, and feel like an idiot.<\/p>\n
I've posted a hint in the comments... It's in the interest of fairness because I turned on some debugging and got the information I share. But it also really narrows your attention to a couple of lines, so I don't want to include it in the main post.<\/p>","protected":false},"excerpt":{"rendered":"
Alright, let’s have a little fun… I just added a new blog and went to include it on the main page, but my code failed citing the database throwing errors. It took me forever to find. I’m curious if others … Continue reading