SQL Error when You hit the tracker folder after selecting my account after upgrading to mySQL 5.0.19

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;