Counterize II is a small Statistics-Plugin for WordPress, which saves IP, timestamp, visited URl, referring URl and browserinformation in the database and displays total hits, unique hits and other statistics in WordPress webpages.
Download and Installation
Download: Counterize II
The installation is very easy:
- Unzip the plugin to your plugin path
- Activate the plugin on your WordPress-PlugIn-page
Update from earlier versions
If you are using Counterize I then you can use the automated update:
- Deactivate the plugin on your WordPress-PlugIn-page
- Unzip the plugin to your plugin path
- Activate the plugin on your WordPress-PlugIn-page
Your data will be converted to the new data structure.
History
Counterize was originally developed by Anders Holte Nielsen with excellent statistical functions. I took the project with version 2 and built a completely new datastructure which saves a lot of db-space. This gave me also the ability to develop new features in the future.
Features
- After you have installed Counterize II you will see a small overview on your dashboard:
- You will see advanced statistics under Manage/Counterize:
New Features in Counterize II
- Counterize II has a new data-structure which saves a lot of space
- Counterize II has new analyses:
- Counterize graphs, visits based on day of actual month
- Counterize graphs, visits based on day of week
- It is possible to set filters on IP’s, useragents and referers
- You can see the location of tracked IP’s via Geo IP Tool and Google Maps on a map:
- Counterize II logs statistics over search engine keywords (e.g. from Google, Live.com, MSN, Yahoo, Lycos, …):
- You can put a complete statistics page on one of your blog posts. Just write
<!-- counterize_stats -->into the source code. Visit my stats page to see Counterize II in action.
Blog
New releases will be published in the Counterize RSS-Feed.
[...] Counterize II (http://www.navision-blog.de/counterize/counterize-ii-english) Simple counter-plugin – saves IP, timestamp, visited URl, referring URl and browserinformation in database, and can display total hits, unique hits and other statistics in WordPress webpages. Admin-interface available with detailed information. [...]
Pingback by MakeLogic » Blog Archive » post test — Thursday, 7. December 2006 um 10:23 Uhr
I’m trying to install this on my website but something is barfing. When I activate the plugin I get a lot of mysql errors saying these and those tables can’t be found. When I check the database I can see that only three tables have been created: wp_counterize_pages, referers and useragents. When I open the counterize page I get errors all over the place because wp_counterize can’t be found. Same problem when I try to view the website.
Is this some kind of bug or am I just missing something important? I use the newest versions of both WP and Counterize.
Best regards,
Olle Mattsson
Comment by Olle Mattsson — Friday, 8. December 2006 um 13:23 Uhr
Hi,
try to create the table manually:
CREATE TABLE `wp_Counterize` (
`id` int(11) NOT NULL auto_increment,
`IP` varchar(16) NOT NULL default ‘unknown’,
`timestamp` datetime NOT NULL default ’0000-00-00 00:00:00′,
`pageID` int(11) NOT NULL,
`refererID` int(11) NOT NULL,
`agentID` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
Comment by Steffen Forkmann — Friday, 8. December 2006 um 13:28 Uhr
I’m adding the first error:
WordPress database error: [Invalid default value for 'timestamp']
create table wp_Counterize ( id integer not null auto_increment, IP varchar(16) not null default ‘unknown’, timestamp datetime not null default ‘now()’, url varchar(255) not null default ‘unknown’, referer varchar(255) not null default ‘unknown’, useragent text, primary key(id) )
The Invalid default value for ‘timestamp’ seems odd. After this the error messages are basicly the same: wp_counterize does not exist.
Comment by Olle Mattsson — Friday, 8. December 2006 um 13:31 Uhr
OK,
try both:
CREATE TABLE `wp_Counterize` (
`id` int(11) NOT NULL auto_increment,
`IP` varchar(16) NOT NULL default ‘unknown’,
`timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
`pageID` int(11) NOT NULL,
`refererID` int(11) NOT NULL,
`agentID` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
or
CREATE TABLE `wp_Counterize` (
`id` int(11) NOT NULL auto_increment,
`IP` varchar(16) NOT NULL default ‘unknown’,
timestamp datetime not null default ‘now()’,
`pageID` int(11) NOT NULL,
`refererID` int(11) NOT NULL,
`agentID` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
Please tell me if one of these statements work and what version of mysql you use.
Comment by Steffen Forkmann — Friday, 8. December 2006 um 13:37 Uhr
It worked once I tried:
CREATE TABLE `wp_Counterize` (
`id` int(11) NOT NULL auto_increment,
`IP` varchar(16) NOT NULL,
`timestamp` datetime NOT NULL,
`pageID` int(11) NOT NULL,
`refererID` int(11) NOT NULL,
`agentID` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
I don’t know why mysql wouldn’t let me add a default to ip or timestamp…
Comment by Olle Mattsson — Friday, 8. December 2006 um 13:41 Uhr
Thanks Olle,
i will take your statement for version 2.04
Comment by Steffen Forkmann — Friday, 8. December 2006 um 13:48 Uhr
Great
Everything seems to be working now. Thank you for this very neat plugin!
Comment by Olle Mattsson — Friday, 8. December 2006 um 13:49 Uhr
Great. Feel free to recommend it
Comment by Steffen Forkmann — Friday, 8. December 2006 um 14:30 Uhr
For a brand new install, your plugin is not checking for divide by zero on a few lines given there is no data yet.
Lines generating warnings: 241, 299, and 407.
Comment by Mike — Saturday, 9. December 2006 um 15:37 Uhr
Thank you Mike,
this will be fixed in one of the next releases. Workaround: Make one click on your site
Comment by Steffen Forkmann — Sunday, 10. December 2006 um 9:58 Uhr
[...] Keep up the good work, Steffen! [...]
Pingback by Raskas’ blog » counterize and other wordpress plugins — Sunday, 10. December 2006 um 11:33 Uhr
You’ll want to tell people who upgrade (like me) to delete the old Counterize files in your plugins folder, and add the entire Counterize II folder. There was some confusion for me at first.
Comment by MacStansbury — Monday, 11. December 2006 um 16:10 Uhr
Sorry,
i posted this in my update blog-entry – but not on this page.
Comment by Steffen Forkmann — Monday, 11. December 2006 um 16:52 Uhr
2.0.4 has a bug in it where on line 1132 you are trying to insert keywordID into the wp_Counterize_Pages table, but keywordID doesn’t exist as a field.
Your install code needs to add the following code:
ALTER TABLE wp_Counterize_Pages ADD `keywordID` INT( 11 ) NOT NULL ;
mike
Comment by Mike — Tuesday, 12. December 2006 um 13:41 Uhr
Hi Mike,
thank you. You’re right the line 1132 had an problem. I fixed this. Just download again – but don’t add a keywordID field in the Counterize_Pages-Table – this is not the right place.
Steffen
Comment by Steffen Forkmann — Tuesday, 12. December 2006 um 14:18 Uhr
Hello fellow,
I try to install Counterize II in my wp blog but when I activate it from the plugin section in my admin panel none of the tables that are supposed to be created exist.
Could you post the sql code so I can create them manually?
Thanks in advance and by the way
Great Job!
Comment by krap — Tuesday, 12. December 2006 um 15:20 Uhr
Hi,
you can use the SQL-Script for Counterize II 2.04 and add the tables and fields you need.
Comment by Steffen Forkmann — Tuesday, 12. December 2006 um 15:37 Uhr
Thank you!
I face know this problem. Can you be of any help?
WordPress database error: [Unknown column 'refererID' in 'field list']
Sorry for bothering you again!
Comment by krap — Tuesday, 12. December 2006 um 15:55 Uhr
Hi,
sorry – what is your concrete problem? Can you please explain with some words?
Comment by Steffen Forkmann — Tuesday, 12. December 2006 um 16:08 Uhr
Yeah my mistake, I’m sorry.
When the blog tries to insert something into wp_Counterize_Pages table it produces a warning because it can’t find the refererID column.
I believe I must create this column in order to have the plugin work properly!
Comment by krap — Tuesday, 12. December 2006 um 16:14 Uhr
You’re right. This is not my day. I fixed the error. Please download again and tell me if it works.
Comment by Steffen Forkmann — Tuesday, 12. December 2006 um 16:25 Uhr
Seems to be ok now…
Thank you for your time…
You are an excellent coder!
Comment by krap — Tuesday, 12. December 2006 um 16:35 Uhr
Xmm!
Another problem…
When I go to read a comment in the post I get this warning:
Warning: sprintf() [function.sprintf]: Too few arguments in /…/plugins/counterize/counterize.php on line 1129
Any ideas?
Comment by krap — Tuesday, 12. December 2006 um 16:41 Uhr
and download again
Comment by Steffen Forkmann — Tuesday, 12. December 2006 um 16:47 Uhr
Seems ok now.
I hope I won’t need to bother you again…
By the way do you mind deleting my previous comment. I don’t feel very nice to give the exact path publicaly!
Tnx again for everything!
Keep the good work!
Wishes!
Comment by krap — Tuesday, 12. December 2006 um 16:55 Uhr
Thanks for the nice plugin
Is there also an (numeric) counter
to show in the side bar ?
Thanks !
Comment by Daniel — Wednesday, 13. December 2006 um 11:59 Uhr
Hi Daniel,
of cause: echo counterize_getamount();
I will post an english version of the german functions-page today.
Comment by Steffen Forkmann — Wednesday, 13. December 2006 um 12:04 Uhr
Thanks Steffen !
Comment by Daniel — Thursday, 14. December 2006 um 14:19 Uhr
[...] Counterize: Contador de visitas, por referrer, dirección IP y un montón de elementos más. [...]
Pingback by ioeweb 0.4 » Blog Archive » Wordpress como CMS — Saturday, 16. December 2006 um 16:34 Uhr
[...] Yesterday I tried ShortStats Plugin, but it doesn’t work with WordPress 2.0.5. Today I’ve installed Counterize II. It works! [...]
Pingback by Scribe’s Writing Desk » Blog Archive » Blog Stats - 2nd Attempt — Sunday, 17. December 2006 um 9:39 Uhr
I installed the plugin without a problem. Thank you.
Is it possible to stop the plugin adding my visits to the stats page?
Comment by Karen Lee Field — Sunday, 17. December 2006 um 9:45 Uhr
You can exclude your user-account on the settings-page.
Comment by Steffen Forkmann — Sunday, 17. December 2006 um 12:40 Uhr
I didn’t realise there was a settings page. I’ve found it and have made the necessary changes.
Thank you.
Comment by Karen Lee Field — Monday, 18. December 2006 um 9:00 Uhr
Great new version with good improvements. Thank you and keep up the good work !
Merry Christmas
Comment by Ingrid — Tuesday, 19. December 2006 um 11:14 Uhr
Hello and happy holidays
I was wondering if there is a manual way up creating .all. the tables since its not exactly working on my page.. heh.. version MySQL 4.0.12-nt, and unfortunately I’ve checked and none of the tables are made, though I don’t have this problem with counterize I.
thank you
Comment by mo — Thursday, 21. December 2006 um 16:43 Uhr
i installed QII on another site but it doesn’t insert any data in the table …
where is the php file called on ( Header | Footer | ??? ) ?
Comment by Daniel — Friday, 22. December 2006 um 23:42 Uhr
Hello again, I understand from the above posts that with this code
CREATE TABLE `wp_Counterize` (
`id` int(11) NOT NULL auto_increment,
`IP` varchar(16) NOT NULL,
`timestamp` datetime NOT NULL,
`pageID` int(11) NOT NULL,
`refererID` int(11) NOT NULL,
`agentID` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
I can install the first table manually, but there are I think 3 more same level tables to make, could you please give me the manual SQL entry for them.
Thank you.
Comment by mo — Thursday, 28. December 2006 um 15:58 Uhr
Hello,
first of all thank you for your great plugin!
I’m not very familiar with php and databases, so I decided to ask here.
I’m interested in the majority of the info provided by this great plugin (visits, referers, keywords, entries), but I’m not very interested on the IP-related (hits from unique IP), so in order to reduce db growth I was thinking to avoid the recording of the IP details.
Do you think it’s possible to avoid IP recording in your plugin whitout big problems? And with an appreciable gain in db growth?
Thank you in advance for any answer!
Emanuele.
Comment by ema — Saturday, 30. December 2006 um 14:05 Uhr
counterize_getuniquereferers()
I get this error
WordPress database error: [Unknown column 'referer' in 'field list']
SELECT DISTINCT referer FROM wp_Counterize
thanks
Comment by Jilly — Sunday, 31. December 2006 um 8:33 Uhr
best counter so far for wp.
love it
Comment by xclouds — Sunday, 31. December 2006 um 21:54 Uhr
Hi mo,
you can see the tabledescriptions in this txt-File
Comment by Steffen Forkmann — Thursday, 4. January 2007 um 10:35 Uhr
Thanks for updating andersdrengen.dk’s plugin
I got a quick question: Is there a way to make it count how many times a link to a mp3 or jpg on my page has been clicked?
Comment by dubqnp — Sunday, 7. January 2007 um 16:40 Uhr
To day Jan 7th (Sunday) I install Counterize II , it`s very nice plugin ! But I have one problem : in part “Counterize II graphs, visits based on day of week” have name of day Monday(incorrect) right is Sunday . Can you help me correct this ?
Karel
Comment by Karel — Sunday, 7. January 2007 um 23:50 Uhr
Hi Karel,
i will fix this in the next version.
Comment by Steffen Forkmann — Monday, 8. January 2007 um 9:23 Uhr
I’ve just installed this plugin and found a bug: Below “Counterize II graphs, visits based on day of week” there are visits shown for Tuesday, while today is actually Monday (maybe a simple +/- 1 calculation problem).
Comment by Mark — Monday, 8. January 2007 um 12:43 Uhr
Ups, one should read the other comments. My bug was already described in #44. Sorry.
Comment by Mark — Monday, 8. January 2007 um 12:44 Uhr
hi Steffen,
do you have any idea why QII doesn’t work on my site??
it says on 0 visitors. i installed the same as on another website… Thanks !
Comment by Daniel — Monday, 8. January 2007 um 14:10 Uhr
Try to activate it again. Any error messages?
Comment by Steffen Forkmann — Monday, 8. January 2007 um 14:25 Uhr
Update for comments #44 and #46: The problem is the result of MySQL’s DAYOFWEEK function. Sunday is 1, Monday 2, …, Saturday is 7.
I have patched the code so that it gets a reasonable output. Steffen, if you want and if you haven’t fixed the code yourself yet, I can send you my changes.
Comment by Mark — Monday, 8. January 2007 um 16:28 Uhr
hey, i sow this plugin: http://andersdrengen.dk/projects/counterize/
is there a way to show this stats on a page or in the sidebar ?
Comment by bluEyez — Monday, 8. January 2007 um 16:34 Uhr
Hi Mark,
thx – I patched this already but the version is not released.
Hi blueEyez,
see the functions-page: http://www.navision-blog.de/counterize-ii-english/functions/
Comment by Steffen Forkmann — Monday, 8. January 2007 um 16:39 Uhr
Great, great plugin, -one stupid question;
“It is possible to set filters on IP’s, useragents and referers”.
..my guess would be that this “filter”, denies access to all my wordpress pages, from the filterd ip. Is this correct?
Comment by Konggullerod — Monday, 8. January 2007 um 21:26 Uhr
When I activate the absolute latest version of the plugin (2.04.03), my system barfs up SQL errors. See below:
———————————————————-
WordPress database error: [Table 'texpundit.wp_Counterize_UserAgents' doesn't exist]
SELECT count(agentID) from wp_Counterize_UserAgents where name = ‘Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1′
WordPress database error: [Table 'texpundit.wp_Counterize_UserAgents' doesn't exist]
INSERT INTO wp_Counterize_UserAgents (name,count) VALUES (‘Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1′,0)
WordPress database error: [Table 'texpundit.wp_Counterize_UserAgents' doesn't exist]
SELECT agentID from wp_Counterize_UserAgents where name = ‘Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1′
WordPress database error: [Table 'texpundit.wp_Counterize_Pages' doesn't exist]
SELECT count(pageID) from wp_Counterize_Pages where url = ‘/’
WordPress database error: [Table 'texpundit.wp_Counterize_Pages' doesn't exist]
INSERT INTO wp_Counterize_Pages (url,count) VALUES (‘/’,0)
WordPress database error: [Table 'texpundit.wp_Counterize_Pages' doesn't exist]
SELECT pageID from wp_Counterize_Pages where url = ‘/’
WordPress database error: [Table 'texpundit.wp_Counterize_Referers' doesn't exist]
SELECT count(refererID) from wp_Counterize_Referers where name = ‘http://texpundit.com/wp-admin/index.php?page=counterize/counterize.php’
WordPress database error: [Table 'texpundit.wp_Counterize_Keywords' doesn't exist]
SELECT count(keywordID) from wp_Counterize_Keywords where keyword = ”
WordPress database error: [Table 'texpundit.wp_Counterize_Keywords' doesn't exist]
INSERT INTO wp_Counterize_Keywords (keyword,count) VALUES (”,0)
WordPress database error: [Table 'texpundit.wp_Counterize_Keywords' doesn't exist]
SELECT keywordID from wp_Counterize_Keywords where keyword = ”
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]
INSERT INTO wp_Counterize_Referers (name,count,keywordID) VALUES (‘http://texpundit.com/wp-admin/index.php?page=counterize/counterize.php’,0,)
WordPress database error: [Table 'texpundit.wp_Counterize_Referers' doesn't exist]
SELECT refererID from wp_Counterize_Referers where name = ‘http://texpundit.com/wp-admin/index.php?page=counterize/counterize.php’
WordPress database error: [Table 'texpundit.wp_Counterize_Keywords' doesn't exist]
SELECT count(keywordID) from wp_Counterize_Keywords where keyword = ”
WordPress database error: [Table 'texpundit.wp_Counterize_Keywords' doesn't exist]
INSERT INTO wp_Counterize_Keywords (keyword,count) VALUES (”,0)
WordPress database error: [Table 'texpundit.wp_Counterize_Keywords' doesn't exist]
SELECT keywordID from wp_Counterize_Keywords where keyword = ”
WordPress database error: [Table 'texpundit.wp_Counterize' doesn't exist]
INSERT INTO wp_Counterize (IP, timestamp, pageID, refererID, agentID) VALUES (’205.252.38.10′,’2007-01-08 17:07:57′, ”, ”, ”)
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
update wp_Counterize_UserAgents set count = count + 1 where agentID =
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
update wp_Counterize_Pages set count = count + 1 where pageID =
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
update wp_Counterize_Referers set count = count + 1 where refererID =
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
update wp_Counterize_Keywords set count = count + 1 where keywordID =
Comment by Texpundit — Monday, 8. January 2007 um 23:10 Uhr
I’ve used previous versions on my site (http://sojoe.info) and not had a problem. This one has a few problems. When I activate the plugin, it takes me to the 404 page for my site. It still seems to activate, but it doesn’t appear it created the tables correctly. I tried running the manual examples you showed in the comments, but I’m still getting the following for the last 50 entries:
WordPress database error: [Unknown column 'r.keywordID' in 'where clause']
SELECT id, ip, timestamp, p.url as url, r.name as referer, ua.name as useragent, m.refererID, m.agentID, m.pageID, k.keyword FROM wp_Counterize m, wp_Counterize_Pages p, wp_Counterize_UserAgents ua, wp_Counterize_Referers r, wp_Counterize_Keywords k WHERE m.pageID = p.pageID and m.agentID = ua.agentID and m.refererID = r.refererID and id=65569 and k.keywordID = r.keywordID
I’ve temporarily gone back to 2.02 and it seems to work there, but would like to keep up with fixes and features, etc. Help!
Comment by Joe — Tuesday, 9. January 2007 um 3:54 Uhr
Hi!
I just installed Counterize II, but I get this error message (after activation, when clicking Panel -> Counterize II):
Warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, ‘counterize_dashboard’ was given in /usr/home/web/wse99990/www/wp-includes/functions.php on line 1329
What might be the probmen?
Comment by Sebastian Dahlgren — Tuesday, 9. January 2007 um 7:30 Uhr
Hi Konggullerod,
no this filter “(F)” filters only the analysis view for better analyses.
Hi Joe,
you might have to add the field keywordID to your referer-Table.
Hi Sebastian,
what WordPress-Version do you use?
Hi Texpundit,
try to add the tables manually. (SQL-Script)
Comment by Steffen Forkmann — Tuesday, 9. January 2007 um 9:15 Uhr
I’m using 2.0.6.
Comment by Sebastian Dahlgren — Tuesday, 9. January 2007 um 13:52 Uhr
After upgrade, when I try to activate plugin, I get the following code. Also, only options show up but no stats. No clue how to solve this problem.
WordPress database error: [Duplicate column name 'pageID']
ALTER TABLE `wp_Counterize` ADD `pageID` INT( 11 ) NOT NULL;
WordPress database error: [Duplicate column name 'agentID']
ALTER TABLE `wp_Counterize` ADD `agentID` INT( 11 ) NOT NULL;
WordPress database error: [Duplicate column name 'refererID']
ALTER TABLE `wp_Counterize` ADD `refererID` INT( 11 ) NOT NULL;
WordPress database error: [Table 'wp_Counterize_Pages' already exists]
CREATE TABLE `wp_Counterize_Pages` ( `pageID` int(11) NOT NULL auto_increment, `url` varchar(255) NOT NULL, `count` int(11) NOT NULL default '1', `postID` bigint(20) default NULL, PRIMARY KEY (`pageID`), KEY `url` (`url`), KEY `count` (`count`) )
WordPress database error: [Table 'wp_Counterize_Referers' already exists]
CREATE TABLE `wp_Counterize_Referers` ( `refererID` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `count` int(11) NOT NULL default '1', PRIMARY KEY (`refererID`), KEY `name` (`name`), KEY `count` (`count`) )
WordPress database error: [Table 'wp_Counterize_UserAgents' already exists]
CREATE TABLE `wp_Counterize_UserAgents` ( `agentID` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `count` int(11) NOT NULL default '1', PRIMARY KEY (`agentID`), KEY `name` (`name`), KEY `count` (`count`) )
Comment by Fr. Daniel — Tuesday, 9. January 2007 um 19:00 Uhr
Hi,
I installed your plug-in yesterday and it works great with no fuss! Bravo.
Just curious, is there an easy way to put the hit counts on the site page? I’m a beginner to PHP and SQL but would like to see the hit count without logging in.
Lee
Comment by Lee — Tuesday, 9. January 2007 um 23:22 Uhr
Thanks for the scritp. It works very well…
Comment by Wanttogetm — Wednesday, 10. January 2007 um 22:21 Uhr
how to add stats on my blog ? on sidebar ?
Comment by bluEyez — Thursday, 11. January 2007 um 0:47 Uhr
Hi Fr.Daniel.
Your error message means that you already have those tables in your database. Make a backup using a utility such as phpMyAdmin, or MySQL it self. You should backup and delete/rename the tables mentioned in your errorlog.
Good luck!
Comment by Sebastian Dahlgren — Thursday, 11. January 2007 um 7:30 Uhr
I updated to the counterize II from counterize I – no issues, lovely plugin, thank you!
Comment by Elaine — Friday, 12. January 2007 um 18:35 Uhr
Very simple, very easy to install, very good for PHP nitwits. Good tool. I like it.
Comment by Pieter Batenburg — Friday, 12. January 2007 um 19:04 Uhr
Steffen,
I found a bug in the latest 2.04.03 version. I had to reinstall a blog and after taking some hits on it today, it is showing the visits per day of the week on Saturday. Ok..except for today is Friday. The visits by day (12th) and month (Jan) are correct. Day of the week rendering is off by a day.
Mike
Comment by Mike — Friday, 12. January 2007 um 23:01 Uhr
Steffen,
I used your script and manually created the tables and…no more errors! Now I’m just waiting for a few hits so I can see the stats.
Thanks!
Comment by Texpundit — Friday, 12. January 2007 um 23:13 Uhr
Hi Mike,
this is a known bug and will be changed in the next release.
Comment by Steffen Forkmann — Saturday, 13. January 2007 um 9:55 Uhr
Hey Steffen. This looks like a really cool plugin. I tried installing it a minute ago, but ran into the same problem as textpundit above. Apparently creating the tables manually solves the problem. Only thing is that I, being a bit illiterate technically, don’t know how to do that! Can you tell me how? That would be great!
Arni
Comment by Arni — Sunday, 14. January 2007 um 5:17 Uhr
Hi Arni,
you have to edit your database with a tool like mysqlAdmin or something like that (this is mostly provided from your webspace-provider). There you can run the Sql-Script or change the database schema manually.
Comment by Steffen Forkmann — Sunday, 14. January 2007 um 11:55 Uhr
Thanks Steffen! I figured it out now.. Appreciate it!
Comment by Arni — Sunday, 14. January 2007 um 17:12 Uhr
i’m having the same issues as Joe posted earlier. any fix?
other than that, great plugin!
WordPress database error: [Unknown column 'r.keywordID' in 'where clause']
SELECT id, ip, timestamp, p.url as url, r.name as referer, ua.name as useragent, m.refererID, m.agentID, m.pageID, k.keyword FROM wp_Counterize m, wp_Counterize_Pages p, wp_Counterize_UserAgents ua, wp_Counterize_Referers r, wp_Counterize_Keywords k WHERE m.pageID = p.pageID and m.agentID = ua.agentID and m.refererID = r.refererID and id=27409 and k.keywordID = r.keywordID
Comment by mike — Wednesday, 17. January 2007 um 0:05 Uhr
Can you add a feature to the next version to allow an admin to manually set some of the counts (specifically total page count)? I am moving an existing site over and don’t have direct command line SQL access and would like to copy over the page count, please.
Thanks for counterize!
Comment by Brad — Friday, 19. January 2007 um 14:27 Uhr
I managed to get the plugin updated, but now every time I activate another plugin Counterize II tried to initialize and spews out the table already exists errors. Is there an edit I can make to the plugin to stop this?
Comment by Peng — Friday, 19. January 2007 um 23:04 Uhr
I ended up manually creating the wp_Counterize_Keywords table, but now I’m getting the error messages Joe (#55) and Mike (#72) have. I’d go back to 2.02 if I knew where to get my hands on it. In the meantime I’ve gone back to 0.53, which is the latest I had locally. I guess it’s a good thing I’m not trying to run WP 2.1, eh?
Comment by Peng — Sunday, 21. January 2007 um 9:06 Uhr
Ok, I’m a newb, but after installing Counterize 2, my bar graph graphics no long show up. Just the %’s. Obviously, this isn’t vital, but it looks so much better with the graphics.
Any idea?
Comment by tatsuke — Sunday, 21. January 2007 um 18:39 Uhr
wow i just installed. very nifty job. i like it
Comment by Jenny — Sunday, 21. January 2007 um 22:08 Uhr
There’s no data in the database – You can’t see stats until you have data
Does anyone get this error. I had to install the schema manually because the install didnt create the tables.
Im guessing that the install process should insert some records but which ones..i have activated and deactiavted many times to no avail…
Any Help would be appreciated
Comment by troy — Monday, 22. January 2007 um 3:00 Uhr
Excellent plugin!! I have a feature request: How about counting hists to the RSS feeds too?
Thanks again!
-Eric
Comment by Eric — Monday, 22. January 2007 um 5:14 Uhr
more to this..it works on a fresh copy of wordpress but not this particular install. Also..it doesnt display on the dashboard.
I guess i can work with the new wordpress with the working counterize, but i would like to fix the old one, just in case the problem occurs again
Comment by troy — Monday, 22. January 2007 um 6:04 Uhr
Found out what the problem was. My theme did not have the following line of code in it within header.php
Comment by troy — Monday, 22. January 2007 um 12:52 Uhr
Joe (#55) and Mike (#72) and Peng (#75)
I was in the same boat as you guys and noticed that the first error I was getting said that the table wp_Counterize_Keywords didn’t exist. Rather than try to create the table from scratch I checked Counterize.php for a “Create Table” SQL statement. [It’s right after the “if($MinorVersion
Comment by Savage — Wednesday, 24. January 2007 um 6:07 Uhr
(Sorry it seems my previous post cut short)
Joe (#55) and Mike (#72) and Peng (#75)
I was in the same boat as you guys and noticed that the first error I was getting said that the table wp_Counterize_Keywords didn’t exist. Rather than try to create the table from scratch I checked Counterize.php for a “Create Table” SQL statement. [It's right after the "if($MinorVersion" part, which I suspect is broken.]
I copied and tweaked the SQL but I created the table. That was fixed but then I also go that error “Unknown column ‘r.keywordID’ in ‘where clause’”. I checked the table and sure enough the coulmn didn’t exist. Well if you check out the SQL statement right after the above one you’ll see:
ALTER TABLE wp_Counterize_Referers ADD ‘keywordID’ INT( 11 ) NOT NULL
which fixes the already existing table from Counterize I and that solves the funny errors on the Counterize II admin. Sure it’s all blank, but that’s better than errors! Yeah!
Comment by Savage — Wednesday, 24. January 2007 um 6:10 Uhr
Well after some time it seems that my “Latest 50 entries” shows a somewhat sporadic view of visitors. I imagine some entries were filtered out, but it’s hard to tell with all the missing entires. The ids don’t even seem sequential. Is there a way to manage the filter other than going into the database or at least see the ids and times?
Thanks
Comment by Savage — Wednesday, 24. January 2007 um 15:25 Uhr
thanks.
Comment by thesuperstar — Thursday, 25. January 2007 um 6:49 Uhr
good evening dear Steffen ,
great plugin , in WP2.1 is all ready here . I have one idea : one section you can add overview statistic about land connect – is`t possible ?
Again thanks …
Comment by Karel — Friday, 26. January 2007 um 0:34 Uhr
I had trouble activating the plugin(WP 2.1), got an internal server error. Used to run an older version of counterize. In the end I dropped the old counterize tables and re-activated the plugin, then things worked fine. Good job.
Comment by Peter Unold — Saturday, 27. January 2007 um 21:02 Uhr
I like this plugin, but have one big problem with it. All my registered users can view the graphs through their dashboards, as it shows up on its own tab. They can also delete history, etc.
So I was wondering if there was a way to shield this from people who register for the blog and keep it strictly available to admins only?
Comment by Shane Ryan Staley — Sunday, 28. January 2007 um 6:58 Uhr
Hey! Very nice and neat plug-in! Congrats on that..
I have on q.. Is there any possibility to show total hits in blog? I would appreaciate any help with this..
Thanks!
Comment by cloudm — Sunday, 28. January 2007 um 11:27 Uhr
Hi,
I’m upgrading my wordpress powered website from 1.5.2 to 2.1, and also upgrading counterize from the old 0.31 to your newest versio 2.04, however I’m having some problems with the creation of tables for the new version. How can I force the creation of the new MySQL tables (Counterize_Pages, Counterize_Referers, Counterize_UserAgents)???
Comment by IraqiGeek — Sunday, 28. January 2007 um 15:15 Uhr
Hi,
Solved the problem. Found the post on your blog, and the comment about manually deleting “Counterize_MajorVersion” and “Counterize_MinorVersion” from wp_options. After doing that and disabling-enabling the Counterize II, all worked fine.
Thanks for the wonderful plugin
Comment by IraqiGeek — Sunday, 28. January 2007 um 16:21 Uhr
First, thanks for this plugin – I was using ShortStat until I noticed a post by Jim (http://open-dialogue.com/blog/2007/01/10/one-plugin-gained-one-lost/)
Of the WordPress stats plugins I’ve used, your’s is by far the best – both because of display as well as reconfigurability.
Anywho, when we change the amount of history that is displayed, any way the number can show correctly on the expanded statistics page?
So, if I change Amount of lines to show in history-view below, that number should display in the heading of “Latest 50 entries” (in place of ’50′).
A quick link to the configuration page from the stats page would also be rather nice, so I don’t have to flip through all those tabs.
Comment by James Skemp — Sunday, 28. January 2007 um 22:13 Uhr
Counterize has suddenly stopped working on my 2.1 WordPress (no more connection recorded) . I would like to install it again FROM SCRATCH. I have deleted 5 tables (name beginning with wp_counterize) and all the parameters beiginning with wp_counterise in the wp_options table.
I have deleted the counterize folder in plugins directory.
I copy the latest version of counterize II, and activate it : it tells me that tables are missing. How can I force it to recreate them himself to ensure a clean installation ?
I recreated them using the SQL script you mention above. The tables are created but they always remain empty, even if a lot of people are connected.
Did I miss something ?
Thanks for your help ! Your plugin is perfect when it works !
Comment by SuperNo — Monday, 29. January 2007 um 20:30 Uhr
Thanks for picking up this plugin and running with it! Great job!
Comment by John Boyd — Wednesday, 31. January 2007 um 6:52 Uhr
Hello,
I tried to install Counterize II but unfortunately there’s no “Counterize II” item which displays in the “Manage” sub menu, whereas it does in the “Options” sub menu. I uninstalled it many times and re-installed it but it didn’t change anything.
Then I installed the Counerize I version and it works. SO I don’t know what’s the problem! I’m using WordPress 2.1.
Thank you so much for any help, because I’d really wish to use this one-of-a-kind plugin.
Comment by kReEsTaL — Wednesday, 31. January 2007 um 17:42 Uhr
Me again – I realised that the “Counterize II” manage link is to be found next the “Dashboard” link, for some unknown reason. Anyway my problem is solved. Sorry for the 2 posts!
Comment by kReEsTaL — Wednesday, 31. January 2007 um 17:58 Uhr
What a pity – its not downloading.
I’ve been trying for an hour now but no luck. If you’re updating, please let me know when I can try it again.
Thanks.
Comment by Cris — Friday, 2. February 2007 um 14:48 Uhr
Ignore last post – downloaded!
I’m an idiot.
Comment by Cris — Friday, 2. February 2007 um 14:49 Uhr
I’d just like to add that it works absolutely perfectly and is very easy to get displayed in the sidebar to show exactly what you want visitors to see.
You can see how i modded it to my requirements here.
Thank you – i’d been looking for the perfect stat counter and this is the one.
Comment by Cris — Friday, 2. February 2007 um 15:46 Uhr
How can I filter out IP addresses that I don;t want to track?
Comment by mark — Monday, 5. February 2007 um 5:55 Uhr
Two more questions:
1) How well does Counterize II play with wp-cache? Has anyone had any experiences with this?
2) How about the ability to filter out referrer pages that are from your own domain? For sites that link amongst themselves, such as mine, the top 25 referrer pages are my own …
Comment by James Skemp — Wednesday, 7. February 2007 um 14:29 Uhr
greetings.
just installed this great plugin.
echo comment 88 – am curious if you could direct me to how i might restrict access to its panel according to role. no doubt there is a straight forward answer somewhere, but in case you know..
thanks for the great work in any case!
Olaf
Comment by Olaf Bertram-Nothnagel — Friday, 9. February 2007 um 21:32 Uhr
I love this plugin, it worked great from the start and I love the info it gives me. like what was searched for, links to where visitors came from..
But has anyone noticed that it gives you much larger visits than Google Analytics? Google says I had 30 hits today where Counterize says I’ve had 160. That’s a BIG difference.anyone have an explanation?
Comment by Curbob — Wednesday, 14. February 2007 um 0:25 Uhr
It only shows this on my counterize page
Counterize II status
Total hits:
58316
Hits from unique IPs:
And it cuts off there
Any help ???
Comment by Rekzai — Tuesday, 20. February 2007 um 22:17 Uhr
Yesterday I installed counterize. Great plugin. Is it possible to import the data of awstats, I use? Counterize starts with zero, so all the other millions.. eh.. sorry thousands counts are neglected?
Comment by Adrianus V — Wednesday, 21. February 2007 um 15:21 Uhr
nvm i got it
Comment by Rekzai — Thursday, 22. February 2007 um 1:57 Uhr
I installed the plugin, but in the Dashboard I keep getting:
“There’s no data in the database – You can’t see stats until you have data.”
All the tables are created in the db. No errors whatsoever. Any ideas anyone?
Pleas help!
Comment by biv — Friday, 23. February 2007 um 12:31 Uhr
Hi, just surf on your your blog to get data…
Comment by Steffen Forkmann — Friday, 23. February 2007 um 13:18 Uhr
I understand, did that already. I’ve got is setup on an other site and it works fine over there. Used exact the same files but get the ‘no data’ message.
More ideas?
Comment by biv — Friday, 23. February 2007 um 18:00 Uhr
“And it cuts off there”!!!!
Well…
Since 01 Feb i was using that great plugin.
Yestarday,
Kaboooooommmmm!!!!
Same problem that Rekzai report.
Comment by fabio caparica de luna — Tuesday, 27. February 2007 um 5:16 Uhr
très bon plugin (anglais) de stats aussi pour la version 2.1 !
les tableaux sont nombreux et clairs, mieux que ce que google propose, merci !
Comment by Annie — Wednesday, 28. February 2007 um 19:11 Uhr
Why does counterize count referring urls from the same domain as my page? Is it possible to disable this?
Comment by Pervvy — Saturday, 3. March 2007 um 13:50 Uhr
Hi,
This plugin has been working well for me for a couple months. Thank you for the work.
Today I decided to install google site/web search, but counterize produces and SQL error:
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
update wp_Counterize_Pages set count = count + 1 where pageID =
there any fix for this?
Thanks in advance!
Comment by FH — Monday, 12. March 2007 um 21:39 Uhr
Hello
I’ve just upgraded from Counterize to Counterize II and I seem to have some problems: how come my “Latest entries” list is incomplete? One out of two or three records doesn’t appear… (of course, no filter displayed).
Thanks a lot anyway.
Comment by zozo — Sunday, 18. March 2007 um 9:25 Uhr
Hi, I’m using your Counterize II version 2.4 (which is what it says on my blog’s control panel). There’s something wrong with my Top 5 most visited pages. The first site on that list is 59% and the blue bar extends all the way to the right, making the site side scroll. It extends past the table grid you have there. Is there a way to fix this?
Comment by Billy — Monday, 26. March 2007 um 4:07 Uhr
is it possible to display unique hits per post?
Comment by phil — Thursday, 5. April 2007 um 4:23 Uhr
How about saving the IP’s as unsigned int’s in the DB? Saves space and only requires 7 lines to change.
Comment by Jeppe — Thursday, 5. April 2007 um 13:02 Uhr
Hi!
What should I do to add more visits to the total amount of unique visitors? I’ve just installed Counterize on an old WP installation, so I need to update this number.
Thanks!
Comment by kReEsTaL — Thursday, 5. April 2007 um 18:26 Uhr
@Pervvy
You can fix Counterize II to only display EXTERNAL referers by making the following change to counterize/counterize.php:
Find the following lines:
function counterize_most_visited_referrers($number = 10)
{
$sql = “SELECT count, name FROM %sCounterize_Referers ORDER BY count DESC LIMIT $number”;
$sql = sprintf($sql, $GLOBALS['table_prefix']);
$wpdb =& $GLOBALS['wpdb'];
$tmp = $wpdb->get_results($sql);
Change the SELECT statement so this group of lines reads like this:
function counterize_most_visited_referrers($number = 10)
{
$sql = “SELECT count, name FROM %sCounterize_Referers WHERE name NOT LIKE ‘” . get_option(“siteurl”) . “%%’ ORDER BY count DESC LIMIT $number”;
$sql = sprintf($sql, $GLOBALS['table_prefix']);
$wpdb =& $GLOBALS['wpdb'];
$tmp = $wpdb->get_results($sql);
This will omit displaying refers that are from your own site.
Comment by eric — Thursday, 5. April 2007 um 20:02 Uhr
I realy think Counterize is the best stats-plugin for wordpress.
It does not use a lot of database space and have very clean and perfect UI). but I think a feed for daily stats is realy require! looklike Live stat
Comment by Hassan — Sunday, 8. April 2007 um 19:34 Uhr
I am unable to get the changes noted by Eric to counterize.php to enable logging of external sites only. When I make the adjustment to the code, I get the following parse error -
Parse error: parse error, unexpected T_STRING in /home/content/h/o/w/howellgb/html/wp/wordpress/wp-content/plugins/counterize/counterize.php on line 305.
I am replacing (right after the # New in 0.53 comment) with the text from his post.
Any suggestions?
Comment by Glenn — Monday, 9. April 2007 um 6:05 Uhr
Can some1 post here the sql command lines please?
Comment by HELP — Monday, 9. April 2007 um 6:53 Uhr
Glenn, the problem is how the code is displayed. Try copying it to notepad and den paste it in your file.
It worked for me
Comment by darran — Wednesday, 11. April 2007 um 13:57 Uhr
This is very wierd …
Total hits, today: 82
Hits from unique IPs, today: 32
But in 11th April, I got 61, 12th April: 21.
It is adding 2 days, not very accurate anymore. It is counting 2 days as 1. Can anyone help me?
Comment by darran — Thursday, 12. April 2007 um 7:28 Uhr
I am also running into the problem of today being Saturday and seeing hits recorded for Sunday. The DATE is correct, but the day of the week is off. Where can I look in the code to correct this?
Thanks
Also, I’ll try the copy to clipboard/notepad of the code mentioned earlier.
Comment by Glenn — Saturday, 14. April 2007 um 19:26 Uhr
Copying the code to notepad didnt help me. I still received the same error.
Comment by Glenn — Sunday, 15. April 2007 um 3:55 Uhr
thank you very much for this plug-in. It is all I have been looking for for some while now. God bless!
Comment by Daniel — Tuesday, 17. April 2007 um 0:28 Uhr
Today I noticed a large number of hits from User Agent “Missigua Locator 1.9″.
Can this be a problem?
Can I / Should I block it?
If so, how?
Comment by Recipe — Thursday, 19. April 2007 um 7:28 Uhr
Hello
I’m sorry to post this again but I am really annoyed not being able to see ALL of my latest (50) entries. Counterize II just skips some of them.
I’ve tried to read the code in order to modify it but, well, I’m not fluent in PHP
I didn’t even manage to see where and why this was happening (like some filter remaining despite my clicking the reset filters link?).
Can anybody here please help me get this solved? Thank you very much in advance.
zozo
Comment by zozo — Thursday, 19. April 2007 um 17:42 Uhr
You would have to retype all the quotations because of the text formatting in the blog … hope that helps
Comment by darran — Friday, 20. April 2007 um 8:36 Uhr
Thanks for the tip on replacing the quotes. Works like a charm now.
Comment by Glenn — Sunday, 22. April 2007 um 6:23 Uhr
Here is the error I keep getting… can’t figure out how to fix it.
WordPress database error: [Unknown column 'm.pageID' in 'where clause']
SELECT id FROM wp_Counterize m , wp_Counterize_Pages p, wp_Counterize_UserAgents ua, wp_Counterize_Referers r WHERE m.pageID = p.pageID and m.agentID = ua.agentID and m.refererID = r.refererID and 1 = 1 ORDER BY m.timestamp DESC LIMIT 50
Comment by jen — Sunday, 22. April 2007 um 7:29 Uhr
After applying the code, I still see my own as being my site referers, why is that so?
Comment by darran — Sunday, 22. April 2007 um 11:54 Uhr
Great plugin. It is possible to view the hits in the home page ? I show my stats to the visitors ok my blog..
Comment by Daniele — Thursday, 26. April 2007 um 17:49 Uhr
see http://www.navision-blog.de/counterize-ii-english/functions/
Comment by Steffen Forkmann — Thursday, 26. April 2007 um 18:45 Uhr
Hey..This plugin is Awesome, but I have a small problem. The formatting of the data is fine on my XP machine /w IE 6 but is messed up when accessing my site through FireFox on my Ubuntu Laptop – I hope you/someone here can help. I’ve read all the other comments and not seen anything.
Good work BTW
Comment by Max — Saturday, 5. May 2007 um 4:16 Uhr
PS – Forgot to put the URL in http://www.netflame.co.uk/wordpress/?page_id=7
Comment by Max — Saturday, 5. May 2007 um 4:50 Uhr
Hi Max,
i am working on a Firefox-Version. Maybe in a week…
Regards,
Steffen
Comment by Steffen Forkmann — Saturday, 5. May 2007 um 9:24 Uhr
Steffen, you star! – I thought I was going mad..thank you. Looking forward to it.
Cheers,
Max
Comment by Max — Saturday, 5. May 2007 um 11:32 Uhr
is it possible to show also the trend of the number of unique IPs, not only the number of IPs (all of them)?
Comment by Daniel — Wednesday, 9. May 2007 um 22:04 Uhr
I just want a plain old hit counter. I have had a loothrough the stats plugins and installed one but it did not produce a hit counter.
I downloaded this and turned it on and got
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1]‘
WordPress database error: [Table 'test.wp_Counterize GROUP BY url' doesn't exist]
INSERT INTO `wp_Counterize_Pages` (url,count) SELECT url, count(url) FROM `wp_Counterize GROUP BY url;
WordPress database error: [Table 'test.wp_Counterize GROUP BY referer' doesn't exist]
INSERT INTO `wp_Counterize_Referers` (name,count) SELECT referer, count(referer) FROM `wp_Counterize GROUP BY referer;
WordPress database error: [Table 'test.wp_Counterize GROUP BY useragent' doesn't exist]
INSERT INTO `wp_Counterize_UserAgents` (name,count) SELECT useragent, count(useragent) FROM `wp_Counterize GROUP BY useragent;
Warning: session_start(): Cannot send session cookie – headers already sent by (output started at /home/at1/econo/public_html/yudtp/wp-includes/wp-db.php:121) in /home/at1/econo/public_html/yudtp/wp-content/plugins/cryptographp/crypt/cryptographp.fct.php on line 14
Warning: session_start(): Cannot send session cache limiter – headers already sent (output started at /home/at1/econo/public_html/yudtp/wp-includes/wp-db.php:121) in /home/at1/econo/public_html/yudtp/wp-content/plugins/cryptographp/crypt/cryptographp.fct.php on line 14
Comment by tim — Thursday, 10. May 2007 um 15:52 Uhr
It starts, and my nickname ripe is UreP, and Japanese.
It started and it met Counterize II this week.
It is a very wonderful thing though saw by installing it.
However, there was an incomprehensible place for a moment because it was a display
of English, too.
Fortunately, because file for translation had been appended, being going being
Japanese to make of little bit
Then, how many points is it as for the noticed thing, and we will inform.
･Counterize configuration
In the box of “Amount of rows to show in history”, there should be an initial value by you.
(initial value “0″)
SaveSettings of “Rows to show in’ top xx ‘Bars” is not made multilingual.
A part of message when preserving it seems not to be made multilingual. (BOT etc.)
･Dashboard
I think that it only has to be able to replace order suitably because in the part displayed in the dashboard, there is a difference of the order in the language.
An important thing was forgotten.
It is 2.5 on a set screen, and it seems to be confused though the downloaded version is 2.
05.
Production person’s originality was esteemed, and it was made to assume only the demand and the opinion though there was an ending problem, too, if it improved it for myself.
If the thing that is not good at English, and wants to say is transmitted even
a little, it is glad.
Thank you for a wonderful thing.
Comment by urepko — Saturday, 12. May 2007 um 8:34 Uhr
Hi Steffen, just wodnering if there’s any update on the old firefox problem? Hope you’re well,
Max
Comment by Max — Tuesday, 22. May 2007 um 17:54 Uhr
Hi Stephen,
Thanks for the great plugin.
Any idea if it would be possible to insert in a blog’s page a map displaying visitor’s origin?
I currently use Clustrmaps, which is a free service to do that, but i would much prefer having a function displaying Counterize stats on a google map.
Tks
Ed
Comment by Ed en Vadrouille — Wednesday, 23. May 2007 um 19:43 Uhr
Hi Max,
I mailed you a preview of version 2.07 – but it came back
Comment by Steffen Forkmann — Friday, 25. May 2007 um 9:23 Uhr
nice plugin, and now I’m used it.
Thanks.
Comment by dzaia-bs — Saturday, 26. May 2007 um 17:39 Uhr
Hi Steffen,
I thought there was something wrong with that email addy. Anyhoo, I’ve entered a different one now, hopefully you can see it. Can’t wait to take a look at 2.07.
Peace Out!
Max
Comment by Max — Monday, 28. May 2007 um 12:40 Uhr
Counterize II…
Counterize II is an incredibly cool wordpress plugin. Stop reading this and… Wait, no not yet! Come back! First install the plugin and then stop reading this. Back when I started wm161.net, I had nary an idea what I should blog about. One thought…
Trackback by wm161.net — Tuesday, 29. May 2007 um 2:38 Uhr
Hmmm… one suggestion, can you put back or make it as option where it shows clearly what browser users are using. Because now all i can see is unknown on some visits and i can’t tell if it’s a bot or real user.
Comment by CJ — Sunday, 3. June 2007 um 11:06 Uhr
Hi CJ,
please download again. Now it shows you the complete UserAgent string if the browser is unknown.
Regards,
Steffen
Comment by Steffen Forkmann — Sunday, 3. June 2007 um 11:37 Uhr
Nope. Still says unknown browser.
Comment by CJ — Sunday, 3. June 2007 um 19:32 Uhr
Sorry CJ,
it was too early for me
. Was still the old version.
Please try again – Version 2.09.
Comment by Steffen Forkmann — Monday, 4. June 2007 um 8:54 Uhr
Ah, nice. And thanks.
Comment by CJ — Monday, 4. June 2007 um 10:24 Uhr
Hi Steffen. I used a 2.04 version of Counterize II and loved it.
Now I’m trying to install the version 2.09 plugin onto a brand new blog (version 2.2) , and have since run into some rather frustrating troubles!
My problems might be similar to Tim’s (post # 141), as I received similar messages when I activated Counterize II. Oddly, when I refreshed the page a few minutes later, the warnings messages disappeared, but Counterize still did not work.
Counterize does not appear as a tab under dashboard, but there is a normal looking Counterize counter in “latest activity”. When I click on that, I am warned that counterize/counterize.php cannot be loaded!
I’d really appreciate your help. Thanks in advance
Comment by Oliver — Wednesday, 6. June 2007 um 7:58 Uhr
Hi Oliver,
please compare your table structure to the one in http://www.navision-blog.de/download/sqlscript_020401.txt.
Maybe there was an error during the install-script.
Regards,
Steffen
Comment by Steffen Forkmann — Wednesday, 6. June 2007 um 8:28 Uhr
I don’t think that link works…
These were the aforemath mentioned error messages I got:
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1]
‘
WordPress database error: [Table 'happy_wrdp1.wp_Counterize GROUP BY url' doesn't exist]
INSERT INTO `wp_Counterize_Pages` (url,count) SELECT url, count(url) FROM `wp_Counterize GROUP BY url;
WordPress database error: [Table 'happy_wrdp1.wp_Counterize GROUP BY referer' doesn't exist]
INSERT INTO `wp_Counterize_Referers` (name,count) SELECT referer, count(referer) FROM `wp_Counterize GROUP BY referer;
WordPress database error: [Table 'happy_wrdp1.wp_Counterize GROUP BY useragent' doesn't exist]
INSERT INTO `wp_Counterize_UserAgents` (name,count) SELECT useragent, count(useragent) FROM `wp_Counterize GROUP BY useragent;
Would the solution be to create tables manually, and is this the code to use? If so, exactly Where do I put this code?
CREATE TABLE `wp_Counterize` (
`id` int(11) NOT NULL auto_increment,
`IP` varchar(16) NOT NULL,
`timestamp` datetime NOT NULL,
`pageID` int(11) NOT NULL,
`refererID` int(11) NOT NULL,
`agentID` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
Comment by Oliver — Friday, 8. June 2007 um 6:34 Uhr
Hi Oliver,
please use the script from http://www.navision-blog.de/download/sqlscript_020401.txt and run it on your myphpAdmin.
Regards,
Steffen
Comment by Steffen Forkmann — Friday, 8. June 2007 um 8:29 Uhr
Hi, wonderful plugin! But, I’m having an issue with the latest version, 2.09. I had to manually create the new tables under Counterize_UserAgents. But even then, I still receive “unknown” browser, browser version and OS. Any ideas?
Comment by Omer — Friday, 8. June 2007 um 13:36 Uhr
Thanks for the new link Steffen. I’m not technically adept…can you, in detail, walk me (and perhaps others) through the steps to running the script on myphpAdmin? I can access something called phpMyadmin through my cpanel, but have no idea what to do from there.
Comment by Oliver — Sunday, 10. June 2007 um 5:39 Uhr
I absolutely love counterize. However, I’ve got some ideas you could use to improve it. First, move the stats page from the ‘Manage’ tab to the ‘Dashboard’ tab. According to the codex, the Manage tab is to be used for editing and moderation. The ‘Dashboard’ section is read-only information about things. I’ve edited my install of Counterize II and all I had to do was replace ‘edit.php’ with ‘index.php’ for all my files.
The second idea I have implemented is to not using javascript to add the status to the dashboard main page. You can just use the activity_box_end trigger to output the little blurb. In wordpress 2.2 and above (might be earlier, but I’m not sure). The trigger occurs just before the HTML closes off the box, allowing you to stick stuff inside it. The modification to counterize_dashboard.php is as simple as replacing that whole if statement block that checks to make sure it is the dashboard with
echo $content;.Comment by Trever Fischer — Wednesday, 13. June 2007 um 3:37 Uhr
^ Heh, yeah. I did same thing with the first idea. It’s much easier to view stats when it’s on dashboard.
Comment by CJ — Saturday, 16. June 2007 um 9:24 Uhr
Could you consider to give a change list for upcoming new version? so that some ppl can upgrade it on his own. It is a really good tools
Comment by aw — Wednesday, 20. June 2007 um 8:28 Uhr
I don’t get any hits showing anymore, this started yesterday, and I thought that i’d try the new Counterize II, so I updated, but again, nothing happens. I dont know what to do.
I’m not that good at db, but I checked phpmyadmin, and the tables are there. Strange. Any ideas?
http://fillibabba.se/mattias/?page_id=162
Comment by Mattias — Sunday, 1. July 2007 um 20:00 Uhr
Tried to flush the db, that worked, but still get no new hits. I’ve even removed my own ip, so it should show. Strange. Help!
Comment by Mattias — Sunday, 1. July 2007 um 20:36 Uhr
I had following errors when activate counterize II.
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1]
'
WordPress database error: [Table 'bog.wp_Counterize GROUP BY url' doesn't exist]
INSERT INTO `wp_Counterize_Pages` (url,count) SELECT url, count(url) FROM `wp_Counterize GROUP BY url;
WordPress database error: [Table 'blog.wp_Counterize GROUP BY referer' doesn't exist]
INSERT INTO `wp_Counterize_Referers` (name,count) SELECT referer, count(referer) FROM `wp_Counterize GROUP BY referer;
WordPress database error: [Table 'blog.wp_Counterize GROUP BY useragent' doesn't exist]
INSERT INTO `wp_Counterize_UserAgents` (name,count) SELECT useragent, count(useragent) FROM `wp_Counterize GROUP BY useragent;
Comment by test — Monday, 2. July 2007 um 8:15 Uhr
Hey I had the same database error, when I activated, but a quick deactivate, activate did the job for me. Its working wonderfully
Comment by Mikel — Wednesday, 4. July 2007 um 9:13 Uhr
Sorry for the double post, but I also noticed a bug. I am currently Using Safari version 3.02 beta for windows ( I use vista), but Counterize logs it asMac OS X using Safari 522.13.1. I am not yet any familiar with Coutnerize, but I know it will be very useful for making the page i manage more cross-browser friendly
Comment by Mikel — Wednesday, 4. July 2007 um 9:19 Uhr
Hi. First of all, thanks for a great plugin, love it! I’m experiencing a small problem with my counter that is showing on my blog. I use the script
But it do not show the exact amount of unigue users. In the db > Counterize II Status it shows 52 unique hits.
Why is this happening? Any ideas?
Comment by Kenny — Thursday, 5. July 2007 um 8:13 Uhr
hmm can understand the confusement in my post now. just gona add that in in my blog it right now shows 47 unique hits and in the counterize II status it says that I have 65 unique hits.
Now can anyone tell me why?
Sorry fot the dubble post.
Comment by Kenny — Friday, 6. July 2007 um 8:30 Uhr
Is there an easy way (phpAdmin or otherwise) that I can alter the main hit counter in Counterize II? I can’t seem to get it to take — This is just for the main number of hits to the blog that I am displaying on the main page. Can anyone help?
Comment by Brad — Friday, 6. July 2007 um 21:07 Uhr
Update the link with the new version
Comment by Diesis — Saturday, 7. July 2007 um 15:25 Uhr
Steffan, Thank you for the plug in. I had trouble with the 2.10 version and went to your rss feed to stay up to date and noticed the 2.08 version for english so i deactivated the 2.10 and removed it from my db and installed the 2.08 english version, oddly enough it worked excellent.
Maybe some of these people who are having trouble with the
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
is using a foriegn version??? Does this sound right to you? Cuz it worked for me.
Comment by Mark McGuire — Monday, 9. July 2007 um 5:21 Uhr
Concerning the small overview in the dashboard, is there any way to get that in the sidebar to serve as a hit counter? A stats page by way of is way more than I want my readers to see.
That is the only thing this terrific plugin does not have, and so I still have to go to an outside service just to get a hit counter in the sidebar of my blog.
Comment by Wayne Hatcher — Friday, 13. July 2007 um 0:54 Uhr
http://www.navision-blog.de/counterize-ii-english/functions/
Comment by Steffen Forkmann — Friday, 13. July 2007 um 8:53 Uhr
You forgot do make .mo file for russian translation
Comment by Ivan — Monday, 16. July 2007 um 12:46 Uhr
Hello Steffen.
Thank you for a wonderful plug-in.
My name is Urepko.
Counterize II is always used.
The Japanese translation file of version 2.10 was made.
WordPress Plugins/JSeries (The plugin and the language file made Japanese are distributed)
http://wppluginsj.sourceforge.jp/
Introduction in Japanese of Counterize II
http://wppluginsj.sourceforge.jp/i18n-ja_jp/counterize-ii/
Counterize II 2.10 Japanese Language File
http://prdownloads.sourceforge.jp/wppluginsj/26342/counterize-ii%202.10-ja_UTF.zip
Four places were added to an original language file.
msgid “Most used browsers ”
msgstr “”
msgid “Most used browsers versions ”
msgstr “”
msgid “Most used operating systems ”
msgstr “”
msgid “Maximum width for labels”
msgstr “”
It was not possible to extract even if gettext is executed, and forgive the thing
added without permission, please.
Comment by urepko — Monday, 16. July 2007 um 23:03 Uhr
How would I manually place Counterize in a page? Like this?
I’m asking because I have a separate page for mobile browsers and hits to it are not being recorded.
Comment by Glenn — Tuesday, 24. July 2007 um 5:20 Uhr
Just some suggestions.
Translation for next release (both files): http://bobrik.hovel.ru/uploads/counterize-ru_RU.tar.gz
Please add “Unknown browser: Yandex/1.01.001 (compatible; Win16; I)” as search bot and make option “Do NOT show unknown browsers in statistics”.
Comment by Ivan — Tuesday, 24. July 2007 um 7:05 Uhr
Hi,
things are working OK but when I try to access counterize_admin.php I get:
Fatal error: Cannot redeclare counterize_options_page() (previously declared in [...]/html/wp-content/plugins/counterize/counterize_admin.php:7) in [...]html/wp-content/plugins/counterize/counterize_admin.php on line 3
I’m trying to access counterize II’s admin / options page so I can exclude my own IP from being counted — and I cannot see how to get to the controls section from the page that loads at MANAGE > COUNTERIZE II. Am I missing something simple??
Comment by Joel — Friday, 27. July 2007 um 14:24 Uhr
WordPress database error: [Table 'wordpress.wp_Counterize_UserAgents' doesn't exist]
SELECT count(agentID) from wp_Counterize_UserAgents where name = ‘Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)’
I get this upon activation – nothing works – any ideas?
Comment by Ricardo — Monday, 30. July 2007 um 4:52 Uhr
NEVERMIND. hahahahaha. I found it: OPTIONS > COUNTERIZE
I’m new to WP and counterize, yeah, that’s my excuse.
thanks for such a great plugin!
Comment by Joel — Monday, 30. July 2007 um 12:36 Uhr
Is there a way to add to version 2.10 the ability to display the user-agent string in addition to the OS, Browser and Country icons?
I rely on the user agent string in 2.04 to allow me to ban bad bots and rouge IP’s.
Thanks.
Comment by Glenn — Monday, 6. August 2007 um 17:46 Uhr
Hello, this is Richard from China. I know there are lots of Chinese WP users like to use your plugin very much. I have an idea that can I tanslate it into Chinese to spread the plugin over the whole China evan the users are not familiar with English or German.
If you think the idea is accecptable, I will do the work and send the PO and MO files back to you.
Thanks a lot! BTW, the plugin is very nice.
Comment by Richard — Monday, 13. August 2007 um 10:10 Uhr
Hi.
I am using this from long but recently one of my blog got heavy in traffic and it is really pain, it takes ages for counterize stats page to load up..
Earlier I saw that you were working to improve it.. but now thats gone.. ?
Any plan to make it efficient ?
Comment by Linux forum — Wednesday, 15. August 2007 um 15:09 Uhr
Hi,
I updated the italian translation.
You can find it here:
http://lacroa.altervista.org/dokucount/doku.php?id=counterize_ii_mod:en:localization
…yes, I have a lot of free time…
Comment by Emanuele — Monday, 20. August 2007 um 15:08 Uhr
Hi Steffen,
it seems that the strings in the dashboard are not translated at least because is missing the “,’counterize’” after the string. I’m not sure if is also necessary to add a second underscore before the parenthesis.
P.S.
I’ve updated the italian translation because I found a couple of errors…sorry.
Comment by Emanuele — Tuesday, 21. August 2007 um 15:44 Uhr
Hi,
I installed this wonderful piece of art and I am very satisfied.
The only “problem” that I have is the number of online visitors. It always give a number like 40, 50, even 100+, but my other plugin says that there are only few online visitors at the moment.
Why is this so?
Best,
Oktay
Comment by Oktay — Wednesday, 22. August 2007 um 19:54 Uhr
Hi, thanks for the plugin. It was working really great 2 days ago. Since yesterday, I found out that it doesn’t update the info anymore. I’ve changed my theme yesterday too. Is this why it doesn’t work?
Comment by Carmen — Friday, 31. August 2007 um 3:03 Uhr
i just installed this plugin on my blog and i love it! thank you!
Comment by Manele — Tuesday, 11. September 2007 um 9:14 Uhr
wordpress stats pt2…
In a previous post, I talked about quick stats. My new wordpress stat plugin of choice is Counterize II.
It gives good simple bar graphs and you can control who much of what is shown on the page! It also pops a nice little ‘hits’ box on t…
Trackback by jpc101 — Friday, 14. September 2007 um 18:55 Uhr
Super plugin, works fine on my blog
Should you create another version could you include a check box so that we can select all those that we want to delete in place of the one by one kill option, and if we could know how much time someone spent on a page it would be cool too (I had this on mabulle.com) but even as is, it realy a super neat plugin. Many thanks.
Kendreague
Comment by Kendreague — Friday, 21. September 2007 um 19:31 Uhr
Vielen Dank! This is my favourite plugin.
I start my day checking the number of visitors and looking to the used keywords. Trying to adapt my site to the wishes of the visitors.
What happens to the old statistics? Are the still there in the Counterize database? How can I see those statistics?
Would be nice to see a graph of the Unique IP addresses over a longer period?
Comment by Bril — Monday, 24. September 2007 um 15:34 Uhr
Just installed it after reading my friend’s blog on this plugin. It seems that I’m going to love this plugin
Comment by Irwan — Tuesday, 25. September 2007 um 4:00 Uhr
It seems like upgrading from counterize I failes.
How can I fix this problem?
wordpress 2.2.3 , couterize II 2.10
WordPress database error: [Unknown column 'browserName' in 'field list']
SELECT sum(count) as amount, browserName as label, browserCode FROM wp_Counterize_UserAgents group by label ORDER BY amount DESC LIMIT 5
Comment by hogeo — Tuesday, 25. September 2007 um 8:43 Uhr
I found some problems in counterize_install.php.
I tried upgrade directly from counterize_install().
execute following php.
# php -f upgrade.php
upgrade.php
It displayed lots of SQL syntax error.
$refererID = $wpdb->get_var("Select refererID from `".counterize_refererT\
able()."` where name='" . $entry->referer ."'");
If referer has quote, SQL syntax errors occurs.
I guess addslashes() is needed here.
memory_limit problem was found on my server, too.
I use MySQL5.
Comment by hogeo — Tuesday, 25. September 2007 um 9:45 Uhr
I just upgraded my WordPress to 2.3. But my there is a small problem with my Counterize II. I don’t know if you have the same problem which is the “Visits based on day of month (only this month)” doesn’t show any number anymore. But other functions work normally.
I love this plugin. Could someone solve this problem? Thanks!
Comment by stanley — Monday, 1. October 2007 um 2:47 Uhr
Hi stanley,
it’s a new month. Maybe you don’t have any hits this month?!
Comment by Steffen Forkmann — Monday, 1. October 2007 um 9:18 Uhr
i am using this plugin.
it’ll be better if there is a “empty database” button in “edit.php?page=counterize/counterize.php” directly.
thanks for the plugin..
Comment by emrah ustun — Monday, 1. October 2007 um 16:16 Uhr
Hello!
I really appreciate your plugin and use it exclusively to track my blog traffic.
I have recently updated to 2.04 and you say that you can filter referrers but I don’t see how. I can see that you can exclude certain users and ip addresses, but I am constantly getting spammed (or ATTEMPTED to be spammed…I’m stopping it all w/ akismet, etc) but each attempt is logged by Counterize. It seems that just about every one of these comes from a .info referrer.
Here is an example from Counterize II:
http://viagra-51581sf4.televiz orchik.info (F
Is there something I’m missing in preventing these bots from being logged and skewing my traffic numbers? If not, perhaps in future versions you can have a way to “ignore” referrers like above.
Regardless, your plugin is great! Thanks!
Dave
Comment by Dave — Thursday, 4. October 2007 um 15:24 Uhr
I have installed the plug-in – easily done – great work. Quick question; the plug-in tells me that there are # users currently online. How can I identify those users? Is it displayed somewhere in the stats? Thanks, Earl
Comment by Dr. Earl R. Smith II — Saturday, 6. October 2007 um 17:31 Uhr
I want to erase my lastest entries from database. How can I do that?
Comment by Sertalp Bilal — Saturday, 6. October 2007 um 19:07 Uhr
great plugin – worked straight out of the box with no hassles!
many thanks for your great work
simon
Comment by simon — Monday, 8. October 2007 um 12:52 Uhr
Hi Steffen!
I installed the plugin in some installations, and always got some SQL errors in the first minutes, but after some short time (i think it’s because the server delay) the plugin began to work normally.
But today I’m trying to install the plugin in a new webpage, and it’s not working. It didn’t create the tables, so I did it manually according to your SQL script:
http://www.navision-blog.de/download/sqlscript_020401.txt
Ok, no more SQL errors, but there’s still some problems. I keep getting the “No data in the tables” errors, instead, the website has a good visitation rating, and I already surfed (a lot) on it to see if this problem get fixed.
It seems the plugin can’t write in the tables. What’s wrong?
In Troy’s comment: ‘(Kommentar von troy — Montag, 22. Januar 2007 um 12:52 Uhr)’, he cites something related to the header.php file, but I can’t find out what it is (it seems he forgot to paste, or something).
Please, I would like to get some help, because your plugin is really wonderfull.
PS: I think it would be a good idea to create a forum or another kind of help center. It’s really hard to get some information in this comment list between a mixed of congratulations, help inquires, SQL codes and modifications suggestions to the next releases. Just organize the information.
I can help on it if you wish.
Thank You Very Much!
Comment by Vinicius — Friday, 12. October 2007 um 2:14 Uhr
Vinicius and everyone else that is getting the same error, what you need to copy from another theme is:
between the tags in header.php
This worked fine for me with no problems so far (well after inserting the tables manually
)
Comment by Adrian — Monday, 15. October 2007 um 14:46 Uhr
Hrm,,, doesn’t like plain code so ill try it this way
needs to be between the head /head tags.Comment by Adrian — Monday, 15. October 2007 um 16:40 Uhr
Even using the code tags it won’t worjk so look at this picture to find the text.
http://i23.tinypic.com/j9qxz4.gif
Comment by Adrian — Monday, 15. October 2007 um 16:44 Uhr
Hi,
looking at my log, I found some additional useragent strings used by bots.
I extracted the distinctive part and I used it in the botarray in order to avoid to count it.
They are:
“Pagebull”
“HTTrack”
“OffByOne”
“PrintSmart”
“Getleft”
“Indy Library”
“DE Slurp”
“compatible; ICS”
“Powermarks”
“C-CCK-MCD”
“depspid”
“Twingly Recon”
“Netcraft”
“Check&Get”
“relevantnoise”
maybe are useful to someone else.
Comment by Emanuele — Thursday, 18. October 2007 um 21:36 Uhr
Got it. That’s the solution. Easy, easy…
Counterize seems to track and use this tag to put data in the tables. That’s why the templates that don’t have it leaves the tables empty.
Just put the code (without .s (points)) between head and /head HTML tags:
Hope it appeared.
And I still think a Forum would help us a lot to solve issues like this one.
Thanks!
Comment by Vinicius Andre Massuchetto — Wednesday, 24. October 2007 um 2:30 Uhr
Better look at Adrian’s file:
http://i23.tinypic.com/j9qxz4.gif
At least is everything working now.
:p
Cheers!
Comment by Vinicius Andre Massuchetto — Wednesday, 24. October 2007 um 2:32 Uhr
Thanks for the plugin! I’ve made the spanish translation for my web page ( http://mc.delendis.com/estadisticas/ ). I can send to you the po and mo files if you want to include them in next releases.
Thanks again, a really cool plugin!
Sandra
Comment by Sandra — Friday, 2. November 2007 um 12:55 Uhr
Hi, my blog recently got spam by this ip 207.178.0.196, i wonder how can you delete all of that ip static in my counter all at once without going one by one? Thanks
Comment by Tiff — Sunday, 18. November 2007 um 7:33 Uhr
Hi,
there will be a feature for deleting multiple entries within the next release. I am planning this for the next week.
Regards,
Steffen
Comment by Steffen Forkmann — Sunday, 18. November 2007 um 9:47 Uhr
Some times ago I modified a little bit the code in order to introduce this feature on my version of counterize II, but if now it become a built-in functionality that’s great!
Thank you Steffen!
Ciao!
Emanuele.
Comment by Emanuele — Sunday, 18. November 2007 um 12:14 Uhr
I just merged your version
Thanks Emanuele.
Comment by Steffen Forkmann — Sunday, 18. November 2007 um 12:49 Uhr
This is an excellent plug-in. Thank you very much for giving it to the public.
I found something likely to be a bug. After emptying the database, the search keyword table still retains its original values.
Comment by Jiwei — Thursday, 22. November 2007 um 3:26 Uhr
Thanks Jiwei – this will be fixed in the next version.
Regards,
Steffen
Comment by Steffen Forkmann — Thursday, 22. November 2007 um 9:01 Uhr
Version 2.04 works great but 2.10 breaks.
This morning I deactived 2.04. Deleted the 2.04 files. Uploaded the 2.10 files. Activated the Plug-in. get these errors
Warning: main(counterize_install.php): failed to open stream: No such file or directory in E:\www\micro\htdocs\dave\wp-content\plugins\counterize\counterize.php on line 992
Warning: main(): Failed opening ‘counterize_install.php’ for inclusion (include_path=’.;c:\php4\pear’) in E:\www\micro\htdocs\dave\wp-content\plugins\counterize\counterize.php on line 992
Fatal error: Call to undefined function: counterize_install() in E:\www\micro\htdocs\dave\wp-content\plugins\counterize\counterize.php on line 996
Removed 2.10 and reinsalled 2.04. Again works fine.
Running WordPress 2.3.1, MySQL 4.0.18-nt, PHP 4.4.2
Comment by Dave Riddle — Monday, 26. November 2007 um 16:43 Uhr
Hi,
is there a way to delete the detail of a visit keeping only the total number of visits in order to save database space?
Sorry for my english I hope you understand my question.
TIA
Comment by g t — Sunday, 2. December 2007 um 12:55 Uhr
edit previous post: the details of all visits
Comment by g t — Sunday, 2. December 2007 um 12:57 Uhr
This feature is planned for the next release.
Comment by Steffen Forkmann — Monday, 3. December 2007 um 9:07 Uhr
thank you!
Comment by g t — Monday, 3. December 2007 um 18:59 Uhr
Counterize sees “0″ total hits today and “0″ unique hits when all other indications including StatCounter show 300+ visitors in same time period.
what stopped working?
Comment by BGR — Friday, 7. December 2007 um 2:59 Uhr
My client wants an individual hit counter for each page. I know, I know, I’m trying to talk him out of it.
Is this even possible?
He also likes the look of the odometer – has anyone done a modification that would display the total hit count with graphics?
Thanks for a great plug in!
Maida
Comment by Maida — Monday, 10. December 2007 um 1:13 Uhr
Ich hatte 2 jahre in Deutschland gewohnt, in da nahe von Heidelberg. Mein Deutsch is noch schlect.
Comment by Maida — Monday, 10. December 2007 um 1:14 Uhr
i upgraded to the latest version of wp and counterize ii
The chart bars in the graphics are no longer showing up.
Everything else seems to work ok.
Any explanation?
Comment by nchenga — Tuesday, 11. December 2007 um 6:46 Uhr
nothing is showing on my counterize page. this is weird. the old plugin is fine, but not the new plugin.
Counterize II Status »
Total: 0 hits and 0 unique.
Today: 0 hits and 0 unique.
Currently: 0 users online.
Comment by eLson — Tuesday, 11. December 2007 um 13:55 Uhr
yup..same with me too. im using the latest version also. the plugin aint functioning
Comment by eLson — Tuesday, 11. December 2007 um 15:40 Uhr
Thanks for creating the plugin, however I can’t seem to get it to work at the moment. It’s coming up with these errors:
WordPress database error: [Table 'thefly.wp_Counterize' doesn't exist]
SELECT COUNT(1) FROM wp_Counterize
WordPress database error: [Table 'thefly.wp_Counterize' doesn't exist]
SELECT count(DISTINCT IP) FROM wp_Counterize
WordPress database error: [Table 'thefly.wp_Counterize' doesn't exist]
SELECT COUNT(1) FROM wp_Counterize WHERE timestamp >= ’2007-12-13′
WordPress database error: [Table 'thefly.wp_Counterize' doesn't exist]
SELECT count(DISTINCT IP) FROM wp_Counterize WHERE timestamp > DATE_SUB(now(), INTERVAL 5 MINUTE)
WordPress database error: [Table 'thefly.wp_Counterize' doesn't exist]
SELECT count(DISTINCT ip) FROM wp_Counterize WHERE timestamp >= ’2007-12-13′
Any help would be much appreciated. Thanks
Comment by The Fly — Friday, 14. December 2007 um 3:56 Uhr
From v2.12.2, there was an error in the installation. The fix is:
counterize_install.php, line 16 – Change the “%” to “.” to concatenate, not to to do a modular.
Comment by tenajs — Saturday, 15. December 2007 um 5:14 Uhr
Also, thank you for this plugin. It is simple and useful!
Comment by tenajs — Saturday, 15. December 2007 um 5:16 Uhr
very interesting, but I don’t agree with you
Idetrorce
Comment by Idetrorce — Saturday, 15. December 2007 um 13:00 Uhr
I just want to inform you, that your plugin cause my wp database to crash yesterday and i need to get all my backup database… too bad after so long i use this plugin, the latest update give me this trouble… few more others but yesterday was the worst… my wp all break into pieces…
regards,
eizil
Comment by Eizil — Saturday, 22. December 2007 um 13:19 Uhr
I’ve noticed that referrals from google image results are getting cut off after a certain amount of characters, so i can’t see what the person was searching for, since it cuts that part of the URL off. Any way to fix this?
Comment by Zach — Friday, 28. December 2007 um 3:44 Uhr
Nice plugin, I have been using it since my blog went live
If you could make the blog-statistic page nicer to view it’d be very very great!
Comment by vkeong — Saturday, 12. January 2008 um 13:40 Uhr
Which function should I use if I want to display “xxx users online”?
Comment by robi — Sunday, 13. January 2008 um 7:43 Uhr
How come Counterize doesn’t show icons for Mozilla Firefox 2.0.06 to 2.0.0.11? It shows small icon for other builds. Bug?
Comment by CJ — Sunday, 13. January 2008 um 14:21 Uhr
I mean in “Most used operating systems”.
Comment by CJ — Sunday, 13. January 2008 um 14:22 Uhr
Errr… browsers.
Comment by CJ — Sunday, 13. January 2008 um 14:22 Uhr
Great plug in, thank you
Comment by EnJ — Thursday, 24. January 2008 um 5:47 Uhr
There’s no data in the database – You can’t see stats until you have data.
Comment by samy — Saturday, 26. January 2008 um 13:23 Uhr
Hi Steffen,
I really like the plugin but there’s something missing that I would really find useful. In the counterize pages table there’s a postID field which is never written but which I assume is meant to hold the postID for the page (if any).
I’m interrogating the DB with my own SQL and this would make the results a lot more useful to me.
I can see what is needed, I think. In counterize_getPageID when inserting a new entry into the database you can get the post ID (if any) from the global $post.
I’m planning to patch my local copy but an official update would be preferable of course.
Cheers, Alfred
Comment by Alfred Armstrong — Tuesday, 29. January 2008 um 16:52 Uhr
Steffen, after some testing here’s a working patch. Change line 852 of counterize.php from:
$sql = "INSERT INTO " . counterize_pageTable() ." (url,count) VALUES ('".$wpdb->escape($url)."',0)";
to
global $post;
$post_id = is_single() || $post->post_type == 'page'? $post->ID: 'NULL';
$sql = "INSERT INTO " . counterize_pageTable() ." (url,count,postID) VALUES ('".$wpdb->escape($url)."',0,".$post_id.")";
Comment by Alfred Armstrong — Tuesday, 29. January 2008 um 17:39 Uhr
I’m using 2.12.7 and I miss seeing the user-agent string in the Latest Entries area. Is there a code snippet I can use to put it back in addition to the Browser Sniff info?
Thanks
Comment by Glenn — Thursday, 31. January 2008 um 2:40 Uhr
I am using WP 233 and Counterize II at Halfway To Concord and the Stats Page works fine.
Thanks, Steffan.
The Stats Counterize reports seems higher than what I see StatCounter Report. How can I account for this discrepancy?
Comment by BGR — Thursday, 7. February 2008 um 16:02 Uhr
Hi MY counterize does not update, It has been stuck on Jan 8th since i installed it. Can you help please?
Thanks
Comment by gooder — Thursday, 7. February 2008 um 18:24 Uhr
hi
i go the same error of some others here: the counterize stats are stuck oo zero
i’m not so into coding, so i guess the answer is
–<
CREATE TABLE `wp_Counterize` (
`id` int(11) NOT NULL auto_increment,
`IP` varchar(16) NOT NULL,
`timestamp` datetime NOT NULL,
`pageID` int(11) NOT NULL,
`refererID` int(11) NOT NULL,
`agentID` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
–<
but… where i have to put this code?
and then, to show the stats in the sidebar, i wrote in a text widget as html:
Visitatori oggi:
it will works once i had fixed the table issue, or it’s wrong too?
many thanks!
matteo
Comment by matteo — Sunday, 10. February 2008 um 12:02 Uhr
Hey there,
Have you considered adding a javascript link decorator to bounce all external links through a redirector? This would allow counterize to capture data about which links are most relavent.
Cheers,
C.J.
Comment by C.J. Adams-Collier — Sunday, 10. February 2008 um 19:17 Uhr
Great plugin very useful
Would it be possible to tag IP address so it displays a name instead of a number or can have a prefix added.
This would give the ability to distinguish the IP address I know from unknown visiting ones with minimal effort.
Comment by malc — Monday, 11. February 2008 um 23:27 Uhr
This plugin is fantastic.
But I’ve installed the latest version, 2.13.0, from the wordpress website, and upgraded. After I upgraded I also created a stats page on my blog and then later on I noticed that there’s no IP information anymore. It’s missing on the latest entries table and there’s no information on IP addresses anywhere. Is there something I might have done wrong, or does the new version not support IP logging?
Comment by crowth — Monday, 18. February 2008 um 1:01 Uhr
Counterize II 2.13 doesn’t store any IP information, because this is illegal in some countries (e.g. Germany).
Counterize stores only a small hash to distingiush between different users and to get information about the user count.
Comment by Steffen Forkmann — Monday, 18. February 2008 um 9:17 Uhr
Thanks for that Steffen… I may reinstall 2.12, that was my favourite feature.
Comment by crowth — Monday, 18. February 2008 um 9:39 Uhr
Again, great plugin, and the other features are all great too, many thanks.
Comment by crowth — Monday, 18. February 2008 um 9:44 Uhr
Hi,
erstmal: Danke für das geniale Plugin. Wie ich unter Kommentar #250 sehe, wurde die Speicherung der IP-Adressen entfernt – wegen Legalitätsproblemen.
Meine Frage nun:
Wie kann ich über das UI den Traffic eines speziellen Nutzers filtern, um ihn z.B. zu löschen? Wäre es möglich, losgelöst von der IP-Adresse, den unique-Hash als Filterkriterium anzuzeigen, damit im Falle eines Crawling-Bots, der nicht als Bot erkannt wird, hier der Traffic gelöscht werden kann, um die Statistik “zu bereinigen”?
Die nächste Frage wäre: Kann man ebenfalls eine Möglichkeit erhalten, diesen Traffic “auszusperren”? Ich habe das bisher über die IP-Adresse getan über den Filter in den Einstellungen…
Comment by Kim — Monday, 18. February 2008 um 13:45 Uhr
@Kim:
Ich verstehe dein Problem und werde mal drüber nachdenken. Möglicherweise bringe ich das in dieser Form wieder rein.
Grüße Steffen
Comment by Steffen Forkmann — Monday, 18. February 2008 um 13:54 Uhr
@Steffen:
Wäre schon genial, wenn man das so irgendwie machen könnte. Es gibt nämlich verschiedene Dienste aus anderen Kontinenten, die sich einfach als IE6 oder so ausgeben und keine ordentliche BOT-Kennung haben, so dass sie von deinem Plugin als normaler Benutzer gezählt werden. Wenn man dann aber die Besuchszeiten pro Seite (< 2 Sekunden) sieht und die riesige Menge an Seiten (bei mir derzeit einige hundert immer) die diese dann abgrasen, ist klar, dass dies kein menschlicher Benutzer ist, sondern eben ein Script, was die Seite abcrawlt.
Im Grunde würde es ja reichen, den internen Hash aus der IP-Adresse als Filterkriterium anzueigen – der ist anonym genug, denke ich, um zu sagen: Wir können nicht rückverfolgen, wer es war… aber eindeutig genug um zu sagen: es war der gleiche wie gestern/vorgestern und den mag ich nicht zählen.
Comment by Kim — Monday, 18. February 2008 um 14:22 Uhr
@Steffen:
Wieso soll es eigentlich illegal sein, IP-Adressen zu speichern zu internen Zwecken, wenn diese nicht veröffentlicht werden?
Jedes Logfile eines Webservers beinhaltet die gleichen Daten – oder ist neuerdings das Access.Log eines Apache-Webservers illegal? War diese Aktion vielleicht ein Schuss in die falsche Richtung?
Comment by Kim — Monday, 18. February 2008 um 17:48 Uhr
http://www.heise.de/newsticker/meldung/103440
Die Sache ist nicht abschließend geklärt, aber ich habe keine Lust von irgendwelchen Dritten abgemahnt zu werden.
Grüße Steffen
Comment by Steffen Forkmann — Monday, 18. February 2008 um 18:01 Uhr
Oha, das verändert die Situation natürlich ein wenig.
Comment by Kim — Monday, 18. February 2008 um 20:57 Uhr
Whauh… 2.13 sucks big time. Why? Because you just butchered the counterize by removing the IP table. Anyway, time to bring the backup and reinstall older version. Goodbye.
Comment by ICL — Wednesday, 20. February 2008 um 0:13 Uhr
I use the current version of Counterize II on WP 2.3.2 and my stats have not updated since the 18th. Nothing showed up yesterday and today. do you have any thoughts while that might be?
Thanks.
Comment by Mark — Wednesday, 20. February 2008 um 17:21 Uhr
Die Tatsache, daß Counterize in der aktuellen Version kurzerhand und ohne den Benutzer zu fragen, die IP-Tabelle verschlüsselt, finde ich sehr bedenklich und ärgerlich. Man stelle sich vor, was wäre, wenn Windows je nach Microsofts Gutdünken, die Inhalte der von User-Dateien verändern würde.
Sie hätten die User zumindest über den Umstand informieren sollen.
Comment by Hans-Dieter — Friday, 29. February 2008 um 10:37 Uhr
Das steht im Changelog und auf der Pluginseite http://wordpress.org/extend/plugins/counterizeii/ in der Beschreibung. Ich gebe zu, ich hätte während des Update-Prozesses auch nochmal darauf hinweisen können.
Das Ganze hat aber rein garnichts mit “Gutdünken” zu tun, sondern ist eine rechtliche Absicherung. Ich werde keine Software zur Verfügung stellen, von der ich weiß, das sie evtl. rechtliche Probleme bei mir oder bei den Usern erzeugt.
Comment by Steffen Forkmann — Friday, 29. February 2008 um 10:50 Uhr
I have upgraded from Counterize 1.
I uploaded the new Counterize II, and activated it.
I go to the options panel and click on Counterize II and see the Configuration and Exclude List. That is it.
I do not see any of my old data displayed on this page. I have well over a years worth of data.
Somehow the data did not get converted from the old plugin. How can I update the data?
Let me know if you have any questions.
Thanks for any help or direction.
Comment by Bert — Monday, 3. March 2008 um 20:29 Uhr
I love your plugin and I’ve been playing around with my stats page. works really well.
However, is there a way to just pick the stats I want to display on my stat page (not on the sidebar)?
The plugin page on wordpress tells me that I need to use something like these:
echo counterize_getuniqueurl() � Returns amount of unique URl’s that have been shown
echo counterize_getamount() � Returns total hits seen by Counterize.
echo counterize_gethitstoday() � Returns total hits registered today.
I’m really not an expert on how to use this properly and I can’t seem to make it work. Will you please help?
I’d really appreciate it.
Thanks!
Comment by Sharon — Friday, 7. March 2008 um 0:04 Uhr
How come IP addresses are not listed in the advanced statistics under Manage/Counterize? The original Couterize would show the IP address of the visitor.
Comment by Shane — Sunday, 9. March 2008 um 19:37 Uhr
Does the plugin show hits on jpg files? I have a gallery and I want to track how many times each jpg is viewed (clicked to enlarge).
If not, is there a way to add a tag so it can?
Thanks!
Comment by dwest — Monday, 10. March 2008 um 3:53 Uhr
@ Shane
Read comment 250. No more IP logging. If you want it back you’ll have to downgrade to version 2.12.
Comment by crowth — Monday, 10. March 2008 um 16:56 Uhr
Hello,
I wanted to say first I love your plugin and I use it on every site I have which around 7 sites.
The question I have is I am not able to get the IP Adresses to show in the stats page and I was wondering what I am doing wrong with the new version on the plugin.
Thank you
Ken
Comment by KennyG — Monday, 17. March 2008 um 3:12 Uhr
Read comment 250. No more IP logging. Sorry.
Comment by Steffen Forkmann — Monday, 17. March 2008 um 8:59 Uhr
Hello!
I gotta tell you, I just love Counterize! But, there’s just one little problem right now … I had to start all over again since my last WordPress installation wouldn’t respond to rss feeds. Well, the sad part is that I my new counterize starts at zero, so my question is: Is there anyway to export the data from an old Counterize to a newer one so that it continues where the old one stopped?
Thanks in advance,
Soph.
Comment by Soph — Wednesday, 19. March 2008 um 14:42 Uhr
Hello.
First i would like to thank you for this great plugin !
Seccond, i would like to know if there is a way i could reset the counter to a specified value ?
I moved from another website, and lost my actual number (was arround 10000 unique hits). Can i actually reset the counterize ii to start from that number ?
Thank you in advance !
Comment by MonkY — Wednesday, 19. March 2008 um 19:04 Uhr
Hi, i use this nice counterize II, thanks for you.
but i have some problem, the counterize is counting my image like this :
2008-03-24 22:52:48 /images/footer.gif (F)
2008-03-24 22:52:48 /images/commentalt.gif (F)
2008-03-24 22:52:48 /images/bullet.gif (F)
2008-03-24 22:52:48 /images/sidebar-top.gif (F)
how do i stop Counterize II to stop counting my image, thanks.
Comment by dodi — Tuesday, 25. March 2008 um 5:33 Uhr
anyone has tested this plugin with the upcoming wordpress 2.5 ?
TIA
Comment by g t — Friday, 28. March 2008 um 13:40 Uhr
…answering me… Works fine on WP 2.5
Comment by g t — Monday, 31. March 2008 um 17:41 Uhr
–> is there a way to delete the detail of all visits keeping only the total number of visits in order to save database space? <–
is this feature still planned?
Comment by g t — Wednesday, 2. April 2008 um 13:10 Uhr
Will there be a WP2.5-version och this plugin featuring the widgetized dashboard?
Comment by Fizzgigg — Wednesday, 2. April 2008 um 14:22 Uhr
Hello,, I have WordPress 2,5 and now my counterize don’t work at al, I don’t get anything from in the dashbord. With WP 2,3 I had it.
I download it again and install but still nothing on the dashbord.
In the settings I don’t what to write there, and the code you have written above I don’t know where I will write them, is it in counterize_dashbord.php? And wshall I write on a specific place in the .php file? I am not so good on .php but I mangage to put codes in it if I know where to put it.
I just like counterize and little sad that I not can get it to work for me.
Comment by anki — Friday, 4. April 2008 um 14:51 Uhr
I am using CII with WP 2.5. I had hoped to have a Google Map display of where my visitors were located. I guess this is no longer available since CII has disabled IP tracking.
I wonder if IP tracking could be made available for IPs that are not in Germany. That is, a user could state that they were not in Germany and then IP tracking would be switched on. If it turned out that the person was not telling the truth, and their IP was in Germany after all, then the IP tracking would turn off. This would allow the rest of the world not to have to be limited by Germany’s internal internet restrictions.
Would that be possible? Thanks.
Comment by Ranebo — Saturday, 5. April 2008 um 19:14 Uhr
I’m using this on 2.5, and whenever I activate/deactivate other plugins I get this:
WordPress database error: [Duplicate column name 'pageID']
ALTER TABLE `wp_Counterize` ADD `pageID` INT( 11 ) NOT NULL;
WordPress database error: [Duplicate column name 'agentID']
ALTER TABLE `wp_Counterize` ADD `agentID` INT( 11 ) NOT NULL;
WordPress database error: [Duplicate column name 'refererID']
ALTER TABLE `wp_Counterize` ADD `refererID` INT( 11 ) NOT NULL;
WordPress database error: [Table 'wp_Counterize_Pages' already exists]
CREATE TABLE `wp_Counterize_Pages` ( `pageID` int(11) NOT NULL auto_increment, `url` varchar(255) NOT NULL, `count` int(11) NOT NULL default '1', `postID` bigint(20) default NULL, PRIMARY KEY (`pageID`), KEY `url` (`url`), KEY `count` (`count`) )
WordPress database error: [Table 'wp_Counterize_Referers' already exists]
CREATE TABLE `wp_Counterize_Referers` ( `refererID` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `count` int(11) NOT NULL default '1', PRIMARY KEY (`refererID`), KEY `name` (`name`), KEY `count` (`count`) )
WordPress database error: [Table 'wp_Counterize_UserAgents' already exists]
CREATE TABLE `wp_Counterize_UserAgents` ( `agentID` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `count` int(11) NOT NULL default '1', PRIMARY KEY (`agentID`), KEY `name` (`name`), KEY `count` (`count`) )
Comment by Erin — Wednesday, 9. April 2008 um 1:51 Uhr
Hi Erin,
do you have access to you mySQL-database? Got to the wp_options-Table and change the values for counterize_MajorVersion to 2 and counterize_MinorVersion to 13.
Best regards,
Steffen
Comment by Steffen Forkmann — Wednesday, 9. April 2008 um 9:08 Uhr
[...] a huge fan of Counterize II, but the one thing I wish it did was keep better track of my unique hits, rather than just all [...]
Pingback by Counterize II Mod to show Unique stats | FlishFun.com — Wednesday, 9. April 2008 um 22:40 Uhr
Great plugin, Steffen.
I just want to display the total amount of hits and keep the rest hidden. How can I do that?
Thanks!
Thomas
Comment by Thomas — Thursday, 10. April 2008 um 9:13 Uhr
>I just want to display the total amount of hits and keep the rest hidden.
In a post, that is.
Comment by Thomas — Thursday, 10. April 2008 um 10:08 Uhr
You ca use this function in your wordpress-theme:
< ?php echo counterize_getHitsOnCurrentArticle(); ?> HitsComment by Steffen Forkmann — Thursday, 10. April 2008 um 10:32 Uhr
using on a few sites and have no problems on any of them.]
thanks
Comment by Richard McLaughlin — Friday, 11. April 2008 um 19:15 Uhr
Fantastic, it works just fine! Thx, Thomas
Comment by Thomas — Friday, 11. April 2008 um 22:55 Uhr
I do have counterize_MajorVersion set to 2 and counterize_MinorVersion set to 13. Now the when trying to activate a plugin, the page goes blank. No idea what’s going on.
Comment by Erin — Saturday, 12. April 2008 um 9:42 Uhr
[...] est-il qu’en installant la nouvelle version 2.10 du plugin Counterize II, je me suis aperçu que vous êtes plus de 88% à visiter mon blog depuis Windows (moi même en [...]
Pingback by Microsoft à Buenos Aires « Scavenblog, la brèche digitale — Tuesday, 15. April 2008 um 10:47 Uhr
Regarding comment 249, 250, 251 and furter.. Could it be possible to add this feature again with an option to log or not log ipaddresses? When I downgraded to 2.12.7 the ip addresses seems to be hashed instead.. is there an easy fix for this issue? (92300d7a380f9abe)
Comment by cjl — Saturday, 19. April 2008 um 11:56 Uhr
I too was very disappointed to see the removal of IP logging. Can you please make it available as an option once more?
I am now on WP-2.5 and don’t really wish to have to downgrade everything.
Best Regards
Al
Comment by The Open Sourcerer — Sunday, 20. April 2008 um 19:36 Uhr
just installed,
echo counterize_getfromcurrentip()
returns
Fatal error: Call to undefined function counterize_getfromcurrentip()
Comment by Chad — Tuesday, 22. April 2008 um 4:33 Uhr
The funny thing is, that the wordpress comment system stores the IP addresses from commenters, so why can’t you store it too?
Comment by The Open Sourcerer — Monday, 28. April 2008 um 0:50 Uhr
I just installed the latest version and yet I still got this same error on my two website. Any help is much appreciated.
WordPress database error: [Table './d60432199/wp_Counterize' is marked as crashed and last (automatic?) repair failed]
ALTER TABLE `wp_Counterize` ADD INDEX ( `timestamp` );
WordPress database error: [Table './d60432199/wp_Counterize' is marked as crashed and last (automatic?) repair failed]
UPDATE `wp_Counterize` set IP=MD5(IP);
Comment by pinoyconsole — Wednesday, 30. April 2008 um 23:41 Uhr
after i installed how come i don’t see IP address under Manage->Counterize II , please help me, thanks
Comment by Tiff — Friday, 2. May 2008 um 4:00 Uhr
Hi there, great plugin indeed.I’ve got the latest version (2.14.1.0), downloaded it from the wordpress plugin page.But there seems to be a problem with it.In Settings>Counterize II it shows “Counterize configuration – Version 2.013″ this, version 2.013 ? Is that right? And i don’t have the options, discribed in the article here, it doesn’t store ips and it does’t show the whereabout of the ip.Is it some problem with the version?Or is it something else?
Comment by mental — Wednesday, 14. May 2008 um 19:27 Uhr
[...] or Counterize II: this is a WONDERFUL WordPress Plugin. If you want something simple, installable, and pretty much [...]
Pingback by Terry Apodaca » Blog Archive » Website Statistics/Analytics — Wednesday, 14. May 2008 um 20:26 Uhr
i have mu system and i want the plugins auto configureted.
means- i dont want to enter to each user and configure the options.
do you have an idea how can i do that?
thanks,
rami
Comment by rami — Monday, 19. May 2008 um 19:43 Uhr
Nice plug in
One question, how to change display number in decimal format ? e.g 10.000 instead of 10000
Thank you
Comment by Eri — Tuesday, 10. June 2008 um 6:23 Uhr
Hi,
I used this plugin, but i have one question.
What time zone this plugin use for make new day, i mean i am in Indonesia, that timezone is + 7.00 .
I saw that the report like in my link, showing different amount between hit today and amoun hit in the day of this month.
What time cut off, morning 0 o’clock or 6 o’clock morning or 12.00 am/pm afternoon for Indonesia time.
or may any parameter can be set in the plugin?
thank be 4
Kastam – ID
Comment by Kastam — Thursday, 12. June 2008 um 6:58 Uhr
Hi and thanks much for the plugin. But i have a question : it’s possible to have a history of the connections of the users with their logins and dates of their connections?
I clarify that it’s a private blog thus with an access secured by password.I shall simply like knowing who connected and when. Thank you in advance for your answer.
Comment by Fibie — Monday, 23. June 2008 um 23:30 Uhr
[...] of the Counterize II plugin for WordPress, I’ve been trying to analyze traffic charts like this for the past few [...]
Pingback by Providing Ample Value [incoherence.net] — Wednesday, 9. July 2008 um 11:27 Uhr
Hi cool plug! Thanks!
my question is: Can I filter out my own machine. My own hits are skewing results I think….
Thanks in advance.
Comment by awsumgal — Thursday, 10. July 2008 um 17:57 Uhr
i have counterize II on my blog. how can i see hit counter on my sidebar.
thank you
Comment by percem — Friday, 11. July 2008 um 8:48 Uhr
i use this plugin… thanks to this plugin’s coders…
Comment by iLker AksoY — Friday, 18. July 2008 um 19:07 Uhr
Hi…
I’ve just tested your plugin, and it works great! the thing is, i’m having a problem with the “View Stats” page. it doesn’t print out the page name, just some “…”
can someone help me on this matter? Thanks!
Comment by jusuchin85 — Monday, 21. July 2008 um 17:59 Uhr
[...] new blogging engine. It has thousands of plugins, virtually one plugin per possible requirement. Counterize II is a powerful hit-tracking [...]
Pingback by Olaf's Thoughts About Development » Tracking Blog-Hits with WordPress — Friday, 1. August 2008 um 14:22 Uhr
hello, with this last version no table created, as i do not know create it, i try to take oldiest version, i take 2.14.00 , now ok 5 tables created, i have just now my first informations of stats ; i have persist because i had this plugin 1 year ago and it work at this time…
Comment by Annie — Friday, 1. August 2008 um 16:37 Uhr
Would like to bring to your attention the problem of referrer spam: http://www.wired.com/culture/lifestyle/news/2002/10/56017
And: http://en.wikipedia.org/wiki/Referer_spam
Your plugin, though greatly appreciated, has made my site vulnerable to this malicious form of advertising.
I notice that this issue was brought to your attention on October 4, 2007 (see below for a comment from your own site).
I suggest that for future versions of Counterize you implement the rel=”no follow” hyperlink structure to the Referrer section: http://en.wikipedia.org/wiki/Nofollow
Furthermore, it would be considerate to add an administrative option to turn off referrer stats.
I removed the following section of code to achieve the same result:
Comment by BGR — Friday, 1. August 2008 um 22:51 Uhr
i had counterize ii installed on my website and it was giving me some problems. i uninstalled it and dropped its tables from my db, i reinstalled it and it won`t create it`s tables and it`s not working at all, can anyone help me on this?
Comment by just a guy — Saturday, 23. August 2008 um 23:57 Uhr
does it work with wp-mu? i plunked it into the /plugins/ folder and activated using ‘plugin commander’. Only works on two of my blogs, doesn’t work on the rest. On another wp-mu install, it totally didn’t work. =(
Comment by sandg — Thursday, 28. August 2008 um 18:37 Uhr
Hey, i`m having some serious problems with this plugin, it keeps falling behind , i have another counter not in the wp itself, but another counter from a well knows network. The problem with counterize is that i have to activate it and deactivate it to keep correct track of my visitors otherwise it falls behind with several hunded visitors per day, how can i fix this ?
Comment by mike — Saturday, 27. September 2008 um 8:44 Uhr
Cannot load counterizeii/counterize.php.
I get this when I click the little arrow next to my count in the dashboard section.
What is going wrong?
I can see my stats in manage, but if I click reset filters, I get the same error
Thanks,
Linda
Comment by linda lee — Monday, 29. September 2008 um 1:56 Uhr
Is it working for wordpress 2.6 and above?
Comment by Karthikeyan — Sunday, 19. October 2008 um 13:47 Uhr
Is there any way to get past data? I noticed that when I installed the plugin it is only retrieving current users… we launched my blog about five days ago and would love to see some data on all of that– I’m assuming this isn’t possible, but was wondering if anyone knew of a way/there was an easy tweak.
-Melissa
Comment by Melissa — Tuesday, 21. October 2008 um 21:43 Uhr
[...] Counterize II – Es un plugin que muestra estadísticas sobre nuestros visitantes, tales como desde dónde vienen, que páginas visitan, la hora y fecha, total de visitas únicas y total de hits entre otras.La información es presentada mediante gráficos y tablas. [...]
Pingback by Plugins Wordpress para Contadores y Estadísticas :Como Ganar Dinero desde Casa — Wednesday, 22. October 2008 um 1:03 Uhr
hello,
i try to use counterize in french but it seems that it is not working with my configuration:
WordPress – Version 2.6
Counterize configuration – Version 2.013
Please if you have suggestions
Thanks
Comment by jerome — Wednesday, 22. October 2008 um 1:40 Uhr
i have activated the counterize plugins but it does not show any thing please help
There’s no data in the database – You can’t see stats until you have data.
Comment by sumit — Thursday, 23. October 2008 um 5:00 Uhr
hi, I love this plug in and I use it all the time, but the color bars do not show up in any of my host gator clients.
They do show up with godaddy.
I called hostgator and they have no idea.
Anyone else had this problem?
Thanks
Comment by linda lee — Friday, 24. October 2008 um 0:28 Uhr
Hi,
Love your plugin. It’s a nice passtime to look at the realtime stats.
On one website i just installed WP Supercache plugin which caches pages.
And I notice that in Counterize the visitor numbers are lower for that website.
Is that because my visitor numbers dropped or can’t Counterize measure the number correctly with WP Supercache?
That website is on WordPress 2.51 with Counterize 2.12.7 and WP supercache 0.8.4
Comment by handig — Saturday, 25. October 2008 um 10:10 Uhr
Thanks for this fine plugin. I use it on my site with no problems, but i installed it on another site and it is not counting anything. is there somewhere to look for error messages?
thanks
rw
Comment by rick whitley — Wednesday, 19. November 2008 um 17:43 Uhr
Hi,
At Manage->Counterize II I just get “no data in the database” even after I surf around a little, then deactivate and activate again. By reading these messages and googling I’ve found that adding the tables manually would help. However, I only have access to the blog but not to the sql tables. Is there any way to add the tables by temporarily modifying the counterize.php file in WP Plugin editor, and then changing it back? Just asking if it can be done?
Comment by john — Sunday, 23. November 2008 um 23:35 Uhr
Nevermind-
it started working by itself after a while without doing anything to the tables. Cool!
Comment by john — Sunday, 23. November 2008 um 23:51 Uhr
Hello
I’m using Counterize II and Google Analytics to track the usage of my site.
Both gives very different results. So, i’m very confuse.
Ex for september 2008
Google Analytics says: 2 (unique) visits
Counterize II says: 122 visits
So, i don’t know if I have 2 visitors (so, I have to stop or to do an hard work) or 122 visitors (so, it’s a good starting point to continue my work)
I someone able to comment about the difference?
I’ve a comment:”Google Analytics places a cookie on
your visitors computer that expires after 30 minutes, as long as that cookie
has not expired all of their pageviews are considered part of the same
visit.”
Thank you in advance
Jean-Claude
Comment by Jean-Claude — Thursday, 27. November 2008 um 8:59 Uhr
[...] is also a plugin for WordPress called "Counterize II" (Counterize II – English Rash thoughts about .NET, C#, F# and Dynamics NAV.) that I use which integrates stats right into the dashboard, and has a display very similar to that [...]
Pingback by Blog visits - Surpass Web Hosting Forums — Tuesday, 9. December 2008 um 2:10 Uhr
I have used this plugin for guite some time now, but I recently found out that since may it did not record anything. I can’t remeber changing anything. Any ideas?
Regards,
Bas
Comment by bvo — Sunday, 14. December 2008 um 10:00 Uhr
I too had problems in that the plugin did not record anything. I had migrated the plugin and data from an old server to a new server.
Counterize did not make new tables upon activation.
I solved the problem by:
#1. Deleted the entries in the wp_options table that had %count% in the option_name filed
#2. Removed the plugin files and re-installed the plugin files
#3. Activated the plugin
Comment by Niraj — Tuesday, 23. December 2008 um 0:27 Uhr
Thanks for this unique wp plugin. It seems quite informative.
Comment by Web Hosting — Tuesday, 3. February 2009 um 17:57 Uhr
Hello,
I am using CounterizeII since few weeks and still facing this problem : it counterizes “visits” coming from “/wp-admin/” (when I visualize an article draft for example)…
I’ve tried to modify counterize.php but nothing fixed this issue.
Anyone has an idea?
Thanks in advance.
Comment by PeF — Thursday, 5. February 2009 um 16:11 Uhr
This is a fantastic plugin! Thank you.
Comment by SimplicIT — Tuesday, 17. February 2009 um 12:33 Uhr
I can’t seem to get the backend of Counterize to display in English…everything is written in German and I’d like it to display in English.
How do I fix this?
Thanks.
Comment by AG — Sunday, 15. March 2009 um 23:26 Uhr
Hi, I have counterize II Ver 2.14.1 and I cant get to see the list of Ip’s hit in the counterize stat page.
Comment by G — Thursday, 2. April 2009 um 5:57 Uhr
[...] fix them. These are not made visible to search engine robots as well, until you correct them.” Counterize II: “Is a small Statistics-Plugin for WordPress, which saves IP, time stamp, visited URL, referring [...]
Pingback by The Best Blogging Tools Update | Tracy's Internet Marketing — Thursday, 14. May 2009 um 4:57 Uhr
Hi, sorry, i’m not good in english, anyway i want say to you i like your blugin and i translated it to arabic language, but i face problem with create tables in database. The problem is hapen when i deactivate the plugin and drop the tables from database, then i activate it again, but it’s don’t creating tables that needed to it’s, why? and what i do for create tables?.
Comment by Yasser — Friday, 29. May 2009 um 15:29 Uhr
I use Costumize II version 2.14.1
Comment by Yasser — Friday, 29. May 2009 um 15:32 Uhr
sorry i main counterize II 2.14.1
Comment by Yasser — Friday, 29. May 2009 um 15:37 Uhr
using the counterize II on my website and it is working fine only there is a warning error in my header. something that is new.
Warning: strpos() [function.strpos]: Empty delimiter in /home1/jasperho/public_html/wp-content/plugins/counterizeii/counterize.php on line 740
what does this mean and how can i fix it???
please email me if you have solutions. I can’t figure out exactly what is wrong.
jasperhomepage@hotmail.com
Thank you
Comment by Mitch — Saturday, 30. May 2009 um 1:15 Uhr
Using the counterize II and it has a warning appearing in the header:
Warning: strpos() [function.strpos]: Empty delimiter in /home1/jasperho/public_html/wp-content/plugins/counterizeii/counterize.php on line 740
What does this mean and how do I fix it??
Please help
Comment by mitch — Saturday, 30. May 2009 um 4:56 Uhr
I wrote in my comment above “main”, i was mean “mean” not “main”, i’m so sorry
.
Anyway, i solved the problem that i was face.
The solving is write following code in counterize.php file as first code to execute.
delete_option(‘counterize_MajorVersion’);
delete_option(‘counterize_MinorVersion’);
regards,
Comment by Yasser — Sunday, 31. May 2009 um 21:03 Uhr
Does counterize II work with WordPress 2.8?
Comment by MagMom — Thursday, 18. June 2009 um 6:59 Uhr
Is this plugin released under GPL-like Licence?
Comment by centree — Tuesday, 23. June 2009 um 3:00 Uhr
Can it be that the links to GEO ip tool are missing in the latest version?
Cheers, Matt.
Comment by Matt — Wednesday, 1. July 2009 um 23:20 Uhr
On your page http://www.navision-blog.de/counterize-ii-english/ and under the header “Features”, you say, “After you have installed Counterize II you will see a small overview on your dashboard:” Your page shows a small graphic of “Counterize Status”.
I’m using version 2.14.1. I do not see any control in my WP Dashboard for Manage/Counterize. I don’t get a “Counterize Status” graphic.
Can you tell me why this feature is not working for me?
Comment by Rokko — Monday, 27. July 2009 um 21:29 Uhr
Make sure the “counterizeii” plugin directory has write access available to ALL. That means if you’re looking in UNIX or using WinSCP via Windows, give the directory a permission value of 0777. (In english, mark all checkboxes for Write to ON).
When I first installed the plugin for our church’s website, it could not store data. Once I made that directory writable to all access, it worked like a charm!
Comment by Jason S — Thursday, 27. August 2009 um 5:00 Uhr
I received this error today when I tried to activate another plugin:
WordPress database error: [Too many keys specified; max 64 keys allowed]
ALTER TABLE wp_Counterize ADD INDEX ( timestamp );
This must have something to do with this plugin.
Shall I reset the counter?
– it has been on since 04.02.2008
Comment by Mikael Boldt — Friday, 28. August 2009 um 15:39 Uhr
great plugin, now I know my traffic details
thanks
Comment by akira mahawira — Friday, 28. August 2009 um 18:46 Uhr
if this plugin still supported IP Logging, it would have been the best statistic plugin out there
Are you really sure it’s illegal in Germany?
Comment by st4rtup — Tuesday, 1. September 2009 um 12:25 Uhr
Mikael the problem is a small typo in the file “counterize_install.php”. If you open the file and you go to the end you will find twice something like:
if($minorVersion < …
you have to change them to:
if($MinorVersion < …
please note the "M" of "minor" now capital.
In addition I would suggest you to remove all the duplicate indices of "timestamp" in the database (at least because they take a lot of space
), at the end you should have only one.
Comment by Emanuele — Saturday, 5. September 2009 um 17:11 Uhr
Hi. I installed Counterize II to keep track of my blog. I don’t seem to see any of those statistics or menus that you mention above except for the first one. Any ideas??
Thanks!
Comment by Patty — Tuesday, 8. September 2009 um 19:59 Uhr
that little M-thing helped thanks
Comment by Mikael Boldt — Saturday, 12. September 2009 um 20:04 Uhr
I have now deleted 60,000 timestamps – and my counter on the frontpage is now showing 60,000 visitors less.
this function is counting numbers of timestamps instead of looking at the ID of the latest arrival.
I solved the problem the lazy way:
Comment by Mikael Boldt — Sunday, 13. September 2009 um 17:25 Uhr
sorry codes got deleted tries to do it again
I have now deleted 60,000 timestamps – and my counter on the frontpage is now showing 60,000 visitors less.
this function is counting numbers of timestamps instead of looking at the ID of the latest arrival.
I solved the problem the lazy way:
Comment by Mikael Boldt — Sunday, 13. September 2009 um 20:20 Uhr
comments still deletes code
echo counterize_getamount()+60000
Comment by Mikael Boldt — Sunday, 13. September 2009 um 20:22 Uhr
I dont have error codes, but not show all information in wp-admin/edit.php?page=counterizeii/counterize.php, in Most searched keywords today(5)only soy 2 entries and no more.
excuse my english
Comment by Santi — Monday, 14. September 2009 um 12:07 Uhr
Just like comment #346 I also miss the IP Logging function.
Couldn’t you just make two versions – one for use in Germany and one for everyone else, and keep the second one on a COM domain?
Comment by Sokurah — Wednesday, 7. October 2009 um 23:47 Uhr
There is a BIG problem in the pluging: ALL Google Chrome users are marked as Safari users. This confusion is somewhat normal, but what really gets my goat is the ALL ALL ALL Google Chrome users (including me), no matter WHAT operating systems they are really using, are marked as using Mac OS X. This isn’t good for my demographic research.
Comment by Vistro — Thursday, 15. October 2009 um 23:47 Uhr
Disgusting documentation
Installed but not able to make it working.
Does this Plugin works only in sidebars or inside a page?
Please tell us where is the read documentation.
Comment by Mario — Wednesday, 21. October 2009 um 19:22 Uhr
Hi! I installed this plugin, but nothing happens. Repeat: NOTHING happens.
Tables have been created. Folder has been put 777 as permission. Linux server running.
I cannot understand how to make it work. Please, I need your help. Many thanks in advance!
Comment by ale_mar — Wednesday, 4. November 2009 um 9:42 Uhr
This plugin seems not more supported… :S
Comment by Cristian O. Balan — Thursday, 14. January 2010 um 11:42 Uhr
now i can see how many visitors visited my website by using this plugin. what are differences this plugin and google analytic?
it works like charm with wordpress 2.91
Comment by iphone 5g — Thursday, 28. January 2010 um 4:18 Uhr
The plug in seems to have a problem with the current version of WordPress. At first the dashboard summary seemed to drop the daily hit count part way through the day. On the dashboard page it will show the daily count first thing in the morning but then, later on in the day, it shows zeros. The users on line count still seems to be working. When I go to the statistics page, there is a heading for the hits for each day in the current month but no data displayed. Do you have a fix for this? Thanks, Dr. Smith
Comment by Dr. Earl R. Smith II — Monday, 1. February 2010 um 3:43 Uhr
How it is possible to show the stats not only for the admin user but also for editors? Thank you
Comment by Andrea — Monday, 22. February 2010 um 18:14 Uhr
[...] http://www.navision-blog.de/counterize-ii-english [...]
Pingback by Plugins para wordpress | Alex Santolaya — Saturday, 13. March 2010 um 10:14 Uhr
Hi,
I installed the plugin, it works, but I cannot see the IPs for individual visits at the bottom anymore, only “IDs” which counts the number of visits. How can I enable IP listing???
Comment by Ferrer — Monday, 15. March 2010 um 11:19 Uhr
[...] Counterize-II: A great plugin that fetches and displays total hits, unique hits, including IPs, time, URLs, referring URLs and browser-information. For back-end use, displays graphs and all statictics you ever need to know about your WordPress site. [...]
Pingback by Blog » XX Best/Useful Wordpress plugins — Tuesday, 23. March 2010 um 2:27 Uhr
I get these errors. Is there a fix?
Warning: Division by zero in /nfs/c02/h11/mnt/20263/domains/siteurl.com/html/says/wp-content/plugins/counterizeii/counterize.php on line 954
Warning: Division by zero in /nfs/c02/h11/mnt/20263/domains/siteurl.com/html/says/wp-content/plugins/counterizeii/counterize.php on line 954
Warning: Division by zero in /nfs/c02/h11/mnt/20263/domains/siteurl.com/html/says/wp-content/plugins/counterizeii/counterize.php on line 954
Comment by Roane — Tuesday, 23. March 2010 um 16:52 Uhr
[...] 1.Counterize IIをDL counterizeii.zip http://www.navision-blog.de/counterize-ii-english/ [...]
Pingback by カウンターを設置する « upomo! -日々コレ好日- — Sunday, 11. April 2010 um 11:07 Uhr
[...] ■Counterize II – English » Rash thoughts about .NET, C#, F# and Dynamics NAV. [...]
Pingback by Wordpressのおすすめアクセス解析プラグイン「Counterize II」と「WordPress.com Stats」 - Nakamori Report — Friday, 16. April 2010 um 1:39 Uhr
Hi
How do I add the shortcodes to my php files rather than the posts?
Thanks
Comment by James — Friday, 7. May 2010 um 11:55 Uhr
I am having the same problem as Dr. Smith (#360)
My stats zero out at 8pm and do not collect any data until midnight.
Thank you,
Paul from CoupleDumb.com
Comment by Paul Reyes-Fournier — Tuesday, 1. June 2010 um 13:32 Uhr
How do I change the time zone to my local time zone 10+
Comment by Tim — Thursday, 17. June 2010 um 2:25 Uhr
I can’t find documentation on Counterize II. I want to know more about the latest entries part of the stats. If I delete entries, will they be deleted from the rest of the statistics or am I merely deleting them from the “latest entries” area?
Thanks
Bon
Comment by Idearella — Thursday, 17. June 2010 um 10:12 Uhr
I keep getting the following error message on my website.
How can I fix it?
I’ve tried reinstalling the plugin 3 times now.
Warning: strpos() [function.strpos]: Empty delimiter in /home/abbarue1/public_html/science/wp-content/plugins/counterizeii/counterize.php on line 740
Comment by Harold Lehmann — Thursday, 22. July 2010 um 19:29 Uhr
Hi, thank you for the great plugin. But I just have one simple question: Does this automatically show your stats to your readers on the blog? Or is it a private counter, only seen on the dashboard?
Thank you so much!
Comment by Sasha — Friday, 23. July 2010 um 22:54 Uhr
Nice plugin.. Without errors for me
Comment by Consultor — Sunday, 25. July 2010 um 8:06 Uhr
Hi,
Is it possible to update Counterize II to work with WordPress 3.0? It’s a great plugin, but in the newest version of WP it doesn’t look fine. Thanks a lot!
Comment by Martin — Sunday, 15. August 2010 um 19:05 Uhr
Hi,
Nice graphics on this I had not problems loading. I do have one question. The unique IP hits does not jive with my google ad sense hits. Anyone know why the off set?
Comment by Joke Smith — Monday, 16. August 2010 um 3:15 Uhr
What does “unique hits” mean?
Comment by Bob Yarwood — Monday, 16. August 2010 um 22:55 Uhr
What does “unique” mean, as in “unique hits”?
Comment by bob_yarwood — Wednesday, 18. August 2010 um 12:54 Uhr
When the blog is viewed from the Edit page, it should not register as a hit on the counter.
Comment by bob_yarwood — Saturday, 21. August 2010 um 9:41 Uhr
See http://wordpress.org/support/topic/plugin-counterize-ii-post-installation-issues-counterizei-counterizeii?replies=2 I have installed counterize ii under WordPress 3.0.1 , but somehow it does not want to show OS, browser and recent entries data, even though I had some hits already. Any ideas why? Does it run well under 3.0.1 ?
Comment by Jasper — Wednesday, 25. August 2010 um 10:46 Uhr
Well, I have all the necessary tables for referrers,browsers and pages only no OS table. But they are not being populated. Why?
Comment by Jasper — Wednesday, 25. August 2010 um 12:54 Uhr
Well apparently population of tables takes some time. All working now. Would have been nice to see that in the readme as well as the counterizeii folder’s need for CHMOD 777. Just a suggestion..
Comment by Jasper — Wednesday, 25. August 2010 um 14:46 Uhr
I added three comments here yesterday. All gone! Well that problem was solved. Counterize took some time populating the database. See WordPress support on the story. I now need to return the ip column as in my jurisdiction this is allowed. How can I easily adjust the necessary files, tables?
Comment by Jasper — Thursday, 26. August 2010 um 6:34 Uhr
Hmm .. Sorry they are here now.. Odd. Please have a look at my questions in comment 382
Comment by Jasper — Thursday, 26. August 2010 um 6:34 Uhr