Hi

I have a site with almost 1 thousand nodes. I've been using workflow for them for months without problems. Today I've added a couple of nodes and suddenly I got an error, here is the output:

    * 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) = workflow_node.nid LEFT JOIN term_node term_node ON node.nid' at line 1 query: SELECT count(DISTINCT(node.nid)) FROM node node LEFT JOIN workflow_node workflow_node ON DISTINCT(node.nid) = workflow_node.nid 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 WHERE (node.type IN ('version')) AND (workflow_node.sid IN ('4','6','5')) AND (term_data.name = 'Chronicles of Riddick, The - Escape from Butcher Bay') AND (node.nid != 766) in /home/macarro/www/includes/database.mysql.inc on line 174.
    * 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) = workflow_node.nid LEFT JOIN term_node term_node ON node.nid' at line 1 query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN workflow_node workflow_node ON DISTINCT(node.nid) = workflow_node.nid 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 WHERE (node.type IN ('version')) AND (workflow_node.sid IN ('4','6','5')) AND (term_data.name = 'Chronicles of Riddick, The - Escape from Butcher Bay') AND (node.nid != 766) GROUP BY node.nid, node_title ORDER BY node_title ASC LIMIT 0, 15 in /home/macarro/www/includes/database.mysql.inc on line 174.
    * 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) = workflow_node.nid LEFT JOIN term_node term_node ON node.nid' at line 1 query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, node_data_field_media.field_media_value AS node_data_field_media_field_media_value FROM node node LEFT JOIN workflow_node workflow_node ON DISTINCT(node.nid) = workflow_node.nid 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 LEFT JOIN content_type_analisis node_data_field_media ON node.vid = node_data_field_media.vid WHERE (node.type IN ('analisis')) AND (workflow_node.sid IN ('4','10','6','12','5','11')) AND (term_data.name = 'Chronicles of Riddick, The - Escape from Butcher Bay') GROUP BY node.nid, node_title ORDER BY node_title ASC in /home/macarro/www/includes/database.mysql.inc on line 174.
    * 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) = workflow_node.nid LEFT JOIN term_node term_node ON node.nid' at line 1 query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN workflow_node workflow_node ON DISTINCT(node.nid) = workflow_node.nid 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 WHERE (node.type IN ('truco_guia')) AND (workflow_node.sid IN ('4','10','6','12','5','11')) AND (term_data.name = 'Chronicles of Riddick, The - Escape from Butcher Bay') GROUP BY node.nid, node_title ORDER BY node_title ASC in /home/macarro/www/includes/database.mysql.inc on line 174.

I haven't touched anything in the configuration of the site. Anyone knows where could be the problem?

Kind regards.

PD.- link to the page with error http://www.pixelgordo.com/juego/chronicles-of-riddick-the-escape-from-bu...

Comments

NoRandom’s picture

NoRandom commented

Weird, it seems there is any kind of problem with the name of the node:

original title: "Chronicles of Riddick, The - Escape from Butcher Bay" -> error

If I rename the node to "foo" -> OK, error disappears.

...rename to "Chronicles of Riddick, The - Escape from Butcher Bay 2" - error again

...rename to "2 Chronicles of Riddick, The - Escape from Butcher Bay" - error again

Server is running with:

Drupal 5.16
MySQL 5.0.44
PHP 5.2.5-pl1-gentoo
Web server Apache/2.0.59 (Unix) mod_ssl/2.0.59 OpenSSL/0.9.8g

NoRandom’s picture

NoRandom commented

I did a little bit of research and it could be a views module problem, here is the full explanation: #443118: Problem with "title" argument.

Bastlynn’s picture

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

Hi,

With the release of Drupal 7, Drupal 5 is no longer receiving security updates, reviews, or development from many contributed modules. Since 5 is now considered a depreciated version, you really should seriously look into upgrading to Drupal 6 or 7. The newer versions of Drupal work better, have more support, and will be safer (literally! security patches!) for your website. We are currently working on a new release for Workflow to Drupal 7. In light of that, further support for Drupal 5 issues is infeasible at the moment. Please consider upgrading to Drupal 6 or 7 in the near future - you'll be glad you did.

- Bastlynn