Opened 2 years ago

Closed 16 months ago

#2576 closed defect (fixed)

Schema report: Use explicit property list for query in showclass.php

Reported by: jng Owned by: jng
Priority: low Milestone:
Component: General Version: 2.5.0
Severity: trivial Keywords:
Cc: External ID:

Description

Reported here: http://osgeo-org.1560.x6.nabble.com/PostgreSQL-SelectFeatures-td5236983.html

Currently showclass.php does the equivalent of "select * from table", which works fine most of the time, but in the case of the PostgreSQL FDO provider, causes errors if the mapped database table contains columns not supported or recognised by the FDO provider.

The fix is to explicitly specify all the valid properties in the query before executing it.

Change History (1)

comment:1 Changed 16 months ago by jng

Resolution: fixed
Status: newclosed

Fixed trunk (r9000), 3.1 (r9001), 3.0 (r9002), 2.6 (r9003)

Note: See TracTickets for help on using tickets.