AnsweredAssumed Answered

New FMS11 outputs only last-record data for all found records

Question asked by JoelShapiro on Nov 27, 2013
Latest reply on Dec 2, 2013 by LyndsayHowarth

Hi all

 

This is a new one for me...

 

A client recently put FMS11 onto a new machine and then moved over their DBs & websites from their old-but-working setup.

 

Doing a query for a single record performs fine, but when there are multiple records returned from the query, the data from the last found record is repeated for each record, so if 20 records are returned, all 20 show the data of the last record.

 

This is unique to this server, as the same page and same DB works fine in my dev environment, and had worked fine in their previous setup.

 

When working, the output is:

1) apple

2) orange

3) banana

 

On this server, the output is:

1) banana

2) banana

3) banana

 

I see this when I output the full contents of the $records array, not just when I use a foreach loop.

 

Has anyone else seen this before? Any thoughts?

 

FMS11 11.0.5.510 / One-machine config / FMI-installed PHP (5.3.15)

OS X 10.7.3 (I'll ask them to upgrade to 10.7.5, but don't think that's relevant)

 

TIA,

-Joel

Outcomes