0
Hi there
I purchased your fantastic Content Statistics. I am now starting to use it with my project.
I seem to be getting a problem, when i create the Content Statistics Compare Evolution In Time module for the front-end, i want to create module that shows data to the logged in user / the user who is currently viewing. Each time i select that option from back-end module i get this error message on front-end of my joomla site. Here is the error message:
SQL=SELECT COUNT(st.id) AS howmuch, st.date_event FROM fd6ht_content_statistics as st WHERE st.type = 1 AND st.reference_id = AND st.component = "com_community" AND st.date_event BETWEEN SUBDATE(CURDATE(), 7) AND NOW() AND st.user_id = 543 GROUP BY DAY(date_event), MONTH(date_event), YEAR(date_event) ORDER BY date_event
I have tried testing setting up module to track all users and it seems to work fine, but just getting error message when selecting > Current User.
Please help with this frustration!
Your product, help and support is much appreciated.
Thank you for such a great joomla extension i look forward to getting it working.
Mark
I purchased your fantastic Content Statistics. I am now starting to use it with my project.
I seem to be getting a problem, when i create the Content Statistics Compare Evolution In Time module for the front-end, i want to create module that shows data to the logged in user / the user who is currently viewing. Each time i select that option from back-end module i get this error message on front-end of my joomla site. Here is the error message:
SQL=SELECT COUNT(st.id) AS howmuch, st.date_event FROM fd6ht_content_statistics as st WHERE st.type = 1 AND st.reference_id = AND st.component = "com_community" AND st.date_event BETWEEN SUBDATE(CURDATE(), 7) AND NOW() AND st.user_id = 543 GROUP BY DAY(date_event), MONTH(date_event), YEAR(date_event) ORDER BY date_event
I have tried testing setting up module to track all users and it seems to work fine, but just getting error message when selecting > Current User.
Please help with this frustration!
Your product, help and support is much appreciated.
Thank you for such a great joomla extension i look forward to getting it working.
Mark
Responses (7)
-
Accepted Answer
0Hello Mark,
"Current User", what will do is to show data ONLY "generated" by the viewing user. in this case I see you're using it for JomaSocial.
you seem to want to display "user profile views". but what you have selected would show user profile views PERFORMED by this user, NO the views that this particular user's profile has received.
do you know what I mean? -
Accepted Answer
0Hi there Germinal
Thank you for your very swift reply, it is much appreciated.
Forgive me for being a little confused.
Yes, i am using this to show the logged in user on the front-end an activity chart for some of their activity in the Com_Community (JomSocial)
Am i correct in assuming this will display to logged in registered users, a data chart relating to only that users activity , yes ?
Thank you again-
Germinal Campsmore than a month agoActually, not. if you want a graphic, where the logged in user can see "how many visits did his profile had" (is that it?), then actually a little code tweak on the code is necessary, because what it will show now is either actions made BY HIM, or what you want, but only if it's displayed in the user profile page (not outside of it). do you know what I mean?
-
-
Accepted Answer
0Hi Germinal.
Thank you again for clarifying that, that is great. I understand now.
So let me confirm, this module would need to be added to the jomsocial profile pages, and it will display how many views that profile page has had whilst user is on that particular page ?
This will still be great for my project, i just need to be able to show some activity data charts on the front-end of my JomSocial community.
Please clarify - If i add this module to the JomSocial Group pages, and select > Content Criteria > Group Page Comments. Selector > Current Group / profile etc. It will display the data chart for the group comments on that group page that is being viewed , yes ?
Thank you again for you really great support -
Accepted Answer
-
Accepted Answer
0Hey Germinal
This is really fantastic.
I understand this now, it is all working as i hoped
One last quick question for you - I seem to be having a problem displaying the chart when i publish the module on to a page where i am using a custom Joomla template. When i display module on page using standard Joomla Protostar template everything displays, but when i publish module to page where i am using a custom Joomla template the chart does not display.
I believe it may be due to some Jquery / Javascript conflicts with my template. Have you any idea what may be causing the issue ?
As my template already uses Jquery library, i have unset / removed default Joomla Jquery reference from Joomla head tag, of my custom template..
Could this cause a problem ?
Thank you again -
Accepted Answer
-
Accepted Answer
0Hi Germinal
Thank you again for your much fantastic support.
I will come back and perhaps raise a different support ticket regarding the templating issue. I will see if i can look at it myself, and perhaps revisit if i need to call upon your awesome support.
Thank you again, i would like to purchase other products from JoomlaThat in the future, your products and support are world class.
Thank you again.-
Germinal Campsmore than a month agono problem! thanks for your very kind words.
-
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »