[QGIS-trac] [Quantum GIS] #3089: Problem with On-the-fly CRS transformation

[Quantum GIS]

#3089: Problem with On-the-fly CRS transformation
--------------------------------------+-------------------------------------
   Reporter:  shenriod                |              Owner:  nobody       
       Type:  bug                     |             Status:  new          
   Priority:  minor: annoyance        |          Milestone:  Version 1.6.0
  Component:  Projection Support      |            Version:  1.5.0        
   Keywords:  on-the-fly, projection  |   Platform_version:  Seven Pro    
   Platform:  Windows                 |           Must_fix:  No           
Status_info:  0                       |  
--------------------------------------+-------------------------------------
 Dear all,

 I have data in a PostGIS database (1.4.2) that I access through Qgis 1.5.

 All my data is in CRS 32642 (WGS84 - UTM zone 42N)

 When I try to display in un-projected WGS84 using the the on-the-fly CRS
 transformation, I get the following error message:


 {{{
  1 cursor states lost.
     SQL: declare qgisf14 binary cursor for select
 "distr_id",asbinary("the_geom",'NDR') from "admin"."admin_center" where
 "the_geom" &&
 setsrid('BOX3D(179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368.0000000000000000
 179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368.0000000000000000,
 inf inf)'::box3d,32642)
     Result: 7 (ERREUR: BOX3D parser - couldnt parse. It should look like:
 BOX3D(xmin ymin zmin,xmax ymax zmax) or BOX3D(xmin ymin,xmax ymax)
     LINE 1: ...admin"."admin_center" where "the_geom" &&
 setsrid('BOX3D(179...
     ^
     )


 }}}


 This message is displayed twice in a row for each layer I have in the
 table of contents but finally everything is displayed correctly in
 Lat/Long degrees

 This bug seems to appear with
 * Qgis 1.5 on Windows 7

 but NOT
 * Qgis 1.4 on Windows 7
 * Qgis 1.5 on Ubuntu 10.04

 Also, if I save my laser as a shapefile and open his shapefile, I don't
 have the error message when using on-the-fly CRS transformation

 Thanks in advance for your help!

 Stéphane

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/3089>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats