Closed (won't fix)
Project:
Views Alpha Pager
Version:
5.x-1.4
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
13 Aug 2008 at 03:57 UTC
Updated:
3 Feb 2013 at 16:24 UTC
Enabling alpha pager results in the following error message:
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 'DISTINCT(node.nid), node_created_created ORDER BY LEFT(TRIM(LEADING 'AND ' FROM ' at line 1 query: SELECT DISTINCT(node.nid), node.created AS node_created_created, users.uid AS users_uid, node.title AS node_title, node.changed AS node_changed FROM node node INNER JOIN users users ON node.uid = users.uid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( (node.status = '1') AND (node.type IN ('bio')) AND (LEFT(TRIM(LEADING 'AND ' FROM (TRIM(LEADING 'THE ' FROM (TRIM(LEADING 'A ' FROM (TRIM(LEADING '\'' FROM (TRIM(LEADING '"' FROM (TRIM(LEADING ' ' FROM (UPPER(node.created))))))))))))), 1) = 'All') ) GROUP BY DISTINCT(node.nid), node_created_created ORDER BY LEFT(TRIM(LEADING 'AND ' FROM (TRIM(LEADING 'THE ' FROM (TRIM(LEADING 'A ' FROM (TRIM(LEADING '\'' FROM (TRIM(LEADING '"' FROM (TRIM(LEADING ' ' FROM (UPPER(node.created))))))))))))), 1), node_created_created ASC LIMIT 0, 10 in /var/www/drupal57-jq12/includes/database.mysql.inc on line 172.
Comments
Comment #1
pomliane commentedThis version of Views Alpha Pager is not supported anymore. The issue is closed for this reason.
Please upgrade to a supported version and feel free to reopen the issue on the new version if applicable.
This issue has been automagically closed by a script.