Hi,

when I activate the pager for the views "privatemsg_example" I get the following error message (did not check the other views yet):

user warning: 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 ') count_alias' at line 6 query: SELECT COUNT(*) FROM (SELECT MAX(pm_message.mid) AS mid FROM pm_message pm_message INNER JOIN pm_index pm_index ON pm_message.mid = pm_index.mid WHERE (pm_index.deleted = 0) AND (pm_index.uid = 1) GROUP BY ) count_alias in /var/www/vhosts/mysite.de/httpdocs/sites/all/modules/views/includes/view.inc on line 745.

Best,
Tobias

Comments

tobiberlin’s picture

Title: When pager is activated » When pager is activated get message "user warning: You have an error in your SQL syntax"
crea’s picture

This bug is fixed (workarounded) in dev. New release of the module is needed, but I don't have time for it.

crea’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.