Joomla 2.5.28 CiviCRM 4.7.7 PHP 5.5.30 MySQL 5.6.30
I have a Search Profile that allows a member to search for a local group based on Country and State OR they can search by name.
When the Country is selected, the state field does not populate.
You can see the page here:
https://www.theipca.org/index.php/local-guilds
Updated 5/10: Search now works thanks to patch recommended by SleighD. When you do a successful search, the State field then works but still does not work on the initial Profile Search page.
ISSUE BELOW THIS LINE HAS BEEN RESOLVED. STATE FIELD ISSUE PERSISTS.
*When you search for the local group by name, you get an error page.And you can search for Tallahassee in the Organization Name field. Log file shows the following errors:
May 09 14:21:52 [info] $backTrace = #0
> /home/ipca/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(371):
> CRM_Core_Error::backtrace("backTrace", TRUE)
> #1 /home/ipca/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/Type.php(424):
> CRM_Core_Error::fatal("One of parameters (value:
> `Home-state_province`) is not of the type MysqlCol...")
> #2 /home/ipca/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/Sort.php(124):
> CRM_Utils_Type::validate("`Home-state_province`", "MysqlColumnName")
> #3 /home/ipca/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Selector/Controller.php(222):
> CRM_Utils_Sort->__construct((Array:6), NULL)
> #4 /home/ipca/public_html/administrator/components/com_civicrm/civicrm/CRM/Profile/Page/Listings.php(394):
> CRM_Core_Selector_Controller->__construct(Object(CRM_Profile_Selector_Listings),
> NULL, NULL, 4, Object(CRM_Profile_Page_Listings), 2)
> #5 /home/ipca/public_html/administrator/components/com_civicrm/civicrm/CRM/Profile/Page/Router.php(124):
> CRM_Profile_Page_Listings->run()
> #6 /home/ipca/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(312):
> CRM_Profile_Page_Router->run((Array:2), NULL)
> #7 /home/ipca/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(86):
> CRM_Core_Invoke::runItem((Array:13))
> #8 /home/ipca/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(54):
> CRM_Core_Invoke::_invoke((Array:2))
> #9 /home/ipca/public_html/components/com_civicrm/civicrm.php(90): CRM_Core_Invoke::invoke((Array:2))
> #10 /home/ipca/public_html/components/com_civicrm/civicrm.php(11): civicrm_invoke()
> #11 /home/ipca/public_html/libraries/joomla/application/component/helper.php(380):
> require_once("/home/ipca/public_html/components/com_civicrm/civicrm.php")
> #12 /home/ipca/public_html/libraries/joomla/application/component/helper.php(348):
> JComponentHelper::executeComponent("/home/ipca/public_html/components/com_civicrm/civicrm.php")
> #13 /home/ipca/public_html/includes/application.php(194): JComponentHelper::renderComponent("com_civicrm")
> #14 /home/ipca/public_html/index.php(42): JSite->dispatch()
> #15 {main}
Any ideas on how to fix?*
