Hello,

I just installed the google analytics statistics module and tried to create a view of taxonomy terms.
I want to pull out the most popular article tags.
I created a taxonomy term view and after that a relationship to the content tagged with this taxonomy.
After that when I hit to preview it displays:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ga_stats_count_pageviews_today.metric' in 'on clause'

It looks like the module didnt installed correctly so I installed it again, but with no luck.

Am I doing something wrong or is it the module that is doing something wrong?

thanks!

Comments

drupalerocant’s picture

drupalerocant commented
Issue summary: View changes
drupalerocant’s picture

drupalerocant commented

I am still having the same problem, and don't know how to solve it.
I think the problem comes with the relationship 'Representative node'.
The module is working correctly in another view I have that orders the most popular content.
With this one no problem, but when it comes through the relationship I get the same error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ga_stats_count_pageviews_today.metric' in 'on clause'

Thanks in advance for any help!

cojobo’s picture

cojobo commented

Just in case someone else is having this problem, I found a work around that worked for me. I created a field with the Google statistic without a relationship. Then create an additional Google statistic field with the relationship that I wished to have. I then hide the first Google statistic field that was not relevant to the view I was trying to create. Strangely enough, this by passed the error.