Skip to Content Skip to Menu

[SOLVED] fields with several cumulative values

  • mfe13
  • mfe13
  • OFFLINE
  • Posts: 572
  • Thanks: 26
  • Karma: 5
10 years 9 months ago #239666 by mfe13
Replied by mfe13 on topic fields with several cumulative values
Hi,

Hits and Connections fields works in profile user but no delimiter but not the delimiter that contains the query response.

In debug mode, there is this error 500.
Code:
JDatabaseMySQL::query: 1054 - Unknown column 'connections' in 'field list' SQL=SELECT ( `hits` + `connections` ) FROM `tig13_comprofiler` WHERE `id` = '49' Call stack # Function Location 1 JSite->dispatch() /home/geniusyoX/www/index.php:42 2 JComponentHelper::renderComponent() /home/geniusyoX/www/includes/application.php:197 3 JComponentHelper::executeComponent() /home/geniusyoX/www/libraries/joomla/application/component/helper.php:351 4 require_once() /home/geniusyoX/www/libraries/joomla/application/component/helper.php:383 5 userProfile() /home/geniusyoX/www/components/com_comprofiler/comprofiler.php:290 6 HTML_comprofiler::userProfile() /home/geniusyoX/www/components/com_comprofiler/comprofiler.php:710 7 CBuser->getProfileView() /home/geniusyoX/www/components/com_comprofiler/comprofiler.html.php:434 8 cbTabs->getViewTabs() /home/geniusyoX/www/administrator/components/com_comprofiler/plugin.foundation.php:1159 9 cbTabs->generateViewTabsContent() /home/geniusyoX/www/administrator/components/com_comprofiler/comprofiler.class.php:3432 10 cbTabs->_getTabContents() /home/geniusyoX/www/administrator/components/com_comprofiler/comprofiler.class.php:3391 11 cbTabs->_getFieldsContents() /home/geniusyoX/www/administrator/components/com_comprofiler/comprofiler.class.php:3947 12 cbTabs->_getSingleFieldContent() /home/geniusyoX/www/administrator/components/com_comprofiler/comprofiler.class.php:4115 13 cbPluginHandler->callField() /home/geniusyoX/www/administrator/components/com_comprofiler/comprofiler.class.php:4177 14 cbPluginHandler->call() /home/geniusyoX/www/administrator/components/com_comprofiler/plugin.class.php:375 15 call_user_func_array() /home/geniusyoX/www/administrator/components/com_comprofiler/plugin.class.php:583 16 cbFieldHandler->getFieldRow() 17 CBfield_query->getField() /home/geniusyoX/www/administrator/components/com_comprofiler/plugin.class.php:815 18 CBfield_query->getQuery() /home/geniusyoX/www/components/com_comprofiler/plugin/user/plug_cbqueryfield/cbqueryfield.php:89 19 CBdatabase->loadResult() /home/geniusyoX/www/components/com_comprofiler/plugin/user/plug_cbqueryfield/cbqueryfield.php:186 20 JDatabase->loadResult() /home/geniusyoX/www/administrator/components/com_comprofiler/library/cb/cb.database.php:756 21 JDatabaseMySQL->execute() /home/geniusyoX/www/libraries/joomla/database/database.php:1138 22 JError::raiseError() /home/geniusyoX/www/libraries/joomla/database/database/mysql.php:548 23 JError::raise() /home/geniusyoX/www/libraries/joomla/error/error.php:251

Thanks

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
10 years 9 months ago #239669 by krileon
Replied by krileon on topic fields with several cumulative values
The below will work as is tested working.

Code:
SELECT ( `hits` + '[connections]' ) FROM `#__comprofiler` WHERE `id` = '[user_id]'

Please understand when I provide code and state it's an example it's exactly that. I do not test examples. I write them off the top of my head to get you started. So please be sure to keep this in mind when an example is provided.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
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 CST to 4:00 PM CST. 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.

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

  • mfe13
  • mfe13
  • OFFLINE
  • Posts: 572
  • Thanks: 26
  • Karma: 5
10 years 9 months ago #239670 by mfe13
Replied by mfe13 on topic fields with several cumulative values
Ok it works very well with this [connections] in query.
I understood ... thank you very much for helping me
The following user(s) said Thank You: krileon

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

Moderators: beatnantkrileon
Powered by Kunena Forum