Databases
StackOverflow2013
Postsdbo
POjQuery $.ajax failing silently, no error messages, and server responded with 200 OK
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjQuery $.ajax failing silently, no error messages, and server responded with 200 OK
    primarykey
    data
    text
    <p>I am about to do my head in over this problem. I am using very simple jQuery ajax calls to get values from a database and populate a few select elements with the values, all returned as JSON. It works seamlessly for me on most browsers, however the client is reporting that neither them nor their clients are seeing the result.</p> <p>I added some Console.log() commands along the way to make sure the code was executing, and it was. Sometimes the ajax GET to the URL in question works, other times is STILL returns 200 OK but the code simply does not execute further, and NO ajax error messages are shown in the error callback.</p> <p>Here is the code I am using, can someone spot something obvious that may result in some browsers choking? If so, I'd be grateful if you could point it out:</p> <pre><code> var $j = jQuery.noConflict(true); $j(document).ready(function(){ //console.log("jQuery has loaded"); //console.log("attempting to load country list via AJAX call now"); $j.ajax({ url: 'http://www.topplaces.co.za/templates/seb_one/positions/search_establishments_filter/search/db.php?q=countries&amp;rand='+Math.random(), success: function(data){ //console.log("Successfully got country list, going to populate the dropdown now"); if(data.length){ $j("#country").children("option:not(:first)").remove(); $j("#country").attr("disabled", false); $j.each(data, function(resultIndex, result){ var o = new Option(); $j(o).html(result.country).val(result.country); $j("#country").append(o); }) //console.log("Country list should be populated now?"); } }, error: function (xhr, ajaxOptions, thrownError){ //console.log(xhr.responseText); console.log(thrownError); }, dataType: 'json', cache: false }) $j("#country").live('change', function(){ var id = $j(this).val(); if(id == ""){ $j("#province").attr("disabled", "disabled"); $j("#town").attr("disabled", "disabled"); return false; } $j.ajax({ url: 'http://www.topplaces.co.za/templates/seb_one/positions/search_establishments_filter/search/db.php?q=provinces&amp;c='+id+'&amp;rand='+Math.random(), success: function(data){ if(data.length){ $j("#province").children("option:not(:first)").remove(); $j("#province").attr("disabled", false); $j.each(data, function(resultIndex, result){ var o = new Option(); $j(o).html(result.province).val(result.province); $j("#province").append(o); }) } }, dataType: 'json', cache: false }) }); $j("#province").live('change', function(){ var id = $j(this).val(); if(id == ""){ $j("#town").attr("disabled", "disabled"); return false; } $j.ajax({ url: 'http://www.topplaces.co.za/templates/seb_one/positions/search_establishments_filter/search/db.php?q=towns&amp;p='+id+'&amp;rand='+Math.random(), success: function(data){ if(data.length){ $j("#town").children("option:not(:first)").remove(); $j("#town").attr("disabled", false); $j.each(data, function(resultIndex, result){ var o = new Option(); $j(o).html(result.town).val(result.town); $j("#town").append(o); }) } }, dataType: 'json', cache: false }) }); }) </code></pre> <p>I have commented out the Consol.log commands for the pure fact that the client was receiving error messages on IE as there is no console.</p> <p><strong>EDIT: I failed to mention that this a same domain request and therefore obeys the Same Origin Policy</strong></p> <p>The full site is here: <a href="http://www.topplaces.co.za/" rel="nofollow">http://www.topplaces.co.za/</a> On the right is a dynamic select group that starts with country and initiates AJAX calls until a Province is selected. The issue, a lot of people say that Country is no loading for them...</p> <p>Kind regards, Simon</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSimonDowdles
    1. USSimonDowdles
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COIs this cross domain? (answered in edit: no) What does your return JSON look like? Is it an array? If not, is it an object with a `length` property? Why is your `error` function commented out in the AJAX options? Without an error handler, failures will be silent.
      singulars
      1. POjQuery $.ajax failing silently, no error messages, and server responded with 200 OK
      1. USJAAulde
    2. CO@JAAulde - I uncommented it in the above question, this was from my dev copy, but the production site has it commented out. The response is a properly formatted JSON string. As I said, it works for me and about 10 people I asked to test, but then another 10 will say it does not load, and their FireBug console shows the GET request as 200 OK but yet the select is not populated and no errors thrown
      singulars
      1. POjQuery $.ajax failing silently, no error messages, and server responded with 200 OK
      1. USSimonDowdles
    3. COI have added the full site URL: http://www.topplaces.co.za/ to the answer. The set of 3 dynamic selects on the right are what populate from the returned JSON data. At first I had assumed that maybe the client was going via a work place proxy and caching was aggressive, but they wiped (5gb!!!) of cache, no difference, and besides some others on an 'open' web report the select not working too.
      singulars
      1. POjQuery $.ajax failing silently, no error messages, and server responded with 200 OK
      1. USSimonDowdles
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload