Complete error message:

user warning: Unknown column 'n.language' in 'where clause' query: SELECT DISTINCT sid, MIN(timestamp) AS timestamp FROM accesslog WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( path = 'node/1' AND uid = 0 AND timestamp >= 1285365600 AND timestamp <= 1285624800 )GROUP BY sid ORDER BY sid in /opt/lampp/htdocs/drupal/sites/all/modules/pathtrack/pathtrack.module on line 150.

Solution from similar issue #853364: Unknown column 'n.language' in 'where clause' query: SELECT nn.nid FROM node works for me. (add [, 'nn'] to db_rewrite_sql in line 150 and line 159)

Comments

xibun’s picture

xibun commented

after further testing... to see pages in other languages the change is also required in lines 56, 114 and 267.

(additional note: other modules solved this error by removing "db_rewrite_sql" completely)