bob-ak.com

When I migrated from one host to another last week, I downloaded the latest version of the software (2.5.1) and installed it. This went very smoothly and all my posts from my old blog (was probably version 2.1?) came through.

Earlier today I went to add a new post and realised that the admin page was missing the most important buttons (Write, Manage, Design, Comments) which basically meant I couldn’t do anything!

I spent over an hour googling and looking through WP’s forums but found nothing that would explain this except references to old versions of plugi-ns (which I wasn’t using).

A few posts by WP staff on WP’s forum seemed top point the fault at the user and not the software. The thing is that I didn’t touch my blog since I did a fresh install of WP 2.5.1.

Anyways, I had to intsall the new version (2.6) and it all fell into place.

The only good thing was that I had a back up of my WP blog, otherwise I’d have lost some data here.

Doesn’t look great for WP or maybe it’s one of those things that happens to software (!!).

I hear these guys have very good customer service (from 1938media.com). Reading up on their site, it seems like they offer a lot of very new technologies and for $20/month this could be the one to go for.

To remove a foreign key constraint from a Postgres database, you must copy the table,  delete it,  and then re-create it!

e.g. if you have a table called ‘log’ with a foreign key ‘fk’ – I tried using:

ALTER TABLE log DROP CONSTRAINT fk;

This does work for check constraints but not for foreign key constraints.

It took a while to find this out and reiterated the fact that I don’t like Postgres!

In MySQL you can use:

ALTER TABLE log DROP FOREIGN KEY fk;

So this is what you’d do for Postgres:

CREATE TABLE temp AS SELECT * FROM log;
DROP TABLE log;
CREATE TABLE log AS SELECT * FROM temp;
DROP TABLE temp;

Link from postgressql.com

This is an article about “Iran Awakening”, a book written by Shirin Ebadi published in 2006.

Seldom in the United States do politicians refer to literary works or memoirs when discussing foreign policy. Most politicians, like most Americans, think of literature as entertaining, spiritually edifying, even educational, to be read in the evening after work. But occasionally a book appears that politicians might do well to read during work.

Article written by Betty Jean Craige is a professor of comparative literature at the University of Georgia.

Detailed analysis of UK/UK intelligence agencies’ view of Iran’s nuclear program:

http://www.atimes.com/atimes/Middle_East/JD23Ak03.html

From groovymother.com:

A few months ago, I was in the pub with a couple of geekchums. The topic of job interviews was going round the table, in part because I’d been talking about my goal of getting a job and moving to the Bay Area. Someone mentioned that they’d interviewed at Google, had read Programming Interviews Exposed the night before the interview, and nearly every question they’d been asked was pretty much out of the book.

Not that I’m looking for a new job but I do think I should shape up a little and learn stuff!

1. What people are watching RIGHT NOW on YouTube – link
2. What people are posting on flickr in 3D – link
3. What people are posting on youtube in 3D – link
4. And posts on good old twitter – link (this is the newest one I think)

After a little research, I found the ‘mystery’ track on hypemachine. Fantastic!

His surname is spelled ‘Cavalli’ and it turns out he is a country/blue singer from France – amazing stuff.

Read more about him here. You can listen to his album online here.

I was listening to WFMU when they played a track by Don Cavilli called “New Hollywood Babylon ” which grabbed my attention. I couldn’t track it down anywhere but I did find “Going To A River” by Don Cavalli on YouTube. I’m hoping this is the same Don on WFMU – if not, this is still a great track. Enjoy.