1. Forums
  3. Support and Presales
  5. Developer Members Support
  7. [#5887] Drop Down Single Select Query External Database

[#5887] Drop Down Single Select Query External Database

8 years 1 month ago #279934 by krileon
Replied by krileon on topic Drop Down Single Select Query External Database
Query action in CB Auto Action is fine as it has already had the fix applied. You can quickfix with the below.

IN: components/com_comprofiler/plugin/user/plug_cbqueryfield/cbqueryfield.php
ON: Line 74
FROM:
$_SQL_database					=	new cbDatabase( $_J_database );
TO:
$_SQL_database					=	new CmsDatabaseDriver( $_J_database, $prefix, checkJversion( 'release' ) );

Then at the top of the file with all the other use statements add the following.

use CBLib\Database\Driver\CmsDatabaseDriver;

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.
The following user(s) said Thank You: edmundcheong

Please Log in to join the conversation.

8 years 1 month ago - 8 years 1 month ago #279936 by edmundcheong
Replied by edmundcheong on topic Drop Down Single Select Query External Database

krileon wrote:
Then at the top of the file with all the other use statements add the following.

use CBLib\Database\Driver\CmsDatabaseDriver;


Thanks but not too sure where to put this.

Please Log in to join the conversation.

8 years 1 month ago #279938 by krileon
Replied by krileon on topic Drop Down Single Select Query External Database
Please re-read my reply. I specifically say where to place it as follows.

"Then at the top of the file with all the other use statements add the following."

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.
The following user(s) said Thank You: edmundcheong

Please Log in to join the conversation.

8 years 1 month ago #279948 by edmundcheong
Replied by edmundcheong on topic Drop Down Single Select Query External Database
Sorry kyle.. i had to read it a few times to get it.. pardon my ability.. ;)
The following user(s) said Thank You: krileon

Please Log in to join the conversation.

8 years 1 month ago #279987 by edmundcheong
Replied by edmundcheong on topic Drop Down Single Select Query External Database
Saw that the fixed is done on forge.joomlapolis.com/issues/5887

Somehow there are no nightly built for cb query fields on www.joomlapolis.com/cb-20-addon-status

Please Log in to join the conversation.

8 years 1 month ago #279989 by nant
Replied by nant on topic Drop Down Single Select Query External Database

edmundcheong wrote: Saw that the fixed is done on forge.joomlapolis.com/issues/5887

Somehow there are no nightly built for cb query fields on www.joomlapolis.com/cb-20-addon-status


There is now.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)
The following user(s) said Thank You: edmundcheong

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Support and Presales
  5. Developer Members Support
  7. [#5887] Drop Down Single Select Query External Database
Time to create page: 0.447 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Support and Presales
  4. Developer Members Support
  5. [#5887] Drop Down Single Select Query External Database

Search

Login / Logout

User Menu