Feed Statistics WordPress Plugin Updated

Comments

8 responses to “Feed Statistics WordPress Plugin Updated”

1. 

   Jesse Harris

   October 16, 2007

   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?

   Reply
2. 

   augenbar

   October 16, 2007

   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.

   Reply
3. 

   Jesse Harris

   October 17, 2007

   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.

   Reply
4. 

   Ray Marotta

   October 18, 2007

   Help!

   Need the bit of php code to add to my sidebar to make the feed stats display…..it;’s not listed in the readme or on the site pgae….

   thanks….

   Reply
5. 

   Guilherme

   November 25, 2007

   Hello!
   How can I do to appear my feed count in my theme?
   Thanks!

   Reply
6. 

   Separatista

   November 27, 2007

   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…

   Reply
7. 

   Joel Wideman

   December 4, 2007

   I’m having the same problem as Jesse Harris.

   Reply
8. 

   statistically speaking

   September 25, 2008

   Thanks, now I get new version!! Feed Stat!

   Reply