This module in my opinion rivals many of the best essential modules drupal developers have to offer. Nothing says community website like operational avatar effects.

I have read the dialog that was written so far on this issue & I am having the same problem. The following message is showing up on the error report at the top of the screen.

user warning: Unknown table 'n' in on clause query: SELECT uid,name,picture FROM slcommunityusers INNER JOIN slcommunitynode_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'ogr_access') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 39 AND na.realm = 'og_admin'))) AND ( uid > 0 AND access > 0 AND picture <> "" ) ORDER BY created DESC LIMIT 0, 5 in /home/content/?/?/?/databasename/siteroot/foldername/drupalfolder/includes/database.mysql.inc on line 172.

When I went to the database there were many errors as simple as mispellings of the word 'error'. I don't know how much this matters. If there aren't any errors I don't know if anyone cares. However on the database.inc file there is a primary table = 'n'. I don't know what this makes reference to but it is the only thing I found that remotely looked like the unknown table that was being referenced.

I actually shut down imagecache and all the modules that came with it and tried to run Avatar Blocks without any of them. It still showed up while I was an administrator. As soon as I logged out, the same error message came up. Once I deactivated the Avatar Blocks module, the error message above ceased.

Hope this helps to start pinpointing the problem.

Comments

roopletheme’s picture

I think you also posted this to another active issue thread. I've responded here:

http://drupal.org/node/287300#comment-943520

Was there supposed to be a patch attached to this one?

roopletheme’s picture

Status: Needs review » Closed (duplicate)