error on creating first album

blackfox - May 16, 2007 - 18:44
Project:Acidfree Albums
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:minor
Assigned:Unassigned
Status:closed
Description

I've just reinstalled acidfree on my testpage. when creating the first album I got 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) AS node_nid FROM node node LEFT JOIN term_node term_node ON ' at line 1 query: SELECT DISTINCT(node.nid), node.sticky AS node_sticky, DISTINCT(node.nid) AS node_nid FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid AND term_data.vid IN ('8') LEFT JOIN 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 = '19') GROUP BY node.nid ORDER BY node_sticky DESC, node_nid DESC LIMIT 0, 15 in /includes/database.mysql.inc on line 172.

The album was created correctly anyway and with a second album I couldn't reproduce this error... Maybe you can find something in the message above.

#1

vhmauery - May 17, 2007 - 03:16
Status:active» closed

You need to be sure that you are using the latest Views module. This may mean using a -beta version. Currently, this is 5.x-1.6-beta5.

If you are still experiencing this problem with the latest version of Views, file a bug against the Views module.

 
 

Drupal is a registered trademark of Dries Buytaert.