WordPress database error: [Incorrect file format 'wp_comments']
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (21,20,19,18) GROUP BY ID

2005 July | TicTap Blog

Archive for July, 2005

TicTap Widget is SMS-Enabled

Saturday, July 30th, 2005

A couple of bugs were fixed.

The latest version allows you to send a product’s information to your handphone using SMS.

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 21 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '21' AND comment_approved = '1'

No Comments »

TicTap Widget for Konfabulator

Wednesday, July 27th, 2005

Every once in a while, we come across a tool that is reeeally cool.

Yesterday, I came across Konfabulator .

Konfabulator is an incredible product that allows us to build nifty widgets that sits on your desktop. The price is just an incredible - zero. That’s right, Konfabulator was recently bought over by Yahoo!, and they […]

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 20 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '20' AND comment_approved = '1'

No Comments »

What Do Others Want?

Tuesday, July 12th, 2005

That’s what I ask when I feel like spoiling myself with a gift.

So a friend kindly suggested to fix this problem by building it right into TicTap. Hmm.. Come to think of it, he asks the same question too.

Anyway, astute observers of TicTap (and I know there’s at least 1 of you!) will notice a […]

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 19 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '19' AND comment_approved = '1'

No Comments »

Odd Google Bar Behaviour on IE

Tuesday, July 12th, 2005

I had a shock this afternoon when clicking on a product link from TicTap did not open a new window to Amazon.com!

It appears that the Google Bar’s popup blocker was blocking it.

After desperately fumbling with the configuration for 5 minutes, I did what 15 yrs of experience using Microsoft products taught me - restart.

That worked. […]

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 18 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '18' AND comment_approved = '1'

No Comments »