Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By Anonymous (not verified) on
When I try to use the weblink top 10 block I getthe following error ...
user error: You have an error in your SQL syntax near 'SELECT n.nid, n.title, n.status, n.moderate, w.weblink, w.click FROM node n LEFT' at line 1
query: SELECT n.nid, n.title, n.status, n.moderate, w.weblink, w.click FROM node n LEFT JOIN weblink w on n.nid = w.nid WHERE n.type='weblink' AND n.status = 1 AND n.moderate = 0 ORDER by w.click DESC LIMIT SELECT n.nid, n.title, n.status, n.moderate, w.weblink, w.click FROM node n LEFT JOIN weblink w on n.nid = w.nid WHERE n.type='weblink' AND n.status = 1 AND n.moderate = 0 ORDER by w.click DESC, 10 in /var/www/drupalit/includes/database.mysql.inc on line 75.
