CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • State / Province dropdown not showing states
Pages: [1] 2

Author Topic: State / Province dropdown not showing states  (Read 9403 times)

geraldr_sc

  • Guest
State / Province dropdown not showing states
August 08, 2007, 09:38:27 pm
I installed a new joomla site (1.0.13)  and then installed 1.8.beta.10790.

When entering a new individual, the country shows only the United States, which is ok, but it does not show any states no matter what I type in the drop-down box.  What could be wrong?

I am using:
php version is 5.2.3
mySql is 4.1.22-standard

Gerald

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: State / Province dropdown not showing states
August 09, 2007, 03:51:06 am
Gerald:

We tried this on our local install, worked fine. May be you should clear your browser cache and try again. We tested on firefox 2.0.

kurund
Found this reply helpful? Support CiviCRM

geraldr_sc

  • Guest
Re: State / Province dropdown not showing states
August 09, 2007, 05:16:07 am
It still doesn't work. I tried with Firefox 2.0 and IE 7.

I installed Firebug extension and it shows this error when I click the first character in the states/provinces field:


uncaught exception: [Exception... "Component returned failure code: 0x80070057 (NS_ERROR_ILLEGAL_VALUE) [nsIXMLHttpRequest.open]"  nsresult: "0x80070057 (NS_ERROR_ILLEGAL_VALUE)"  location: "JS frame :: javascript: eval(__firebugTemp__); :: anonymous :: line 1"  data: no]

Line 0

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: State / Province dropdown not showing states
August 09, 2007, 06:51:55 am
Can you provide us exact steps to replicate this issue.

thanx,

kurund
Found this reply helpful? Support CiviCRM

geraldr_sc

  • Guest
Re: State / Province dropdown not showing states
August 09, 2007, 07:46:04 am
I am testing with a new installation of joomla with no content and a new installation of civicrm.

Inside Jooma administrator:
1) click components/civicrm/Civicrm home
2) under Civicrm Shortcuts in the left column click New individual
3) Enter test in field for first name, and user in field for last name
4) scroll down to address and enter 123 abc in Street address
5) enter Lexington in City
6) enter U in Country and United States displays
7) click down error to select United states and press enter to accept it.  At that point -type first letters- shows up in states field
8) click S and nothing displays in states field.
9) click down arrow on states field and nothing shows
10) continue to spell south carolina and try sc and nothing show
11) click save and name, city, country is saved but nothing is saved for the state.

The same thing happens using IE 7, so I assume it is not the browser. I am using Windows XP. It just occurred to me that perhaps the firewall is blocking the ajax. I will try to check that, though I don't know what I am doing there either.




and the following shows up in firebug window:
/administrator/index2.php?option=com_civicrm&task=civicrm/ajax/state&s=%{searchString} dojo.js (2953)
option   com_civicrm
s   %{searchString}
task   civicrm/ajax/state
« Last Edit: August 20, 2007, 07:33:11 pm by geraldr_sc »

geraldr_sc

  • Guest
Re: State / Province dropdown not showing states
August 09, 2007, 08:17:07 am
I disabled the windows xp firewall and turned off Windows Defender and it still does not work. There is a router firewall but the settings are low, which I believe allows anything going out and replys, but nothing coming in that is not a response.

Sometimes with a new individual attempt, the state field is grayed and stays grayed even after the country is selected, not allowing state entry. On editing an existing individual, it shows -type first letters- but does not populate a drop down.

When editing and the country is already in the record, this javascript error always comes up:
GET administrator/index2.php?option=com_civicrm&task=civicrm/ajax/state&s=%{searchString}406 (438ms)dojo.js (line 2953)

with this response:
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<HTML><HEAD>
<TITLE>406 Not Acceptable</TITLE>
</HEAD><BODY>
<H1>Not Acceptable</H1>
An appropriate representation of the requested resource /administrator/index2.php could not be found
 on this server.<P>
<HR>
<ADDRESS>Apache/1.3.37 Server at  Port 80</ADDRESS>
</BODY></HTML>
« Last Edit: August 20, 2007, 07:33:53 pm by geraldr_sc »

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: State / Province dropdown not showing states
August 13, 2007, 11:47:46 pm
We have made few changes to state/province code. So can you recheck it on http://demo.civicrm.org/drupal.

Quote
uncaught exception: [Exception... "Component returned failure code: 0x80070057 (NS_ERROR_ILLEGAL_VALUE) [nsIXMLHttpRequest.open]"  nsresult: "0x80070057 (NS_ERROR_ILLEGAL_VALUE)"  location: "JS frame :: javascript: eval(__firebugTemp__); :: anonymous :: line 1"  data: no]

You get this error, when to try to select disabled state province. You should always select country in order to enable state.

kurund
Found this reply helpful? Support CiviCRM

geraldr_sc

  • Guest
Re: State / Province dropdown not showing states
August 14, 2007, 11:32:53 am
Thanks, It works great on the demo.
Can this fix be downloaded?

Gerald

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: State / Province dropdown not showing states
August 14, 2007, 11:49:29 am
Gerald:

Thnx for testing. This fix will be available in next beta release (1-2 days)

kurund
Found this reply helpful? Support CiviCRM

geraldr_sc

  • Guest
Re: State / Province dropdown not showing states
August 18, 2007, 03:24:43 pm
I downloaded the new civicrm 1.8.10954 for joomla using php5 and it still causes errors. This time it triggered the firewall at the host to block me out, presumably after several incidents. When I requested information from the hosting company about what triggered the block, they sent me an email that sad the following was the incident that triggered the firewall to block my ip:

[Sat Aug 18 15:30:32 2007] [error] [client xx.xx.xx.xx] mod_security: Access denied with code 406. Error normalising REQUEST_URI: Invalid URL encoding detected: invalid characters used [severity "EMERGENCY"] [hostname "xxxxxxx.xxx"] [uri "/administrator/index2.php?option=com_civicrm&task=civicrm/ajax/state&s=%{searchString}"]

Is this something to do with civicrm, or is this just related to their firewall settings?

Even after they whitelisted the ip address, I get the same error:
"/administrator/index2.php?option=com_civicrm&task=civicrm/ajax/state&s=%{searchString}"
which give a 406 error.

When I start typing the state, I get this:
uncaught exception: [Exception... "Component returned failure code: 0x80070057 (NS_ERROR_ILLEGAL_VALUE) [nsIXMLHttpRequest.open]" nsresult: "0x80070057 (NS_ERROR_ILLEGAL_VALUE)" location: "JS frame :: javascript: eval(__firebugTemp__); :: anonymous :: line 1" data: no]

When I type the "U" to start United States in the country field, it gives this
"/administrator/index2.php?option=com_civicrm&task=civicrm/ajax/country&s=U"  and no error is returned

It is as if the %{searchString} is not getting set when I type the first character of the state or something.

Any ideas?
Gerald

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: State / Province dropdown not showing states
August 20, 2007, 05:57:47 am
Quote
[Sat Aug 18 15:30:32 2007] [error] [client xx.xx.xx.xx] mod_security: Access denied with code 406. Error normalising REQUEST_URI: Invalid URL encoding detected: invalid characters used [severity "EMERGENCY"] [hostname "xxxxxxx.xxx"] [uri "/administrator/index2.php?option=com_civicrm&task=civicrm/ajax/state&s=%{searchString}"

- tried on joomla installs. was not able to replicate this. can you check your server settings ?
Check http://forum.joomla.org/index.php?topic=202690.msg952084, might be useful.. (Google: "mod_security: Access denied with code 406".)

Can you get on IRC, it will be easier to debug...

- kurund



« Last Edit: August 20, 2007, 06:08:13 am by Kurund Jalmi »
Found this reply helpful? Support CiviCRM

geraldr_sc

  • Guest
Re: State / Province dropdown not showing states
August 20, 2007, 11:42:19 am
The hosting company said that the filter that is being triggered in mod_security is

SecFilterCheckURLEncoding On

They turned if off for a short time and I tried the address entry again and it worked fine, so it is definitely  the culprit. They do not want to leave it off so I and anyone else who is using a host with that mod_security setting will need a way around this.

Gerald

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: State / Province dropdown not showing states
August 21, 2007, 03:01:34 am
Gerald:

We have fixed this issues and will be available in next 1.8 release in a couple of weeks.

kurund
Found this reply helpful? Support CiviCRM

geraldr_sc

  • Guest
Re: State / Province dropdown not showing states
August 21, 2007, 06:16:30 am
Until the next release, I was able to disable the SecFilterCheckURLEncoding filter with this entry in the .htaccess file:

<IfModule mod_security.c>
  SecFilterCheckURLEncoding Off
</IfModule>

which I could have done from the beginning if I knew what I was doing :).

sergeich

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
    • USDLC
Re: State / Province dropdown not showing states
November 01, 2008, 01:13:12 am
I get same exact phenomenon under my installation, I tried to disable Mod_security - no dice.
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • State / Province dropdown not showing states

This forum was archived on 2017-11-26.