FCHouse A blog about our lives, our passions, our photos

Scaricato :-)

Stasera lo provo :-)

Posted by Enzo on 24 March 2006 @ 5pm

Hi!

It looks like a sweet plugin and it seems to work. I just get one problem and that’s when I click “Referral Domains”. I get this error:

WordPress database error: [Unknown column 'VIS_ReferralDomain' in 'having clause']
SELECT COUNT( * ) AS ‘Count’, VIS_ReferralDomain AS Domain FROM wp_FCHS_Visits WHERE VIS_DateTime>’0′ GROUP BY VIS_ReferralDomain HAVING VIS_ReferralDomain ” ORDER BY Count DESC;

I did check the table for the column and it is there, I also checked for typos. It seems to react the column name in the HAVING-clause but the column is called earlier in the request….

Any ideas?

Posted by Jens Ljungkvist on 8 April 2006 @ 8am

Hi Jens,
The error is quite strange… The best thing you should try is to get a copy of the plugin I have modified for you and test if it works. I have made a little change.

The Sql now should be “SELECT COUNT( * ) AS ‘Count’, VIS_ReferralDomain AS Domain FROM wp_FCHS_Visits WHERE VIS_DateTime>’0′ GROUP BY Domain HAVING Domain<>” ORDER BY Count DESC;“, but it is all in the linked file!

Please let me know if it works!

Cheers

Carlo

Posted by Carlo on 8 April 2006 @ 9am

Hey Carlo!

Yes it worked. Thanks!
Strange how this hasn’t happened to anyone else.
Do you know why?

Posted by Jens Ljungkvist on 9 April 2006 @ 9am

Hi Jens,
I think that it is a different version of MySql that is causing the problem.
I will correct the entire plugin, because I fear that there are more places where this trick is present.
By The Way I’m glad this is solved!

Cheers

Carlo

Posted by Carlo on 9 April 2006 @ 11am

Yes! That’s probably it.

I am using 3.23.54, but I am in the process of upgrading to 4.1.
Anything I should be afraid off?

Posted by Jens Ljungkvist on 9 April 2006 @ 3pm

Hi Jens!
I checked on FCHS plugin and I did not get any other problematic SQL queries, so the plugin should be ok now!

In some weeks I will release a new version of the plugin, with a lot of advanced features and with ajax!

I hope you appreciate the plugin!

Bye!

Posted by Carlo on 9 April 2006 @ 5pm

Carlo … a very nice idea, but it’s not producing any stats on my site? …. I am using a custom prefix for the WP SQL tables, but FCHS did create them in my database, but has made no entries since. Both my host and Statcounter say I have had visits. I get no error messages …. the stats pages all show with columns and formatting but no data.

Posted by dhkeller on 12 April 2006 @ 12am

Hi DHKELLER!

Does the tables has ANY record inside or you can’t see any info in the plugin?
Check the “table_prefix”FCHS_Visits and let me know!

Another question: did you install ip2nation? I found that it is not optional, but the tables are mandatory :(

Bye

Carlo

Posted by Carlo on 12 April 2006 @ 11am

Thanks for helping me!

The tables themselves are structured but empty, so the info in the admin panel also shows nothing. The ip2nation table is populated, but I did have trouble with it initially; I activated the plugin before the table was installed, and did get an error message in the plugin. The ip2nation table has since been installed, so no error message … but no data either.

I am running v0.3.2 on WP2.0.2. Could there be another problem with a missing prefix somewhere? I’m not sharp enough to find it.

Posted by dhkeller on 12 April 2006 @ 5pm

Hi DHKELLER,
the tables should be called “table_prefix”FCHS_”nameoftable”. Do your installation have these tables?
The problem seems to reside on the fact that you cannot write into the tables, but if the tablenames were wrong, it would write you an error message on the webpage that I cannot see. More of this it seems that the plugin is unable to track the page…
mmm… check the table names and let me know if also the Bots table is empty or not (and of course if the FCHS table prefix is the same of your prefix!

Cheers

Carlo

Posted by Carlo on 12 April 2006 @ 6pm

I have the following tables, all with no data:

Browse: (0 Rows) wge_FCHS_Bots
Browse: (0 Rows) wge_FCHS_Details
Browse: (0 Rows) wge_FCHS_Searches
Browse: (0 Rows) wge_FCHS_Visits

The prefix is correct (matches the rest of the WP tables). Could my host have a server setting or version that conflicts with FCHS plugin? I have other plugins using their own tables, and they all seem to work just fine. I had to have my host’s support team add the ip2nation table, which is also the first time I’ve ever had that problem with MySQL.

Posted by dhkeller on 12 April 2006 @ 8pm

Hi DH
Aorry for the late answer!
I do not think that the problem should come from a conflict in the config… the fact is that it seems that the event tracker is not working (the Wordpress part in which the statistic functions are launched)!
This is weird!
I will check for anything that should block them or that can makes FCHS goes wrong!

Posted by Carlo on 14 April 2006 @ 7am

thanks … for what it’s worth, everything seemed to be working well with this plug-in: http://www.thunderguy.com/semicolon/wordpress/search-meter-wordpress-plugin/

Posted by dhkeller on 19 April 2006 @ 3am

Hi,

Nice plugin! However, when the admin is logged in, the stat shouldn’t track the admin’s activity. For small blogs, admin’s activity can be deceiving. At least it should be configurable.

Also I’m using another plugin that uses the flags, so I thought of giving an option to change image paths (although I can easily hack it, as image paths only appear twice in the code).

Anyway, I hope you continue the good work!

Posted by Laexter on 18 June 2006 @ 9am

Hi Laexter!
the FCHS is still in Beta because I don’t have a lot of time to fix it, and also because I’m following other projects…
I will set up a Subversion repository for the modifications, in order to grant everyone the possibility to propose some modifications.
I was planning some major redesign to the plugin… but time has run out and other BIG changes (like changing nation :) has taken myself from this!

BTW: Thanks for the comment, I will try to make a small patch for it!

Carlo

Posted by Carlo on 18 June 2006 @ 1pm