If u want to search members with only picture. It shows with and without pics?

Whats wrong here?
i use Jommla and cb latest version.

When i turn on the wrongsarch function it says:

500 - JDatabaseMySQL::query: 1146 - Table 'mysite_com.jos_gj_users' doesn't exist SQL=SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id AND s.id_user = 12316Du kan kanske inte se denna sida eftersom:

JDatabaseMySQL::query: 1146 - Table 'datedirekt_se.jos_gj_users' doesn't exist SQL=SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id AND s.id_user = 12316


Call stack
# Function Location
1 JSite->render() /customers/mysite/mysite.com/httpd.www/index.php:79
2 JDocumentHTML->render() /customers/mysite/mysite.com/httpd.www/includes/application.php:168
3 JDocumentHTML->_parseTemplate() /customers/mysite/mysite.com/httpd.www/libraries/joomla/document/html/html.php:249
4 JDocumentHTML->getBuffer() /customers/mysite/mysite.com/httpd.www/libraries/joomla/document/html/html.php:386
5 JDocumentRendererModules->render() /customers/mysite/mysite.com/httpd.www/libraries/joomla/document/html/html.php:190
6 JDocumentRendererModule->render() /customers/mysite/mysite.com/httpd.www/libraries/joomla/document/html/renderer/modules.php:41
7 JModuleHelper->renderModule() /customers/mysite/mysite.com/httpd.www/libraries/joomla/document/html/renderer/module.php:84
8 require() /customers/mysite/mysite.com/httpd.www/libraries/joomla/application/module/helper.php:173
9 require() /customers/mysite/mysite.com/httpd.www/modules/mod_cb_superthumb/mod_cb_superthumb.php:67
10 JDatabaseMySQL->loadObjectList() /customers/mysite/mysite.com/httpd.www/modules/mod_cb_superthumb/tmpl/default.php:77
11 JDatabaseMySQL->query() /customers/mysite/mysite.com/httpd.www/libraries/joomla/database/database/mysql.php:458
12 JError->raiseError() /customers/mysite/mysite.com/httpd.www/libraries/joomla/database/database/mysql.php:231
13 JError->raise() /customers/mysite/mysite.com/httpd.www/libraries/joomla/error/error.php:171
14 JException->__construct() /customers/mysite/mysite.com/httpd.www/libraries/joomla/error/error.php:136

Post edited by: krileon, at: 2010/12/17 17:14

Thanks, when turning superthumb of the problem. The problem of seraching for a s úser with only picture doesent work. It still show a list of members with and without pics (nophoto).

When trying to search for wrong in the backend i can see under the Fieldlist as follow (Can you see any wrong here?):

SQL question logged
1. DELETE
FROM jos_session
WHERE ( time < '1290628620' )
2. SELECT *
FROM jos_session
WHERE session_id = 'blablabla'
3. UPDATE `jos_session`
SET `time`='1290718620',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1'
WHERE session_id='1blablabla'
4. SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
5. SELECT *
FROM jos_components
WHERE parent = 0
6. SELECT COUNT(*)

FROM jos_comprofiler_lists AS a
7. SELECT listid, title, description, published,`default`,ordering,useraccessgroupid

FROM jos_comprofiler_lists a

ORDER BY ordering
LIMIT 0, 100
8. SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0
9. SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 1
ORDER BY position, ordering
10. SELECT a.name, a.admin_menu_link, a.admin_menu_img
FROM jos_components AS a
INNER JOIN jos_components AS b
ON b.id = a.parent
WHERE b.OPTION = 'com_comprofiler'
AND b.parent = 0
ORDER BY a.ordering ASC
11. SELECT a.*, SUM(b.home) AS home
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
GROUP BY a.id
12. SELECT *
FROM jos_components
WHERE `option` <> "com_frontpage"
AND `option` <> "com_media"
AND enabled = 1
ORDER BY ordering, name
13. SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 62
14. SELECT COUNT( session_id )
FROM jos_session
WHERE guest <> 1

Sorry, what i am trying to explain is:

Whe you are logged in. And trying the search function.

Say you want to search members in london, 18--30 years old, with photos only.


The results always show members with and without photos.

There must be something wrong becuase the search list can´t list members just with photo as a result of a search.