I noticed that the dates on blog posts were off by a day, since the default timezone on a Wordpress install is about a day behind Fiji Time. So I reset the timezone to UTC +12. Unfortunately that doesn’t change the creation date of old posts.

So for that:

update wp_posts set post_date = post_date_gmt + INTERVAL 12 HOUR, post_modified = post_modified_gmt + INTERVAL 12 HOUR

Fortunately the wordpress developers are pretty savvy. They included the GMT dates which can be used as an absolute on which to get the timezone relative dates as above. Way to go wordpress.

In reality, all dates are relative, so the above would depend on the timezone setting of your database, and hopefully it is set correctly. It is most likely correct however. It may also be depended on the PHP timezone, if PHP is used to calculate the GMT times - I haven’t looked at the actual SQL inserts in wordpress so it could be either or.

I didn’t even realize it was Fiji Day, I didn’t know it was a pulic holiday for that matter.

Fiji Day isn’t a huge affair in Fiji like it is in the US. You’d know it was Fiji day if you were a Fijian in the US. Biggest get together of the year. Fijians flying around the country to get to a Fiji Day Celebration. There are so many different celebrations going on now though you don’t know which one to go to. Kind of dilutes the whole notion of Fiji Day, would be nice if every Fijian were able to meet in one location.

Good thing we didn’t go out last night. Had a cold an that would have been worse if mixed with Fiji Bitter.

Wow, it has been 2 weeks since I last updated this blog - baahm - there you go, updated!

A second post :D.. Maybe I should get my old blog back up lol..

Spent the day grocery shopping with Joana and Gabe… the price of food everything is ridiculous… makes my head hurt thinking about what Joana will have to deal with when she gets older… :sigh: I hope the future is brighter..

She is.. amazing.. lol.. I never tire of saying that.. she’s forming her own sentences and opinions about things.. but of course that goes hand in hand with tantrums.. I’m so glad I got her attached to a security blanket (I have 3 of the same kind and I rotate between them) and that has been a huge help.. whenever I sense a huge tantrum coming on.. I give it to her and she calms right down.. you can’t snuggle your blankie, suck your thumb and have a tantrum at the same time lol… if we’re at home I prefer to let her have a good old yell..

So it’s Friday night and I’m at home… hmmm… bored.. hence the post.. Gabe’s been having really bad sinus problems.. the weather on this part of the country isn’t healthy for him.. too much humidity in the air… so I’m going to invest in some hypo-allergenic bedding… of course there is no way in hell I’ll be able to get anything of the sort here in Fiji so I’m getting a relative to get them for me at Targets lol… that’s one thing I miss about being overseas.. it’s so easy to get things like that.. there’s a wider range, better quality at a lower price… Fiji is expensive but it has the things which matter the most to us.. our family.. hehe.. and good ol’ fijian hospitality..

speaking of Fijian hospitality… while Joana was in the trolley at the supermarket.. this huge guy came up and  stood behind us and was talking to her.. Fijians are known to do that.. and as a Fijian I’m supposed to be happy that someone is taking time out to be friendly to my child.. but for some reason I felt like telling him to leave her alone and get lost.. maybe it’s because he was such a huge guy and was towering over her.. i don’t know… i think the norm now is that it’s ok for you to say hi and wave and what not but I don’t think it’s ok at all for someone to touch your child.. he patted her head and she didn’t like it at all and wanted to be carried out of the trolley… maybe I’ve been stuck in my own world for so long I’m losing touch with that Fijian hospitality I’m supposed to have lmao.. something to ponder on Fiji Day.. or Fiji night lol..

well that’s enough from me.. another post when I’m bored.. which should be soon lol..

Vara