7 Replies Latest reply on Jul 18, 2012 6:24 PM by tcmeyers

    SERIOUS bug: FileMaker Server 12 Web Publishing Engine omitting portal data from RESULT

    tcmeyers

      Summary

      SERIOUS bug: FileMaker Server 12 Web Publishing Engine omitting portal data from RESULT

      Product

      FileMaker Server

      Version

      Server 12.0.1.178

      Operating system version

      Lion Server 10.7.3

      Description of the issue

      The XML results of a query to the WPE completely (and erroneously) omit column data for portals that have no related records; the field name elements for these in the XML are (correctly) not omitted. Thus, the results have more elements than elements, so data ends up being attributed to incorrect fields.

      Steps to reproduce the problem

      Include a portal on a layout to be used with the WPE. Add the portal and its fields, then afterwards add some more fields or portals, so that the result can be expected to have non-portal data presented AFTER the test portal as well.

      Make sure the test portal's relationship does not have any related records for the test record.

      Request the XML using the FMPXMLRESULT.xml?-db= etc. method.

      Observe that the data elements in the do not align with the field names in the section.

      Expected result

      There should be exactly as many elements as elements.

      Actual result

      For portals that have no related records, the elements are totally OMITTED, rather than being supplied as for each field in the portal, as they should be.

      Exact text of any error message(s) that appear

      None, other than lots of "Undefined index" errors and data appearing in wrong places, further downstream in the PHP output.

      Workaround

      None.