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)

Archive for the 'Work' Category
29
Mar
Web Discussion and Work.  | 

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 stuff talk 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
27
Nov
Web Discussion and Work.  | 

(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

28
Aug
Work and Graphic Design.  | 

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:

llyc1.jpg

chowder-card.jpg

mu_logos.jpg

bookstore.jpg

cfl.jpg

pks_middle.jpg

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

23
Jul

animas.jpg

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:

animas2.jpg

10
Jul
Work and Graphic Design.  | 

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.

forthekids.jpg