[SOLVED] Pb table country_info
- pub
- OFFLINE
-
Senior Member
- Posts: 55
- Thanks: 2
- Karma: 0
8 years 9 months ago - 8 years 9 months ago #267488
by pub
[SOLVED] Pb table country_info was created by pub
Hello,
can you help me ?
when i try to go in admin : community builder->gestion member ans i clic on a member :
Table 'vpsxxxx-cifxxxxexpertise-com.country_info' doesn't exist SQL=SELECT `country` FROM `country_info` ORDER BY country
Thank you !
CB 2.0.10
CBSubs 4.0
Joomla 3.4.3
php 5.6.10
can you help me ?
when i try to go in admin : community builder->gestion member ans i clic on a member :
Table 'vpsxxxx-cifxxxxexpertise-com.country_info' doesn't exist SQL=SELECT `country` FROM `country_info` ORDER BY country
Thank you !
CB 2.0.10
CBSubs 4.0
Joomla 3.4.3
php 5.6.10
Last edit: 8 years 9 months ago by krileon.
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68555
- Thanks: 9095
- Karma: 1434
8 years 9 months ago #267501
by krileon
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.
Replied by krileon on topic Pb table country_info
Looks like you tried following the below tutorial, but didn't import the database file.
www.joomlapolis.com/support/tutorials/107-use-cases/18377-configuring-a-country-field-with-cb-query-field-plugin
So you've a query field trying to query a table that doesn't exist. Note if you've CBSubs it's possible to use its database table instead of the one provided in the tutorial. For example you'd have a query field as follows if CBSubs Tax is installed as its geolocation tables are needed.
Field Type: Query Drop Down (Single Select)
Query:Value Column: country_iso_code3
Label Column: country_name
Group Column: country_region
www.joomlapolis.com/support/tutorials/107-use-cases/18377-configuring-a-country-field-with-cb-query-field-plugin
So you've a query field trying to query a table that doesn't exist. Note if you've CBSubs it's possible to use its database table instead of the one provided in the tutorial. For example you'd have a query field as follows if CBSubs Tax is installed as its geolocation tables are needed.
Field Type: Query Drop Down (Single Select)
Query:
SELECT `country_iso_code3`, `country_name`, country_region FROM `#__comprofiler_countries` WHERE `country_region` != '' ORDER BY `country_region`, `country_name`Label Column: country_name
Group Column: country_region
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 to join the conversation.
- pub
- OFFLINE
-
Senior Member
- Posts: 55
- Thanks: 2
- Karma: 0
8 years 9 months ago #267556
by pub
Replied by pub on topic Pb table country_info
OK, thank you !
It was the query file for the country, i change it and it's ok !
THANK YOU !
It was the query file for the country, i change it and it's ok !
THANK YOU !
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.175 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Developer Members Support
- [SOLVED] Pb table country_info