Hi and thank you for this module,

Here is what my !site/fr/tracker displays :

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 'DESC LIMIT 0, 25' at line 1 query: SELECT DISTINCT(node.nid), last_comment_timestamp, node.type AS node_type, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN forward_statistics forward_statistics ON node.nid = forward_statistics.nid LEFT JOIN node_comment_statistics node_comment_statistics ON forward_statistics.nid = node_comment_statistics.nid LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='fr' OR i18n.language ='' OR i18n.language IS NULL) AND ( (node.status = '1') ) ORDER BY DESC LIMIT 0, 25 in /home/sfdwfstm/public_html/test2/includes/database.mysql.inc on line 172.

I don't know if it is a problem with the tracker module or with the forward module ?
Thank you for your help.

R

Comments

rconstantine’s picture

rconstantine commented

I have the same problem with slightly different errors:

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 'DESC LIMIT 0, 25' at line 1 query: SELECT node.nid, last_comment_timestamp, node.type AS node_type, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN forward_statistics forward_statistics ON node.nid = forward_statistics.nid LEFT JOIN node_comment_statistics node_comment_statistics ON forward_statistics.nid = node_comment_statistics.nid WHERE (node.status = '1') ORDER BY DESC LIMIT 0, 25...

The common thing is the forward module and disabling it returns things to normal. I will investigate further. For now, the devel module is pointing to a badly formed view.

rconstantine’s picture

rconstantine commented

BTW, seems that the 'ORDER BY' is what shouldn't be there.

seanr’s picture

seanr
he/him
commented

It's not the order by, it's that there's nothing between order by and desc. Not sure what's supposed to be there. Can you tell me what that query ends up looking like with forward turned off?

seanr’s picture

seanr
he/him
commented

BTW, please try also with the extra language stuff turned off just to narrow down potential conflicts a bit.

rconstantine’s picture

rconstantine commented

I found one solution. With devel's backtrace turned on, the page still prints to the screen everything else that should be there including navigation menus, etc. (I don't recall what it does with backtrace off). So I just clicked on the 'override' views tab and deleted the 'Sort criteria' altogether. Now everything is peachy!

I do not know which field it was supposed to be ORDERed BY. And you're right about the field being missing. That was an oversight on my part, obvious though it was. I hate to say it, but since I've got it working now, I don't really want to break it again to answer your questions. Sorry.

seanr’s picture

seanr
he/him
commented
Status: Active » Fixed

This page has completely changed and appears to be working for me, but please feel free to reopen if it's still not working for you with the latest versions of everything.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.