Also confirmed for staging:

Joomla! 3.3.4-dev Development [ Ember ] 25-July-2014 13:00 GMT

When displaying a module of Type Popular Tags (mod_tags_popular) with Time Period set to Last Xyz an MySQL error is thrown

Error displaying the error page: 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 '2014-07-27 16:03:54'', INTERVAL -1 YEAR) AND `m`.`type_alias` = `c`.`core_type_a' at line 5

because date is single quoted twice in query string at

AND `tag_date` > DATE_ADD(''2014-07-27 16:03:54'', INTERVAL -1 YEAR)

Pull request will follow.
Opened On:
27 Jul 2014, 11:22 by Volkmar Schlothauer
Closed On:
28 Jul 2014, 1:10
Fixed in SVN/GitHub

Filed Under

  • Apache 2.2.x
  • First
  • Modules
  • MySQL 5.5.x
  • No Platform Implications
  • PHP 5.4.x


Posted on 27 Jul 2014, 11:34 by David Hurley

Confirmed. PR please quickly ;)
Posted on 27 Jul 2014, 11:39 by Volkmar Schlothauer

Pull request
Posted on 27 Jul 2014, 12:41 by Constantin Romankiewicz

Works fine, solves the issue for me.
Posted on 28 Jul 2014, 1:10 by Jean-Marie Simonet

Corrects the error. Merged. Thanks.