I've an error 1054 because of c.thumb in profilevisits.php & vendorsprofile.php.
Unknown column 'c.thumb' in 'field list' SQL=SELECT u.username , c.thumb AS avatar FROM #__users u LEFT JOIN #__community_users c ON c.userid = u.id WHERE u.id = '762'
In profilevisits: if($profileman=='cb')
$q .= ', c.avatar AS thumb , c.avatarapproved ';
elseif($profileman=='js')
$q .= ',c.thumb';
In vendorprofile: if(!$userid)
$userid = $user->id;
$q = "SELECT u.".$naming." ";
if($profileman=='cb')
$q .=", c.avatar ";
elseif($profileman=='js')
$q .=", c.thumb AS avatar ";
How to fix this?