The error you will recive would be similar to

user error: Unknown column 'n.nid' in 'on clause'
query: SELECT COUNT(n.nid) FROM node n, term_node t LEFT JOIN comments c ON n.nid = c.nid WHERE n.nid = t.nid AND n.status = 1 AND (n.uid = 248 OR c.uid = 248) in \includes\database.mysql.inc on line 66.

Which stems from the line 189 of xtracker.module which is
$sql_count = 'SELECT COUNT(n.nid) FROM {node} n, {term_node} t LEFT JOIN {comments} c ON n.nid = c.nid WHERE n.nid = t.nid AND n.status = 1 ' . $sql_where;

It seems that when upgrading from 4.1.x to 5.0.1x the position of the tables in the FROM statement for a LEFT JOIN is significant. By switching the code "FROM {node} n, {term_node} t LEFT JOIN" to "FROM {term_node} t,{node} n LEFT JOIN" the resultant SQL call will operate as expected for both release 4 and 5 of mySQL versions of the code.

Here is the affected code with the changes in place.

$sql_count = 'SELECT COUNT(n.nid) FROM {term_node} t,{node} n LEFT JOIN {comments} c ON n.nid = c.nid WHERE n.nid = t.nid AND n.status = 1 ' . $sql_where;

Comments

jayesh’s picture

jayesh commented

Still code is not working.

It shows no data to be displayed.

What to do ?

uncue’s picture

uncue commented

Fresh install of 4.7.2 on Ubuntu 6.06 Server LTS mySQL 5.0.19

same problem. I'm disabling the module. If you could fix it, that would be great.

Uncue

uncue’s picture

uncue commented

My apologies. The SQL statement does resolve my problem. I'm not sure if it causes errors in SQL 4, but if not this fix should be added to the module.

thanks again!

Uncue

uncue’s picture

uncue commented

Also statement in question is on line 198 not 189.

Csabo’s picture

Csabo commented

I had the same problem after installing xtracker using same MySQL. Applied this fix, it works fine now. Thanks for the patch! (It should be fixed in the module though.)