Subscribe: Comments on: Feed Statistics Wordpress Plugin Updated
http://www.chrisfinke.com/2007/10/13/feed-statistics-wordpress-plugin-updated/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
database error  database  error  feed  harris  jesse harris  jesse  key  net  null  plugin  separatista net  separatista  subscribers  varchar null 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Comments on: Feed Statistics Wordpress Plugin Updated

Comments on: Feed Statistics WordPress Plugin Updated



Christopher Finke writes about things he has done.



Last Build Date: Fri, 24 Nov 2017 09:16:36 +0000

 



By: statistically speaking

Thu, 25 Sep 2008 19:23:07 +0000

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



By: Joel Wideman

Tue, 04 Dec 2007 20:46:22 +0000

I'm having the same problem as Jesse Harris.



By: Separatista

Tue, 27 Nov 2007 09:03:26 +0000

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...



By: Guilherme

Sun, 25 Nov 2007 15:19:28 +0000

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



By: Ray Marotta

Thu, 18 Oct 2007 07:50:33 +0000

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....



By: Jesse Harris

Wed, 17 Oct 2007 22:03:21 +0000

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.



By: augenbar

Tue, 16 Oct 2007 20:40:39 +0000

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.



By: Jesse Harris

Tue, 16 Oct 2007 16:01:42 +0000

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?