WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ros_wp.ros_wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM ros_wp_posts WHERE post_date < '2020-10-30 11:02:13' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

October 21, 2008

Filed under: Uncategorized — ros @ 2:20 pm

That has got to be the understatement of the year and, to be honest, it is not so much technical problems but extreme technical incompetence. Apparantly it takes over two months for BT to set up Option 1 broadband. This morning, after spending two hours on the phone to their technical support ‘gurus’, I was told that actually no one had a clue what was going on with my internet and I would be offline until at least November the 4th.

Somewhere in India, there are two helpdesk people, sitting, shaking, and possibly crying underneath their desks. I have given up my policy of not blogging from my workplace and have come into school to write a post even though it is half term.

Other than lack of technology and blogging equipment (I also had no desktop, no photo software and my camera card reader got lost somewhere in my move) things are pretty sweet in West London. I found a flat which is essentially a large kitchen with attached sleeping area. It has an ancient rickety gas cooker, which has already caused me several burns, but, hey, at least it’s gas! The freezer is on the barely existing side, but to make up for it I have a big pink sofa. Yay! 

Now that I’m back, I’m quite convinced that my irritation at living on the Islington-Hackney border was not just a case of the grass being greener. I am so happy to be back in Hammersmith. My flat is within 10 minutes walk of at least eight nice but affordable restaurants and at least two nice but more expensive restaurants. Roll on payday! A five minute detour on my way home from work takes me to what must be the best butcher in London. The supermarkets are decent. True, a floor assistant responded to my request for black pudding by taking me to the chilled dessert section,  but I found brawn in the bargain bin! ! Woohoo! I also have a supply of interesting ingredients from Shepherds Bush market and a load of expensive but bizarre things to gawp at in Wholefoods.

The new job seems very promising too….. but more on that later.

I’ve been spoiling myself this month, eating and drinking far too much. This has had the effect that I am skint, yet again, until I get paid on Friday. To avoid this happening next month, I am using the fact I can’t visit my butcher on Sundays to force myself to eat more vegetarian food. Last Sunday I didn’t need much convincing. After a heavy weekend I go off the idea of meat and start craving grains and other healthy foods. I used the opportunity to make myself a few portions of a nourishing meal that would freeze well, just in case work gets more demanding as we head towards mid winter.

4 Bean Chilli

four bean chilli

  • 1 can each ready to use kidney beans, pinto beans, black beans, chickpeas
  • 2 x 400g tins chopped tomatoes (or 800g fresh, peeled and chopped)
  • 2 medium/small onions onions, minced
  • 6 small cloves garlic, minced
  • vegetable oil to fry 
  • cayenne peper- 2-3 teaspoons
  • paprika- 2-3 teaspoons
  • 3 teaspoons dried oregano 
  • frehly ground cumin- about a teaspoon
  • freshly ground coriander seed- a teaspoon
  • a small bunch of coriander 
  • 3 red peppers, cored, deseeded, chopped into small pieces
  • beef stock- around 500ml
  • a good shake of tabasco (optional)
  • Tortillas to serve with soured cream and grated manchego (or mild cheddar) cheese and possibly a nice green salad.
  1. Put the onion and garlic in a large saucepan and fry gently in the olive oil.
  2. Chop the coriander stem finely- about a handful would be good- throw this into the pan with the spices.
  3. When the onion is soft, add the red pepper and allow to sweat, pan covered, for a couple of minutes.
  4. Stir in the beans and tomatoes. Add the tomato puree and stock and stir well
  5. Let the mixture simmer, covered, for half an hour, stirring occasionally.
  6. Uncover, take off the lid and allow to bubble down to a thick sauce consistency..
  7. Taste, adjust spicing if you like and if you’re that way inclined, add a shake of tabasco.
  8. Just before serving, stir in a couple of handfuls of chopped coriander leaf.
  9. Serve on flour tortillas with a big dollop of sour cream, grated machego cheese, some more chopped coriander to garnish and a simply dressed green salad.


I have missed blogging a lot. Now I’ve started my new job, I should have time to write a couple of times a week so hopefully, as soon as I have a net connection I’ll be back for good and I may even be able to let you see what the kids here have been cooking in our after school club. Wish me luck! 


  1. Oh dear. It’s really not going to make you feel any better to learn that my BT broadband was ready and switched on the day I moved into my Yorkshire village, is it? Of course you get much more bandwidth, but then if you don’t actually receive it…

    Comment by Mike (Trig's dad) — October 21, 2008 @ 4:23 pm

  2. Glad you are back Ros - I love reading your blog and am off to add the 4 bean chilli to next weeks dinner list!

    Comment by Jodsgirl — October 22, 2008 @ 4:34 pm

  3. YAY! Ros blogging again woo!

    No mice in this flat right?

    Comment by Lauren — October 22, 2008 @ 6:15 pm

  4. Sounds like you’re having a nightmare, hope you get it sorted soon.

    I’d be interested to hear about the restaurants you like in Hammersmith, I work there and am always on the hunt for new places.

    Comment by Ginger — October 23, 2008 @ 10:36 am

  5. I did wonder what had happened to you! Don’t even get me started on BT. if you search on the internet, you may find posts by me on every forum possibel slating them and their shoddy outfit, among the comments of millions of others. Mine took over two months as well. When I tried to cancel, I was on the phone for 5 hours with the receiver resting on my shoulder and I eventually had to give up as I wanted to go home. They are very quick to answer when you want to sign up, but then you are stuffed after that. They messed up my cancellation so I not only couldn’t have the internet with them, but I coulsn’t get it with anyone else either. Annoyed, moi?!

    On a more positive note, I’m glad to see you back and to ehar your news about the living and job arrangements. Also good to see you are eating well!

    Comment by Helen — October 23, 2008 @ 2:12 pm

  6. Mike, I’m jealous! It’s frustrating to have lots of nice stuff to write about but not have access to the blog but hopefully I’ll be making up for it soon.

    Jodsgirl, I hope you enjoy the chilli. It was a good ready meal to have after staying late at work.

    Lauren, I’m afraid there were mice :( . I think I’ve got rid of them now but there’s obviously loads living in the the building in general as a new one appears every time I make cheese on toast. They aren’t clever mice- I catch them quickly.

    Ginger, I’ll e-mail you about Hammersmith restaurants. There’s plenty to recommend, especilly if you’re able to go up towards the Goldhawk road and/or Chiswick.

    Helen, it’s comforting to know I’m not the only one! We’ll see what happens in a couple of weeks.

    Comment by ros — October 31, 2008 @ 5:39 pm

  7. Oh dear! I hate tecchie problems more than anything. Astonishingly, we’ve been with BT both as dial-up and later as broadband customers for years and have never had a single problem. Of course, now having said that I’ve jinxed it and it will all go pear-shaped! Love the 4-bean chilli - I think I might try a version of it tonight.

    Comment by Jeanne — November 20, 2008 @ 1:04 pm

RSS feed for comments on this post. TrackBack URI

Leave a comment

In the aid of defeating SPAM Comments, please follow these instructions: