Feed Statistics, Plugins, WordPress

Feed Statistics WordPress Plugin Updated

Note: Feed Statistics has been discontinued and is no longer supported.

I’ve updated the Feed Statistics WordPress Plugin (now at version 1.3.1) to be more compatible with WordPress 2.3 and to fix some bugs from the previous version’s clickthrough tracking.

To install this plugin:

Standard

8 comments on “Feed Statistics WordPress Plugin Updated

  1. I just installed this on WP 2.1.3 and got the following error when activating the plugin:

    WordPress database error: [Specified key was too long; max key length is 1000 bytes]
    CREATE TABLE IF NOT EXISTS cfe_feed_subscribers ( subscribers INT(11) NOT NULL DEFAULT 0, identifier VARCHAR(200) NOT NULL DEFAULT ”, feed VARCHAR( 200 ) NOT NULL, date datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, user_agent VARCHAR(255) NOT NULL DEFAULT ”, PRIMARY KEY (identifier, feed) )

    Any thoughts?

  2. augenbar says:

    we used it for about a month, bit the plugin has a problem… while it offers nice features, the way to measure clickthroughs is by generating hashes and appending them to domain.tld/feed-statistics.php?hash. This almost inevitably makes you lose privacy-sensitive subscribers. what the plugin needs is a comparison with external solutions (e.g. awstats) or a more explicit hint that some functions may be privacy-sensitive.

    @jesse harris, seems your database user does not have the permissions to actually create the database table the plugin needs and attempts to create, but fails to find. check you permissions or ask your hoster.

  3. Actually, it looks like a MySQL bug that’s a solid two years old. Despite the two primary key columns being a total of 400 bytes, UTF-8 uses extra bytes and consumes 1200, well over the 1000-byte limit imposed by MySQL. The solution is to either remove one of the primary keys or make the columns no more than a combined 333 characters. I just don’t know what they would break.

  4. Hello, there are two problems with this plugin activated (1.3.1, WP 2.3.1):
    1) My RSS feed is not updated in Google Reader (I am not sure if this plugin is somehow changing my RSS?).
    2) My RSS of comments shows following error:
    WordPress database error: [Duplicate entry ‘85.160.207.149’ for key 1]
    INSERT INTO wp_feed_subscribers SET subscribers=1, identifier=’85.160.207.149′, user_agent=’Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)’, feed=’/comments/feed/’, date=NOW()

    Warning: Cannot modify header information – headers already sent by (output started at /var/www/web5/separatista.net/separatista.net/wp-includes/wp-db.php:160) in /var/www/web5/separatista.net/separatista.net/wp-includes/feed-rss2-comments.php on line 2

    After deatcivating this plugin all works well…
    Thank you for your help…

Leave a Reply

Your email address will not be published. Required fields are marked *