I recently upgraded my site to the newest head version, 3/12. After adding an album, I get the following 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 'LIMIT 0, 15' at line 1 query: SELECT DISTINCT(node.nid), node.sticky AS node_sticky FROM drupal_node node LEFT JOIN drupal_term_node term_node ON node.nid = term_node.nid LEFT JOIN drupal_term_data term_data ON term_node.tid = term_data.tid AND term_data.vid IN ('2') LEFT JOIN drupal_term_node term_node2 ON node.nid = term_node2.nid WHERE (term_node.tid IS NOT NULL) AND (term_data.tid IS NOT NULL) AND (node.status = '1') AND (term_node2.tid = '43') GROUP BY node.nid ORDER BY node_sticky DESC, LIMIT 0, 15 in **/database.mysql.inc on line 172.
I have tried adding a couple albums in different locations to see if the error continues. The error always appears, but the album is created.
Comments
Comment #1
janosch commentedLook here ;)
http://drupal.org/node/123481