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 (98,97,96,95,94,93,92,91,90,89) GROUP BY ID

General (talk) | TicTap Blog

Archive for the 'General (talk)' Category

Improved Amazon Price Alerts

Tuesday, August 22nd, 2006

For a long time now, every product in TicTap has a price alert feature. It allows you to set a price and we’ll email you when it meets your budget. This is a nifty feature that has saved many people money.

But previously, it would only track your budget against the lowest price.

Today, […]

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

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

No Comments »

TCA Intermittent Failures

Sunday, August 20th, 2006

Of late, the external web host of TicTap Contextual Ads has been havng some issues.

We’re disappointed enough to want to move over to a new host. That might take about a week. So we ask for your understanding if we face anymore issues in the mean time.

This has been a lesson for both Damon and […]

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

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

No Comments »

TCA is Alive!

Friday, August 11th, 2006

TicTap Contextual Ads is back up and running again. We hope this problem doesn’t occur again with the web host. They’re actually helpful guys, and accidents happen.

If anyone has problems using TCA, please drop us a note.

Thanks for your patience!

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

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

No Comments »

TCA Server Failure

Thursday, August 10th, 2006

We’ve just been informed by the folks who host tca.tictap.com that they’ve experienced a dramatic hard disk failure.

It will be a while before they restore our files from backup. In the meantime, TicTap Contextual Ads will be inaccessible to new users.

We’re really sorry about this.

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

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

No Comments »

Wireless and Screen Reader Access in TicTap

Friday, July 21st, 2006

Not many people are aware that we have designed TicTap for use in screen readers and wireless devices.

Our stats tells us that most people still visit the main TicTap site. So we’ve included 2 convenient links within each product page that link directly to the wireless and screen reader page.

This should be […]

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

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

No Comments »

We’re Taking Requests for TicTap Contextual Ads 2.0

Wednesday, July 19th, 2006

We’re in the midst of the upgrade to TCA version 1. This is a major rewrite of the code as we try to add in more useful features to spur people to buy from your sites.

Let us know what you want ok?

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

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

No Comments »

International Shipping for Foreign Buyers

Thursday, June 29th, 2006

Previously, it was difficult to know if an Amazon Marketplace seller ships internationally. We just didn’t have that information to tell you at TicTap.

That has changed.

From today, we make clear which sellers ship internationally. If you don’t see the ‘Ships internationally’ phrase for a seller’s description, that means it doesn’t.

Expedited shipping information is […]

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

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

No Comments »

Updated - WordPress Plugin for TicTap Contextual Ads

Wednesday, June 28th, 2006

With version 2.2 of the WordPress Plugin for TicTap Contextual Ads, you can now preview your ads in the Configurations page.

Every time you update your configurations, the plugin will show you the products that will appear in your blog.

It also helps with troubleshooting. If you can see product previews, then you know TCA is […]

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

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

No Comments »

Amazon’s Self-Optimising Links Violates Adsense TOS

Tuesday, June 27th, 2006

Amazon UK has a new beta tool for its Associates called Self-Optimising Links.

According to the site, “Self-Optimising Links feature products chosen automatically based on the content of your site. To create Self-Optimising Links simply modify the template and appearance elements and copy the resulting code on to your site. With Self-Optimising Links, you do not […]

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

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

No Comments »

WordPress Plugin Fix for Plugin Hooks

Sunday, June 18th, 2006

We’ve just release version 2.1 of the WordPress Plugin for TicTap Contextual Ads.

It contains code to check if wp_footer() and wp_head() were declared in the WordPress templates, and alerts you if it cannot find them.

In the previous post, we mentioned this problem of plugin hooks that theme creators leave out.

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

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

No Comments »