[TheSupportForum]

Originally Posted by IGOTASTi

Here is my code.

if( $vbulletin->options['lpavatar_enable'] == 1 && $vbulletin->options['lpavatar_forumbit'] == 1 )
{
$counter_select .= iif($vbulletin->options['avatarenabled'], ', user.avatarrevision AS avatarrevision, forum.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight');
$tachyjoin .= iif($vbulletin->options['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)");
}

there are also other plugins that go with this
login to your hosting control panel and open up PHPMySQL or similar
you have to ensure that the fieldname e.g. avatarid etc exists

or the other option who be to uninstall it and reinstall the mod
sometimes it resolves the issue