I upgraded from rc4 to rc6. Afterward, I received the following:

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.title AS node_title, node.created AS node_created' at line 1 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.title AS node_title, node.created AS node_created FROM node node WHERE (node.type in ('story')) AND (node.status <> 0) ORDER BY node_created DESC ) AS count_alias in /mnt/data/apoba/drupal/sites/apobamain/modules/views/includes/view.inc on line 652.

and

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.title AS node_title, node.created AS node_created' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.title AS node_title, node.created AS node_created FROM node node WHERE (node.type in ('story')) AND (node.status <> 0) ORDER BY node_created DESC LIMIT 0, 10 in /mnt/data/apoba/drupal/sites/apobamain/modules/views/includes/view.inc on line 677.

Both of these errors can be viewed at http://apoba.zanlus.com

I've run mysqlcheck -e apobamain with no luck.

Although this seems to indicate a problem in the Views tables, I can't help but think it is a CCK issue, given that it occurred only after updating CCK.

Comments

zanlus’s picture

zanlus commented

Sorry, by "I've run mysqlcheck -e apobamain with no luck", what I mean is that it says that all tables are ok.

yched’s picture

yched commented
Status: Active » Closed (won't fix)

I know there is currently problems around the 'distinct' setting in Views.
It might have been awakened by the rc4 to rc6 upgrade, but AFAICT this is not bug for CCK.
Search the Views issue queue