500 - JDatabaseMySQL::query: 1052 - Column 'name' in order clause is
ambiguous SQL=SELECT ue.*, u.*, '' AS 'NA' FROM jos_comprofiler ue,
jos_users u WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1
AND u.gid IN ( 18, 19, 20, 21, 30, 23, 24, 25) AND u.`id` = ue.`id`
ORDER BY `name` ASC LIMIT 0, 10

*You may not be able to visit this page because of:*

   1. an *out-of-date bookmark/favourite*
   2. a search engine that has an *out-of-date listing for this site*
   3. a *mistyped address*
   4. you have *no access* to this page
   5. The requested resource was not found.
   6. An error has occurred while processing your request.

*Please try one of the following pages:*

    * Home Page </index.php>

If difficulties persist, please contact the System Administrator of this
site.

JDatabaseMySQL::query: 1052 - Column 'name' in order clause is ambiguous
SQL=SELECT ue.*, u.*, '' AS 'NA' FROM jos_comprofiler ue, jos_users u
WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND u.gid IN
( 18, 19, 20, 21, 30, 23, 24, 25) AND u.`id` = ue.`id` ORDER BY `name`
ASC LIMIT 0, 10

*Call stack*	
*#*		*Function*		*Location*	
1		JSite->dispatch()		/home/content/o/u/r/ourtimeofneed/html/index.php:68	
2		JComponentHelper->renderComponent()	
/home/content/o/u/r/ourtimeofneed/html/includes/application.php:124	
3		require_once()	
/home/content/o/u/r/ourtimeofneed/html/libraries/joomla/application/component/helper.php:162

4		usersList()	
/home/content/o/u/r/ourtimeofneed/html/components/com_comprofiler/comprofiler.php:93

5		CBdatabase->loadObjectList()	
/home/content/o/u/r/ourtimeofneed/html/components/com_comprofiler/comprofiler.php:1013

6		CBdatabase->query()	
/home/content/o/u/r/ourtimeofneed/html/administrator/components/com_comprofiler/library/cb/cb.database.php:838

7		JDatabaseMySQL->query()	
/home/content/o/u/r/ourtimeofneed/html/administrator/components/com_comprofiler/library/cb/cb.database.php:673

8		JError->raiseError()	
/home/content/o/u/r/ourtimeofneed/html/libraries/joomla/database/database/mysql.php:229

9		JError->raise()	
/home/content/o/u/r/ourtimeofneed/html/libraries/joomla/error/error.php:171	
10		JException->__construct()	
/home/content/o/u/r/ourtimeofneed/html/libraries/joomla/error/error.php:136