Dear all, I get the following error message (actually using both dev and regular releases)
user warning: Unknown column 'viewers.uid' in 'field list' query: SELECT viewers.uid, users.name FROM drupal_viewers INNER JOIN drupal_users ON users.uid = viewers.uid WHERE page = 'node/705' AND viewers.uid <> 0 in ......./sites/all/modules/viewers/viewers.module on line 231.
This is the offending line:
$query = db_query("SELECT viewers.uid, users.name FROM {viewers} INNER JOIN {users} ON users.uid = viewers.uid WHERE page = '%s' AND viewers.uid <> %d", $path
This query only works if no table prefixes have been used during installation. It should either read
$query = db_query("SELECT {viewers}.uid, {users}.name FROM {viewers} INNER JOIN {users} ON {users}.uid = {viewers}.uid WHERE page = '%s' AND {viewers}.uid <> %d", $path, 0);
or
$query = db_query("SELECT viewers.uid, users.name FROM {viewers} viewers INNER JOIN {users} users ON users.uid = viewers.uid WHERE page = '%s' AND viewers.uid <> %d", $path, 0);

Thanks for the nice module btw!
John

Comments

apanag’s picture

Status: Needs review » Fixed

Hello wickedwookie,
you 're right. I just uploaded a fixed version, using your second way.

Thank you,
apanag

Status: Fixed » Closed (fixed)

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