I get the following error when visiting my group home page (and a few other pages around my site).

user warning: Unknown column 'nid' in 'field list' query: SELECT nid from files where filepath like '%myimage.jpg' in /home/mysite/public_html/sites/all/modules/og_user_roles/og_user_roles.module on line 2339.

If I refresh the page the error disappears, but will come back the next time I revisit the page. I'm using og 6.x-1.0-rc6 and the latest 6.x-dev versions of filefield and imagefield to upload the file called myimage.jpg to my group node (I'm not using the built in group logo function in og_user_roles). I have clear cache enabled in og_user_roles.

I already applied the patch in #325559 so my line 2339 reads:

$file = db_fetch_object(db_query("SELECT nid from {files} where filepath like '%s'", '%' . $basename));

Comments

somebodysysop’s picture

somebodysysop commented
Status: Active » Fixed

Re-checked the distribution code here to be absolutely sure:

http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/og_user_rol...

In the official OGUR 6.x distribution, the line you identify has been commented out and replaced by this line:

        $file = db_fetch_object(db_query("SELECT u.nid FROM {files} f INNER JOIN {upload} u ON f.fid = u.fid where f.filepath like '%s'", '%' . $basename));

So, either you have modified the code in question, or the code you have is not the official 6.x distribution.

If I'm wrong about this, please let me know, otherwise the fix for this is to download the official 6.x distribution here:

http://ftp.drupal.org/files/projects/og_user_roles-6.x-1.x-dev.tar.gz

sjf’s picture

sjf commented

You're absolutely right - It is the official 6.x. distribution but I had misapplied the patch and uncommented out the line rather than removing it completely. Sorry...

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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