Error 1064 for modules

Monday, October 20 2014, 01:59 PM

Offline

Hello

I have created a content statistics module - compare evolution in time and when I go to assign the module to a page and set the position then click save - I am getting a 1064 error in the front-end? Specifically it says '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 'GROUP BY DAY(date_event), MONTH(date_event), YEAR(date_event) ORDER BY date_even' at line 1 SQL=GROUP BY DAY(date_event), MONTH(date_event), YEAR(date_event) ORDER BY date_event'.

Please advise?

Responses (6)

Accepted Answer

Germinal Camps

Offline
Monday, October 20 2014, 03:16 PM - #Permalink
0

which are the setting of the module? can you make a screenshot?
The reply is currently minimized Show
Accepted Answer

JPC

Offline
Monday, October 20 2014, 03:57 PM - #Permalink
0

See attached of the settings. Advanced settings - I have made no changes

Attachments:

1.png

2.png

3.png

4.png

5.png
The reply is currently minimized Show
Accepted Answer

Germinal Camps

Offline
Monday, October 20 2014, 04:02 PM - #Permalink
0

The settings look correct. We must be missing something. Can you send me joomla access to the site at support@ joomlathat.com so I can take a look?
The reply is currently minimized Show
Accepted Answer

JPC

Offline
Tuesday, October 21 2014, 01:32 PM - #Permalink
0

I'm not sure I can give you access as the site is locked down in terms of IP...

I am running on Joomla 3.1.5 and it is producing this error with the compare evolution in time, evolution in time and rankings module. I guess if you have any suggestions or previous similar problem solutions it would be really good to know how you solved so I can try them..thank you..
The reply is currently minimized Show
Accepted Answer

Germinal Camps

Offline
Tuesday, October 21 2014, 04:06 PM - #Permalink
0

I really can't know without looking at it...

what I would suggest, to narrow down, the problem, is that you deactivate all stats module except one Evolution in time, for example, and try to make it work.

try for instance to change the "content provider" to something else to see if the results appear...
The reply is currently minimized Show
Accepted Answer

JPC

Offline
Monday, December 08 2014, 03:36 PM - #Permalink
0

Thanks, I have sent an email to support@joomlathat.com regarding this and will await your response.
The reply is currently minimized Show