WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY year(post_date), month(post_date), dayofmonth(post_date)' at line 1]
SELECT DISTINCT post_date FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_categories ON (wp_post2cat.category_id = wp_categories.cat_ID) WHERE 1=1 AND category_id IN (19) AND (post_type = 'post' AND (post_status = 'publish')) AND ID NOT IN (165,157,166,172,174,190,204,202,212,214) GROUP BY wp_posts.ID GROUP BY year(post_date), month(post_date), dayofmonth(post_date)
I had to write these for a six-month review at work, but figured I might as well put’em out there so I’ll feel guiltier when I don’t achieve have something to aspire to.
(Note: The use of the strike tag is not supported in XHTML 1.0 Strict DTD.)
- Begin projects as soon as I get them, which gives me more time to improve and consider my decisions.
- Creating personal process templates that include questions to ask clients, high-level factors to consider, and simple things like final double-checks of buildout in all browsers. I’m not sure how helpful this would be to team members, but I hope some of them (maybe a guide for logo process) could be some help.
- Go to at least two social design/web events, act like a normal person.
- Blog more, and engage in longer discussions on other blogs.
- Become more proficient in jQuery, and break through the point that gives me larger access to programming in general.
- More blogging, and working with the design team to come up with more inspiring or professional development activities.
Outside of work, I suppose I’ve added these (public) ones to the list:
- Relearn Katakana at some point
- Be better husband
- Stop accepting freelance work
- Stop feeling responsible for other peoples’ problems (ie: “I really need this site done and my designer bailed on me, Doug”)
- Maybe take photographs again, since I haven’t touched my camera since October
- Find some kind of group of people outside of work that I can
use to get free stufftalk to on a regular basis - Blog more “professionally.” Use titles like “The Wet Floor Effect: Still Awesome?” instead of “Things I Have Found Under My Couch.”
- Don’t swear on Twitter
(11:41:01 AM) Doug Avery: I think the tunnel’s down again? i haven’t updated any local files, but i’m getting the “did not respond” error from the facebook server.
(11:42:05 AM) Mele Avery: was that for kyle?
(11:42:10 AM) Doug Avery: NO
(11:42:13 AM) Doug Avery: FIX MY TUNNEL
As the summer comes to an end (don’t disagree: see previous post), I feel like reposting a little design work from this month. Some have links, some don’t:



And finally: A small and early preview of the blog redesign.

A few weeks ago, I got to work with Cartoon Network to design a page and some ads for their August 1 TV event, ‘Animas!’ It was great talking with the team over there, and getting to use some of the character art and logo work they’d done. (It was also great to get to pull out my loudest colors and craziest fonts).
My favorite ad from the bunch is currently appearing on their homepage every few times you visit:

I’ve been designing a lot of sites lately (I think it’s like 1.25 per week), but this is one I had particular fun with: A youth site with a superwide, bizarre homepage. I’ve turned it on its ear for your viewing enjoyment.







Recent Comments