Hi John

I think I have recreated the problem. What I am seeing is the Ajax request in the bufferFeature function of spatialReports.js failing. With no buffer layer present the run-report event handler outputs the error message. The Ajax request is failing because it is not going via the proxy.

I'm not sure if this would be the preferred way to fix this but I was able to solve it by adding a proxy option prior to calling the map_helper::map_panel function in the get_form function of the report_map.php prebuilt form:

    if (defined('DRUPAL_BOOTSTRAP_CONFIGURATION') && module_exists('iform_proxy')) {
      global $base_url;
      $options['proxy'] = $base_url . '?q=' . variable_get('iform_proxy_path', 'proxy') . '&url=';
    }

Then, in spatialReports.js, changing the url of the Ajax call to

mapDiv.settings.proxy + mapDiv.settings.indiciaSvc + 'index.php/services/spatial/buffer'
          +'&wkt='+feature.geometry.toString()+'&buffer='+$('#geom_buffer').val()

I guess this url might want wrapping in a conditional statement in case the proxy is not in use.

Jim

Thanks, Anne, but I don't think that is related. It is a cross-site scripting problem that may not be apparent if both client and warehouse are on localhost. It needs an update to the code and I'd like it to be in a way that is consistent with what John has done elsewhere but I couldn't find a suitable bit of javascript to copy.

Jim.

Post #3 contains all the information required for an interim fix if you want to try it - both files to be modified can be found in the iform module. Once that has been reviewed we will commit a fix to the repository. You may have to wait while we fulfil other obligations, though.

Jim Bacon

Hi Anne,

You can ignore my note about the conditional statement. That is an improvement we might want to incorporate to cover all eventualities but is not necessary in the temporary workaround you are trying to effect.
The code snippet to be incorporated in the report_map.php needs to go in the function called get_form, just before the call to map_panel.
I'll email you my copy of the two files because, if you are not familiar with program code and don't have a helpful editor it will be difficult to get right.

Jim Bacon.

Hi

For those following this thread the resolution to this was as follows:

While using a warehouse at version 0.7.1 or below, apply the patch in #3 to spatialReports.js. The change to report_map.php is superfluous as it is already incorporated by a call to iform_map_get_map_options. In addition, ensure the Drupal IForm Ajax Proxy module is enabled.

Meanwhile a fix has been committed to the repository and will be released in version 0.8 which uses JSONP and circumvents the need for the proxy.

Jim Bacon.

Hi Alice,

Well, I haven't seen anything like that before. Perhaps a total red herring but all those redeclaration errors would have me viewing the html source and looking to see if scripts are being included multiple times. I can't see why they would be but you have to start somewhere.

If you set the warehouse log_threshold to 4 (debug) in application/config/config.php you can see the queries being run when you ask for the report. I observe that there is a filter

 AND st_intersects(s.geom, st_geomfromtext('POINT(0 0)',900913))

if I have not selected any area on the map. A filter like that means you will get no results.

Jim Bacon.

Hi Alice,

Is it the case that you view this page and see a Map Parameters box where you can select your survey with a blank map below? You then select a survey, draw a polygon on the map and click run report, after which the map vanishes? I can see an indication in your html that you have drawn a polygon.

Can you use Firebug to select the area where the map should be and find an empty div? That would take us back to JavaScript problems rather than CSS I think.

Jim Bacon.

Hi Alice,

I think you are using Instant Indicia 0.8.2.
Try the following
Find the file sites/all/libraries/iform/client_helpers/report_helper.php and make a backup copy.
Now open the original file and goto line 1547.
Does it read as follows?

$addFeaturesJs.= "div.addPt(features, ".json_encode($record).", '$wktCol', $opts".(empty($rowId) ? '' : ", '".$record[$options['rowId']]."'").", $locationId);\n";

If so, change it to the following and save.

$addFeaturesJs.= "div.addPt(features, ".json_encode($record).", '$wktCol', $opts" . (empty($rowId) ? '' : ", '" . $record[$options['rowId']] . "'") . (empty($locationId) ? '' : ", $locationId") . ");\n";

Now visit your troublesome web page and try again.
This fixes a problem which caused invalid JavaScript to be injected in to the page.
With luck, the error messages you saw were a side effect of this.

Jim Bacon.

Hi Alice

Well, I guess it works because, as the operating system traverses the directory structure, when it sees a dot it knows to stay in the current directory (which might not be common knowledge to anyone who has grown up with only a graphical user interface) and I guess it just ignores the double slash.

The double / looks like a typo at line 671 of sites/all/modules/iform/iform.module which I will correct in the repository.
The . comes from line 1015 of the same file. It does appear superfluous but perhaps there are circumstances where it matters so I'll leave it alone. Someone put it there for a reason.

Jim Bacon

Hi Alice

Can you confirm that the records you have entered have made it in to the cache_occurrences table?

Jim Bacon.

Hi Alice

That web page is a presentation of information taken from the occurrences table in the database. In order to speed up reporting from the database a cache_occurrences table is built which joins information from various other tables. The cache_occurrences table is built when the scheduled_tasks runs (as mentioned in the tip on the doc page you are working through).

Even though you have occurrences, the cache_occurrences table could still be empty and hence you would get no results showing.

You can only see the contents of the cache_occurrences table by logging in to the database itself. Have you found pgAdmin on your warehouse and explored the database yet?

Jim Bacon