[SOLVED] Search users cant show only with pics?

8 years 11 months ago #146994 by Mike999
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
8 years 11 months ago #147019 by krileon
Error seams to be coming from mod_cb_superthumb. A module called SuperThumbs? It appears to be searching for GJ 1.8 database tables which you don't appear to have. Please if possible review the modules parameters and configure it to not display GJ information. Otherwise please unpublish and confirm if issue still present.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Templates - CBSubs - Hosting - Forge - Incubator - GroupJive
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM EST to 4:00 PM EST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
8 years 11 months ago #147041 by Mike999
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
8 years 11 months ago #147065 by krileon

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?):

Sorry, don't understand your issue. Please better explain what the problem is.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Templates - CBSubs - Hosting - Forge - Incubator - GroupJive
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM EST to 4:00 PM EST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
8 years 11 months ago #147078 by Mike999
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.
8 years 11 months ago #147143 by krileon
Please upgrade to CB 1.3 and confirm if issue still present, thank you.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Templates - CBSubs - Hosting - Forge - Incubator - GroupJive
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM EST to 4:00 PM EST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Moderators: beatnantkrileon
Time to create page: 0.421 seconds
Facebook Twitter Google LinkedIn