I have a table that has a field call Team. In this field, there are two values: 'DS' and 'MF'.
When I set the Parameters-->Query in the field definition to:
select `team` from `j3_aqi_user_profile_data_v` where `id`='[user_id]'
Either DS or MF should be returned, depending on the value for the user.
If the user has MF set as their team, I see MF when I look at it the user's profile.
If the user has DS set as their team, I see / when I look at the user's profile
What in Joomla is returning a / when the value is DS?
Database Queries in Joomla Debug shows:
Code:
Query Time: 0.41 ms After last query: 0.64 ms Query memory: 0.010 MB Memory before query: 25.960 MB Rows returned: 1
select `team`
from `j3_aqi_user_profile_data_v`
where `id`='582'
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE j3_aqi_user_profile_data ALL NULL NO INDEX KEY COULD BE USED NULL NULL 61 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720
20 JDatabaseDriver->loadResult() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
19 CBLib\Database\Driver\CmsDatabaseDriver->loadResult() JROOT/components/com_comprofiler/plugin/user/plug_cbqueryfield/cbqueryfield.php:514
18 CBfield_query->getField() JROOT/libraries/CBLib/CB/Legacy/cbFieldHandler.php:100
17 cbFieldHandler->getFieldRow() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:881
16 cbPluginHandler->call() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1077
15 cbPluginHandler->callField() JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1375
14 cbTabs->_getSingleFieldContent() JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1290
13 cbTabs->_getFieldsContents() JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1025
12 cbTabs->_getTabContents() JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:314
11 cbTabs->generateViewTabsContent() JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:369
10 cbTabs->getViewTabs() JROOT/libraries/CBLib/CB/Legacy/CBuser.php:410
9 CBuser->getProfileView() JROOT/components/com_comprofiler/comprofiler.html.php:280
8 HTML_comprofiler::userProfile() JROOT/components/com_comprofiler/comprofiler.php:613
7 userProfile() JROOT/components/com_comprofiler/comprofiler.php:107
6 require_once JROOT/components/com_comprofiler/comprofiler.php JROOT/libraries/cms/component/helper.php:394
5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369
4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191
3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230
2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265
1 JApplicationCms->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
krileon
