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 (52,51,50,49,48,47,46,45) GROUP BY ID

2005 November | TicTap Blog

Archive for November, 2005

Amazon Adsense?

Friday, November 18th, 2005

Update - 22 April 2006

We just launched the TicTap web search engine that incorporates this contextual ads technology for Amazon products.

Read the blog post announcing this.
——————————————————————

Does anyone know if it has been tried?

I’ve looked through the ECS documentation, and it has nothing that looks remotely like it.

Posted in General (talk) |

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

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

No Comments »

Yahoo Mail Slowdown - Possible Fix

Wednesday, November 16th, 2005

Yahoo Mail’s been very slow for me the last 2 days.

To make it worse, I kept getting an IE dialog box that says the current security settings doesn’t allow an ActiveX control to be installed.

It turns out that IE was trying to download the ocget.dll control whenever I am at Yahoo Mail.

The Microsoft KB […]

Posted in General (talk) |

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

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

No Comments »

Amazon Sales Rank History and Trend

Friday, November 11th, 2005

We received a suggestion today to improve our Amazon Sales Rank History feature.

The gentleman by the name of Barry suggested that we include some kind of trend feature to complement the history. This will make it easier to see how well (or badly) a product is selling at a glance.

We thought it was a great […]

Posted in General (talk) |

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

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

No Comments »

Adding TicTap To A9.com’s OpenSearch

Thursday, November 10th, 2005

It’s been more than a week since we released TicTap search results in the OpenSearch format.

One question we’ve been asked is how one goes about adding the TicTap column to A9.com?

Once you’re in A9.com, click on the drop-down list with the words “More Choices…”, and scroll down all the way to “Add/Remove”. […]

Posted in General (talk) |

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

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

No Comments »

PHP Session Problems - Solved!

Thursday, November 10th, 2005

At least, we hope so ;)

We were informed that search histories and watch list items have been disappearing. We were aware of it too, as our own histories and lists have mysteriously disappeared as well.

It turns out that we had misunderstood the session_set_cookie_params ( int lifetime ..) PHP function.

Apparently, the cookie expiry date is […]

Posted in General (talk) |

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

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

No Comments »

What are Microsofties Buying?

Friday, November 4th, 2005

I’ve always wondered. And I’ve also wondered what people from Stanford University and General Electric are buying.

Now we know . Using data from Amazon.com, you can find products that are popular at many locations in the US and around the world.

Try these places.

Microsoft
Stanford University
General Electric
Australia
New York
Singapore
Palo Alto, CA

Posted in General (talk) |

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

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

No Comments »

Safari Problems with TicTap?

Friday, November 4th, 2005

Our access logs tell us that 6% of visitors use the Safari browser.

Problem is, neither Damon nor I have access to one.

So if any Safari user has problems with TicTap, please let us know.

Specifically, if you are using version 1.2 and greater, try out the email and watchlist features. They make use of AJAX […]

Posted in General (talk) |

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

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

No Comments »

Organize Your Products With A Watchlist

Tuesday, November 1st, 2005

An often requested feature with many users is a way to keep track of items they like.

Although TicTap allows users to track their product searches using email and RSS, some prefer to store them in a separate list.

Today, we launched My Watchlist. Simply click on the ‘Add to watchlist’ link and they’ll be added […]

Posted in General (talk) |

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

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

No Comments »