The next version of Counterize II (2.05) will be released during the next week. For now I am searching some Beta-Testers and translators for several languages (incl. German).
I have made a lot of small Bugfixes (like the famous DayOfWeek-Bugfix) and started to use the WordPress-LocalizationFramework.
The biggest changes concern the analysis sql-statements. I have completly rewritten the whole stuff and made some dramatic perfomance gains:
I have 100.000 log entries in my blog database. In version 2.04 it take 25 seconds to compute the complete statistics – in version 2.05 I need only 3 sec.
Version 2.05 supports external statistic pages – view my stats page.
If you want to test the new version 2.05 just write a comment and I will send you an email.
Tags: Counterize, English posts, Tools
I would like to test out this plugin. I use it on my site and have 100k+ log entries as well
Comment by Omer Hasan — Monday, 30. April 2007 um 13:38 Uhr
I noticed it is MUCH quicker than before. It used to take me well over a minute to load the page and it has been brought down to about 5-7 seconds. But the only problem I still have is I get these error messages I don’t know how to resolve.
First error:
WordPress database error: [Table 'web20_db1.wp_Counterize_Keywords' doesn't exist]
SELECT count as amount, keyword as label FROM wp_Counterize_Keywords where keywordID 1 GROUP BY keyword ORDER BY count DESC LIMIT 5
Second Error:
WordPress database error:
[Table 'web20_db1.wp_Counterize_Keywords' doesn't exist]
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 k.keywordID = r.keywordID and 1 = 1 ORDER BY m.timestamp DESC LIMIT 5
I realize that I need to create a table but I don’t know how. I do have phpmyadmin installed if that helps.
Comment by Omer Hasan — Tuesday, 1. May 2007 um 0:33 Uhr
I would love to test the new version.
Comment by Anthony — Tuesday, 1. May 2007 um 8:34 Uhr
Hi Omer,
i did not change anything within the table structure (from version 2.04 to 2.05) – but it seems your keywords-table does not exists.
Please use this statement:
CREATE TABLE `wp_Counterize_Keywords` (
`keywordID` int(11) NOT NULL auto_increment,
`keyword` varchar(255) NOT NULL,
`count` int(11) NOT NULL,
PRIMARY KEY (`keywordID`),
KEY `keyword` (`keyword`)
);
You can see the complete table-structure in the following textfile: http://www.navision-blog.de/download/sqlscript_020401.txt
Comment by Steffen Forkmann — Tuesday, 1. May 2007 um 8:58 Uhr
Thank you very much. That worked.
Comment by Omer Hasan — Tuesday, 1. May 2007 um 15:44 Uhr
What’s the code for creating a statistics page?
Comment by Omer Hasan — Tuesday, 1. May 2007 um 15:50 Uhr
Just write <!-- counterize_stats --> into one of your blog posts or pages.
Comment by Steffen Forkmann — Tuesday, 1. May 2007 um 15:52 Uhr
Just tried out. It works perfectly and way faster than before although I havent got so much log entries. The new statistic page works very well too.
Comment by Sebastian Wolf — Tuesday, 1. May 2007 um 18:45 Uhr
I don’t need a german translator anymore. I did it myself. But there are a lot of other languages out there….
Comment by Steffen Forkmann — Wednesday, 2. May 2007 um 13:44 Uhr
The GeoIP site GeoIPTool.com appears to be broken. I kept on getting IE cannot load the page. An alternative is http://www.ip-adress.com/ which works better with more accurate location. I changed reference in line 1355 of counterize.php to “http://www.ip-adress.com/?QRY=”. It works like a charm.
If you could add an configurable parameter on this, it would be perfect.
Thanks.
Comment by Jiwei — Friday, 21. December 2007 um 3:55 Uhr
I’d also like to suggest a feature. To me and most other people, unique visitors are far more important than hits. If you could add the graph for unique visitors per day, it’d be great.
I’d also like to be a beta tester to help develop future versions.
Comment by Jiwei — Friday, 21. December 2007 um 3:58 Uhr
my counterize dont works, why I installed 5 months ago y dont works? why?
Comment by Ricardo Lince — Wednesday, 30. July 2008 um 21:21 Uhr