Joomla x3 doesn't recognize c.thumb in VMvendor

  • Topic Author
  • Visitor
  • Visitor
4 years 11 months ago #43635 by
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?

Please Log in or Create an account to join the conversation.

Time to create page: 0.301 seconds
Powered by Kunena Forum
Disclaimer: Nordmograph is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.